Udemy - The Sql Primer Masterclass

Category Other
Type Tutorials
Language English
Total size 3.0 GB
Uploaded By freecoursewb

Downloads 167
Last checked 3 days ago
Date uploaded 2 years ago
Seeders 3
Leechers 4

Infohash : C99FCD74A4C7F6D9790812B7AF920AEFFF8BE9E8

The Sql Primer Masterclass

https://DevCourseWeb.com

Published 5/2023
MP4 | Video: h264, 1280x720 | Audio: AAC, 44.1 KHz
Language: English | Size: 2.97 GB | Duration: 8h 31m

Become SQL Master with just ONE course. Learn BigQuery, dbt, Window functions, CTE, Joins,Nested structures & many more!

What you'll learn
Gain a comprehensive understanding of SQL and BigQuery, from basic syntax and queries to advanced data manipulation and retrieval techniques.
Master essential SQL skills such as subqueries, Joins, Common Table Expressions (CTEs), Window Functions, and the effective use of nested and repeated structure
Incorporate best practices in SQL, including code formatting, aliasing, filtering, commenting, and more, to write clean, efficient, and professional code.
Apply learned concepts in real-world scenarios, practice SQL commands, functions, and operators through exercises, and analyze data to derive insights from an A
Learn to employ advanced SQL features such as Window Functions, template SQL with JINJA, and understand the importance of 'DRY' (Don't Repeat Yourself)

Requirements
No prior knowledge of SQL or any other programming language is required. We'll start from the very basics and build up.
An interest in data analysis: This course is perfect for those who are curious about data and how to extract valuable insights from it.
Willingness to Learn: A key prerequisite is a can-do attitude and a readiness to learn new concepts and practice them through the exercises provided.

                Files: 

                [ DevCourseWeb.com ] Udemy - The Sql Primer Masterclass
Get Bonus Downloads Here.url (0.2 KB)
~Get Your Files Here !1 - Course Introduction1 - Welcome.mp4 (7.6 MB)
2 - Course Overview.mp4 (16.7 MB)
3 - How to get best out of this course.mp4 (11.9 MB)
10 - Data Definition Language DDL30 - CREATE.mp4 (22.6 MB)
31 - ALTER.mp4 (9.9 MB)
32 - DROP.mp4 (6.5 MB)
11 - Data Manipulation Language DML33 - INSERT.mp4 (16.3 MB)
34 - UPDATE.mp4 (11.5 MB)
35 - TRUNCATE.mp4 (12.9 MB)
36 - DELETE.mp4 (8.6 MB)
37 - MERGE Pt 1.mp4 (21.1 MB)
38 - MERGE Pt 2.mp4 (81.9 MB)
12 - DDL DML Exercises39 - DDLDMLExercise 1.mp4 (20.0 MB)
40 - DDLDMLExercise 2.mp4 (10.4 MB)
41 - DDLDMLExercise 3.mp4 (5.7 MB)
42 - DDLDMLExercise 4.mp4 (5.4 MB)
43 - DDLDMLExercise 5.mp4 (12.0 MB)
44 - DDLDMLExercise 6.mp4 (9.9 MB)
45 - DDLDMLExercise 7.mp4 (10.2 MB)
46 - DDLDMLExercise 8.mp4 (9.5 MB)
47 - DDLDMLExercise 9.mp4 (7.0 MB)
48 - DDLDMLExercise 10.mp4 (8.3 MB)
49 - DDLDMLExercise 11.mp4 (8.5 MB)
13 - AGGREGATE Functions50 - SUM.mp4 (53.8 MB)
51 - COUNT.mp4 (40.3 MB)
52 - COUNTIF.mp4 (22.3 MB)
53 - AVG.mp4 (18.3 MB)
54 - MINMAX.mp4 (58.3 MB)
55 - AggregateExercise 1.mp4 (20.0 MB)
56 - AggregateExercise 2.mp4 (9.0 MB)
57 - AggregateExercise 3.mp4 (8.7 MB)
58 - AggregateExercise 4.mp4 (14.8 MB)
59 - AggregateExercise 5.mp4 (7.1 MB)
60 - AggregateExercise 6.mp4 (10.9 MB)
61 - AggregateExercise 7.mp4 (5.8 MB)
62 - AggregateExercise 8.mp4 (4.8 MB)
63 - AggregateExercise 9.mp4 (4.5 MB)
64 - AggregateExercise 10.mp4 (6.3 MB)
65 - AggregateExercise 11.mp4 (6.9 MB)
66 - AggregateExercise 12.mp4 (6.4 MB)
14 - STRING Functions67 - CONCAT.mp4 (19.2 MB)
68 - REPLACE.mp4 (20.8 MB)
69 - LOWER.mp4 (7.7 MB)
70 - UPPER.mp4 (12.1 MB)
71 - NORMALIZE.mp4 (38.2 MB)
72 - SPLIT.mp4 (18.9 MB)
73 - LEFTRIGHT.mp4 (16.8 MB)
74 - TRIM.mp4 (7.6 MB)
75 - StringExercise 1.mp4 (6.9 MB)
76 - StringExercise 2.mp4 (10.1 MB)
77 - StringExercise 3.mp4 (8.9 MB)
78 - StringExercise 4.mp4 (12.9 MB)
79 - StringExercise 5.mp4 (5.0 MB)
80 - StringExercise 6.mp4 (8.7 MB)
81 - StringExercise 7.mp4 (13.5 MB)
82 - StringExercise 8.mp4 (9.0 MB)
83 - StringExercise 9.mp4 (26.7 MB)
84 - StringExercise 10.mp4 (7.5 MB)
85 - StringExercise 11.mp4 (9.4 MB)
15 - SQL Operators86 - Arithmetic Operators.mp4 (34.7 MB)
87 - Logical Operators.mp4 (41.8 MB)
88 - CASEWHEN.mp4 (47.0 MB)
89 - OperatorsExercise 1.mp4 (18.5 MB)
90 - OperatorsExercise 2.mp4 (11.9 MB)
91 - OperatorsExercise 3.mp4 (8.8 MB)
92 - OperatorsExercise 4.mp4 (11.3 MB)
93 - OperatorsExercise 5.mp4 (14.3 MB)
94 - OperatorsExercise 6.mp4 (15.2 MB)
16 - SUBQUERIES CTEs100 - SubqueriesCTEExercise 3.mp4 (6.2 MB)
101 - SubqueriesCTEExercise 4.mp4 (9.7 MB)
95 - Sub Queries.mp4 (28.0 MB)
96 - Common Table Expressions CTEs.mp4 (31.1 MB)
97 - Common Table Expression Recursive.mp4 (13.8 MB)
98 - SubqueriesCTEExercise 1.mp4 (10.8 MB)
99 - SubqueriesCTEExercise 2.mp4 (15.9 MB)
17 - JOINs102 - JOINs Introduction.mp4 (55.5 MB)
103 - LEFT JOIN.mp4 (36.7 MB)
104 - LEFT JOIN Exclusive.mp4 (6.4 MB)
105 - RIGHT JOIN.mp4 (23.5 MB)
106 - RIGHT JOIN Exclusive.mp4 (3.5 MB)
107 - INNER JOIN.mp4 (17.6 MB)
108 - OUTER JOIN.mp4 (14.1 MB)
109 - OUTER JOIN Exclusive.mp4 (5.4 MB)
110 - CROSS JOIN.mp4 (16.5 MB)
111 - JOINexercise 1.mp4 (15.2 MB)
112 - JOINexercise 2.mp4 (7.3 MB)
113 - JOINexercise 3.mp4 (6.1 MB)
114 - JOINexercise 4.mp4 (9.6 MB)
115 - JOINexercise 5.mp4 (6.9 MB)
116 - JOINexercise 6.mp4 (6.5 MB)
117 - JOINexercise 7.mp4 (11.4 MB)
118 - JOINexercise 8.mp4 (28.4 MB)
18 - Nested Repeated Structures119 - Nested Repeated Structures Introductions.mp4 (33.5 MB)
120 - Nested.mp4 (37.7 MB)
121 - Repeated.mp4 (34.6 MB)
122 - Nested Repeated.mp4 (37.8 MB)
123 - NestedRepeated Exercise 1.mp4 (24.7 MB)
124 - NestedRepeated Exercise 2.mp4 (8.8 MB)
125 - NestedRepeated Exercise 3.mp4 (8.7 MB)
126 - NestedRepeated Exercise 4.mp4 (19.3 MB)
127 - NestedRepeated Exercise 5.mp4 (30.2 MB)
19 - WINDOW Analytics Functions128 - Window Functions Intro.mp4 (40.4 MB)
129 - Syntax.mp4 (31.6 MB)
130 - Aggregate Window Function.mp4 (57.7 MB)
131 - Navigation Windown Function LAG LEAD.mp4 (28.5 MB)
132 - Navigation Windown Function FIRST LAST Value.mp4 (45.6 MB)
133 - Navigation Windown Function RANK.mp4 (18.6 MB)
134 - Navigation Windown Function DENSE RANK.mp4 (12.3 MB)
135 - Navigation Windown Function Documentation Walkthrough.mp4 (18.9 MB)
136 - Navigation Windown Function ROW NUMBER.mp4 (23.2 MB)
137 - WindowFunctions Exercise 1.mp4 (16.4 MB)
138 - WindowFunctions Exercise 2.mp4 (9.5 MB)
139 - WindowFunctions Exercise 3.mp4 (15.3 MB)
140 - WindowFunctions Exercise 4.mp4 (20.7 MB)
141 - WindowFunctions Exercise 5.mp4 (23.4 MB)
2 - Setting up Resources4 - BigQuery Setup.mp4 (25.5 MB)
5 - Resources.mp4 (62.9 MB)
6 - Setting up Dataset Table.mp4 (35.4 MB)
7 - dbt Setup.mp4 (144.2 MB)
__MACOSX_the-sql-primer-resources (0.2 KB)
the-sql-primer-resources_.DS_Store (0.1 KB)
_README.md (0.2 KB)
exercises_.DS_Store (0.1 KB)
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)
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)
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-resourcesDS_Store (14.0 KB)
README.md (6.5 KB)
exercisesDS_Store (6.0 KB)
exercises01-ddl-dml-exercise.sql (3.7 KB)
02-aggregate-exercise.sql (0.8 KB)
03-string-exercise.sql (1.4 KB)
04-sql-operators-exercise.sql (1.2 KB)
05-sub-queries-cte-exercise.sql (0.4 KB)
06-joins-exercise.sql (1.8 KB)
07-nested-repeated-exercise.sql (3.3 KB)
08-window-function-exercise.sql (0.7 KB)
09-case-study-1-exercise.sql (2.5 KB)
DS_Store (6.0 KB)
solutions01-ddl-dml-exercise-solutions.sql (5.6 KB)
02-aggregate-exercise-solutions.sql (3.2 KB)
03-string-exercise-solutions.sql (4.3 KB)
04-sql-operators-exercise-solutions.sql (3.9 KB)
05-sub-queries-cte-exercise-solutions.sql (2.3 KB)
06-joins-exercise-solutions.sql (5.0 KB)
07-nested-repeated-exercise-solutions.sql (7.8 KB)
08-window-function-exercise-solutions.sql (2.9 KB)
09-case-study-1-exercise-solutions.sql (6.9 KB)
DS_Store (6.0 KB)
lecture-sql-codeDS_Store (6.0 KB)
jinjasql-sudo-code.py (1.0 KB)
sql-code-from-lectures.sql (25.8 KB)
sample-dataDS_Store (6.0 KB)
sql-primer-dim-date.csv (347.9 KB)
sql-primer-table-customer-source.csv (2.2 KB)
sql-primer-table-customer-target.csv (201.5 KB)
sql-primer-table-customer.csv (201.5 KB)
sql-primer-table-orders.csv (164.8 KB)
20 - Templated SQL142 - Templating Introduction.mp4 (17.4 MB)
143 - JINJA SQL.mp4 (38.7 MB)
21 - dbt Data Build Tool144 - dbt Overview.mp4 (17.7 MB)
145 - dbt Role in a Data Warehouse.mp4 (15.3 MB)
146 - dbt Examples.mp4 (58.2 MB)
22 - SQL Best Practices147 - Best Practices Introductions.mp4 (3.3 MB)
148 - Code Formatting.mp4 (18.2 MB)
149 - SELECT.mp4 (5.1 MB)
150 - ALIAS.mp4 (7.2 MB)
151 - Explicit JOIN.mp4 (4.6 MB)
152 - Filtering.mp4 (12.8 MB)
153 - ORDER BY.mp4 (4.4 MB)
154 - UNION ALL.mp4 (3.5 MB)
155 - Comments.mp4 (5.4 MB)
156 - CTEs.mp4 (4.6 MB)
157 - DRY Dont repeat yourself.mp4 (6.7 MB)
23 - UseCase 1 Airbnb158 - UseCase Intro Questions.html (3.8 KB)
24 - Wrap Up159 - Wrap Up.mp4 (1.6 MB)
3 - Basic SQL10 - Database Data Warehouse.mp4 (26.7 MB)
8 - History of SQL.mp4 (14.0 MB)
9 - What is SQL.mp4 (16.7 MB)
4 - Bigquery Intro Walkthrough11 - BigQuery Introduction.mp4 (22.1 MB)
12 - BigQuery Interface Walkthrough.mp4 (79.1 MB)
5 - Basic SQL Structure13 - Basic SQL Structure.mp4 (28.5 MB)
6 - Query Syntax14 - SELECT.mp4 (34.2 MB)
15 - ALIAS.mp4 (26.9 MB)
16 - WHERE.mp4 (20.0 MB)
17 - GROUP BY.mp4 (15.3 MB)
18 - HAVING.mp4 (10.0 MB)
19 - ORDER BY.mp4 (10.7 MB)
20 - LIMIT.mp4 (9.3 MB)
7 - Order of True SQL Statements21 - Order of True SQL Pt 1.mp4 (13.8 MB)
22 - Order of True SQL Pt 2.mp4 (23.0 MB)
23 - Order of True SQL Exercise.mp4 (13.5 MB)
8 - Schema Data Types24 - Schema.mp4 (17.3 MB)
25 - Data Types Intro.mp4 (2.1 MB)
26 - Data Types MySQL.mp4 (15.3 MB)
27 - Data Types BigQuery.mp4 (48.6 MB)
28 - Data Types Recap.mp4 (4.1 MB)
9 - Important SQL Commands29 - Important SQL Commands.mp4 (22.4 MB)
Bonus Resources.txt (0.4 KB)

There are currently no comments. Feel free to leave one :)

Code:

udp://tracker.torrent.eu.org:451/announce
udp://tracker.tiny-vps.com:6969/announce
http://tracker.foreverpirates.co:80/announce
udp://tracker.cyberia.is:6969/announce
udp://exodus.desync.com:6969/announce
udp://explodie.org:6969/announce
udp://tracker.opentrackr.org:1337/announce
udp://9.rarbg.to:2780/announce
udp://tracker.internetwarriors.net:1337/announce
udp://ipv4.tracker.harry.lu:80/announce
udp://open.stealth.si:80/announce
udp://9.rarbg.to:2900/announce
udp://9.rarbg.me:2720/announce
udp://opentor.org:2710/announce