Learn SQL for Beginners - COMPLETE SQL Tutorial
Learn SQL for beginners easily through a comprehensive tutorial covering the basics and essentials🔥
► I'll introduce you to SQL using SQL Server and SQL Server Management Studio (SSMS).
► We'll show you how to write your first SQL queries using basic commands (SELECT, FROM, WHERE, ORDER BY, etc.), aggregations (GROUP BY, COUNT, MAX, MIN, AVG, etc.), and joins (LEFT JOIN, INNER JOIN, LEFT OUTER JOIN, CROSS JOIN, etc.).
📢 My newsletter where I decipher data news and share my tips to boost your skills 🚀👇👇
https://dataseito.substack.com/
00:00 - What is SQL?
01:09 - Setting up the environment
03:22 - Loading the data
05:48 - First SQL query
06:37 - SELECT and FROM
08:05 - SELECT *
09:29 - TOP N
09:57 - WHERE
14:17 - ORDER BY
15:28 - DISTINCT
16:07 - COUNT
16:49 - GROUP BY
20:08 - HAVING
20:59 - SQL joins
22:25 - USE
22:25 - LEFT JOIN
25:15 - RIGHT JOIN
25:49 - INNER JOIN
26:07 - FULL OUTER JOIN
26:17 - CROSS JOIN
26:36 - Examples of SQL joins
29:37 - UNION
30:53 - UNION ALL
My networks
► Contact me: / claudioanfuso
► More exclusive content: / dataseito
🌐 SQL Server: https://www.microsoft.com/fr-fr/sql-s...
🌐 SQL Server Management Studio - SSMS: https://learn.microsoft.com/fr-fr/sql...
🌐 Data and exercises used: https://github.com/Dataseito/Apprendr...
#sql #beginner #tutorial #sqlserver
Ps: SUBSCRIBE 🔥 It's the best way to keep improving yourself😉