GET YOUR DATA JOB ➡ https://mochen.info/

ULTIMATE DATA PORTFOLIO: Everything you need to get your data job ➡ https://mochen.info/ultimatedatapor...

AI JOB QUEST: Change the way you apply to jobs ➡ https://mochen.info/aijobquestlp/

PATREON ➡   / mo_chen  

1:1 MENTORSHIP PROGRAM: I put my heart and soul into this program. I'm here to help you succeed ➡ https://mochen.info/11mentorshiplp/

CourseCareers: Start the FREE Data Analytics Introduction Course Now ➡ https://coursecareers.com/a/mochen?co...'>https://coursecareers.com/a/mochen?co...

Portfolio Projects Playlist: Endtoend, FREE guided portfolio projects covering Excel, SQL, Tableau, Power BI and Python ➡    • Portfolio Projects  


┋Community & Socials┋

  / discord   ⬅ Join our Discord Data Community

  / mo_chen1   ⬅ My IG is personal only follow if you're interested in nondata stuff as well

  / mochen1   ⬅ Daily tips & advice on how to enhance your data analysis skills

  / mo_chen_1   ⬅ Figuring out what I want to do in this space...


┋Professional Certificates┋

CourseCareers ➡ https://coursecareers.com/a/mochen

DataCamp Courses & Certifications ➡ https://datacamp.pxf.io/c/4216860/111...

Google Data Analytics Professional Certificate ➡ https://www.coursera.org/googlecerti...

Google Advanced Data Analytics Professional Certificate ➡ https://www.coursera.org/googlecerti...

Tableau Business Intelligence Professional Certificate ➡ https://imp.i384100.net/TableauBIAnalyst

Microsoft Power BI Data Analyst Professional Certificate ➡ https://www.coursera.org/professional...

IBM Data Science Professional Certificate ➡ https://imp.i384100.net/IBMdataScience

Google Project Management Professional Certificate ➡ https://imp.i384100.net/GoogleProject...


┋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


┋Files┋

Github repo for code ➡ https://github.com/mochen862/fullsql...

Install pgAdmin (Windows & Mac) ➡ https://www.postgresql.org/download/

Thanks so much for taking a little time out of your day to watch this!