The Complete MySQL Bootcamp Course

Name: The Complete MySQL Bootcamp Course
Brand: Stackskill
Price: 11.99 USD
Availability: Discontinued

182 Enrolled

5 Hours

Deal Price$11.99

Suggested Price$200.00

You save 94%

The Ultimate MySQL Bootcamp: Go from SQL Beginner to Expert

34 Lessons (5h)

Introduction and 5 Minutes of SQL
Course Introduction1:08
Instructor Introduction(s)1:25
Syllabus Walkthrough and Prerequisites4:18
Your First 5 Minutes of SQL - Let's Get Coding!6:13
CODE: Your First 5 Minutes of SQL
How The Course Works3:44
Getting Started: Overview and Installation
Section Introduction1:02
What Is a Database?7:16
SQL Vs. MySQL5:50
Installation Overview - WATCH BEFORE INSTALLING5:10
Setting Up Cloud94:47
Cloud9 What If I Dont Have a Credit Card
Exploring The Cloud9 Interface5:51
Cloud9 Interface Challenge2:42
Installing MySQL on Cloud98:35
CODE: Installing MySQL on Cloud9
Your First MySQL Activity3:58
CODE: Your First MySQL Activity
Mac Installation11:41
CODE: Mac Installation
Windows Installation3:32
Creating Databases and Tables
Section 3 Introduction1:09
Creating Databases5:20
CODE: Creating Databases
Dropping Databases1:46
CODE: Dropping Databases
Using Databases3:00
CODE: Using Databases
Introduction to Tables5:09
The Basic Datatypes7:52
Basic Datatypes Challenge2:35
Basic Datatypes Challenge - Solution
Creating Your Own Tables3:06
CODE: Creating Your Own Tables
How Do We Know It Worked?2:33
CODE: How Do We Know It Worked?
Dropping Tables1:36
CODE: Dropping Tables
Creating Your Own Tables Challenge4:29
CODE: Creating Your Own Tables Challenge
Inserting Data (and a couple other things)
Section 4 Introduction1:40
Inserting Data5:03
CODE: Inserting Data
Super Quick Intro To SELECT2:07
CODE: Super Quick Intro To SELECT
Multiple INSERT3:00
CODE: Multiple Insert
INSERT Challenges1:35
INSERT Challenges Solution4:43
CODE: INSERT Challenges Solution
MySQL Warnings5:35
CODE: MySQL Warnings
NULL and NOT_NULL6:54
CODE: NULL and NOT NULL
Setting Default Values7:17
CODE: Setting Default Values
A Primer On Primary Keys12:21
CODE: A Primer on Primary Keys
Table Constraints Exercise1:51
Table Constraints Exercise Solution3:34
CODE: Table Constraints Exercise Solution
CRUD commmands
Section 5 Introduction1:30
Introduction to CRUD1:44
CODE: Introduction to CRUD
Preparing Our Data2:29
CODE: Preparing Our Data
Official Introduction to SELECT4:18
CODE: Official Introduction to SELECT
Introduction to WHERE5:04
CODE: Introduction to WHERE
SELECT Challenges2:00
SELECT Challenges Solution2:45
CODE: SELECT Challenges Solution
Introduction to Aliases2:55
CODE: Introduction to Aliases
The UPDATE Command3:58
CODE: The UPDATE Command
UPDATE Challenges0:37
UPDATE Challenges Solution3:58
CODE: UPDATE Challenges Solution
Introduction to DELETE4:41
CODE: Introduction to DELETE
DELETE Challenges1:10
DELETE Challenges Solution2:45
CODE: DELETE Challenges Solution
CRUD Challenge Section
Section 6 Introduction1:52
CRUD Exercise Overview7:26
CRUD Exercise Create Solution5:55
CODE: CRUD Exercise Create Solution
CRUD Exercise Read Solution1:48
CODE: CRUD Exercise Read Solution
CRUD Exercise Update Solution4:10
CODE: CRUD Exercise Update Solution
CRUD Exercise Delete Solution3:21
CODE: CRUD Exercise Delete Solution
The World Of String Functions
Section 7 Introduction2:04
Running SQL Files10:15
CODE: Running SQL Files
Loading Our Book Data5:25
CODE: Loading Our Book Data
Working with CONCAT11:07
CODE: Working With CONCAT
Introducing SUBSTRING10:04
CODE: Introducing SUBSTRING
Introducing REPLACE6:39
CODE: Introducing REPLACE
Using REVERSE3:39
CODE: Using REVERSE
Working with CHAR LENGTH4:54
CODE: Working with CHAR LENGTH
Changing Case with UPPER and LOWER3:20
CODE: Changing Case with UPPER and LOWER
String Function Challenges4:42
String Function Challenges Solution13:08
CODE: String Function Challenges Solution
Refining Our Selections
Section 8 Introduction0:35
Seed Data: Adding A Couple New Books2:47
CODE: Seed Data: Adding A Couple New Books
Using DISTINCT8:24
CODE: Using DISTINCT
Sorting Data with ORDER BY11:19
CODE: Sorting Data with ORDER BY
Using LIMIT9:03
CODE: Using LIMIT
Better Searches with LIKE7:42
CODE: Better Searches with LIKE
LIKE Part 2: More Wildcards6:09
CODE: LIKE Part 2: More Wildcards
Refining Selections Exercises4:52
Refining Selections Exercises Solution12:29
CODE: Refining Selections Exercises Solution
The Magic of Aggregate Functions
Section 9 Introduction3:56
The Count Function8:38
CODE: The Count Function
The Joys of Group By12:22
CODE: The Joys of Group By
Min and Max Basics4:12
CODE: MIN and MAX Basics
SUBQUERIES - A Problem with Min and Max7:14
CODE: A Problem with Min and Max
Using Min and Max with Group By6:39
CODE: Using Min and Max with Group By
The Sum Function4:27
CODE: The Sum Function
The Avg Function6:00
CODE: The Avg Function
Aggregate Functions Challenges4:27
Aggregate Functions Challenges Solution9:10
CODE: Aggregate Functions Challenges Solution
Revisiting Data Types
Section 10 Introduction1:56
CHAR and VARCHAR14:29
Note about CHAR and VARCHAR
CODE: CHAR and VARCHAR
DECIMAL6:07
CODE: DECIMAL
FLOAT and DOUBLE7:44
CODE: FLOAT and DOUBLE
DATE, TIME, and DATETIME4:31
Creating Our DATE data5:49
CODE: Creating Our DATE data
CURDATE, CURTIME, and NOW5:15
Formatting Dates14:29
CODE: Formatting Dates
Date Math9:40
CODE: Date Math
Working with TIMESTAMPS10:54
CODE: Working with TIMESTAMPS
Data Types Exercises4:50
Data Types Exercises Solution13:58
CODE: Data Types Exercises Solution
The Power of Logical Operators
Section 11 Introduction2:44
Not Equal4:26
CODE: Not Equal
Not Like2:34
CODE: Not Like
Greater Than10:04
CODE: Greater Than
Less Than3:48
CODE: Less Than
Logical AND9:47
CODE: Logical AND
Logical OR6:41
CODE: Logical OR
Between10:57
CODE: Between
In And Not In11:47
CODE: In And Not In
Case Statements11:20
CODE: Case Statements
Logical Operators Exercises6:45
Logical Operators Exercises Solution17:46
CODE: Logical Operators Exercises Solution
Section 12 One To Many
Section 12 Introduction1:57
Real World Data Is Messy10:28
Types of Data Relationships4:36
One To Many: The Basics12:33
Working With Foreign Keys12:04
CODE: Working With Foreign Keys
Cross Join7:36
CODE: Cross Joins
Inner Join12:44
CODE: Inner Joins
Left Join15:17
CODE: Left Joins
Right Joins Pt 110:36
CODE: Right Joins Part 1
Right Joins Pt 29:51
CODE: Right Joins Part 2
Right and Left Joins: A Common Question3:09
CODE: Right and Left Joins FAQ
Our First Joins Exercise6:58
Our First Joins Exercise SOLUTION9:10
CODE: Our First Joins Exercise
Our First Joins Exercise SOLUTION PT. 29:21
CODE: Our First Joins Exercise SOLUTION PT. 2
Section 13 Many To Many
Section 13 Introduction1:54
Many To Many Basics10:48
Creating Our Tables10:57
CODE: Creating Our Tables
TV Joins Challenge 14:49
CODE: TV Joins Challenge 1 Solution
TV Joins Challenge 26:22
CODE: TV Joins Challenge 2 SOLUTION
TV Joins Challenge 34:59
CODE: TV Joins Challenge 3 SOLUTION
TV Joins Challenge 45:59
CODE: TV Joins Challenge 4 SOLUTION
TV Joins Challenge 54:56
CODE: TV Joins Challenge 5 SOLUTION
TV Joins Challenge 611:57
CODE: TV Joins Challenge 6 SOLUTION
TV Joins Challenge 77:08
CODE: TV Joins Challenge 7 SOLUTION
Instagram Database Clone
Section 14 Introduction1:19
Introduction To Instagram Clone Schema8:31
Cloning Instagram's DB: Users Schema6:08
CODE: IG Clone Users Schema
Cloning Instagram's DB: Photos Schema6:37
CODE: IG Clone Photos Schema
Cloning Instagram's DB: Comments Schema6:39
CODE: IG Clone Comments Schema
Cloning Instagram's DB: Likes Schema7:41
CODE: IG Clone Likes Schema
Cloning Instagram's DB: Followers Schema7:20
CODE: IG Clone Followers Schema
Cloning Instagram's DB: Hashtags Part 110:34
Cloning Instagram's DB: Hashtags Part 25:25
CODE: IG Clone Hashtags Schema
CODE: Complete IG Clone Schema
Working With Lots Of Instagram Data
Section 15 Introduction1:41
Loading The JUMBO dataset8:30
The Instagram Clone DATASET
Instagram Clone Challenge 14:52
Instagram Challenge 1 Solution CODE
Instagram Clone Challenge 26:41
Instagram Challenge 2 Solution CODE
Instagram Clone Challenge 37:22
Instagram Challenge 3 Solution CODE
Instagram Clone Challenge 47:05
Instagram Challenge 4 Solution CODE
Instagram Clone Challenge 53:13
Instagram Challenge 5 Solution CODE
Instagram Clone Challenge 65:29
Instagram Challenge 6 Solution CODE
Instagram Clone Challenge 75:14
Instagram Challenge 7 Solution CODE
Section 16 - Introducing Node
Section 16 Introduction1:36
MySQL and Other Languages8:59
BUT WHAT ABOUT PHP7:34
Introduction to JOIN US app8:00
Setting Up Cloud9 for Node6:30
5 Minute NodeJS Crash Course6:12
CODE: 5 Minute Node Crash Course
Introduction to NPM and Faker9:11
CODE: Introduction to NPM and Faker
Introducing the MySQL Package4:53
Connecting Node to MySQL12:46
CODE: Connecting Node to MySQL
Creating Our Users Table6:54
CODE: Creating Our Users Table
Selecting Using Node6:15
CODE: Selecting Using Node
Inserting Using Node11:31
CODE: Inserting Using Node
Some MySQL/Node Magic7:41
Bulk Inserting 500 Users - Finally!8:40
CODE: Bulk Inserting 500 Users
500 Users Exercises2:30
500 Users Exercises Solutions11:55
CODE: 500 Users Exercises Solutions
Section 17 - Building Our Web App
Section 17 Introduction1:52
Join Us Completed CODE
Introducing Express5:40
NPM Init and package.json files6:38
Our First Simple Web App16:33
CODE: Our First Simple Web App
Adding Multiple Routes9:56
CODE: Adding Multiple Routes
Connecting Express and MySQL11:08
CODE: Connecting Express and MySQL
Adding EJS Templates16:02
CODE: Adding EJS Templates
Connecting The Form18:32
CODE: Connecting the Form
Styling Part 18:24
CODE: HTML AND CSS FILES
Styling Part 28:16
Section 18 - Database Triggers
Introduction to Database Triggers6:10
Writing Our First Trigger Part 17:27
Writing Our First Trigger Part 211:36
Preventing Instagram Self-Follows With Triggers8:16
Creating Logger Triggers10:17
Managing Triggers And A Warning6:12

DescriptionInstructorImportant DetailsRelated Products

Go from SQL Beginner to Expert by Creating Complex Databases & Reports Through Real-World Projects

Colt Steele

Instructor

Colt Steele is a developer with a serious love for teaching. In 2016, he launched his Web Developer Bootcamp course, which has since gone on to become one of the best selling and top-rated courses on StackSkills. He was also voted StackSkills Best New Instructor of 2019.

Description

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 solving complex business problems 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. This course is also chock full of exercises, challenges, projects, and opportunities for you to practice what you’re learning. Apply what you’re learning to real-world challenges. It’s a course with ample opportunity for you to get your hands dirty writing code.

Access 34 lectures & 5 hours of content 24/7
Learn the ins & outs of SQL syntax
Analyze data using Aggregate Functions
Run complex queries using MySQL logical operators & string functions
Write all the common SQL joins
Work w/ large datasets containing thousands of entries
Clone the database structure of a photo-sharing social network
Write Javascript code to generate fake data sets

Specs

Important Details

Length of time users can access this course: lifetime
Access options: web & mobile streaming
Certification of completion included
Redemption deadline: redeem your code within 30 days of purchase
Updates included
Experience level required: beginner

Requirements

PC or Mac
Internet access required

Terms

Unredeemed licenses can be returned for store credit within 30 days of purchase. Once your license is redeemed, all sales are final.

Your Cart

Your cart is empty. Continue Shopping!

Processing order...