┋Resources to take your data analytics skills to the next level┋ Ultimate Data Roadmap: The MOST comprehensive data roadmap ➡ https://mochen.info/product/ultimate-data-roadmap/ Ultimate Data Portfolio: Publish your entire data portfolio to the web with ZERO coding ➡ https://mochen.info/product/ultimate-data-portfolio/ Ultimate Resume Template: Literally the resumes that I use for my OWN JOB APPLICATIONS ➡ https://mochen.info/product/ultimate-resume-template/ 1:1 Mentorship: Significantly accelerate your professional GROWTH ➡ https://mochen.info/1-1-mentorship/ Career Compass: My completely FREE weekly data newsletter with actionable tips and insights ➡ https://mochen.beehiiv.com/subscribe/ CourseCareers: Start the FREE Data Analytics Introduction Course Now ➡ https://coursecareers.com/a/mochen?course=data-analytics Portfolio Projects Playlist: End-to-end, FREE guided portfolio projects covering Excel, SQL, Tableau and Python ➡    • Portfolio Projects   Data Portfolio Guide: Over 80 actionable tips on how you can build your dream data portfolio. For completely FREE ➡ https://mochen.beehiiv.com/c/data-portfolio-guide ┋Community & Socials┋ https://discord.gg/EBh7j9uRJ2 ⬅ Join our Discord Data Community https://www.instagram.com/mo_chen1/ ⬅ My IG is personal -- only follow if you're interested in non-data stuff as well https://www.linkedin.com/in/mo-chen1/ ⬅ Daily tips & advice on how to enhance your data analysis skills https://twitter.com/mo_chen_1 ⬅ Figuring out what I want to do in this space... ┋Professional Certificates┋ CourseCareers ➡ https://coursecareers.com/a/mochen Google Data Analytics Professional Certificate ➡ https://www.coursera.org/google-certificates/data-analytics-certificate?irclickid=W2u2Pd23WxyPRWhxQeRIaxGNUkFy6t39nRQTx00&irgwc=1&utm_medium=partners&utm_source=impact&utm_campaign=4216860&utm_content=b2c Google Advanced Data Analytics Professional Certificate ➡ https://www.coursera.org/google-certificates/advanced-data-analytics-certificate?irclickid=W2u2Pd23WxyPRWhxQeRIaxGNUkFy6tWpnRQTx00&irgwc=1&utm_medium=partners&utm_source=impact&utm_campaign=4216860&utm_content=b2c Tableau Business Intelligence Professional Certificate ➡ https://imp.i384100.net/TableauBIAnalyst Microsoft Power BI Data Analyst Professional Certificate ➡ https://www.coursera.org/professional-certificates/microsoft-power-bi-data-analyst?irclickid=W2u2Pd23WxyPRWhxQeRIaxGNUkFy6tVZnRQTx00&irgwc=1&utm_medium=partners&utm_source=impact&utm_campaign=4216860&utm_content=b2c IBM Data Science Professional Certificate ➡ https://imp.i384100.net/IBMdataScience Google Project Management Professional Certificate ➡ https://imp.i384100.net/GoogleProjectManagement ┋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/full-sql-database-course Install pgAdmin (Windows & Mac) ➡︎ https://www.postgresql.org/download/ Thanks so much for taking a little time out of your day to watch this!