filmov
tv
SQL Tutorial for Beginners [Ultimate Full Course] - From Zero to HERO

Показать описание
In this 4-Hour SQL Course for Beginners, you'll learn everything you need to get started with SQL!
☕ Stay connected
📚 Free Courses
🎓Other Platforms (Certifications)
⏱️ 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**
☕ Stay connected
📚 Free Courses
🎓Other Platforms (Certifications)
⏱️ 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**
Комментарии