Description

The Complete MySQL Bootcamp: Go from SQL Beginner to Expert If you want to learn how to gain insights from data but are too intimidated by databases to know where to start, then this course is for you. This course is a gentle but comprehensive introduction to MySQL, one of the most highly in-demand skills in the business sector today. Whether you work in sales or marketing, you run your own company, or you want to build your own apps, mastering MySQL is crucial to answering complex business problems and questions using insights from data. The Ultimate MySQL Bootcamp introduces you to a solid foundation in databases in a way that’s both informative and engaging. Yes, that’s right, it’s possible to make an engaging course on databases. Video Section: 01 Introduction and 5 Minutes of SQL 02 Getting Started Overview and Installation 03 Creating Databases and Tables 04 Inserting Data and a couple other things 05 CRUD commmands 06 CRUD Challenge Section 07 The World Of String Functions 08 Refining Our Selections 09 The Magic of Aggregate Functions 10 Revisiting Data Types 11 The Power of Logical Operators 12 Section 12 One To Many 13 Section 13 Many To Many 14 Instagram Database Clone 15 Working With Lots Of Instagram Data 16 Section 16 - Introducing Node 17 Section 17 - Building Our Web App 18 Section 18 - Database Triggers Course Introduction 00:00:00 Getting Started: Overview and Installation 00:16:49 Creating Databases and Tables 01:17:18 Inserting Data (and a couple other things) 01:55:58 CRUD Commands 02:51:43 CRUD Challenge Section 03:31:44 The World of String Functions 03:56:18 Refining Our Selections 05:11:39 The Magic of Aggregate Functions 06:15:03 Revisiting Data Types 07:22:13 The Power of Logical Operators 09:02:00 Section 12: One to Many 10:40:42 Section 13: Many to Many 12:47:08 Instagram Database Clone 13:57:01 Working With Lots of Instagram Data 14:57:18 Section 16 - Introduction Node 15:47:30 Section 17 - Building Our Web App 17:48:43 Section 18 - Database Triggers 19:31:49