DevCourseWeb com Udemy The Sql Primer Masterclass | C99FCD74A4C7F6D9790812B7AF920AEFFF8BE9E8

DevCourseWeb com Udemy The Sql Primer Masterclass

Name	[ DevCourseWeb.com ] Udemy - The Sql Primer Masterclass	DOWNLOAD Copy Link
Total Size	3.2 GB
Total Files	226
Last Seen	2024-07-04 23:53
Hash	C99FCD74A4C7F6D9790812B7AF920AEFFF8BE9E8

/
Get Bonus Downloads Here.url	0.2 KB
/1 - Course Introduction/
1 - Welcome.mp4	8.0 MB
2 - Course Overview.mp4	17.5 MB
3 - How to get best out of this course.mp4	12.4 MB
/.../10 - Data Definition Language DDL/
30 - CREATE.mp4	23.6 MB
31 - ALTER.mp4	10.4 MB
32 - DROP.mp4	6.9 MB
/.../11 - Data Manipulation Language DML/
33 - INSERT.mp4	17.1 MB
34 - UPDATE.mp4	12.0 MB
35 - TRUNCATE.mp4	13.5 MB
36 - DELETE.mp4	9.0 MB
37 - MERGE Pt 1.mp4	22.1 MB
38 - MERGE Pt 2.mp4	85.8 MB
/.../12 - DDL DML Exercises/
39 - DDLDMLExercise 1.mp4	21.0 MB
40 - DDLDMLExercise 2.mp4	10.9 MB
41 - DDLDMLExercise 3.mp4	6.0 MB
42 - DDLDMLExercise 4.mp4	5.6 MB
43 - DDLDMLExercise 5.mp4	12.6 MB
44 - DDLDMLExercise 6.mp4	10.4 MB
45 - DDLDMLExercise 7.mp4	10.7 MB
46 - DDLDMLExercise 8.mp4	10.0 MB
47 - DDLDMLExercise 9.mp4	7.3 MB
48 - DDLDMLExercise 10.mp4	8.7 MB
49 - DDLDMLExercise 11.mp4	8.9 MB
/.../13 - AGGREGATE Functions/
50 - SUM.mp4	56.4 MB
51 - COUNT.mp4	42.3 MB
52 - COUNTIF.mp4	23.4 MB
53 - AVG.mp4	19.2 MB
54 - MINMAX.mp4	61.1 MB
55 - AggregateExercise 1.mp4	21.0 MB
56 - AggregateExercise 2.mp4	9.5 MB
57 - AggregateExercise 3.mp4	9.2 MB
58 - AggregateExercise 4.mp4	15.5 MB
59 - AggregateExercise 5.mp4	7.4 MB
60 - AggregateExercise 6.mp4	11.4 MB
61 - AggregateExercise 7.mp4	6.1 MB
62 - AggregateExercise 8.mp4	5.0 MB
63 - AggregateExercise 9.mp4	4.7 MB
64 - AggregateExercise 10.mp4	6.6 MB
65 - AggregateExercise 11.mp4	7.2 MB
66 - AggregateExercise 12.mp4	6.7 MB
/.../14 - STRING Functions/
67 - CONCAT.mp4	20.1 MB
68 - REPLACE.mp4	21.8 MB
69 - LOWER.mp4	8.1 MB
70 - UPPER.mp4	12.7 MB
71 - NORMALIZE.mp4	40.1 MB
72 - SPLIT.mp4	19.8 MB
73 - LEFTRIGHT.mp4	17.6 MB
74 - TRIM.mp4	7.9 MB
75 - StringExercise 1.mp4	7.3 MB
76 - StringExercise 2.mp4	10.5 MB
77 - StringExercise 3.mp4	9.4 MB
78 - StringExercise 4.mp4	13.5 MB
79 - StringExercise 5.mp4	5.2 MB
80 - StringExercise 6.mp4	9.1 MB
81 - StringExercise 7.mp4	14.1 MB
82 - StringExercise 8.mp4	9.4 MB
83 - StringExercise 9.mp4	28.0 MB
84 - StringExercise 10.mp4	7.9 MB
85 - StringExercise 11.mp4	9.9 MB
/.../15 - SQL Operators/
86 - Arithmetic Operators.mp4	36.4 MB
87 - Logical Operators.mp4	43.9 MB
88 - CASEWHEN.mp4	49.3 MB
89 - OperatorsExercise 1.mp4	19.4 MB
90 - OperatorsExercise 2.mp4	12.5 MB
91 - OperatorsExercise 3.mp4	9.2 MB
92 - OperatorsExercise 4.mp4	11.9 MB
93 - OperatorsExercise 5.mp4	15.0 MB
94 - OperatorsExercise 6.mp4	16.0 MB
/.../16 - SUBQUERIES CTEs/
100 - SubqueriesCTEExercise 3.mp4	6.5 MB
101 - SubqueriesCTEExercise 4.mp4	10.2 MB
95 - Sub Queries.mp4	29.4 MB
96 - Common Table Expressions CTEs.mp4	32.6 MB
97 - Common Table Expression Recursive.mp4	14.5 MB
98 - SubqueriesCTEExercise 1.mp4	11.3 MB
99 - SubqueriesCTEExercise 2.mp4	16.7 MB
/17 - JOINs/
102 - JOINs Introduction.mp4	58.2 MB
103 - LEFT JOIN.mp4	38.5 MB
104 - LEFT JOIN Exclusive.mp4	6.8 MB
105 - RIGHT JOIN.mp4	24.7 MB
106 - RIGHT JOIN Exclusive.mp4	3.7 MB
107 - INNER JOIN.mp4	18.4 MB
108 - OUTER JOIN.mp4	14.8 MB
109 - OUTER JOIN Exclusive.mp4	5.7 MB
110 - CROSS JOIN.mp4	17.3 MB
111 - JOINexercise 1.mp4	15.9 MB
112 - JOINexercise 2.mp4	7.6 MB
113 - JOINexercise 3.mp4	6.4 MB
114 - JOINexercise 4.mp4	10.1 MB
115 - JOINexercise 5.mp4	7.2 MB
116 - JOINexercise 6.mp4	6.8 MB
117 - JOINexercise 7.mp4	12.0 MB
118 - JOINexercise 8.mp4	29.8 MB
/.../18 - Nested Repeated Structures/
119 - Nested Repeated Structures Introductions.mp4	35.1 MB
120 - Nested.mp4	39.5 MB
121 - Repeated.mp4	36.3 MB
122 - Nested Repeated.mp4	39.7 MB
123 - NestedRepeated Exercise 1.mp4	25.9 MB
124 - NestedRepeated Exercise 2.mp4	9.2 MB
125 - NestedRepeated Exercise 3.mp4	9.1 MB
126 - NestedRepeated Exercise 4.mp4	20.2 MB
127 - NestedRepeated Exercise 5.mp4	31.7 MB
/.../19 - WINDOW Analytics Functions/
128 - Window Functions Intro.mp4	42.4 MB
129 - Syntax.mp4	33.1 MB
130 - Aggregate Window Function.mp4	60.5 MB
131 - Navigation Windown Function LAG LEAD.mp4	29.8 MB
132 - Navigation Windown Function FIRST LAST Value.mp4	47.8 MB
133 - Navigation Windown Function RANK.mp4	19.5 MB
134 - Navigation Windown Function DENSE RANK.mp4	12.9 MB
135 - Navigation Windown Function Documentation Walkthrough.mp4	19.8 MB
136 - Navigation Windown Function ROW NUMBER.mp4	24.3 MB
137 - WindowFunctions Exercise 1.mp4	17.2 MB
138 - WindowFunctions Exercise 2.mp4	10.0 MB
139 - WindowFunctions Exercise 3.mp4	16.1 MB
140 - WindowFunctions Exercise 4.mp4	21.7 MB
141 - WindowFunctions Exercise 5.mp4	24.5 MB
/.../2 - Setting up Resources/
4 - BigQuery Setup.mp4	26.8 MB
5 - Resources.mp4	65.9 MB
6 - Setting up Dataset Table.mp4	37.1 MB
7 - dbt Setup.mp4	151.2 MB
/.../2 - Setting up Resources/__MACOSX/
_the-sql-primer-resources	0.2 KB
/.../the-sql-primer-resources/
_.DS_Store	0.1 KB
_README.md	0.2 KB
/.../the-sql-primer-resources/exercises/
_.DS_Store	0.1 KB
/.../the-sql-primer-resources/exercises/exercises/
_.DS_Store	0.1 KB
_01-ddl-dml-exercise.sql	0.2 KB
_02-aggregate-exercise.sql	0.3 KB
_03-string-exercise.sql	0.2 KB
_04-sql-operators-exercise.sql	0.3 KB
_05-sub-queries-cte-exercise.sql	0.2 KB
_06-joins-exercise.sql	0.3 KB
_07-nested-repeated-exercise.sql	0.3 KB
_08-window-function-exercise.sql	0.2 KB
_09-case-study-1-exercise.sql	0.2 KB
/.../the-sql-primer-resources/exercises/solutions/
_.DS_Store	0.1 KB
_01-ddl-dml-exercise-solutions.sql	0.2 KB
_02-aggregate-exercise-solutions.sql	0.3 KB
_03-string-exercise-solutions.sql	0.2 KB
_04-sql-operators-exercise-solutions.sql	0.3 KB
_05-sub-queries-cte-exercise-solutions.sql	0.2 KB
_06-joins-exercise-solutions.sql	0.3 KB
_07-nested-repeated-exercise-solutions.sql	0.3 KB
_08-window-function-exercise-solutions.sql	0.2 KB
_09-case-study-1-exercise-solutions.sql	0.2 KB
/.../lecture-sql-code/
_.DS_Store	0.1 KB
_jinjasql-sudo-code.py	0.2 KB
_sql-code-from-lectures.sql	0.2 KB
/.../the-sql-primer-resources/sample-data/
_.DS_Store	0.1 KB
_sql-primer-dim-date.csv	0.2 KB
_sql-primer-table-customer-source.csv	0.2 KB
_sql-primer-table-customer-target.csv	0.2 KB
_sql-primer-table-customer.csv	0.2 KB
_sql-primer-table-orders.csv	0.2 KB
/.../the-sql-primer-resources/
DS_Store	14.3 KB
README.md	6.6 KB
/.../the-sql-primer-resources/exercises/
DS_Store	6.1 KB
/.../the-sql-primer-resources/exercises/exercises/
01-ddl-dml-exercise.sql	3.8 KB
02-aggregate-exercise.sql	0.8 KB
03-string-exercise.sql	1.5 KB
04-sql-operators-exercise.sql	1.2 KB
05-sub-queries-cte-exercise.sql	0.4 KB
06-joins-exercise.sql	1.9 KB
07-nested-repeated-exercise.sql	3.4 KB
08-window-function-exercise.sql	0.8 KB
09-case-study-1-exercise.sql	2.5 KB
DS_Store	6.1 KB
/.../the-sql-primer-resources/exercises/solutions/
01-ddl-dml-exercise-solutions.sql	5.8 KB
02-aggregate-exercise-solutions.sql	3.3 KB
03-string-exercise-solutions.sql	4.4 KB
04-sql-operators-exercise-solutions.sql	3.9 KB
05-sub-queries-cte-exercise-solutions.sql	2.4 KB
06-joins-exercise-solutions.sql	5.2 KB
07-nested-repeated-exercise-solutions.sql	8.0 KB
08-window-function-exercise-solutions.sql	3.0 KB
09-case-study-1-exercise-solutions.sql	7.0 KB
DS_Store	6.1 KB
/.../lecture-sql-code/
DS_Store	6.1 KB
jinjasql-sudo-code.py	1.0 KB
sql-code-from-lectures.sql	26.4 KB
/.../the-sql-primer-resources/sample-data/
DS_Store	6.1 KB
sql-primer-dim-date.csv	356.3 KB
sql-primer-table-customer-source.csv	2.2 KB
sql-primer-table-customer-target.csv	206.3 KB
sql-primer-table-customer.csv	206.3 KB
sql-primer-table-orders.csv	168.8 KB
/.../20 - Templated SQL/
142 - Templating Introduction.mp4	18.3 MB
143 - JINJA SQL.mp4	40.6 MB
/.../21 - dbt Data Build Tool/
144 - dbt Overview.mp4	18.6 MB
145 - dbt Role in a Data Warehouse.mp4	16.1 MB
146 - dbt Examples.mp4	61.0 MB
/.../22 - SQL Best Practices/
147 - Best Practices Introductions.mp4	3.4 MB
148 - Code Formatting.mp4	19.1 MB
149 - SELECT.mp4	5.4 MB
150 - ALIAS.mp4	7.6 MB
151 - Explicit JOIN.mp4	4.9 MB
152 - Filtering.mp4	13.5 MB
153 - ORDER BY.mp4	4.6 MB
154 - UNION ALL.mp4	3.6 MB
155 - Comments.mp4	5.7 MB
156 - CTEs.mp4	4.8 MB
157 - DRY Dont repeat yourself.mp4	7.0 MB
/.../23 - UseCase 1 Airbnb/
158 - UseCase Intro Questions.html	3.9 KB
/.../24 - Wrap Up/
159 - Wrap Up.mp4	1.7 MB
/3 - Basic SQL/
10 - Database Data Warehouse.mp4	28.0 MB
8 - History of SQL.mp4	14.7 MB
9 - What is SQL.mp4	17.5 MB
/.../4 - Bigquery Intro Walkthrough/
11 - BigQuery Introduction.mp4	23.2 MB
12 - BigQuery Interface Walkthrough.mp4	82.9 MB
/.../5 - Basic SQL Structure/
13 - Basic SQL Structure.mp4	29.9 MB
/6 - Query Syntax/
14 - SELECT.mp4	35.9 MB
15 - ALIAS.mp4	28.2 MB
16 - WHERE.mp4	21.0 MB
17 - GROUP BY.mp4	16.0 MB
18 - HAVING.mp4	10.4 MB
19 - ORDER BY.mp4	11.2 MB
20 - LIMIT.mp4	9.8 MB
/.../7 - Order of True SQL Statements/
21 - Order of True SQL Pt 1.mp4	14.5 MB
22 - Order of True SQL Pt 2.mp4	24.1 MB
23 - Order of True SQL Exercise.mp4	14.1 MB
/.../8 - Schema Data Types/
24 - Schema.mp4	18.2 MB
25 - Data Types Intro.mp4	2.2 MB
26 - Data Types MySQL.mp4	16.0 MB
27 - Data Types BigQuery.mp4	51.0 MB
28 - Data Types Recap.mp4	4.3 MB
/.../9 - Important SQL Commands/
29 - Important SQL Commands.mp4	23.5 MB
/~Get Your Files Here !/
Bonus Resources.txt	0.4 KB
Total files 226