Email: it@huph.edu.vn

Udemy - The Ultimate MySQL Bootcamp Go from SQL Beginner to Expert 2025-6

0 students Last updated Jul 2025

About the course

Udemy - The Ultimate MySQL Bootcamp Go from SQL Beginner to Expert 2025-6

Course content

Sections: 21

•

Activities: 1

•

Resources: 222

Announcements
1 This Course Was Just Updated
3 Course Intro
4 About Me
5 Getting The Course Code
7 First 5 Minutes of SQL

1 Section Introduction
2 What Is A Database
3 SQL vs MySQL
4 Installation START HERE
6 FOLLOW THE PREVIOUS LECTURE NOTE INSTEAD Installation Windows Instructions
8 FOLLOW THE PREVIOUS LECTURE NOTE INSTEAD Installation Mac Instructions

1 Section Introduction
2 Showing Databases
4 Creating Databases
6 Dropping and Using Databases
8 Introducing Tables
9 Data Types The Basics
10 Basic Datatypes Challenge
12 Creating Tables
14 How Do We Know It Worked
16 Dropping Tables
18 Tables Basics Activity
20 MySQL Comments

1 Section Introduction
2 INSERT The Basics
4 A Quick Preview of SELECT
6 Multi inserts
8 INSERT Exercise
10 Working With NOT NULL
12 Sidenote Quotes In MySQL
13 Adding DEFAULT Values
15 Introducing Primary Keys
17 Working With AUTO_INCREMENT
19 Create Table Insert Exercise

1 Section Introduction
2 Introducing CRUD
3 Getting Our New Dataset
5 Officially Introducing SELECT
7 The WHERE clause
9 Rapid Fire Exercises
10 Rapid Fire Exercises SOLUTION
12 Aliases
14 Using UPDATE
16 A Quick Rule Of Thumb
17 UPDATE Exercise
18 UPDATE Exercise SOLUTION
20 Introducing DELETE
22 DELETE Exercise
23 DELETE Exercise SOLUTION

1 Section Introduction
2 Introducing the CRUD Challenge
3 CRUD Challenge Solution Creating
5 CRUD Challenge Solution Reading
7 CRUD Challenge Solution Updating
9 CRUD Challenge Solution Deleting

1 Section Introduction
2 The World Of String Functions
3 Loading Our Books Data
5 CONCAT
7 SUBSTRING
9 Combining String Functions
11 Sidenote SQL Formatting
12 REPLACE
14 REVERSE
16 CHAR_LENGTH
18 UPPER LOWER
20 Other String Functions
22 String Functions Exercise
23 String Functions Exerise SOLUTION

1 Section Introduction
2 Adding Some New Books
4 DISTINCT
6 ORDER BY
8 More On ORDER BY
10 LIMIT
12 LIKE
14 Escaping Wildcards
16 Refining Selections Exercise
17 Refining Selections Exercise SOLUTION

1 Section Introduction
2 Count Basics
4 GROUP BY
6 MIN and MAX Basics
8 Subqueries
10 Grouping By Multiple Columns
12 MIN and MAX With GROUP BY
14 SUM
16 AVG
18 Aggregate Functions Docs
19 Agg Functions Exercise
20 Agg Functions Exercise SOLUTION

1 Section Introduction
2 Surveying Other Data Types
3 CHAR vs VARCHAR
4 INT TINYINT BIGINT etc
5 DECIMAL
6 FLOAT DOUBLE
7 DATE and TIME
8 Working With Dates
10 CURDATE CURTIME NOW
12 Date Functions
14 Time Functions
16 Formatting Dates
18 Date Math
19 TIMESTAMPS
20 DEFAULT ON UPDATE TIMESTAMPS
22 Data Types Exercise
23 Data Types Exercise SOLUTION

1 Section Introduction
2 Not Equal
4 NOT LIKE
6 Greater Than
8 Less Than Or Equal To
10 Logical AND
12 Logical OR
14 Between
16 Comparing Dates
18 The IN Operator
20 CASE
22 IS NULL
23 Exercise
24 Exercise SOLUTION

1 UNIQUE Constraint
3 CHECK Constraints
5 Named Constraints
7 Multiple Column Constraints
9 ALTER TABLE Adding Columns
11 ALTER TABLE Dropping Columns
13 ALTER TABLE Renaming
15 ALTER TABLE Modifying Columns
17 ALTER TABLE Constraints

1 Section Introduction
2 Data is Messy
3 Relationships Basics
4 One to Many Relationship
5 Working with FOREIGN KEY
7 Cross Joins
9 Inner Joins
11 Inner Joins With Group By
13 Left Join
15 Left Join With Group By
17 Right Join
19 On Delete Cascade
21 Joins Exercise
23 Joins Exercise SOLUTION

1 Section Introduction
2 Many to Many Basics
3 Creating Our Many To Many Tables
5 TV Series Challenge 1
7 TV Series Challenge 2
9 TV Series Challenge 3
11 TV Series Challenge 4
13 TV Series Challenge 5
15 TV Series Challenge 6
17 TV Series Challenge 7

1 Introducing Views
3 Updateable Views
4 ReplacingAltering Views
6 HAVING clause
8 WITH ROLLUP
10 SQL Modes Basics
12 STRICT_TRANS_TABLES
13 More Modes

2 Introducing Window Functions
3 Using OVER
5 PARTITION BY
7 ORDER BY with Windows
9 RANK
10 DENSE_RANK ROW_NUMBER
12 NTILE
14 FIRST_VALUE
16 LEAD and LAG

1 Section Introduction
2 IMPORTANT NOTE ABOUT THIS SECTION
3 Introducing Instagram Clone
4 Users Schema
6 Photos Schema
8 Comments Schema
10 Likes Schema
12 Followers Schema
15 3 Approaches for Hashtags
16 Implementing Hashtags Table

1 Section Introduction
2 Getting Lots of Instagram Data
4 Instagram Challenge 1
6 Instagram Challenge 2
8 Instagram Challenge 3
10 Instagram Challenge 4
12 Instagram Challenge 5
14 Instagram Challenge 6
16 Instagram Challenge 7

2 Introduction to Database Triggers
3 Writing Our First Trigger Part 1
4 Writing Our First Trigger Part 2
6 Preventing Instagram Self Follows With Triggers
7 Creating Logger Triggers
8 Managing Triggers And A Warning

4 Section Introduction
5 MySQL and Other Languages
6 BUT WHAT ABOUT PHP
7 Introduction to JOIN US app
9 5 Minute NodeJS Crash Course
12 Introduction to NPM and Faker
14 Introducing the MySQL Package
17 Connecting Node to MySQL
19 Creating Our Users Table
21 Selecting Using Node
23 Inserting Using Node
25 Some MySQLNode Magic
26 Bulk Inserting 500 Users Finally
28 500 Users Exercises
29 500 Users Exercises Solutions

2 Section Introduction
4 Introducing Express
5 NPM Init and packagejson files
7 Our First Simple Web App
9 Adding Multiple Routes
12 Connecting Express and MySQL
14 Adding EJS Templates
16 Connecting The Form
18 Styling Part 1
20 Styling Part 2

Instructors

Enrolment options

Udemy - The Ultimate MySQL Bootcamp Go from SQL Beginner to Expert 2025-6

Udemy - The Ultimate MySQL Bootcamp Go from SQL Beginner to Expert 2025-6

Course modified date: 19 July 2025

Udemy - The Ultimate MySQL Bootcamp Go from SQL Beginner to Expert 2025-6

Enrolled students: There are no students enrolled in this course.

Guests cannot access this course. Please log in.