SQL Fundamentals
FREE
Master SQL from basics to advanced queries. Learn SELECT, filtering, JOINs, subqueries, table management, and database design with hands-on exercises.
Course Content
Getting Started
SELECT Statement Basics
Filtering Data with WHERE
Comparison Operators - Less Than and Greater Than
Comparison with Equal To
SQL Comments
Logical Operators - AND & OR
BETWEEN and NOT BETWEEN
IN and NOT IN Operators
Working with NULL Values
Pattern Matching with LIKE
Excluding Patterns with NOT LIKE
DISTINCT Operator
Selecting Specific Columns
Column Aliases with AS
COUNT with DISTINCT
SUM and AVG Functions
MAX and MIN Functions
Selecting Multiple Records
ORDER BY Clause
Ascending and Descending Order
Advanced ORDER BY
LIMIT Clause
LIMIT with Ordering and OFFSET
LENGTH Function
Date and Time Functions
Arithmetic Operations
Filtering with Arithmetic
Computed Columns
Concatenating Data
Handling NULL Values
GROUP BY with COUNT
GROUP BY with Aggregates
Advanced GROUP BY
GROUP BY Multiple Columns
GROUP_CONCAT Function
INNER JOIN
OUTER JOINs
Joining Multiple Tables
JOINs with Filtering and Ordering
JOINs with GROUP BY
Complex JOINs and Grouping
Cartesian Product
UNION Operator
INTERSECT and EXCEPT
Subqueries Basics
Subqueries in FROM Clause
Correlated Subqueries
EXISTS Operator
Creating Tables
Inserting Data
Multiple SQL Statements
NOT NULL and UNIQUE Constraints
DEFAULT and CHECK Constraints
PRIMARY KEY Constraint
AUTOINCREMENT
FOREIGN KEY Constraint
Updating Data
Deleting Data
Altering Tables
Renaming and Dropping Tables
SQL Statements with Subqueries
300 min
Course Details
291 lessons
65 chapters
300 minutes total
Updated recently
Progress
0%0 of 291 lessons completed