English | MP4 | AVC 1280×720 | AAC 44KHz 2ch | 249 lectures (14h 13m) | 5.63 GB

Master SQL in just 15 days from Basics to Pro by working daily on real-life projects

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 expert

Much more challenges & hands-on coding exercises than other courses

Much more real-life advanced topics that other courses don’t cover

By 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 topics
- Master SQL by working on real-life challenges
- Learn PostgreSQL – the most modern SQL system & easy to transfer to all other SQL dialects
- We 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-forward
- Understand everything step by step from the absolute basics to the advanced topics
- Learn the practical to upskill your career or find a job with SQL

We cover every single important topic you will need including the advanced topics other courses do not cover!

Including…

- GROUP BY
- JOINs
- Functions
- UNIONs
- Data manipulation & Data Definition
- Views
- Window functions
- Grouping sets
- Rollups
- Transactions
- Subqueries
- Query optimization
- Indexes 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!

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!

## Table of Contents

**Day 1 – Getting started with SQL!**

How to get the most out of the course

How this course works

Why learning SQL

Let’s get started!

What is a database

Databases

Different dialects of SQL

Dialects of SQL

Installing PostgreSQL & pgAdmin (Windows)

Installing PostgreSQL & pgAdmin (MacOS)

Setting up the database

The Project

SELECT

Challenge SELECT

Solution SELECT

ORDER BY

Challenge ORDER BY

Solution ORDER BY

SELECT DISTINCT

Challenge SELECT DISTINCT

Solution SELECT DISTINCT

LIMIT

COUNT()

Today’s challenges

Today’s summary

**Day 2 – Basics Filtering**

WHERE

Challenge WHERE

Solution WHERE

WHERE operators

Challenge WHERE operators

Solution WHERE operators

WHERE with ANDOR

Challenge WHERE with ANDOR

Solution WHERE with ANDOR

BETWEEN

Challenge BETWEEN

Solution BETWEEN

IN

Challenge IN

Solution IN

LIKE

Challenge LIKE

Solution LIKE

Comments & Aliases

Today’s summary

Today’s challenges

**Day 3 – Basics Grouping**

Today’s plan

Aggregate functions

Challenge Aggregate function

GROUP BY

Challenge GROUP BY

Solution GROUP BY

GROUP BY multiple columns

Challenge GROUP BY multiple columns

Solution GROUP BY multiple columns

HAVING

Challenge HAVING

Solution HAVING

Introducing the second project

Today’s summary

**Day 4 – Intermediate Functions**

Today’s plan

LENGTH, LOWER & UPPER

Challenge LENGTH, LOWER & UPPER

Solution LENGTH, LOWER & UPPER

LEFT & RIGHT

Challenge LEFT & RIGHT

Solution LEFT & RIGHT

Concatenate

Challenge Concatenate

Solution Concatenate

POSITION

Challenge POSITION

Solution POSITION

SUBSTRING

Challenge SUBSTRING

Solution SUBSTRING

EXTRACT

Challenge EXTRACT

Solution EXTRACT

TO CHAR

Challenge TO CHAR

Solution TO CHAR

Intervals & Timestamps

Challenge Intervals & Timestamps

Solution Intervals & Timestamps

Today’s slides

**Day 5 – Intermediate Conditional Expressions**

Mathematical functions and operators

Challenge Mathematical functions and operators

Solution Mathematical functions and operators

CASE WHEN – Theory

CASE WHEN – Hands-on

Challenge CASE WHEN

Quick solutions

Solution CASE WHEN

CASE WHEN & SUM

COALESCE

CAST

Challenge CAST & COALESCE

Solution CAST & COALESCE

REPLACE

Today’s slides

**Day 6 – Intermediate Joins**

What are joins

INNER JOIN – Theory

INNER JOIN – Practice

Challenge INNER JOIN

Solution INNER JOIN

FULL OUTER JOIN

JOIN & WHERE

LEFT OUTER JOIN

Challenge LEFT OUTER JOIN

Solution LEFT OUTER JOIN

RIGHT OUTER JOIN

Challenge Joins

Solution Joins

Joins on multiple conditions

Solution Joins on multiple conditions

Joining multiple tables

Joining multiple tables – Practice

Challenge Joining multiple tables

Solution Joining multiple tables

More challenges

Solutions

Today’s slides

**Day 7 – Advanced UNION & Subqueries**

UNION

UNION – Practice

Subqueries in WHERE

Challenge Subqueries in WHERE

Solution Subqueries in WHERE

More challenges Subqueries in WHERE

Solution More challenges

Subqueries in FROM

Challenge Subqueries in FROM

Solution Subqueries in FROM

Subqueries in SELECT

Challenge Subqueries in SELECT

Solution Subqueries in SELECT

Correlated Subqueries in WHERE

Challenge Correlated subqueries in WHERE

Solution Correlated subqueries in WHERE

Correlated Subquery in SELECT

More challenges Correlated subqueres

Solution More challenges

Today’s slides

**Day 8 – Advanced Course project**

Project Introduction

Challenges

Solutions

Solution 1

Solution 2

Solution 3

Solution 4

Solution 5

Solution 6

Solution 7

Solution 8

Solution 9

Solution 10

Solution 11

Solution 12

Solution 13

Solution 14

**Day 9 – Advanced Managing tables & databases**

Managing databases & tables

CREATE DATABASE

CREATE & DROP DATABASE

Data Types

Data Types

Constraints

Constraints

Primary Key & Foreign Key

Primary & Foreign Key

CREATE TABLE

CREATE TABLE

INSERT

INSERT

ALTER TABLE

Challenge ALTER TABLE

Solution ALTER TABLE

TRUNCATE & DROP TABLE

CHECK

Challenge CHECK

Solution CHECK

Today’s slides

**Day 10 – Advanced Views & Data Manipulation**

UPDATE

Challenge UPDATE

Solution UPDATE

DELETE

Challenge DELETE

Solution DELETE

CREATE TABLE AS

Challenge CREATE TABLE AS

Solution CREATE TABLE AS

CREATE VIEW

Challenge CREATE VIEW

Solution CREATE VIEW

CREATE MATERIALIZED VIEW

Managing views

Challenge Managing views

Solution Managing views

Import & Export

Today’s slides

**Day 11 – Pro Window Functions**

OVER() with PARTITION BY

Challenge OVER() with PARTITION BY

Solution OVER() with PARTITION BY

OVER() with ORDER BY

Challenge OVER() with ORDER BY

Solution OVER() with ORDER BY

RANK()

Challenge RANK()

Solution RANK()

FIRST VALUE()

LEAD & LAG

Challenge LEAD & LAG

Solution LEAD & LAG

Additional challenge

Solution Additional Challenge

Today’s slides

**Day 12 – Pro Grouping sets, rollups, self-joins**

GROUPING SETS

Challenge GROUPING SETS

Solution GROUPING SETS

ROLLUP

Challenge ROLLUP

Solution ROLLUP

CUBE

Challenge CUBE

Solution CUBE

Self joins

Challenge Self joins

Solution Self joins

CROSS JOIN

NATURAL JOIN

Today’s slides

**Day 13 – Pro Course project**

Project introduction

The challenges

Solutions

**Day 14 – Pro Stored procedures, transactions & user-defined functions**

User-defined functions

User-defined functions – Example

Challenge User-defined functions

Solution

Transactions

Challenge Transactions

Solution Transactions

Rollbacks

Stored procedures

Challenge Stored procedures

Solution Stored procedure

Today’s slides

**Day 15 – Pro Indexes, Partitining & Query Optimization**

User management

CREATE USER ROLE

GRANT & REVOKE privileges

Privileges – Hands-on

Challenge Privileges

Solution Privileges

What are indexes

B-Tree index

Bitmap index

Indexes – Guidelines

Creating indexes

Creating indexes

Execution plan & query performance

Today’s slides

Resolve the captcha to access the links!