15 Days Of Sql: The Complete Sql Masterclass 2022
Last updated 12/2022
MP4 | Video: h264, 1280x720 | Audio: AAC, 44.1 KHz
Language: English | Size: 5.67 GB | Duration: 14h 9m
Last updated 12/2022
MP4 | Video: h264, 1280x720 | Audio: AAC, 44.1 KHz
Language: English | Size: 5.67 GB | Duration: 14h 9m
Master SQL in just 15 days from Basics to Pro by working daily on real-life projects
What you'll learn
You will master SQL in just 15 Days in real-life projects
Master real-life challenges and projects
Use SQL professionally in your career
Understand SQL for data analysis
Write complex and advanced SQL queries
Create & manage your own databases
Work with 2 complex real-life databases throughout the course and learn everything you need to master SQL
You will learn joining tables, group by, functions, conditional expressions, stored procedures, grouping sets, transactions, indexes and much more!
Requirements
No prior experience is needed - I will teach you everything you need to know
Description
Learn SQL with the world’s best SQL course in just 15 days!1 hour per day, for just 15 days and you will be fluent in SQL!That’s the only course you need to completely master SQL.You will be guided step-by-step from beginner to absolute expert in SQL.Why is this the best course you can take?The most comprehensive course that teaches you everthing from beginner to expertMuch more challenges & hands-on coding exercises than other coursesMuch more real-life advanced topics that other courses don’t coverBy the end of this guided experience you will be so fluent in SQL to get a job and work professionally and with a lot of confidence with SQL!This is the most comprehensive & most modern course you can find on SQL.Here is why:Most comprehenisve course with 14 hours video lectures and most topicsMaster SQL by working on real-life challengesLearn PostgreSQL – the most modern SQL system & easy to transfer to all other SQL dialectsWe will set up two modern databases and learn everything with realistic data, so you can do everything hands-on!Learn from a real expert - crystal clear & straight-forwardUnderstand everything step by step from the absolute basics to the advanced topicsLearn the practical to upskill your career or find a job with SQLWe cover every single important topic you will need including the advanced topics other courses do not cover!Including…GROUP BYJOINsFunctionsUNIONsData manipulation & Data DefinitionViewsWindow functionsGrouping setsRollupsTransactionsSubqueriesQuery optimizationIndexes and much more!Plus, tons of practical challenges and 2 complete course projects and much more challenges than you can find anywhere else!This course will take you all the way from beginner to being able to upskill your career and make you ready to get a job with SQL!Check out the free video previews and enroll now!See you inside the course!
Overview
Section 1: Day 1 - Getting started with SQL!
Lecture 1 Why learning SQL?
Lecture 2 What is a database?
Lecture 3 Different dialects of SQL
Lecture 4 Installing PostgreSQL & pgAdmin (Windows)
Lecture 5 Installing PostgreSQL & pgAdmin (MacOS)
Lecture 6 Setting up the database
Lecture 7 Common problems: Set binary paths
Lecture 8 Common problems: Slow performance
Lecture 9 The Project
Lecture 10 SELECT
Lecture 11 Challenge: SELECT
Lecture 12 Solution: SELECT
Lecture 13 ORDER BY
Lecture 14 Challenge: ORDER BY
Lecture 15 Solution: ORDER BY
Lecture 16 SELECT DISTINCT
Lecture 17 Challenge: SELECT DISTINCT
Lecture 18 Solution: SELECT DISTINCT
Lecture 19 LIMIT
Lecture 20 COUNT()
Lecture 21 Today's challenges
Lecture 22 Today's summary
Section 2: Day 2 - Basics: Filtering
Lecture 23 WHERE
Lecture 24 Challenge: WHERE
Lecture 25 Solution: WHERE
Lecture 26 WHERE operators
Lecture 27 Challenge: WHERE operators
Lecture 28 Solution: WHERE operators
Lecture 29 WHERE with AND/OR
Lecture 30 Challenge: WHERE with AND/OR
Lecture 31 Solution: WHERE with AND/OR
Lecture 32 Quick note on time zones
Lecture 33 BETWEEN
Lecture 34 Challenge: BETWEEN
Lecture 35 Solution: BETWEEN
Lecture 36 IN
Lecture 37 Challenge: IN
Lecture 38 Solution: IN
Lecture 39 LIKE
Lecture 40 Challenge: LIKE
Lecture 41 Solution: LIKE
Lecture 42 Comments & Aliases
Lecture 43 Today's summary
Lecture 44 Today's challenges
Section 3: Day 3 - Basics: Grouping
Lecture 45 Today's plan
Lecture 46 Aggregate functions
Lecture 47 Challenge: Aggregate function
Lecture 48 GROUP BY
Lecture 49 Challenge: GROUP BY
Lecture 50 Solution: GROUP BY
Lecture 51 GROUP BY multiple columns
Lecture 52 Challenge: GROUP BY multiple columns
Lecture 53 Solution: GROUP BY multiple columns
Lecture 54 HAVING
Lecture 55 Challenge: HAVING
Lecture 56 Solution: HAVING
Lecture 57 Introducing the second project
Lecture 58 Note for Mac users
Lecture 59 Problems & solutions of setting up the database
Lecture 60 Today's summary
Section 4: Day 4 - Intermediate: Functions
Lecture 61 Today's plan
Lecture 62 LENGTH, LOWER & UPPER
Lecture 63 Challenge: LENGTH, LOWER & UPPER
Lecture 64 Solution: LENGTH, LOWER & UPPER
Lecture 65 LEFT & RIGHT
Lecture 66 Challenge: LEFT & RIGHT
Lecture 67 Solution: LEFT & RIGHT
Lecture 68 Concatenate
Lecture 69 Challenge: Concatenate
Lecture 70 Solution: Concatenate
Lecture 71 POSITION
Lecture 72 Challenge: POSITION
Lecture 73 Solution: POSITION
Lecture 74 SUBSTRING
Lecture 75 Challenge: SUBSTRING
Lecture 76 Solution: SUBSTRING
Lecture 77 EXTRACT
Lecture 78 Challenge: EXTRACT
Lecture 79 Solution: EXTRACT
Lecture 80 TO_CHAR
Lecture 81 Challenge: TO_CHAR
Lecture 82 Solution: TO_CHAR
Lecture 83 Intervals & Timestamps
Lecture 84 Challenge: Intervals & Timestamps
Lecture 85 Solution: Intervals & Timestamps
Lecture 86 Today's slides
Section 5: Day 5 - Intermediate: Conditional Expressions
Lecture 87 Mathematical functions and operators
Lecture 88 Challenge: Mathematical functions and operators
Lecture 89 Solution: Mathematical functions and operators
Lecture 90 CASE WHEN - Theory
Lecture 91 CASE WHEN - Hands-on
Lecture 92 3 Challenge: CASE WHEN
Lecture 93 Quick solutions
Lecture 94 Solution: CASE WHEN
Lecture 95 CASE WHEN & SUM
Lecture 96 COALESCE
Lecture 97 CAST
Lecture 98 Challenge: CAST & COALESCE
Lecture 99 Solution: CAST & COALESCE
Lecture 100 REPLACE
Lecture 101 Today's slides
Section 6: Day 6 - Intermediate: Joins
Lecture 102 What are joins?
Lecture 103 INNER JOIN - Theory
Lecture 104 INNER JOIN - Practice
Lecture 105 Challenge: INNER JOIN
Lecture 106 Solution: INNER JOIN
Lecture 107 FULL OUTER JOIN
Lecture 108 JOIN & WHERE
Lecture 109 LEFT OUTER JOIN
Lecture 110 Challenge: LEFT OUTER JOIN
Lecture 111 Solution: LEFT OUTER JOIN
Lecture 112 RIGHT OUTER JOIN
Lecture 113 Challenge: Joins
Lecture 114 Solution: Joins
Lecture 115 Joins on multiple conditions
Lecture 116 Solution: Joins on multiple conditions
Lecture 117 Joining multiple tables
Lecture 118 Joining multiple tables - Practice
Lecture 119 Challenge: Joining multiple tables
Lecture 120 Solution: Joining multiple tables
Lecture 121 More challenges
Lecture 122 Solutions
Lecture 123 Today's slides
Section 7: Day 7 - Advanced: UNION & Subqueries
Lecture 124 UNION
Lecture 125 UNION - Practice
Lecture 126 Subqueries in WHERE
Lecture 127 Challenge: Subqueries in WHERE
Lecture 128 Solution: Subqueries in WHERE
Lecture 129 More challenges: Subqueries in WHERE
Lecture 130 Solution: More challenges
Lecture 131 Subqueries in FROM
Lecture 132 Challenge: Subqueries in FROM
Lecture 133 Solution: Subqueries in FROM
Lecture 134 Subqueries in SELECT
Lecture 135 Challenge: Subqueries in SELECT
Lecture 136 Solution: Subqueries in SELECT
Lecture 137 Correlated Subqueries in WHERE
Lecture 138 Challenge: Correlated subqueries in WHERE
Lecture 139 Solution: Correlated subqueries in WHERE
Lecture 140 Correlated Subquery in SELECT
Lecture 141 More challenges: Correlated subqueres
Lecture 142 Solution: More challenges
Lecture 143 Today's slides
Section 8: Day 8 - Advanced: Course project
Lecture 144 Project Introduction
Lecture 145 Challenges
Lecture 146 Solutions
Lecture 147 Solution 1
Lecture 148 Solution 2
Lecture 149 Solution 3
Lecture 150 Solution 4
Lecture 151 Solution 5
Lecture 152 Solution 6
Lecture 153 Solution 7
Lecture 154 Solution 8
Lecture 155 Solution 9
Lecture 156 Solution 10
Lecture 157 Solution 11
Lecture 158 Solution 12
Lecture 159 Solution 13
Lecture 160 Solution 14
Section 9: Day 9 - Advanced: Managing tables & databases
Lecture 161 Managing databases & tables
Lecture 162 CREATE DATABASE
Lecture 163 Data Types
Lecture 164 Constraints
Lecture 165 Primary Key & Foreign Key
Lecture 166 CREATE TABLE
Lecture 167 INSERT
Lecture 168 ALTER TABLE
Lecture 169 Challenge: ALTER TABLE
Lecture 170 Solution: ALTER TABLE
Lecture 171 TRUNCATE & DROP TABLE
Lecture 172 CHECK
Lecture 173 Challenge: CHECK
Lecture 174 Solution: CHECK
Lecture 175 Today's slides
Section 10: Day 10 - Advanced: Views & Data Manipulation
Lecture 176 UPDATE
Lecture 177 Challenge: UPDATE
Lecture 178 Solution: UPDATE
Lecture 179 DELETE
Lecture 180 Challenge: DELETE
Lecture 181 Solution: DELETE
Lecture 182 CREATE TABLE AS
Lecture 183 Challenge: CREATE TABLE AS
Lecture 184 Solution: CREATE TABLE AS
Lecture 185 CREATE VIEW
Lecture 186 Challenge: CREATE VIEW
Lecture 187 Solution: CREATE VIEW
Lecture 188 CREATE MATERIALIZED VIEW
Lecture 189 Managing views
Lecture 190 Challenge: Managing views
Lecture 191 Solution: Managing views
Lecture 192 Import & Export
Lecture 193 Today's slides
Section 11: Day 11 - Pro: Window Functions
Lecture 194 OVER() with PARTITION BY
Lecture 195 Challenge: OVER() with PARTITION BY
Lecture 196 Solution: OVER() with PARTITION BY
Lecture 197 OVER() with ORDER BY
Lecture 198 Challenge: OVER() with ORDER BY
Lecture 199 Solution: OVER() with ORDER BY
Lecture 200 RANK()
Lecture 201 Challenge: RANK()
Lecture 202 Solution: RANK()
Lecture 203 FIRST_VALUE()
Lecture 204 LEAD & LAG
Lecture 205 Challenge: LEAD & LAG
Lecture 206 Solution: LEAD & LAG
Lecture 207 Today's slides
Section 12: Day 12 - Pro: Grouping sets, rollups, self-joins
Lecture 208 GROUPING SETS
Lecture 209 Challenge: GROUPING SETS
Lecture 210 Solution: GROUPING SETS
Lecture 211 Additional challenge
Lecture 212 Solution: Additional Challenge
Lecture 213 ROLLUP
Lecture 214 Challenge: ROLLUP
Lecture 215 Solution: ROLLUP
Lecture 216 CUBE
Lecture 217 Challenge: CUBE
Lecture 218 Solution: CUBE
Lecture 219 Self joins
Lecture 220 Challenge: Self joins
Lecture 221 Solution: Self joins
Lecture 222 CROSS JOIN
Lecture 223 NATURAL JOIN
Lecture 224 Today's slides
Section 13: Day 13 - Pro: Course project
Lecture 225 Project introduction
Lecture 226 The challenges
Lecture 227 Solutions
Section 14: Day 14 - Pro: Stored procedures, transactions & user-defined functions
Lecture 228 User-defined functions
Lecture 229 User-defined functions - Example
Lecture 230 Challenge: User-defined functions
Lecture 231 Solution
Lecture 232 Transactions
Lecture 233 Challenge: Transactions
Lecture 234 Solution: Transactions
Lecture 235 Rollbacks
Lecture 236 Stored procedures
Lecture 237 Challenge: Stored procedures
Lecture 238 Solution: Stored procedure
Lecture 239 Today's slides
Section 15: Day 15 - Pro: Indexes, Partitining & Query Optimization
Lecture 240 User management
Lecture 241 CREATE USER | ROLE
Lecture 242 GRANT & REVOKE privileges
Lecture 243 Privileges - Hands-on
Lecture 244 Challenge: Privileges
Lecture 245 Solution: Privileges
Lecture 246 What are indexes?
Lecture 247 B-Tree index
Lecture 248 Bitmap index
Lecture 249 Indexes - Guidelines
Lecture 250 Creating indexes
Lecture 251 Execution plan & query performance
Lecture 252 Today's slides
Lecture 253 Bonus
Anyone interested in SQL or PostgreSQL,Anyone that is interested in data analysis, data science and data analytics,Anyone that wants to improve their IT skills in any profession