FULL SQL DATABASE COURSE | Learn SQL in 70 minutes

I teach AI and data skills that solve real problems at work. Start here → https://mochen.io Partnerships: 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/