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
28 views
63
19
2 weeks ago 02:39:26 1
React & ИНТЕРНЕТ МАГАЗИН С НУЛЯ. PERN stack PostgreSQL + express + React js +
2 months ago 03:39:43 1
Полный курс Sqlite - работа с базами данных SQL для новичков
2 months ago 00:16:56 1
Big Tech AI Is A Lie
2 months ago 00:07:26 1
Max Consecutive Ones III - Leetcode 1004 - Sliding Window (Python)
2 months ago 00:02:04 1
How to import .bak file to a database in SQL server
2 months ago 00:05:01 1
How to Use Full Text Indexes for beginners | Full Text Indexing in Laravel for Beginners #laravel
3 months ago 01:02:46 1
Heroku’s glory days & Postgres vs the world, w/ Craig Kerstiens
3 months ago 03:44:17 7
Администрирование SQL Server ч.1. Базы данных.
4 months ago 04:26:52 1
Learn Python - Full Course for Beginners [Tutorial]
4 months ago 10:41:18 7
QA Engineer From Scratch FULL AUDIO ENGLISH COURSE
4 months ago 01:14:20 3
393: Query All The Things
4 months ago 11:09:41 1
Python for Data Analytics - Full Course for Beginners
4 months ago 00:08:28 7
Лучшие бесплатные курсы и книги по Python в 2024 год.
5 months ago 06:42:29 1
Python App Development: Build Modern GUIs in 7 Hours (Beginners Course)
5 months ago 19:23:46 1
Data Analyst Bootcamp for Beginners (SQL, Tableau, Power BI, Python, Excel, Pandas, Projects, more)
5 months ago 04:22:13 1
Data Analysis with Python - Full Course for Beginners (Numpy, Pandas, Matplotlib, Seaborn)
5 months ago 04:03:27 1
SQL Server Performance Essentials – Full Course
5 months ago 01:06:45 1
Make Your Own SQL Server Queries Go Faster by John Sterrett
5 months ago 00:06:13 1
SQL for fun and profit
5 months ago 01:51:23 1
Harvard CS50 (2023) – Full Computer Science University Course
5 months ago 01:06:23 1
Energy power meters 3 units connect wtih WinCC Explorer SCADA Server and Client configuration
5 months ago 00:31:15 1
Inside a 1200 Sq Ft Live Room - Hi-Five Studio Tour
5 months ago 00:18:25 2
Уличные портреты на пленочный средний формат в Питере летом. Bronica SQ-Ai. Kodak Portra 160