FULL SQL DATABASE COURSE | Learn SQL in 70 minutes

Data Analysis Lab - Build Your Data Portfolio in 30 DAYS: https://www.skool.com/data-analysis-lab
How I Built 50+ Data Projects in 90 DAYS: https://mochen.info/50-projects-90-days/
How to Frame Real Data Problems: https://mochen.info/data-problem-fram...
3 Projects, 3 Datasets, 3 Domains: https://mochen.info/3-projects-3-data...
33 Projects, 33 Datasets, 3 Domains: https://mochen.kit.com/products/33-da...

Sponsorships: [email protected]

Hi! I'm Mo, and I help career switchers transitioning into Data Analytics. I'm a Data & Analytics Manager, and I've been working in the Financial and Banking Data space for 7 years now.

COURSES & CERTIFICATES
Get 25% OFF DataCamp's Courses & Certificates: https://datacamp.pxf.io/DataCampMoChen

INDUSTRY RECOGNIZED CERTIFICATIONS
Data Analyst Certification Program: https://datacamp.pxf.io/dataAnalystCe...
PowerBI Data Analyst Certification Program: https://datacamp.pxf.io/PowerBIDataAn...
Data Scientist Certification Program: https://datacamp.pxf.io/DataScientist...
SQL Associate Certification Program: https://datacamp.pxf.io/SQLAssociateCert

TOP DATA ANALYST COURSES
Data Analyst with Python: https://datacamp.pxf.io/dataAnalystWi...
Data Analyst with PowerBI: https://datacamp.pxf.io/dataAnalystPo...
Associate Data Analyst in SQL: https://datacamp.pxf.io/AssociateData...

TOP DATA SCIENTIST COURSES
Associate Data Scientist in Python: https://datacamp.pxf.io/AssociateData...
Associate Data Scientist in R: https://datacamp.pxf.io/AssociateData...

TOP DATA ENGINEER COURSES
Data Engineer in Python: https://datacamp.pxf.io/DataEngineerI...

TOP BUSINESS INTELLIGENCE COURSES
PowerBI Fundamentals: https://datacamp.pxf.io/PowerBIFundam...
Tableau Fundamentals: https://datacamp.pxf.io/TableauFundam...

TOP PROGRAMMING LANGUAGE COURSES
Python Fundamentals for Data Science: https://datacamp.pxf.io/PythonFundame...
Python Fundamentals for Programming: https://datacamp.pxf.io/PythonFundame...
SQL Fundamentals: https://datacamp.pxf.io/SQLFundamentals
R Programming Fundamentals: https://datacamp.pxf.io/RFundamentals

TOP AI COURSES
AI Engineer for Developers Course: https://datacamp.pxf.io/AIEngineerDev...
AI Engineer for Data Scientists Course: https://datacamp.pxf.io/AIEngineerDat...
Developing AI Applications Course: https://datacamp.pxf.io/AIApplications

TIMESTAMPS
00:00 Course outline
03:11 Databases
06:27 Queries, tables and keys
09:39 Windows postgreSQL installation
11:48 MacOS postgreSQL installation
13:54 CREATE TABLE
20:58 INSERT INTO
24:37 SELECT, WHERE, AND & OR
28:49 IN, NOT IN, IS NULL, BETWEEN
32:32 ORDER BY, LIMIT, DISTINCT and Renaming columns
35:09 EXTRACT
36:21 UPPER, LOWER, LENGTH, TRIM
38:30 Concatenation, Boolean expressions and Wildcards
43:02 SUBSTRING, POSITION, COALESCE
46:11 MIN, MAX, AVG, SUM & COUNT
48:16 GROUP BY & HAVING
52:05 CASE (with GROUP BY and for transposing data)
56:18 JOIN & UNION
1:02:31 Subqueries
1:07:15 Bonus - 30 day moving total
1:09:34 Outro

PROJECT FILES
Github repo for code ➡︎ https://github.com/mochen862/full-sql...
Install pgAdmin (Windows & Mac) ➡︎ https://www.postgresql.org/download/