FULL SQL DATABASE COURSE | Beginner to Intermediate in 1 Hour

🛣️ Data Analyst Roadmap ➡︎ FULL SQL DATABASE COURSE that’ll take you from complete beginner to an intermediate SQL database user in 1 hour. =========================== Coursera Courses =========================== 📖 Google Data Analytics Professional Certificate ➡︎ 📖 Google Advanced Data Analytics Professional Certificate ➡︎ 📚 Google Business Intelligence Professional Certificate ➡︎ =========================== Connect with me! =========================== Instagram ➡︎ =========================== Github repo for code =========================== =========================== Install pgAdmin (Windows & Mac) =========================== Please note I may earn a small commission for any purchase through these links. Thanks a lot for supporting the channel! All opinions or statements in this video are my own and do not reflect the opinion of the organisation I work for or have ever worked for. =========================== Timestamps =========================== 00:00 Intro 01:11 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