1 Introduction (19.09 MB)
10 Solutions to the SELECT Challenges (29.05 MB)
11 SELECT DISTINCT Statement (21.47 MB)
12 SELECT DISTINCT Challenges (5.63 MB)
13 Solutions to the SELECT DISTINCT Challenges (22.33 MB)
14 Row Ordering - ORDER BY (28.58 MB)
15 Filtering Data with TOP (21.63 MB)
16 ORDER BY Challenges (8.9 MB)
17 Solutions to the ORDER BY Challenges (48.67 MB)
18 WHERE Clause - Three-valued Logic (17.68 MB)
19 Replacing Nulls in Queries (45.56 MB)
2 Understanding the Foundations of SQL (27.39 MB)
20 WHERE Clause - Comparison Operators (13.79 MB)
21 WHERE Clause Challenges (8.96 MB)
22 Solutions to the WHERE Clause Challenges (35.79 MB)
23 Introduction to Collations and Pattern Matching (34.49 MB)
24 Pattern Matching - Part 2 (21.04 MB)
25 Introduction to Character Data Types (18.68 MB)
26 Pattern Matching Challenges (3.52 MB)
27 Solutions to the Pattern Matching Challenges (20.25 MB)
28 Introduction to Aggregate Functions (22.08 MB)
29 GROUP BY and Aggregate Functions (23.63 MB)
3 SELECT Statement (31.04 MB)
30 HAVING Clause (18.47 MB)
31 Logical Query Processing Order (30.16 MB)
32 GROUP BY Challenges (9.93 MB)
33 Solutions to the GROUP BY Challenges (78.77 MB)
34 AND operator (9.62 MB)
35 OR operator (10.39 MB)
36 Operator Precedence (15.57 MB)
37 IN Operator (13.32 MB)
38 Logical Operator Challenges (6.52 MB)
39 Solutions to the Logical Operator Challenges (58.88 MB)
4 Overview of SQL Server (9.28 MB)
5 Windows - How to Setup SQL Server and SSMS on a Windows Computer (30.52 MB)
6 Windows - How to Setup the SAMPLEDB Database on Windows Computer (66.44 MB)
7 MacOS - How to set up SQL Server Database on a Mac Computer using Docker (151.62 MB)
8 Overview of the Course Challenges (14.46 MB)
9 SELECT Challenges (8.63 MB)
1 Inner Joins (28.51 MB)
10 Predicate placement - ON clause vs WHERE clause (45.21 MB)
11 Self-referencing Joins (17.94 MB)
12 Cross Joins (8.55 MB)
13 Advanced Join Challenges (30.02 MB)
14 Solutions to the Advanced Join Challenges (152.45 MB)
2 Outer Joins - LEFT OUTER JOIN and RIGHT OUTER JOIN (25.18 MB)
3 FULL OUTER JOIN (17.63 MB)
4 Integrity Constraints (60.95 MB)
5 Many-to-many Relationships (33.71 MB)
6 Join Challenges (7.81 MB)
7 Solutions to the Join Challenges (41.96 MB)
8 Composite Joins - Joining on multiple columns (39.6 MB)
9 Joining more than two tables (24.21 MB)
1 UNION and UNION ALL (43.72 MB)
2 INTERSECT (12.51 MB)
3 EXCEPT (11.06 MB)
4 Set Operator Precedence (11.74 MB)
5 SET Operator Challenges (12.06 MB)
6 Solutions to the Set Operator Challenges (108.11 MB)
1 Self-contained Subqueries (20.78 MB)
2 Correlated Subqueries (29.6 MB)
3 EXISTS (21.33 MB)
4 Introduction to Window Functions (33.73 MB)
5 Common Table Expressions (35.71 MB)
6 Avoiding the NOT IN trap (48 MB)
7 Subquery Challenges (34.09 MB)
8 Solutions to the Subquery Challenges (102.47 MB)
1 Concatenation in SQL Server (22.6 MB)
2 String Manipulation Functions (34.55 MB)
3 Date and Time Functions (102.62 MB)
4 Function Challenges (26.11 MB)
5 Solutions to the Function Challenges (119.88 MB)
6 CASE Expression (39.01 MB)
7 CASE Expression Challenges (21.41 MB)
8 Solutions to the CASE Expression Challenges (101.75 MB)
1 Overview of Data Types (55.12 MB)
10 UPDATE Statement (17.05 MB)
11 DELETE Statement (13.45 MB)
12 TRUNCATE TABLE statement (23.99 MB)
13 DROP TABLE Statement (44.73 MB)
14 Transactions (50.62 MB)
15 Stored Procedures (27.03 MB)
16 Stored Procedures Demo (229.94 MB)
17 Stored Procedure Challenges (68.03 MB)
18 Solutions to the Stored Procedure Challenges (126.76 MB)
19 ALTER TABLE Statement and sp rename (31.21 MB)
2 Integer Data Types (38.87 MB)
20 ALTER TABLE Challenges (6.13 MB)
21 Solutions to the ALTER TABLE Challenges (36.39 MB)
22 UNIQUE Constraints (63.4 MB)
23 CHECK Constraints (26.41 MB)
24 Introduction to Indexes (46.8 MB)
25 Index Types and Indexing Guidelines (88.87 MB)
26 Index Types Part 2 - Composite vs Included Columns (48 MB)
28 Sargable Queries (37.15 MB)
29 Indexing and Sargable Query Challenges (14.05 MB)
3 DECIMAL Data Type (10.99 MB)
30 Solutions to the Indexing and Sargable Query Challenges (68.99 MB)
31 CREATE VIEW Statement (19.76 MB)
4 FLOAT Data Type (57.9 MB)
5 CREATE TABLE Statement (78.11 MB)
6 INSERT Statement (18.3 MB)
7 CREATE TABLE Challenges (22.87 MB)
8 Solutions to the CREATE TABLE Challenges (63.35 MB)
9 UNIQUEIDENTIFIER (GUID) Data Type (41.06 MB)
1 Introduction to Data Normalization (62.03 MB)
2 Functional Dependencies (23.46 MB)
3 Functional Dependencies Exercise (34.98 MB)
4 Candidate Keys and Super Keys (34.41 MB)
5 First Normal Form (47.65 MB)
6 Restructuring Multi-valued and Multi-type fields (21.72 MB)
7 Second Normal Form (17.14 MB)
8 Third Normal Form (33.15 MB)
9 Boyce Codd Normal Form (56 MB)