Files Included :
1 - About the course (25.67 MB)
2 - How to download your resources (18.49 MB)
3 - What is Database and SQL (247.92 MB)
4 - What can you do with Databases and SQL (140.12 MB)
5 - How to set up your SQL learning environment (35.01 MB)
6 - How to test your SQL environment (274.04 MB)
10 - Implement your data model (41.34 MB)
11 - Working with databases (153.69 MB)
12 - Working with tables (336.06 MB)
13 - Inserting data into a table (286.79 MB)
14 - Inserting from source updating and deleting (252.92 MB)
15 - Selecting data from tables (572.98 MB)
16 - Microproject Solution (329.65 MB)
7 - SQL Classification (124.48 MB)
8 - Microproject Requirement (48.28 MB)
9 - Design your data model (421.24 MB)
17 - Selecting columns (239.84 MB)
18 - Using mathematical expressions (312.24 MB)
19 - Creating logical expressions (230.15 MB)
20 - Designing conditional expressions (352.4 MB)
21 - Filter Expressions (548.41 MB)
22 - CASE and CTE in Filters (711.35 MB)
23 - Subquery Filters (413.16 MB)
24 - Correlated Query Filter (448.59 MB)
25 - Introduction to join (213.85 MB)
26 - Inner Join queries (506.34 MB)
27 - Outer joins (543.11 MB)
28 - Other types of joins (609.49 MB)
29 - Using SQL Functions (920.95 MB)
30 - Mathematical Functions (294.31 MB)
31 - String Functions (440.55 MB)
32 - Date Time Functions (676.45 MB)
33 - Simple Aggregation (338.02 MB)
34 - Grouping Aggregation Part 1 (411.24 MB)
35 - Grouping Aggregation Part 2 (161.78 MB)
36 - Grouping Aggregation Filters (134.52 MB)
37 - Multilevel Aggregation Part 1 (269.14 MB)
38 - Multilevel Aggregation Part 2 (211.8 MB)
39 - Introduction to Window Aggregation (215.68 MB)
40 - Window Aggregates Part 1 (575.09 MB)
41 - Window Aggregates Part 2 (626.67 MB)
42 - Window Aggregates Part 3 (376.58 MB)
43 - Set Operations (80.71 MB)
44 - Pivoting Data Sets (289.91 MB)
45 - Unpivot Data Sets (153.49 MB)
46 - Data Views (189.89 MB)
47 - Auxiliary Statements (244.36 MB)
[center]
Screenshot