15 Days Of Sql: The Complete Sql Masterclass 2022

Posted By: ELK1nG

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

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