Course Overview
Hello and welcome to SQL – MySQL: Complete Master Bootcamp | Beginner-Expert!
Learn and understand the skills you need to become a master of SQL & MySQL using real-world projects. Learn to build real-life data analytic reports with complex queries. Start learning from scratch to advanced topics in SQL with Instructor support: Ask questions and get quick responses.
This course is updated frequently with new lessons, projects, and resources!
Start Learning SQL TODAY!
#Reviews about this course
"This course was very in-depth, it does take a lot of time and focus but was certainly worth it. I would highly recommend it to anyone that is looking to further advance or start a SQL career."
"Thanks for sharing such valuable information."
"It's an interesting well explained course for beginners with enough practice material to get a hold on concepts. I am building more & more knowledge & interest at each micro-step"
"Such a great match! So far he explains it in lamen's terms that are incredibly easy to understand. I am looking forward to more!"
"It is a great opportunity to learn valuable things which can boost you for a perfect job. The Instructor has the talent to transfer knowledge. Watch the videos, and Practice more and more. One of my best courses. Probably the best!"
"I learned a lot of stuff. This course contains a lot of information and is well organized. Really good teacher!"
WHO IS THIS COURSE FOR?
For Beginner, Intermediate & Expert Level (such as SQL fundamentals, SQL essential, intermediary SQL & advanced SQL).
This course is for you if you are tired of SQL courses that are too brief, too simple, or too complicated.
This course is for you if you want to build a real-world database, reports, and projects with SQL & connect to Python.
This course is for you if you want to master the in-and-out of SQL queries including complex and advanced queries.
This course is for you if you want to learn MySQL by doing exciting real-life challenges that will distinguish you from the crowd.
This course is for you if you want to learn Advanced SQL for Business Analysis, Marketing, and Data Management.
This course is for you if you've discovered without SQL you can't do much with data analytics, data science, machine learning, AI, or become a better developer.
This course is for you if you want to master SQL which you can also use for Oracle SQL, Microsoft SQL Server, SQL Lite, and PostgreSQL.
This MySQL tutorial course is for you if you plan to pass SQL Interview for Data, Business, and Financial Analytics, Data Science, Data Modeller, & Database administration.
This course will teach you in detail such as stored procedures, view, transactions, functions, nested and correlated subquery, and several other tips you don't in other MySQL courses.
This course covers all the following (and many more) both the theory, practical with hands-on exercises with the solutions:
Introduction to SQL
Installation MySQL
Select Statement
Database
Table
Data Types
Insert Query
Candidate, Surrogate, Primary, Alternative & Foreign Key
Primary and Foreign Key Constraints | Alter Table
Alias (AS)
Concat Function
Order By Keyword
Limit Clause
Order By & Rand Function
Comments
Where Clause
Index
Wildcards
Update Statement & Replace Function
Select Distinct Statement
Format Function
Group By Statement | Aggregate
Inner Join
Left Join
Right Join
Self Join
Two Tables Join
Three Tables Join
Four Tables Join
Five Tables Join
Six Tables Join
Seven Tables Join
Eight Tables Join
Nine Tables Join
Ten Tables Join
Offset & Limit
Case Function
Cast Function
Nested & Correlated Subqueries
Subqueries & Exits Operator
String Function
Session
Table Locking
Transaction
View
Stored Procedures (Stored Routines)
User-Defined Functions (Stored Routine)
Triggers
Combining SQL and Python
Combining SQL and Tableau
Research Data Set - Real-World Datasets
CAR SHOP DATA SET - Real-World Datasets
CAMERA SUPPLIERS - Real-World Datasets
With all of the above and many more plus the support, assistance, and guidance of the instructor throughout this complete high-quality guide you will gain numerous skills that will boost your career.
Your understanding of SQL through MySQL is highly valuable.
Whether you are a beginner or a professional desiring to gain more knowledge in SQL, this course is for you. You will be learning from experts with over two decades of experience.
What are you waiting for? Enroll now and let's get started!
FAQ
FAQ area empty
Course curriculum
-
Understanding Database
-
How to Create a Database
-
How to Create Database - IF NOT EXISTS
Xem trước -
How to Select a Database
Xem trước -
How to Find Out the Currently Selected Database
-
How to Check If a Database Exists
-
How to Delete a Database
-
How to Delete a Database if Exists
-
CRUD - Understanding CRUD
-
Table - Introduction and Creating Basic Table in MySQL
-
What is Select Statement?
-
Data Types - Introduction
-
Introduction to MySQL Numeric Data Types
-
Integer Types - INTEGER or INT, SMALLINT, TINYINT, MEDIUMINT, BIGINT
-
Client's Integer Data Types Requirement Scenario
-
Boolean Type (tinyint(1))
-
Fixed-Point Types - DECIMAL & NUMERIC
-
Client's Fixed-Point Data Types Requirement Scenario
-
Floating-Point Types - FLOAT, DOUBLE
-
Client's Floating-Point Data Types Requirement Scenario
-
Bit-Value Type - BIT
-
Client's Bit Data Types Requirement Scenario
-
Introduction to MySQL String Data Types
-
CHAR and VARCHAR Types
-
Client's CHAR and VARCHAR Types Requirement Scenario
-
The BINARY and VARBINARY Types
-
Client's BINARY and VARBINARY Types Requirement Scenario
-
The BLOB and TEXT Types
-
Client's BLOB and TEXT Types Requirement Scenario
-
ENUM Type
-
Client's ENUM Types Requirement Scenario
-
SET Type
-
Client's SET Types Requirement Scenario
-
Alter Table - Intro & Adding a New Column
-
Alter Table - Dropping an Existing Column
-
Alter Table - Modify Column Type and Size
-
Alter Table - Drop Primary Key
-
Alter Table - Add Primary Key
-
Alter Table - Add Unique Constraint
-
Alter Table - Rename Column
-
Alter Table - Add Foreign Key
-
Alter Table - Rename Table
-
Alter Table - Add Default to Column
-
Alter Table - Drop Default from a Column
-
Alter Table - Drop Foreign Key
-
Understanding the MySQL Where Clause
-
List of Comparison Operators and EQUAL TO (=) By Example
-
Comparison Operators NOT EQUAL TO (!=, <>) By Example
-
Comparison Operator GREATER THAN (>) By Example
-
Comparison Operator LESS THAN (<) By Example
-
Comparison Operator LESS THAN OR EQUAL TO (<=) By Example
-
Comparison Operator GREATER THAN OR EQUAL TO (>=) By Example
-
Understanding Logical Operator and AND operator by Example
-
Logical Operator OR By Example
-
Logical Operator NOT By Example
-
Comparison and Logical Operators Combine By Example
-
Between Operator By Example
-
Like Operator (Pattern Matching) with Examples
-
Not Like Operator (Pattern Matching) Example
-
IN Operator by Example
-
NOT IN Operator by Example
-
IS NULL Operator by Example
-
IS NOT NULL Operator by Example
-
ANY Operator by Example
-
ALL Operator by Example
-
Understanding SQL Window Function
-
Window Function - Row_Number Function
-
Window Function - Rank Function
-
Window Function - Dense Rank Function
-
Window Function - NTile Function
-
Window Function - LAG Function
-
Window Function - LEAD Function
-
Window Function - FIRST_VALUE Function
-
Window Function - LAST_VALUE Function
-
Window Function - NTH_VALUE Function
-
Window Function - Function Using NorthWind DataSet
-
Understanding the Update Statement
-
Update Statement by Example 1
-
Update Statement by Example 2
-
Update Statement by Example 3
-
Update Statement by Example 4
-
Update Statement by Example 5
-
Update Statement by Example 6
-
Update Statement by Example 7
-
Replace Function by Example 1
-
Replace Function by Example 2
-
Replace Function by Example 3
-
Understanding your Schema
-
Insert for CustomerDemographics & CustomerCustomerDemo
-
Two Tables Join - Example 1
-
Two Tables Join - Example 2
-
Three Tables Join - Example 1
-
Three Tables Join - Example 2
-
Four Tables Join - Example 1
-
Five Tables Join - Example 1
-
Five to Thirteen Tables Join - Examples
-
Join with where - By Example 1 - Country
-
Join with where - By Example 2 - City
-
Join with where - By Example 3 - Region
-
Join with where - By Example 4 - OrderDate
-
Join and Group By - Count - Example 1
-
Join and Group By - Sum - Example 2
-
Join and Group By - Avg & Min - Example
-
Join and Having - By Example
-
Join and Case - By Example
-
Join with Limit and Concat - By Example
-
Simplifying the Schema used for JOIN in the following sections.
-
Two Tables Join - Challenge and Solution 2
-
Two Tables Join - Challenge and Solution 3
-
Two Tables Join - Challenge and Solution 4
-
Two Tables Join - Challenge and Solution 5
-
Three Table Joins - Challenge and Solution 6
-
Three Tables Join - Challenge and Solution 7
-
Four Tables Join - Challenge and Solution 8
-
Five Tables Join - Challenge and Solution 9
-
Five Tables Join - Challenge and Solution 10
-
Six Tables Join - Challenge and Solution 11
-
Seven Tables Join - Challenge and Solution 12
-
Eight Tables Join - Challenge and Solution 13
-
Nine Tables Join - Challenge and Solution 14
-
Ten Tables Join - Challenge and Solution | For Demonstration Purpose
-
Setting up database for challenges with attached downloadable resource
-
Nested Subquery & JOIN methods | < 1million - Challenge & Solution 1
-
Nested Subquery | Budget above average - Challenge & Solution 2
-
Nested Subquery & More Query Tweaking - Challenge & Solution 3
-
Nested Subquery, INNER JOIN, GROUP BY, HAVING - Challenge & Solution 4
-
Intro
-
CarShop Resource Details
-
Fetching Names of Cars - Challenge & Solution 1
-
Names & Price of Cars - Challenge & Solution 2
-
Cars at a specific price - Challenge & Solution 3
-
Between two prices of cars - Challenge & Solution 4
-
Counting Cars - Challenge & Solution 5
-
Price List of Cars - Challenge & Solution 6
-
Price List For Cambodia Customers - Challenge & Solution 7
-
Car Average Price - Challenge & Solution 8
-
The most expensive car - Challenge & Solution 9
-
Most Expensive Cars - Challenge & Solution 10
-
Honda & Toyota - Challenge & Solution 11
-
All details from two tables - Challenge & Solution 12
-
Specific fields from two tables - Challenge & Solution 13
-
Counting Cars Per Manufacturer - Challenge & Solution 14
-
Average Price Per Manufacturer - Challenge & Solution 15
-
Manufacturer Average Car Price Above $35,000 - Challenge & Solution 16
-
The Cheapest Car - Challenge & Solution 17
-
The Most Expensive Car - Challenge & Solution 18
-
Data Insert - Challenge & Solution 19
-
Correcting Wrong Data - Challenge & Solution 20
-
Discounted Prices I - Challenge & Solution 21
-
Discounted Price II - Challenge & Solution 22
-
VIEW for price list - Challenge & Solution 23
-
What is the current database selected? - Assignment 1
-
What is the current database selected? - Assignment 1 Solution
-
What are the available tables in the database? - Assignment 2
-
What are the available tables in the database? - Assignment 2 Solution
-
Display the details of each of the table in the database - Assignment 3
-
Display the details of each of the table in the database -Assignment 3 Solution
-
SQL Query to retrieve data from one table - Assignment 4
-
SQL Query to retrieve data from one table - Solution to Assignment 4
-
Using Alias - Assignment 5
-
Using Alias - Solution to Assignment 5
-
Retrieving data across two tables using JOIN - Assignment 6
-
Retrieving data across two tables using JOIN - Solution to Assignment 6
-
Retrieving data across three tables using JOIN - Assignment 7
-
Retrieving data across three tables using JOIN - Solution to Assignment 7
-
Aggregate - sum, average, minimum, maximum - Assignment 8
-
Aggregate - sum, average, minimum, maximum - Solution to Assignment 8
-
GROUP BY & Average - Assignment 9
-
GROUP BY & Average - Solution to Assignment 9
-
GROUP BY; RIGHT, LEFT, INNER & NO JOIN - Assignment 10
-
GROUP BY; RIGHT, LEFT, INNER & NO JOIN - Solution to Assignment 10
-
VIEW for three tables JOIN - Assignment 11
-
VIEW for three tables JOIN - Solution to Assignment 11
-
INNER JOIN, Subquery & EXISTS - Assignment 12
-
INNER JOIN, Subquery & EXISTS - Solution to Assignment 12
-
Updating Table with 5% Increase in Salary - Assignment 13
-
Updating Table with 5% Increase in Salary - Solution Assignment 13
-
INNER JOIN and SubQuery - Assignment 14
-
INNER JOIN and SubQuery - Solution Assignment 14
-
INNER JOIN & AND - Assignment 15
-
INNER JOIN & AND - Solution Assignment 15
-
INNER JOIN & SubQuery - Assignment 16
-
INNER JOIN & SubQuery - Solution to Assignment 16
-
SUBQUERY & LIMIT - Assignment 17
-
SUBQUERY & LIMIT - Solution to Assignment 17
-
UCASE - Assignment 18
-
UCASE - Solution to Assignment 18
-
Employees With Same Salary - Task 1
-
Solution: Employees With Same Salary - Task 1
-
Solution: Duplicate Title - Task 2
-
Duplicate Title - Task 2
-
Excluding Titles - Task 3
-
Solution - Excluding Titles - Task 3
-
Eight & Last Alphabet 'n' - Task 4
-
Solution: Eight & Last Alphabet 'n' - Task 4
-
Even Rows - Task 5
-
Solution: Even Rows - Task 5
-
Odd Rows - Task 6
-
Solution: Odd Rows - Task 6
-
Second to Fourth - Task 7
-
Solution: Second to Fourth - Task 7
-
Counting Employee with "SALES" - Task 8
-
Solution: Counting Employee with "SALES" - Task 8
-
Using Sub Query - Second to the Highest Salary - Task 9
-
Solution: Using Sub Query - Second to the Highest Salary - Task 9
-
Tricky Exercise - Task 10
-
Solution: Tricky Exercise - Task 10
-
Tricky Exercise - Task 11
-
Solution: Tricky Exercise - Task 11
-
Tricky Exercise - Task 12
-
Solution: Tricky Exercise - Task 12
-
Tricky Exercise - Task 12b
-
Solution: Tricky Exercise - Task 12b
-
Tricky Exercise - Task 13
-
Solution: Tricky Exercise - Task 13
-
Tricky Exercise - Task 14
-
Solution: Tricky Exercise - Task 14
-
Tricky Exercise - Task 15
-
Solution: Tricky Exercise - Task 15
-
Tricky Exercise - task 16
-
Solution: Tricky Exercise - task 16
-
Tricky Exercise - Task 17
-
Solution: Tricky Exercise - Task 17
-
Tricky Exercise - Task 18
-
Solution: Tricky Exercise - Task 18
-
Introduction to Combining SQL and Python
-
Installation of MySQL Connector for Python
-
Creating Database & Show Databases From Python
-
Creating a Table, Show Table & Describe Table
-
Insert A Row of Data Into A Table & Select
-
Insert Multiple Rows of Data Into A Table
-
FetchOne vs FetchAll
-
Select Filter with Python
-
SQL Wildcard with Python
-
Business Intelligence - Introduction & Definition
-
Business Intelligence Process
-
How to Download and Install Tableau
-
Tableau - What-Is-What In Tableau - I
-
Tableau - What-Is-What In Tableau - II
-
Tableau - What-Is-What In Tableau - III
-
Connecting MySQL to Tableau
-
Tableau & MySQL: Querying SQL Database from Tableau
-
Tableau & MySQL: Visualising CarShop Dataset
-
Tableau & SQL Challenge - Gross Sales and Net Sales Report
Requirment
-
No programming experience is needed - I'll teach you everything you need to know
-
No paid software required - everything will be done with MySQL Workbench (which is free)
-
A Mac laptop/iMac or a Windows PC
-
I'll walk you through, step-by-step on how to get MySQL Workbence installed and set up
-
This SQL MySQL tutorial will move you from zero to hero
-
I'll walk you through on how to get MySQL Connector to run with Python
Outcomes
-
Write complex queries with View, Stored Procedure, Trigger, Transaction, User-defined Function, Session, Table Locking and many more
-
Start from beginner level to expert level and build real-world report with SQL
-
Use Python to create databases, tables and write queries. Use tableau to report your data
-
Write complex queries to retrieve information from single and across multiple tables by using Nested & Correlated Subqueries
-
Write complex queries to retrieve data across multiple tables by using Left, Right, Inner and Full Outer joins queries
-
Learn by doing tons of real-world SQL projects, challenges & assignment with solutions
-
Learn to use complex sorting, filtering, extracting and aggregating queries to analyse data
-
Pass your next BI , Data Analysts and Data Science Interviews and Vivas
-
This SQL MySQL tutorial cover SQL Foundations, SQL beginners, SQL intermediate and SQL expert levels training
-
Join and retrieve data from One, Two, Three, Four, Five, Six, Seven, Eight, Nine and Ten tables
2 Students
16 Courses
0 review