FULL SQL DATABASE COURSE | Learn SQL in 70 minutes
Portfolio, Projects, Resume, Courses & Certifications, Newsletter
https://mochen.info
Sponsorships: https://mo-chen.notion.site/partnerships
Hi, I'm Mo! I'm a Data & Analytics Manager. I'm all about turning complex, big data into insights and actions. I am not interested in building yet another dashboard that nobody looks at - I'm interested in solving the most challenging business problems using data.
=========================================================
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/
On this page of the site you can watch the video online FULL SQL DATABASE COURSE | Learn SQL in 70 minutes with a duration of hours minute second in good quality, which was uploaded by the user Mo Chen 29 April 2023, share the link with friends and acquaintances, this video has already been watched 175,762 times on youtube and it was liked by 5.9 thousand viewers. Enjoy your viewing!
