FULL SQL DATABASE COURSE | Learn SQL in 70 minutes
I'M HERE TO HELP YOU LAND YOUR NEXT TECH & DATA JOB
🌐 My website: https://mochen.info/
LET'S COLLABORATE
🤝 Sponsorships & long-term partnerships: https://mo-chen.notion.site/partnerships
ABOUT ME
I'm Mo and I work as a data analytics manager / content creator. I make videos about how best to get your next job in the tech & data space; whether you're a beginner, career switcher, or someone looking to take their tech & data career to the next level.
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/
