1 -Understanding SQL and its Importance (44.95 MB)
2 -Setting Up Your Local SQL Environment and Running Your First Database (85.19 MB)
1 -Hands-on Project Joining Multiple Tables (70.21 MB)
1 -Understanding Subqueries (52.53 MB)
2 -Hands-on Project Writing Subqueries in SQL (98.54 MB)
1 -Understanding CASE Statements (53.44 MB)
2 -Hands-on Project Writing Conditional SQL Queries (98.69 MB)
1 -Understanding Self-Joins (49.94 MB)
2 -Hands-on Project Writing Queries with Self-Joins (66.75 MB)
1 -Combining Result Sets with UNION (45.41 MB)
2 -Hands-on Project Merging Results from Multiple Queries (66.34 MB)
1 -Introduction to Indexing in Databases (37.22 MB)
2 -Hands-on Project Creating and Managing Indexes (70.38 MB)
1 -Overview of SQL Views (60.86 MB)
2 -Hands-on Project Creating and Using Views in SQL (85 MB)
1 -Understanding Transactions in SQL (53.74 MB)
2 -Hands-on Project Implementing Transactions in SQL (80.59 MB)
1 -Introduction to Stored Procedures (54.4 MB)
1 -Understanding SQL Triggers (28.58 MB)
1 -Database Structure and Table Relationships (69.63 MB)
2 -Hands-on Project Creating Databases and Tables in SQL (84.31 MB)
3 -Hands-on Project Verifying Structure and Relationships (58.8 MB)
1 -Importance of Database Normalization (37.78 MB)
2 -Hands-on Project Applying Normalization Techniques (74.52 MB)
1 -Understanding ACID Transactions (43.44 MB)
1 -Overview of SQL Date Functions (30.77 MB)
2 -Hands-on Project Manipulating Dates in SQL Queries (48.32 MB)
1 -Purpose and Syntax of SELECT (42.99 MB)
2 -Hands-on Project Querying Data from Tables in SQL (83.71 MB)
3 -Hands-on Project Use SELECT with Aggregate Functions (52.38 MB)
1 -Filtering Data with WHERE Clause (56.65 MB)
2 -Hands-on Project Applying Logical Operators in SQL Queries (97.47 MB)
1 -Sorting Data Using ORDER BY (54.37 MB)
2 -Hands-on Project Writing Queries with ORDER BY (79.98 MB)
1 -Understanding LIMIT & OFFSET (47.68 MB)
2 -Hands-on Project Limiting Query Results (93.68 MB)
1 -Overview of Aggregate Functions (67.66 MB)
2 -Hands-on Project Applying Aggregate Functions to Data (89.28 MB)
1 -Grouping Data with GROUP BY (58.23 MB)
2 -Hands-on Project Applying Aggregate Functions to Groups (94.02 MB)
1 -Filtering Groups with HAVING (47.57 MB)
2 -Hands-on Project Applying Filters to Grouped Data (85.09 MB)