SQL Tutorial for Beginners [Ultimate Full Course] - From Zero to HERO
70.5 هزار بار بازدید -
2 سال پیش
-
In this 4-Hour SQL Course
In this 4-Hour SQL Course for Beginners, you'll learn everything you need to get started with SQL!
🔗Free Materials (Downloads): https://bit.ly/BaraaNewsletter
👉 Support & Subscribe to Channel: http://bit.ly/3GiCVUE
✋ Update
About Installing MySQL, almost all steps remain the same, but they only removed "developer" option. You need to select "Full" option and everything should be fine.
☕ Stay connected
- Subscribe: http://bit.ly/3GiCVUE
- Join: @datawithbaraa
- Newsletter: https://bit.ly/BaraaNewsletter
- LinkedIn: LinkedIn: baraa-khatib-salkini
- Website: https://www.datawithbaraa.com
📚 Free Courses
✅ Tableau: Complete HR Tableau Project End-to-En...
✅ Tableau Project: Complete HR Tableau Project End-to-En...
✅ SQL Basics: SQL Tutorial for Beginners [Ultimate ...
✅ SQL Advanced: How I'd Learn Advanced SQL and Why (I...
✅ ChatGPT: ChatGPT Tutorial for Beginners [Ultim...
🎓Other Platforms (Certifications)
- Udemy: https://bit.ly/BaraaUdemy
- Skillshare (1 Free Month): https://bit.ly/BaraaSkillshare
⭐ My favorite books: https://kit.co/DataWithBaraa/my-favor...
💻 My gear: https://kit.co/DataWithBaraa/my-deskt...
⏱️ Timestamp
00:00 Introduction to SQL Course
00:01:58 Course Curriculum Overview
00:03:41 Chapter1 - SQL Basics
00:03:50 #1 Introduction to SQL
00:10:20 #2 Why learn SQL?
00:14:29 #3 SQL Database Concepts
00:18:27 #4 SQL Table Concepts
00:21:13 #5 Main SQL Commands
00:25:35 #6 Elements of SQL Statements
00:29:48 Chapter2 - Prepare the Environment
00:30:04 #7 Download & Install MySQL
00:35:54 #8 Tour in MySQL Interface
00:41:26 #9 Install the Course Database
00:46:02 #10 Guide to SQL Coding Style
00:50:26 Chapter3 - Querying Data
00:50:44 #11 SQL SELECT
00:58:13 #12 SQL DISTINCT
01:01:33 #13 SQL ORDER BY
01:10:27 Chapter4 - Filtering Data
01:10:43 #14 SQL WHERE
01:17:05 #15 SQL Comparison Operators
01:24:11 #16 SQL Logical Operators AND, OR, NOT
01:35:41 #17 SQL BETWEEN
01:41:54 #18 SQL IN
01:46:36 #19 SQL LIKE
01:58:45 Chapter5 - Joining Data
01:59:00 #20 JOINS Concept
02:03:42 #21 SQL Alias - AS
02:07:28 #22 SQL INNER JOIN
02:15:49 #23 SQL LEFT JOIN
02:19:00 #24 SQL RIGHT JOIN
02:21:30 #25 SQL FULL JOIN
02:25:37 #26 SQL UNION & UNION ALL
02:35:35 Chapter6 - SQL Functions
02:35:47 #27 SQL Aggregate Functions
02:48:01 #28 SQL String Functions
03:00:39 Chapter7 - SQL Advanced Topics
03:00:51 #29 SQL GROUP BY
03:09:24 #30 SQL HAVING
03:15:09 #31 SQL Subquery: EXISTS vs IN
03:24:47 Chapter8 - Modifying Data
03:25:00 #32 SQL INSERT
03:39:53 #33 SQL UPDATE
03:45:47 #34 SQL DELETE & TRUNCATE
03:50:08 Chapter9 - Defining Data
03:50:24 #35 SQL CREATE Table
04:00:28 #36 SQL ALTER Table
04:02:18 #37 SQL DROP Table
04:03:05 Next SQL Course & THANK YOU
#sql #mysql #sqlite #data
*Please note I may earn a small commission for any purchase through these links, which means at no additional cost to you - Thanks for supporting the channel!*
*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*
🔗Free Materials (Downloads): https://bit.ly/BaraaNewsletter
👉 Support & Subscribe to Channel: http://bit.ly/3GiCVUE
✋ Update
About Installing MySQL, almost all steps remain the same, but they only removed "developer" option. You need to select "Full" option and everything should be fine.
☕ Stay connected
- Subscribe: http://bit.ly/3GiCVUE
- Join: @datawithbaraa
- Newsletter: https://bit.ly/BaraaNewsletter
- LinkedIn: LinkedIn: baraa-khatib-salkini
- Website: https://www.datawithbaraa.com
📚 Free Courses
✅ Tableau: Complete HR Tableau Project End-to-En...
✅ Tableau Project: Complete HR Tableau Project End-to-En...
✅ SQL Basics: SQL Tutorial for Beginners [Ultimate ...
✅ SQL Advanced: How I'd Learn Advanced SQL and Why (I...
✅ ChatGPT: ChatGPT Tutorial for Beginners [Ultim...
🎓Other Platforms (Certifications)
- Udemy: https://bit.ly/BaraaUdemy
- Skillshare (1 Free Month): https://bit.ly/BaraaSkillshare
⭐ My favorite books: https://kit.co/DataWithBaraa/my-favor...
💻 My gear: https://kit.co/DataWithBaraa/my-deskt...
⏱️ Timestamp
00:00 Introduction to SQL Course
00:01:58 Course Curriculum Overview
00:03:41 Chapter1 - SQL Basics
00:03:50 #1 Introduction to SQL
00:10:20 #2 Why learn SQL?
00:14:29 #3 SQL Database Concepts
00:18:27 #4 SQL Table Concepts
00:21:13 #5 Main SQL Commands
00:25:35 #6 Elements of SQL Statements
00:29:48 Chapter2 - Prepare the Environment
00:30:04 #7 Download & Install MySQL
00:35:54 #8 Tour in MySQL Interface
00:41:26 #9 Install the Course Database
00:46:02 #10 Guide to SQL Coding Style
00:50:26 Chapter3 - Querying Data
00:50:44 #11 SQL SELECT
00:58:13 #12 SQL DISTINCT
01:01:33 #13 SQL ORDER BY
01:10:27 Chapter4 - Filtering Data
01:10:43 #14 SQL WHERE
01:17:05 #15 SQL Comparison Operators
01:24:11 #16 SQL Logical Operators AND, OR, NOT
01:35:41 #17 SQL BETWEEN
01:41:54 #18 SQL IN
01:46:36 #19 SQL LIKE
01:58:45 Chapter5 - Joining Data
01:59:00 #20 JOINS Concept
02:03:42 #21 SQL Alias - AS
02:07:28 #22 SQL INNER JOIN
02:15:49 #23 SQL LEFT JOIN
02:19:00 #24 SQL RIGHT JOIN
02:21:30 #25 SQL FULL JOIN
02:25:37 #26 SQL UNION & UNION ALL
02:35:35 Chapter6 - SQL Functions
02:35:47 #27 SQL Aggregate Functions
02:48:01 #28 SQL String Functions
03:00:39 Chapter7 - SQL Advanced Topics
03:00:51 #29 SQL GROUP BY
03:09:24 #30 SQL HAVING
03:15:09 #31 SQL Subquery: EXISTS vs IN
03:24:47 Chapter8 - Modifying Data
03:25:00 #32 SQL INSERT
03:39:53 #33 SQL UPDATE
03:45:47 #34 SQL DELETE & TRUNCATE
03:50:08 Chapter9 - Defining Data
03:50:24 #35 SQL CREATE Table
04:00:28 #36 SQL ALTER Table
04:02:18 #37 SQL DROP Table
04:03:05 Next SQL Course & THANK YOU
#sql #mysql #sqlite #data
*Please note I may earn a small commission for any purchase through these links, which means at no additional cost to you - Thanks for supporting the channel!*
*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*
2 سال پیش
در تاریخ 1401/10/15 منتشر شده
است.
70,550
بـار بازدید شده