mcAfee-secured website

Course name Databases Courses MySql Comprehensive Course from Professional: MySql Comprehensive Course from Professional

MySql Comprehensive Course from Professional Video Course

MySql Comprehensive Course from Professional Video Course is developed by Databases Courses Professionals to help you pass the MySql Comprehensive Course from Professional exam.

You Will Learn:

Was 21.99 USD
Now 19.99 USD

Description

This course will improve your knowledge and skills required to pass MySql Comprehensive Course from Professional exam.

Curriculum For This Course

  • 1. Introduction and 5 Minutes of SQL 4 Videos 00:12:30
    • Course Introduction 01:08
    • Instructor Introduction(s) 01:25
    • Your First 5 Minutes of SQL - Let's Get Coding! 06:13
    • How The Course Works 03:44
  • 2. Getting Started: Overview and Installation 11 Videos 00:60:24
    • Section Introduction 01:03
    • What Is a Database? 07:16
    • SQL Vs. MySQL 05:50
    • Installation Overview - WATCH BEFORE INSTALLING 05:10
    • Setting Up Cloud9 04:48
    • Exploring The Cloud9 Interface 05:51
    • Cloud9 Interface Challenge 02:42
    • Installing MySQL on Cloud9 08:35
    • Your First MySQL Activity 03:58
    • Mac Installation 11:41
    • Windows Installation 03:32
  • 3. Creating Databases and Tables 11 Videos 00:38:35
    • Section 3 Introduction 01:09
    • Creating Databases 05:20
    • Dropping Databases 01:46
    • Using Databases 03:01
    • Introduction to Tables 05:09
    • The Basic Datatypes 07:52
    • Basic Datatypes Challenge 02:36
    • Creating Your Own Tables 03:06
    • How Do We Know It Worked? 02:33
    • Dropping Tables 01:36
    • Creating Your Own Tables Challenge 04:29
  • 4. Inserting Data (and a couple other things) 12 Videos 00:55:40
    • Section 4 Introduction 01:40
    • Inserting Data 05:03
    • Super Quick Intro To SELECT 02:08
    • Multiple INSERT 03:00
    • INSERT Challenges 01:36
    • INSERT Challenges Solution 04:44
    • MySQL Warnings 05:36
    • NULL and NOT_NULL 06:54
    • Setting Default Values 07:17
    • A Primer On Primary Keys 12:21
    • Table Constraints Exercise 01:51
    • Table Constraints Exercise Solution 03:34
  • 5. CRUD commmands 14 Videos 00:39:54
    • Section 5 Introduction 01:31
    • Introduction to CRUD 01:44
    • Preparing Our Data 02:29
    • Official Introduction to SELECT 04:18
    • Introduction to WHERE 05:05
    • SELECT Challenges 02:00
    • SELECT Challenges Solution 02:45
    • Introduction to Aliases 02:55
    • The UPDATE Command 03:58
    • UPDATE Challenges 00:37
    • UPDATE Challenges Solution 03:58
    • Introduction to DELETE 04:41
    • DELETE Challenges 01:11
    • DELETE Challenges Solution 02:45
  • 6. CRUD Challenge Section 6 Videos 00:24:32
    • Section 6 Introduction 01:52
    • CRUD Exercise Overview 07:26
    • CRUD Exercise Create Solution 05:55
    • CRUD Exercise Read Solution 01:48
    • CRUD Exercise Update Solution 04:10
    • CRUD Exercise Delete Solution 03:21
  • 7. The World Of String Functions 11 Videos 01:02:09
    • Section 7 Introduction 02:04
    • Running SQL Files 10:15
    • Loading Our Book Data 05:25
    • Working with CONCAT 11:07
    • Introducing SUBSTRING 10:05
    • Introducing REPLACE 06:39
    • Using REVERSE 03:39
    • CODE: Using REVERSE 04:54
    • Working with CHAR LENGTH 03:20
    • Changing Case with UPPER and LOWER 04:42
    • String Function Challenges 13:08
  • 8. Refining Our Selections 9 Videos 00:50:51
    • Section 8 Introduction 00:35
    • Seed Data: Adding A Couple New Books 02:47
    • Using DISTINCT 08:24
    • Sorting Data with ORDER BY 11:19
    • Using LIMIT 09:03
    • CODE: Using LIMIT 07:42
    • Better Searches with LIKE 06:09
    • LIKE Part 2: More Wildcards 04:52
    • Refining Selections Exercises 12:29
  • 9. The Magic of Aggregate Functions 10 Videos 01:07:05
    • Section 9 Introduction 03:56
    • The Count Function 08:38
    • The Joys of Group By 12:22
    • Min and Max Basics 04:12
    • SUBQUERIES - A Problem with Min and Max 07:15
    • Using Min and Max with Group By 06:39
    • The Sum Function 04:27
    • The Avg Function 06:00
    • Aggregate Functions Challenges 04:27
    • Aggregate Functions Challenges Solution 09:10
  • 10. Revisiting Data Types 12 Videos 01:25:44
    • Section 10 Introduction 01:56
    • CHAR and VARCHAR 14:29
    • Note about CHAR and VARCHAR 06:08
    • DECIMAL 07:45
    • FLOAT and DOUBLE 04:31
    • DATE, TIME, and DATETIME 05:49
    • Creating Our DATE data 05:16
    • CURDATE, CURTIME, and NOW 14:29
    • Formatting Dates 09:40
    • Date Math 10:54
    • Working with TIMESTAMPS 04:50
    • Data Types Exercises 13:58
  • 11. The Power of Logical Operators 12 Videos 01:38:39
    • Section 11 Introduction 02:44
    • Not Equal 04:26
    • Not Like 02:34
    • Greater Than 10:04
    • Less Than 03:48
    • Logical AND 09:47
    • Logical OR 06:41
    • Between 10:57
    • In And Not In 11:47
    • Case Statements 11:21
    • Logical Operators Exercises 06:45
    • Logical Operators Exercises Solution 17:47
  • 12. Section 12: One To Many 14 Videos 02:06:20
    • Section 12 Introduction 01:57
    • Real World Data Is Messy 10:28
    • Types of Data Relationships 04:37
    • One To Many: The Basics 12:33
    • Working With Foreign Keys 12:05
    • Cross Join 07:36
    • Inner Join 12:45
    • Left Join 15:17
    • Right Joins Pt 1 10:37
    • Right Joins Pt 2 09:51
    • Right and Left Joins: A Common Question 03:09
    • Our First Joins Exercise 06:59
    • Our First Joins Exercise SOLUTION 09:10
    • Our First Joins Exercise SOLUTION PT. 2 09:21
  • 13. Section 13: Many To Many 10 Videos 01:09:49
    • Section 13 Introduction 01:54
    • Many To Many Basics 10:48
    • Creating Our Tables 06:08
    • TV Joins Challenge 1 04:49
    • TV Joins Challenge 2 06:23
    • TV Joins Challenge 3 04:59
    • TV Joins Challenge 4 05:59
    • TV Joins Challenge 5 04:56
    • TV Joins Challenge 6 11:57
    • TV Joins Challenge 7 07:09
  • 14. Instagram Database Clone 9 Videos 00:54:49
    • Section 14 Introduction 01:42
    • Introduction To Instagram Clone Schema 08:30
    • Cloning Instagram's DB: Users Schema 04:53
    • Cloning Instagram's DB: Photos Schema 06:41
    • Cloning Instagram's DB: Comments Schema 07:22
    • Cloning Instagram's DB: Likes Schema 07:05
    • CODE: IG Clone Likes Schema 03:13
    • Cloning Instagram's DB: Followers Schema 05:29
    • Cloning Instagram's DB: Hashtags Part 1 05:15
  • 15. Working With Lots Of Instagram Data 9 Videos 00:50:07
    • Section 15 Introduction 01:42
    • Loading The JUMBO dataset 08:30
    • Instagram Clone Challenge 1 04:53
    • Instagram Clone Challenge 2 06:41
    • Instagram Clone Challenge 3 07:22
    • Instagram Clone Challenge 4 07:05
    • Instagram Clone Challenge 5 03:13
    • Instagram Clone Challenge 6 05:29
    • Instagram Clone Challenge 7 05:15
  • 16. Section 16 - Introducing Node 16 Videos 02:01:07
    • Section 16 Introduction 01:36
    • MySQL and Other Languages 08:59
    • BUT WHAT ABOUT PHP 07:34
    • Introduction to JOIN US app 06:30
    • Setting Up Cloud9 for Node 06:12
    • 5 Minute NodeJS Crash Course 09:11
    • Introduction to NPM and Faker 04:53
    • Introducing the MySQL Package 12:46
    • Connecting Node to MySQL 06:54
    • Creating Our Users Table 06:15
    • Selecting Using Node 11:31
    • Inserting Using Node 07:41
    • Some MySQL/Node Magic 07:41
    • Bulk Inserting 500 Users - Finally! 08:40
    • 500 Users Exercises 02:30
    • 500 Users Exercises Solutions 11:55
  • 17. Section 17 - Building Our Web App 10 Videos 01:43:01
    • Section 17 Introduction 01:53
    • Introducing Express 05:41
    • NPM Init and package.json files 06:39
    • Our First Simple Web App 16:33
    • Adding Multiple Routes 09:56
    • Connecting Express and MySQL 11:08
    • Adding EJS Templates 16:02
    • Connecting The Form 18:32
    • Styling Part 1 08:24
    • Styling Part 2 08:16
  • 18. Section 18 - Database Triggers 5 Videos 00:41:42
    • Introduction to Database Triggers 06:10
    • Writing Our First Trigger Part 1 07:27
    • Writing Our First Trigger Part 2 11:36
    • Creating Logger Triggers 10:17
    • Managing Triggers And A Warning 06:12