Udemy - The Sql Primer Masterclass

Download Now


Files Included :

1 - Welcome.mp4 (7.59 MB)
MP4
2 - Course Overview.mp4 (16.65 MB)
MP4
3 - How to get best out of this course.mp4 (11.86 MB)
MP4
30 - CREATE.mp4 (22.55 MB)
MP4
31 - ALTER.mp4 (9.93 MB)
MP4
32 - DROP.mp4 (6.55 MB)
MP4
33 - INSERT.mp4 (16.28 MB)
MP4
34 - UPDATE.mp4 (11.47 MB)
MP4
35 - TRUNCATE.mp4 (12.87 MB)
MP4
36 - DELETE.mp4 (8.57 MB)
MP4
37 - MERGE Pt 1.mp4 (21.07 MB)
MP4
38 - MERGE Pt 2.mp4 (81.87 MB)
MP4
39 - DDLDMLExercise 1.mp4 (19.98 MB)
MP4
40 - DDLDMLExercise 2.mp4 (10.36 MB)
MP4
41 - DDLDMLExercise 3.mp4 (5.69 MB)
MP4
42 - DDLDMLExercise 4.mp4 (5.38 MB)
MP4
43 - DDLDMLExercise 5.mp4 (12 MB)
MP4
44 - DDLDMLExercise 6.mp4 (9.92 MB)
MP4
45 - DDLDMLExercise 7.mp4 (10.25 MB)
MP4
46 - DDLDMLExercise 8.mp4 (9.53 MB)
MP4
47 - DDLDMLExercise 9.mp4 (6.95 MB)
MP4
48 - DDLDMLExercise 10.mp4 (8.28 MB)
MP4
49 - DDLDMLExercise 11.mp4 (8.45 MB)
MP4
50 - SUM.mp4 (53.76 MB)
MP4
51 - COUNT.mp4 (40.3 MB)
MP4
52 - COUNTIF.mp4 (22.29 MB)
MP4
53 - AVG.mp4 (18.33 MB)
MP4
54 - MINMAX.mp4 (58.3 MB)
MP4
55 - AggregateExercise 1.mp4 (19.99 MB)
MP4
56 - AggregateExercise 2.mp4 (9.03 MB)
MP4
57 - AggregateExercise 3.mp4 (8.74 MB)
MP4
58 - AggregateExercise 4.mp4 (14.76 MB)
MP4
59 - AggregateExercise 5.mp4 (7.09 MB)
MP4
60 - AggregateExercise 6.mp4 (10.88 MB)
MP4
61 - AggregateExercise 7.mp4 (5.84 MB)
MP4
62 - AggregateExercise 8.mp4 (4.77 MB)
MP4
63 - AggregateExercise 9.mp4 (4.51 MB)
MP4
64 - AggregateExercise 10.mp4 (6.31 MB)
MP4
65 - AggregateExercise 11.mp4 (6.9 MB)
MP4
66 - AggregateExercise 12.mp4 (6.38 MB)
MP4
67 - CONCAT.mp4 (19.17 MB)
MP4
68 - REPLACE.mp4 (20.75 MB)
MP4
69 - LOWER.mp4 (7.7 MB)
MP4
70 - UPPER.mp4 (12.08 MB)
MP4
71 - NORMALIZE.mp4 (38.22 MB)
MP4
72 - SPLIT.mp4 (18.9 MB)
MP4
73 - LEFTRIGHT.mp4 (16.79 MB)
MP4
74 - TRIM.mp4 (7.55 MB)
MP4
75 - StringExercise 1.mp4 (6.93 MB)
MP4
76 - StringExercise 2.mp4 (10.05 MB)
MP4
77 - StringExercise 3.mp4 (8.93 MB)
MP4
78 - StringExercise 4.mp4 (12.9 MB)
MP4
79 - StringExercise 5.mp4 (4.98 MB)
MP4
80 - StringExercise 6.mp4 (8.68 MB)
MP4
81 - StringExercise 7.mp4 (13.48 MB)
MP4
82 - StringExercise 8.mp4 (8.96 MB)
MP4
83 - StringExercise 9.mp4 (26.68 MB)
MP4
84 - StringExercise 10.mp4 (7.51 MB)
MP4
85 - StringExercise 11.mp4 (9.4 MB)
MP4
86 - Arithmetic Operators.mp4 (34.72 MB)
MP4
87 - Logical Operators.mp4 (41.84 MB)
MP4
88 - CASEWHEN.mp4 (47 MB)
MP4
89 - OperatorsExercise 1.mp4 (18.52 MB)
MP4
90 - OperatorsExercise 2.mp4 (11.9 MB)
MP4
91 - OperatorsExercise 3.mp4 (8.78 MB)
MP4
92 - OperatorsExercise 4.mp4 (11.32 MB)
MP4
93 - OperatorsExercise 5.mp4 (14.29 MB)
MP4
94 - OperatorsExercise 6.mp4 (15.23 MB)
MP4
100 - SubqueriesCTEExercise 3.mp4 (6.2 MB)
MP4
101 - SubqueriesCTEExercise 4.mp4 (9.69 MB)
MP4
95 - Sub Queries.mp4 (28.04 MB)
MP4
96 - Common Table Expressions CTEs.mp4 (31.09 MB)
MP4
97 - Common Table Expression Recursive.mp4 (13.8 MB)
MP4
98 - SubqueriesCTEExercise 1.mp4 (10.78 MB)
MP4
99 - SubqueriesCTEExercise 2.mp4 (15.91 MB)
MP4
102 - JOINs Introduction.mp4 (55.48 MB)
MP4
103 - LEFT JOIN.mp4 (36.72 MB)
MP4
104 - LEFT JOIN Exclusive.mp4 (6.44 MB)
MP4
105 - RIGHT JOIN.mp4 (23.54 MB)
MP4
106 - RIGHT JOIN Exclusive.mp4 (3.52 MB)
MP4
107 - INNER JOIN.mp4 (17.59 MB)
MP4
108 - OUTER JOIN.mp4 (14.13 MB)
MP4
109 - OUTER JOIN Exclusive.mp4 (5.41 MB)
MP4
110 - CROSS JOIN.mp4 (16.49 MB)
MP4
111 - JOINexercise 1.mp4 (15.16 MB)
MP4
112 - JOINexercise 2.mp4 (7.28 MB)
MP4
113 - JOINexercise 3.mp4 (6.07 MB)
MP4
114 - JOINexercise 4.mp4 (9.62 MB)
MP4
115 - JOINexercise 5.mp4 (6.88 MB)
MP4
116 - JOINexercise 6.mp4 (6.52 MB)
MP4
117 - JOINexercise 7.mp4 (11.42 MB)
MP4
118 - JOINexercise 8.mp4 (28.44 MB)
MP4
119 - Nested Repeated Structures Introductions.mp4 (33.5 MB)
MP4
120 - Nested.mp4 (37.68 MB)
MP4
121 - Repeated.mp4 (34.63 MB)
MP4
122 - Nested Repeated.mp4 (37.83 MB)
MP4
123 - NestedRepeated Exercise 1.mp4 (24.71 MB)
MP4
124 - NestedRepeated Exercise 2.mp4 (8.79 MB)
MP4
125 - NestedRepeated Exercise 3.mp4 (8.72 MB)
MP4
126 - NestedRepeated Exercise 4.mp4 (19.27 MB)
MP4
127 - NestedRepeated Exercise 5.mp4 (30.22 MB)
MP4
128 - Window Functions Intro.mp4 (40.41 MB)
MP4
129 - Syntax.mp4 (31.61 MB)
MP4
130 - Aggregate Window Function.mp4 (57.67 MB)
MP4
131 - Navigation Windown Function LAG LEAD.mp4 (28.46 MB)
MP4
132 - Navigation Windown Function FIRST LAST Value.mp4 (45.58 MB)
MP4
133 - Navigation Windown Function RANK.mp4 (18.64 MB)
MP4
134 - Navigation Windown Function DENSE RANK.mp4 (12.27 MB)
MP4
135 - Navigation Windown Function Documentation Walkthrough.mp4 (18.9 MB)
MP4
136 - Navigation Windown Function ROW NUMBER.mp4 (23.16 MB)
MP4
137 - WindowFunctions Exercise 1.mp4 (16.42 MB)
MP4
138 - WindowFunctions Exercise 2.mp4 (9.52 MB)
MP4
139 - WindowFunctions Exercise 3.mp4 (15.32 MB)
MP4
140 - WindowFunctions Exercise 4.mp4 (20.66 MB)
MP4
141 - WindowFunctions Exercise 5.mp4 (23.4 MB)
MP4
4 - BigQuery Setup.mp4 (25.53 MB)
MP4
5 - Resources.mp4 (62.86 MB)
MP4
6 - Setting up Dataset Table.mp4 (35.38 MB)
MP4
7 - dbt Setup.mp4 (144.19 MB)
MP4
142 - Templating Introduction.mp4 (17.42 MB)
MP4
143 - JINJA SQL.mp4 (38.7 MB)
MP4
144 - dbt Overview.mp4 (17.72 MB)
MP4
145 - dbt Role in a Data Warehouse.mp4 (15.32 MB)
MP4
146 - dbt Examples.mp4 (58.22 MB)
MP4
147 - Best Practices Introductions.mp4 (3.27 MB)
MP4
148 - Code Formatting.mp4 (18.25 MB)
MP4
149 - SELECT.mp4 (5.12 MB)
MP4
150 - ALIAS.mp4 (7.22 MB)
MP4
151 - Explicit JOIN.mp4 (4.64 MB)
MP4
152 - Filtering.mp4 (12.84 MB)
MP4
153 - ORDER BY.mp4 (4.43 MB)
MP4
154 - UNION ALL.mp4 (3.46 MB)
MP4
155 - Comments.mp4 (5.41 MB)
MP4
156 - CTEs.mp4 (4.57 MB)
MP4
157 - DRY Dont repeat yourself.mp4 (6.68 MB)
MP4
159 - Wrap Up.mp4 (1.62 MB)
MP4
10 - Database Data Warehouse.mp4 (26.68 MB)
MP4
8 - History of SQL.mp4 (13.99 MB)
MP4
9 - What is SQL.mp4 (16.72 MB)
MP4
11 - BigQuery Introduction.mp4 (22.11 MB)
MP4
12 - BigQuery Interface Walkthrough.mp4 (79.11 MB)
MP4
13 - Basic SQL Structure.mp4 (28.53 MB)
MP4
14 - SELECT.mp4 (34.2 MB)
MP4
15 - ALIAS.mp4 (26.86 MB)
MP4
16 - WHERE.mp4 (20.03 MB)
MP4
17 - GROUP BY.mp4 (15.29 MB)
MP4
18 - HAVING.mp4 (9.96 MB)
MP4
19 - ORDER BY.mp4 (10.72 MB)
MP4
20 - LIMIT.mp4 (9.35 MB)
MP4
21 - Order of True SQL Pt 1.mp4 (13.84 MB)
MP4
22 - Order of True SQL Pt 2.mp4 (22.97 MB)
MP4
23 - Order of True SQL Exercise.mp4 (13.49 MB)
MP4
24 - Schema.mp4 (17.31 MB)
MP4
25 - Data Types Intro.mp4 (2.11 MB)
MP4
26 - Data Types MySQL.mp4 (15.3 MB)
MP4
27 - Data Types BigQuery.mp4 (48.63 MB)
MP4
28 - Data Types Recap.mp4 (4.15 MB)
MP4
29 - Important SQL Commands.mp4 (22.38 MB)
MP4