SQL Essentials Course

Understanding SQL

• Database Basics
• What is SQL?

Retrieving Data

• The SELECT Statement
• Retrieving Individual Columns
• Retrieving Multiple Columns
• Retrieving All Columns

Sorting Retrieved Data

• Sorting Data
• Sorting By Multiple Columns
• Sorting By Column Position
• Specifying Sort Direction

Filtering Data

• Using the WHERE Clause
• The WHERE Clause Operators

Advanced Data Filtering

• Combining WHERE Clauses
• Using the IN Operator
• Using the NOT Operator

Using Wildcard Filtering

• Using the LIKE Operator
• Tips For Using Wildcards

Creating Calculated Fields

• Understanding Calculated Fields
• Concatenating Fields
• Performing Mathematical Operations

Using Data Manipulation Functions

• Understanding Functions
• Using Functions

Summarizing Data

• Using Aggregate Functions
• Aggregates on Distinct Values
• Combining Aggregate Functions

Grouping Data

• Understanding Data Grouping
• Creating Groups
• Filtering Groups
• Grouping and Sorting
• SELECT Clause Ordering

Working with Subqueries

• Understanding Subqueries
• Filtering By Subquery
• Using Subqueries As Calculated Fields

Joining Tables

• Understanding Joins
• Creating a Join

Creating Advanced Joins

• Using Table Aliases
• Using Different Join Types
• Using Joins With Aggregate Functions
• Using Joins And Join Conditions

Combining Queries

• Understanding Combined Queries
• Creating Combined Queries