Learn SQL for Beginners - COMPLETE SQL Tutorial

Published: 30 October 2024
on channel: Dataseito

128,341

2.5k

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😉

On this page of the site you can watch the video online Learn SQL for Beginners - COMPLETE SQL Tutorial with a duration of hours minute second in good quality, which was uploaded by the user Dataseito 30 October 2024, share the link with friends and acquaintances, this video has already been watched 128,341 times on youtube and it was liked by 2.5 thousand viewers. Enjoy your viewing!

13,912

323