| 01-ddl-dml-exercise-solutions.sql | 5.6 KB | ||
| 01-ddl-dml-exercise.sql | 3.7 KB | ||
| 02-aggregate-exercise-solutions.sql | 3.2 KB | ||
| 02-aggregate-exercise.sql | 819.2 B | ||
| 03-string-exercise-solutions.sql | 4.3 KB | ||
| 03-string-exercise.sql | 1.4 KB | ||
| 04-sql-operators-exercise-solutions.sql | 3.9 KB | ||
| 04-sql-operators-exercise.sql | 1.2 KB | ||
| 05-sub-queries-cte-exercise-solutions.sql | 2.3 KB | ||
| 05-sub-queries-cte-exercise.sql | 409.6 B | ||
| 06-joins-exercise-solutions.sql | 5 KB | ||
| 06-joins-exercise.sql | 1.8 KB | ||
| 07-nested-repeated-exercise-solutions.sql | 7.8 KB | ||
| 07-nested-repeated-exercise.sql | 3.3 KB | ||
| 08-window-function-exercise-solutions.sql | 2.9 KB | ||
| 08-window-function-exercise.sql | 716.8 B | ||
| 09-case-study-1-exercise-solutions.sql | 6.9 KB | ||
| 09-case-study-1-exercise.sql | 2.5 KB | ||
| 1 - Welcome.mp4 | 7.6 MB | ||
| 10 - Database Data Warehouse.mp4 | 26.7 MB | ||
| 100 - SubqueriesCTEExercise 3.mp4 | 6.2 MB | ||
| 101 - SubqueriesCTEExercise 4.mp4 | 9.7 MB | ||
| 102 - 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 | ||
| 11 - BigQuery Introduction.mp4 | 22.1 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 | ||
| 119 - Nested Repeated Structures Introductions.mp4 | 33.5 MB | ||
| 12 - BigQuery Interface Walkthrough.mp4 | 79.1 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 | ||
| 128 - Window Functions Intro.mp4 | 40.4 MB | ||
| 129 - Syntax.mp4 | 31.6 MB | ||
| 13 - Basic SQL Structure.mp4 | 28.5 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 | ||
| 14 - SELECT.mp4 | 34.2 MB | ||
| 140 - WindowFunctions Exercise 4.mp4 | 20.7 MB | ||
| 141 - WindowFunctions Exercise 5.mp4 | 23.4 MB | ||
| 142 - Templating Introduction.mp4 | 17.4 MB | ||
| 143 - JINJA SQL.mp4 | 38.7 MB | ||
| 144 - dbt Overview.mp4 | 17.7 MB | ||
| 145 - dbt Role in a Data Warehouse.mp4 | 15.3 MB | ||
| 146 - dbt Examples.mp4 | 58.2 MB | ||
| 147 - Best Practices Introductions.mp4 | 3.3 MB | ||
| 148 - Code Formatting.mp4 | 18.2 MB | ||
| 149 - SELECT.mp4 | 5.1 MB | ||
| 15 - ALIAS.mp4 | 26.9 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 | ||
| 158 - UseCase Intro Questions.html | 3.8 KB | ||
| 159 - Wrap Up.mp4 | 1.6 MB | ||
| 16 - WHERE.mp4 | 20 MB | ||
| 17 - GROUP BY.mp4 | 15.3 MB | ||
| 18 - HAVING.mp4 | 10 MB | ||
| 19 - ORDER BY.mp4 | 10.7 MB | ||
| 2 - Course Overview.mp4 | 16.7 MB | ||
| 20 - LIMIT.mp4 | 9.3 MB | ||
| 21 - Order of True SQL Pt 1.mp4 | 13.8 MB | ||
| 22 - Order of True SQL Pt 2.mp4 | 23 MB | ||
| 23 - Order of True SQL Exercise.mp4 | 13.5 MB | ||
| 24 - 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 | ||
| 29 - Important SQL Commands.mp4 | 22.4 MB | ||
| 3 - How to get best out of this course.mp4 | 11.9 MB | ||
| 30 - CREATE.mp4 | 22.6 MB | ||
| 31 - ALTER.mp4 | 9.9 MB | ||
| 32 - DROP.mp4 | 6.5 MB | ||
| 33 - 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 | ||
| 39 - DDLDMLExercise 1.mp4 | 20 MB | ||
| 4 - BigQuery Setup.mp4 | 25.5 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 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 MB | ||
| 48 - DDLDMLExercise 10.mp4 | 8.3 MB | ||
| 49 - DDLDMLExercise 11.mp4 | 8.5 MB | ||
| 5 - Resources.mp4 | 62.9 MB | ||
| 50 - 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 MB | ||
| 56 - AggregateExercise 2.mp4 | 9 MB | ||
| 57 - AggregateExercise 3.mp4 | 8.7 MB | ||
| 58 - AggregateExercise 4.mp4 | 14.8 MB | ||
| 59 - AggregateExercise 5.mp4 | 7.1 MB | ||
| 6 - Setting up Dataset Table.mp4 | 35.4 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 | ||
| 67 - CONCAT.mp4 | 19.2 MB | ||
| 68 - REPLACE.mp4 | 20.8 MB | ||
| 69 - LOWER.mp4 | 7.7 MB | ||
| 7 - dbt Setup.mp4 | 144.2 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 MB | ||
| 8 - History of SQL.mp4 | 14 MB | ||
| 80 - StringExercise 6.mp4 | 8.7 MB | ||
| 81 - StringExercise 7.mp4 | 13.5 MB | ||
| 82 - StringExercise 8.mp4 | 9 MB | ||
| 83 - StringExercise 9.mp4 | 26.7 MB | ||
| 84 - StringExercise 10.mp4 | 7.5 MB | ||
| 85 - StringExercise 11.mp4 | 9.4 MB | ||
| 86 - Arithmetic Operators.mp4 | 34.7 MB | ||
| 87 - Logical Operators.mp4 | 41.8 MB | ||
| 88 - CASEWHEN.mp4 | 47 MB | ||
| 89 - OperatorsExercise 1.mp4 | 18.5 MB | ||
| 9 - What is SQL.mp4 | 16.7 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 | ||
| 95 - Sub Queries.mp4 | 28 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 | ||
| Bonus Resources.txt | 409.6 B | ||
| DS_Store | 6 KB | ||
| Get Bonus Downloads Here.url | 204.8 B | ||
| README.md | 6.5 KB | ||
| _.DS_Store | 102.4 B | ||
| _01-ddl-dml-exercise-solutions.sql | 204.8 B | ||
| _01-ddl-dml-exercise.sql | 204.8 B | ||
| _02-aggregate-exercise-solutions.sql | 307.2 B | ||
| _02-aggregate-exercise.sql | 307.2 B | ||
| _03-string-exercise-solutions.sql | 204.8 B | ||
| _03-string-exercise.sql | 204.8 B | ||
| _04-sql-operators-exercise-solutions.sql | 307.2 B | ||
| _04-sql-operators-exercise.sql | 307.2 B | ||
| _05-sub-queries-cte-exercise-solutions.sql | 204.8 B | ||
| _05-sub-queries-cte-exercise.sql | 204.8 B | ||
| _06-joins-exercise-solutions.sql | 307.2 B | ||
| _06-joins-exercise.sql | 307.2 B | ||
| _07-nested-repeated-exercise-solutions.sql | 307.2 B | ||
| _07-nested-repeated-exercise.sql | 307.2 B | ||
| _08-window-function-exercise-solutions.sql | 204.8 B | ||
| _08-window-function-exercise.sql | 204.8 B | ||
| _09-case-study-1-exercise-solutions.sql | 204.8 B | ||
| _09-case-study-1-exercise.sql | 204.8 B | ||
| _README.md | 204.8 B | ||
| _jinjasql-sudo-code.py | 204.8 B | ||
| _sql-code-from-lectures.sql | 204.8 B | ||
| _sql-primer-dim-date.csv | 204.8 B | ||
| _sql-primer-table-customer-source.csv | 204.8 B | ||
| _sql-primer-table-customer-target.csv | 204.8 B | ||
| _sql-primer-table-customer.csv | 204.8 B | ||
| _sql-primer-table-orders.csv | 204.8 B | ||
| _the-sql-primer-resources | 204.8 B | ||
| jinjasql-sudo-code.py | 1 KB | ||
| sql-code-from-lectures.sql | 25.8 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 | ||
| ▲ 226 total files | |||
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.
| torrent name | size | uploader | age | seed | leech |
|---|---|---|---|---|---|
| 784.3 MB | freecoursewb | 1 week | 18 | 6 | |
| 2.2 GB | freecoursewb | 1 week | 0 | 0 | |
| 3.7 GB | freecoursewb | 1 week | 0 | 0 | |
| 3.3 GB | freecoursewb | 1 week | 24 | 16 | |
| 410.6 MB | freecoursewb | 1 week | 21 | 8 |
All Comments