What the SQL Essentials course covers
⊕ Expand full topic list
Unit 1: Understanding SQL
- Database Basics
- Introduction to SQL
⊕ See more
Unit 2: Retrieving Data
- The SELECT Statement
- Retrieving Individual Columns
- Retrieving Multiple Columns
- Retrieving All Columns
- Retrieving Distinct Rows
- Limiting Results
- Using Comments
⊕ See more
Unit 3: Sorting Retrieved Data
- Sorting Data
- Sorting by Multiple Columns
- Sorting by Column Position
- Specifying Sort Direction
⊕ See more
Unit 4: Filtering Data
- Using the WHERE Clause
- The WHERE Clause Operators
⊕ See more
Unit 5: Advanced Data Filtering
- Combining WHERE Clauses
- Using the IN Operator
- Using the NOT Operator
⊕ See more
Unit 6: Using Wildcard Filtering
- Using the LIKE Operator
- Tips for Using Wildcards
⊕ See more
Unit 7: Creating Calculated Fields
- Understanding Calculated Fields
- Concatenating Fields
- Performing Mathematical Calculations
⊕ See more
Unit 8: Using Data Manipulation Functions
- Understanding Functions
- Using Functions
⊕ See more
Unit 9: Summarising Data
- Using Aggregate Functions
- Aggregates on Distinct Values
- Combining Aggregate Functions
⊕ See more
Unit 10: Grouping Data
- Understanding Data Grouping
- Creating Groups
- Filtering Groups
- Grouping and Sorting
- SELECT Clause Ordering
⊕ See more
Unit 11: Working with Subqueries
- Understanding Subqueries
- Filtering by Subquery
- Using Subqueries as Calculated Fields
⊕ See more
Unit 12: Joining Tables
- Understanding Joins
- Creating a Join
⊕ See more
Unit 13: Creating Advanced Joins
- Using Table Aliases
- Using Different Join Types
- Using Joins with Aggregate Functions
- Using Joins and Join Conditions
⊕ See more
Unit 14: Combining Queries
- Understanding Combined Queries
- Creating Combined Queries
⊕ See more
Unit 15: Inserting Data
- Understanding Data Insertion
- Copying from One Table to Another
⊕ See more
Unit 16: Updating and Deleting Data
- Updating Data
- Deleting Data
- Guidelines for Updating and Deleting Data
⊕ See more
Unit 17: Creating and Manipulating Tables
- Creating Tables
- Updating Tables
- Deleting Tables
- Renaming Tables
⊕ See more
Unit 18: Using Views
- Understanding Views
- Creating Views
⊕ See more
Unit 19: Working with Stored Procedures
- Understanding Stored Procedures
- Why to Use Stored Procedures
- Executing Stored Procedures
- Creating Stored Procedures
⊕ See more
Unit 20: Managing Transaction Processing
- Understanding Transaction Processing
- Controlling Transactions
⊕ See more