|
|
01-ddl-dml-exercise-solutions.sql
|
SQL
|
5.6 KB
|
|
|
01-ddl-dml-exercise.sql
|
SQL
|
3.7 KB
|
|
|
02-aggregate-exercise-solutions.sql
|
SQL
|
3.2 KB
|
|
|
02-aggregate-exercise.sql
|
SQL
|
819.2 B
|
|
|
03-string-exercise-solutions.sql
|
SQL
|
4.3 KB
|
|
|
03-string-exercise.sql
|
SQL
|
1.4 KB
|
|
|
04-sql-operators-exercise-solutions.sql
|
SQL
|
3.9 KB
|
|
|
04-sql-operators-exercise.sql
|
SQL
|
1.2 KB
|
|
|
05-sub-queries-cte-exercise-solutions.sql
|
SQL
|
2.3 KB
|
|
|
05-sub-queries-cte-exercise.sql
|
SQL
|
409.6 B
|
|
|
06-joins-exercise-solutions.sql
|
SQL
|
5 KB
|
|
|
06-joins-exercise.sql
|
SQL
|
1.8 KB
|
|
|
07-nested-repeated-exercise-solutions.sql
|
SQL
|
7.8 KB
|
|
|
07-nested-repeated-exercise.sql
|
SQL
|
3.3 KB
|
|
|
08-window-function-exercise-solutions.sql
|
SQL
|
2.9 KB
|
|
|
08-window-function-exercise.sql
|
SQL
|
716.8 B
|
|
|
09-case-study-1-exercise-solutions.sql
|
SQL
|
6.9 KB
|
|
|
09-case-study-1-exercise.sql
|
SQL
|
2.5 KB
|
|
|
1 - Welcome.mp4
|
MP4
|
7.6 MB
|
|
|
10 - Database Data Warehouse.mp4
|
MP4
|
26.7 MB
|
|
|
100 - SubqueriesCTEExercise 3.mp4
|
MP4
|
6.2 MB
|
|
|
101 - SubqueriesCTEExercise 4.mp4
|
MP4
|
9.7 MB
|
|
|
102 - JOINs Introduction.mp4
|
MP4
|
55.5 MB
|
|
|
103 - LEFT JOIN.mp4
|
MP4
|
36.7 MB
|
|
|
104 - LEFT JOIN Exclusive.mp4
|
MP4
|
6.4 MB
|
|
|
105 - RIGHT JOIN.mp4
|
MP4
|
23.5 MB
|
|
|
106 - RIGHT JOIN Exclusive.mp4
|
MP4
|
3.5 MB
|
|
|
107 - INNER JOIN.mp4
|
MP4
|
17.6 MB
|
|
|
108 - OUTER JOIN.mp4
|
MP4
|
14.1 MB
|
|
|
109 - OUTER JOIN Exclusive.mp4
|
MP4
|
5.4 MB
|
|
|
11 - BigQuery Introduction.mp4
|
MP4
|
22.1 MB
|
|
|
110 - CROSS JOIN.mp4
|
MP4
|
16.5 MB
|
|
|
111 - JOINexercise 1.mp4
|
MP4
|
15.2 MB
|
|
|
112 - JOINexercise 2.mp4
|
MP4
|
7.3 MB
|
|
|
113 - JOINexercise 3.mp4
|
MP4
|
6.1 MB
|
|
|
114 - JOINexercise 4.mp4
|
MP4
|
9.6 MB
|
|
|
115 - JOINexercise 5.mp4
|
MP4
|
6.9 MB
|
|
|
116 - JOINexercise 6.mp4
|
MP4
|
6.5 MB
|
|
|
117 - JOINexercise 7.mp4
|
MP4
|
11.4 MB
|
|
|
118 - JOINexercise 8.mp4
|
MP4
|
28.4 MB
|
|
|
119 - Nested Repeated Structures Introductions.mp4
|
MP4
|
33.5 MB
|
|
|
12 - BigQuery Interface Walkthrough.mp4
|
MP4
|
79.1 MB
|
|
|
120 - Nested.mp4
|
MP4
|
37.7 MB
|
|
|
121 - Repeated.mp4
|
MP4
|
34.6 MB
|
|
|
122 - Nested Repeated.mp4
|
MP4
|
37.8 MB
|
|
|
123 - NestedRepeated Exercise 1.mp4
|
MP4
|
24.7 MB
|
|
|
124 - NestedRepeated Exercise 2.mp4
|
MP4
|
8.8 MB
|
|
|
125 - NestedRepeated Exercise 3.mp4
|
MP4
|
8.7 MB
|
|
|
126 - NestedRepeated Exercise 4.mp4
|
MP4
|
19.3 MB
|
|
|
127 - NestedRepeated Exercise 5.mp4
|
MP4
|
30.2 MB
|
|
|
128 - Window Functions Intro.mp4
|
MP4
|
40.4 MB
|
|
|
129 - Syntax.mp4
|
MP4
|
31.6 MB
|
|
|
13 - Basic SQL Structure.mp4
|
MP4
|
28.5 MB
|
|
|
130 - Aggregate Window Function.mp4
|
MP4
|
57.7 MB
|
|
|
131 - Navigation Windown Function LAG LEAD.mp4
|
MP4
|
28.5 MB
|
|
|
132 - Navigation Windown Function FIRST LAST Value.mp4
|
MP4
|
45.6 MB
|
|
|
133 - Navigation Windown Function RANK.mp4
|
MP4
|
18.6 MB
|
|
|
134 - Navigation Windown Function DENSE RANK.mp4
|
MP4
|
12.3 MB
|
|
|
135 - Navigation Windown Function Documentation Walkthrough.mp4
|
MP4
|
18.9 MB
|
|
|
136 - Navigation Windown Function ROW NUMBER.mp4
|
MP4
|
23.2 MB
|
|
|
137 - WindowFunctions Exercise 1.mp4
|
MP4
|
16.4 MB
|
|
|
138 - WindowFunctions Exercise 2.mp4
|
MP4
|
9.5 MB
|
|
|
139 - WindowFunctions Exercise 3.mp4
|
MP4
|
15.3 MB
|
|
|
14 - SELECT.mp4
|
MP4
|
34.2 MB
|
|
|
140 - WindowFunctions Exercise 4.mp4
|
MP4
|
20.7 MB
|
|
|
141 - WindowFunctions Exercise 5.mp4
|
MP4
|
23.4 MB
|
|
|
142 - Templating Introduction.mp4
|
MP4
|
17.4 MB
|
|
|
143 - JINJA SQL.mp4
|
MP4
|
38.7 MB
|
|
|
144 - dbt Overview.mp4
|
MP4
|
17.7 MB
|
|
|
145 - dbt Role in a Data Warehouse.mp4
|
MP4
|
15.3 MB
|
|
|
146 - dbt Examples.mp4
|
MP4
|
58.2 MB
|
|
|
147 - Best Practices Introductions.mp4
|
MP4
|
3.3 MB
|
|
|
148 - Code Formatting.mp4
|
MP4
|
18.2 MB
|
|
|
149 - SELECT.mp4
|
MP4
|
5.1 MB
|
|
|
15 - ALIAS.mp4
|
MP4
|
26.9 MB
|
|
|
150 - ALIAS.mp4
|
MP4
|
7.2 MB
|
|
|
151 - Explicit JOIN.mp4
|
MP4
|
4.6 MB
|
|
|
152 - Filtering.mp4
|
MP4
|
12.8 MB
|
|
|
153 - ORDER BY.mp4
|
MP4
|
4.4 MB
|
|
|
154 - UNION ALL.mp4
|
MP4
|
3.5 MB
|
|
|
155 - Comments.mp4
|
MP4
|
5.4 MB
|
|
|
156 - CTEs.mp4
|
MP4
|
4.6 MB
|
|
|
157 - DRY Dont repeat yourself.mp4
|
MP4
|
6.7 MB
|
|
|
158 - UseCase Intro Questions.html
|
HTML
|
3.8 KB
|
|
|
159 - Wrap Up.mp4
|
MP4
|
1.6 MB
|
|
|
16 - WHERE.mp4
|
MP4
|
20 MB
|
|
|
17 - GROUP BY.mp4
|
MP4
|
15.3 MB
|
|
|
18 - HAVING.mp4
|
MP4
|
10 MB
|
|
|
19 - ORDER BY.mp4
|
MP4
|
10.7 MB
|
|
|
2 - Course Overview.mp4
|
MP4
|
16.7 MB
|
|
|
20 - LIMIT.mp4
|
MP4
|
9.3 MB
|
|
|
21 - Order of True SQL Pt 1.mp4
|
MP4
|
13.8 MB
|
|
|
22 - Order of True SQL Pt 2.mp4
|
MP4
|
23 MB
|
|
|
23 - Order of True SQL Exercise.mp4
|
MP4
|
13.5 MB
|
|
|
24 - Schema.mp4
|
MP4
|
17.3 MB
|
|
|
25 - Data Types Intro.mp4
|
MP4
|
2.1 MB
|
|
|
26 - Data Types MySQL.mp4
|
MP4
|
15.3 MB
|
|
|
27 - Data Types BigQuery.mp4
|
MP4
|
48.6 MB
|
|
|
28 - Data Types Recap.mp4
|
MP4
|
4.1 MB
|
|
|
29 - Important SQL Commands.mp4
|
MP4
|
22.4 MB
|
|
|
3 - How to get best out of this course.mp4
|
MP4
|
11.9 MB
|
|
|
30 - CREATE.mp4
|
MP4
|
22.6 MB
|
|
|
31 - ALTER.mp4
|
MP4
|
9.9 MB
|
|
|
32 - DROP.mp4
|
MP4
|
6.5 MB
|
|
|
33 - INSERT.mp4
|
MP4
|
16.3 MB
|
|
|
34 - UPDATE.mp4
|
MP4
|
11.5 MB
|
|
|
35 - TRUNCATE.mp4
|
MP4
|
12.9 MB
|
|
|
36 - DELETE.mp4
|
MP4
|
8.6 MB
|
|
|
37 - MERGE Pt 1.mp4
|
MP4
|
21.1 MB
|
|
|
38 - MERGE Pt 2.mp4
|
MP4
|
81.9 MB
|
|
|
39 - DDLDMLExercise 1.mp4
|
MP4
|
20 MB
|
|
|
4 - BigQuery Setup.mp4
|
MP4
|
25.5 MB
|
|
|
40 - DDLDMLExercise 2.mp4
|
MP4
|
10.4 MB
|
|
|
41 - DDLDMLExercise 3.mp4
|
MP4
|
5.7 MB
|
|
|
42 - DDLDMLExercise 4.mp4
|
MP4
|
5.4 MB
|
|
|
43 - DDLDMLExercise 5.mp4
|
MP4
|
12 MB
|
|
|
44 - DDLDMLExercise 6.mp4
|
MP4
|
9.9 MB
|
|
|
45 - DDLDMLExercise 7.mp4
|
MP4
|
10.2 MB
|
|
|
46 - DDLDMLExercise 8.mp4
|
MP4
|
9.5 MB
|
|
|
47 - DDLDMLExercise 9.mp4
|
MP4
|
7 MB
|
|
|
48 - DDLDMLExercise 10.mp4
|
MP4
|
8.3 MB
|
|
|
49 - DDLDMLExercise 11.mp4
|
MP4
|
8.5 MB
|
|
|
5 - Resources.mp4
|
MP4
|
62.9 MB
|
|
|
50 - SUM.mp4
|
MP4
|
53.8 MB
|
|
|
51 - COUNT.mp4
|
MP4
|
40.3 MB
|
|
|
52 - COUNTIF.mp4
|
MP4
|
22.3 MB
|
|
|
53 - AVG.mp4
|
MP4
|
18.3 MB
|
|
|
54 - MINMAX.mp4
|
MP4
|
58.3 MB
|
|
|
55 - AggregateExercise 1.mp4
|
MP4
|
20 MB
|
|
|
56 - AggregateExercise 2.mp4
|
MP4
|
9 MB
|
|
|
57 - AggregateExercise 3.mp4
|
MP4
|
8.7 MB
|
|
|
58 - AggregateExercise 4.mp4
|
MP4
|
14.8 MB
|
|
|
59 - AggregateExercise 5.mp4
|
MP4
|
7.1 MB
|
|
|
6 - Setting up Dataset Table.mp4
|
MP4
|
35.4 MB
|
|
|
60 - AggregateExercise 6.mp4
|
MP4
|
10.9 MB
|
|
|
61 - AggregateExercise 7.mp4
|
MP4
|
5.8 MB
|
|
|
62 - AggregateExercise 8.mp4
|
MP4
|
4.8 MB
|
|
|
63 - AggregateExercise 9.mp4
|
MP4
|
4.5 MB
|
|
|
64 - AggregateExercise 10.mp4
|
MP4
|
6.3 MB
|
|
|
65 - AggregateExercise 11.mp4
|
MP4
|
6.9 MB
|
|
|
66 - AggregateExercise 12.mp4
|
MP4
|
6.4 MB
|
|
|
67 - CONCAT.mp4
|
MP4
|
19.2 MB
|
|
|
68 - REPLACE.mp4
|
MP4
|
20.8 MB
|
|
|
69 - LOWER.mp4
|
MP4
|
7.7 MB
|
|
|
7 - dbt Setup.mp4
|
MP4
|
144.2 MB
|
|
|
70 - UPPER.mp4
|
MP4
|
12.1 MB
|
|
|
71 - NORMALIZE.mp4
|
MP4
|
38.2 MB
|
|
|
72 - SPLIT.mp4
|
MP4
|
18.9 MB
|
|
|
73 - LEFTRIGHT.mp4
|
MP4
|
16.8 MB
|
|
|
74 - TRIM.mp4
|
MP4
|
7.6 MB
|
|
|
75 - StringExercise 1.mp4
|
MP4
|
6.9 MB
|
|
|
76 - StringExercise 2.mp4
|
MP4
|
10.1 MB
|
|
|
77 - StringExercise 3.mp4
|
MP4
|
8.9 MB
|
|
|
78 - StringExercise 4.mp4
|
MP4
|
12.9 MB
|
|
|
79 - StringExercise 5.mp4
|
MP4
|
5 MB
|
|
|
8 - History of SQL.mp4
|
MP4
|
14 MB
|
|
|
80 - StringExercise 6.mp4
|
MP4
|
8.7 MB
|
|
|
81 - StringExercise 7.mp4
|
MP4
|
13.5 MB
|
|
|
82 - StringExercise 8.mp4
|
MP4
|
9 MB
|
|
|
83 - StringExercise 9.mp4
|
MP4
|
26.7 MB
|
|
|
84 - StringExercise 10.mp4
|
MP4
|
7.5 MB
|
|
|
85 - StringExercise 11.mp4
|
MP4
|
9.4 MB
|
|
|
86 - Arithmetic Operators.mp4
|
MP4
|
34.7 MB
|
|
|
87 - Logical Operators.mp4
|
MP4
|
41.8 MB
|
|
|
88 - CASEWHEN.mp4
|
MP4
|
47 MB
|
|
|
89 - OperatorsExercise 1.mp4
|
MP4
|
18.5 MB
|
|
|
9 - What is SQL.mp4
|
MP4
|
16.7 MB
|
|
|
90 - OperatorsExercise 2.mp4
|
MP4
|
11.9 MB
|
|
|
91 - OperatorsExercise 3.mp4
|
MP4
|
8.8 MB
|
|
|
92 - OperatorsExercise 4.mp4
|
MP4
|
11.3 MB
|
|
|
93 - OperatorsExercise 5.mp4
|
MP4
|
14.3 MB
|
|
|
94 - OperatorsExercise 6.mp4
|
MP4
|
15.2 MB
|
|
|
95 - Sub Queries.mp4
|
MP4
|
28 MB
|
|
|
96 - Common Table Expressions CTEs.mp4
|
MP4
|
31.1 MB
|
|
|
97 - Common Table Expression Recursive.mp4
|
MP4
|
13.8 MB
|
|
|
98 - SubqueriesCTEExercise 1.mp4
|
MP4
|
10.8 MB
|
|
|
99 - SubqueriesCTEExercise 2.mp4
|
MP4
|
15.9 MB
|
|
|
Bonus Resources.txt
|
TXT
|
409.6 B
|
|
|
DS_Store
|
|
6 KB
|
|
|
Get Bonus Downloads Here.url
|
URL
|
204.8 B
|
|
|
README.md
|
MD
|
6.5 KB
|
|
|
_.DS_Store
|
DS_STORE
|
102.4 B
|
|
|
_01-ddl-dml-exercise-solutions.sql
|
SQL
|
204.8 B
|
|
|
_01-ddl-dml-exercise.sql
|
SQL
|
204.8 B
|
|
|
_02-aggregate-exercise-solutions.sql
|
SQL
|
307.2 B
|
|
|
_02-aggregate-exercise.sql
|
SQL
|
307.2 B
|
|
|
_03-string-exercise-solutions.sql
|
SQL
|
204.8 B
|
|
|
_03-string-exercise.sql
|
SQL
|
204.8 B
|
|
|
_04-sql-operators-exercise-solutions.sql
|
SQL
|
307.2 B
|
|
|
_04-sql-operators-exercise.sql
|
SQL
|
307.2 B
|
|
|
_05-sub-queries-cte-exercise-solutions.sql
|
SQL
|
204.8 B
|
|
|
_05-sub-queries-cte-exercise.sql
|
SQL
|
204.8 B
|
|
|
_06-joins-exercise-solutions.sql
|
SQL
|
307.2 B
|
|
|
_06-joins-exercise.sql
|
SQL
|
307.2 B
|
|
|
_07-nested-repeated-exercise-solutions.sql
|
SQL
|
307.2 B
|
|
|
_07-nested-repeated-exercise.sql
|
SQL
|
307.2 B
|
|
|
_08-window-function-exercise-solutions.sql
|
SQL
|
204.8 B
|
|
|
_08-window-function-exercise.sql
|
SQL
|
204.8 B
|
|
|
_09-case-study-1-exercise-solutions.sql
|
SQL
|
204.8 B
|
|
|
_09-case-study-1-exercise.sql
|
SQL
|
204.8 B
|
|
|
_README.md
|
MD
|
204.8 B
|
|
|
_jinjasql-sudo-code.py
|
PY
|
204.8 B
|
|
|
_sql-code-from-lectures.sql
|
SQL
|
204.8 B
|
|
|
_sql-primer-dim-date.csv
|
CSV
|
204.8 B
|
|
|
_sql-primer-table-customer-source.csv
|
CSV
|
204.8 B
|
|
|
_sql-primer-table-customer-target.csv
|
CSV
|
204.8 B
|
|
|
_sql-primer-table-customer.csv
|
CSV
|
204.8 B
|
|
|
_sql-primer-table-orders.csv
|
CSV
|
204.8 B
|
|
|
_the-sql-primer-resources
|
|
204.8 B
|
|
|
jinjasql-sudo-code.py
|
PY
|
1 KB
|
|
|
sql-code-from-lectures.sql
|
SQL
|
25.8 KB
|
|
|
sql-primer-dim-date.csv
|
CSV
|
347.9 KB
|
|
|
sql-primer-table-customer-source.csv
|
CSV
|
2.2 KB
|
|
|
sql-primer-table-customer-target.csv
|
CSV
|
201.5 KB
|
|
|
sql-primer-table-customer.csv
|
CSV
|
201.5 KB
|
|
|
sql-primer-table-orders.csv
|
CSV
|
164.8 KB
|
