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!