Learn SQL Beginner to Advanced in Under 4 Hours

Опубликовано: 08 Октябрь 2024
на канале: Alex The Analyst
85,485
3.3k

💻Take my Full MySQL Course Here: https://www.analystbuilder.com/course...

Download MySQL: https://dev.mysql.com/downloads/insta...

Download Datasets: https://github.com/AlexTheAnalyst/MyS...
____________________________________________

RESOURCES:

💻Analyst Builder - https://www.analystbuilder.com/

📖Take my Full MySQL Course Here: https://bit.ly/3tqOipr
📖Take my Full Python Course Here: https://bit.ly/48O581R
📖Practice Technical Interview Questions: https://bit.ly/46pDqqL

Coursera Courses:
Google Data Analyst Certification: https://coursera.pxf.io/5bBd62
Data Analysis with Python - https://coursera.pxf.io/BXY3Wy
IBM Data Analysis Specialization - https://coursera.pxf.io/AoYOdR
Tableau Data Visualization - https://coursera.pxf.io/MXYqaN

Udemy Courses:
Python for Data Science - https://bit.ly/3Z4A5K6
Statistics for Data Science - https://bit.ly/37jqDbq
SQL for Data Analysts (SSMS) - https://bit.ly/3fkqEij
Tableau A-Z - http://bit.ly/385lYvN

Please note I may earn a small commission for any purchase through these links - Thanks for supporting the channel!
____________________________________________

BECOME A MEMBER -

Want to support the channel? Consider becoming a member! I do Monthly Livestreams and you get some awesome Emoji's to use in chat and comments!

   / @alextheanalyst  
____________________________________________

Websites:
💻Website: AlexTheAnalyst.com
💾GitHub: https://github.com/AlexTheAnalyst
📱Instagram: @Alex_The_Analyst
____________________________________________

0:00 Intro
0:52 Installing MySQL and Setting up Database
11:19 Select Statement
21:47 Where Clause
33:54 Group By
44:18 Having vs Where
47:41 Limit and Aliasing
51:10 Joins
1:08:04 Unions
1:15:10 String Functions
1:26:39 Case Statements
1:35:16 Subqueries
1:45:58 Window Functions
1:58:55 CTEs
2:09:07 Temp Tables
2:16:34 Stored Procedures
2:28:51 Triggers and Events
2:42:46 Data Cleaning Project
3:32:14 Exploratory Data Analysis Project

All opinions or statements in this video are my own and do not reflect the opinion of the company I work for or have ever worked for


Смотрите видео Learn SQL Beginner to Advanced in Under 4 Hours онлайн без регистрации, длительностью часов минут секунд в хорошем качестве. Это видео добавил пользователь Alex The Analyst 08 Октябрь 2024, не забудьте поделиться им ссылкой с друзьями и знакомыми, на нашем сайте его посмотрели 85,48 раз и оно понравилось 3.3 тысяч людям.