MySQL: From Beginner to Monster Level (4-Hour Complete Course)

Описание:

Become a MySQL boss in just 4 hours! This comprehensive course takes you on a journey from absolute beginner to confident database master. In this action-packed course, you'll gain a solid foundation in MySQL, the world's most popular open-source relational database management system. Whether you're a web developer, data analyst, or simply looking to unlock the power of your data, this course equips you with the essential skills you need to succeed. You'll learn MySQL fundamentals, building databases, mastering queries, and data optimization. By the end, you'll confidently design and build relational databases, write effective SQL queries, manage and optimize databases, and tackle any database task. 00:00 - Intro 1:03 - HuXn 2.0 1:26 - What is Database 2:08 - What is DBMS 3:03 - Difference Between SQL & MySQL 4:29 - Analogy 5:08 - Real World Analogy 6:58 - Amazing Setup 14:56 - Databases CRUD Theory 17:26 - Databases CRUD Code 28:58 - Tables Theory 30:15 - Datatypes Theory 33:02 - Tables Code 38:27 - Default Values 43:43 - Exploring Datatypes in detail 47:36 - Detail Datatypes Code 50:29 - Inserting & Retrieving Data From Table Theory 53:42 - Inserting & Retrieving Data From Table Code 1:04:01 - Primary Keys Theory 1:04:22 - Primary Keys Code 1:13:06 - WHERE clause Theory 1:15:03 - WHERE clause Code 1:19:46 - Updating Columns Theory 1:22:27 - Updating Columns Code 1:28:47 - The Power Of WHERE Clause 1:30:26 - Delete Column From The Table Theory 1:31:35 - Delete Column Code 1:32:36 - Delete Everything 1:33:21 - Datatypes Practice 1:47:03 - Functions Theory 1:49:18 - Functions Code 2:01:59 - Order by & Limit Theory 2:03:35 - Oder by & Limit Code 2:07:21 - Like Theory 2:08:02 - Like Code 2:11:36 - Aggregate Functions Theory 2:12:48 - Aggregate Functions Code 2:16:25 - Group By Theory 2:16:50 - Group By Code 2:17:46 - Operators Theory 2:19:56 - Operators Code 2:33:20 - Case Statement Theory 2:34:19 - Case Statement Code 2:38:14 - Unique Theory 2:38:33 - Unique Code 2:41:36 - Check Constraint In Depth 2:53:17 - Altering Tables Theory 2:55:18 - Altering Tables Code 2:59:23 - What is Relationship 3:01:36 - One To One Relationship 3:04:09 - Foreign Keys 3:04:37 - One To Many Relationship Theory 3:06:42 - One To Many Relationship Code 3:21:52 - Joins Intro 3:22:18 - Cross Join 3:24:49 - Inner Join 3:29:24 - Left Join 3:32:03 - Right Join 3:33:43 - Many To Many Relationship Theory 3:34:54 - Many To Many Relationship Code 3:44:36 - Views Theory 3:45:00 - Views Code 3:53:10 - Outro