The Complete MySQL from Scratch: Bootcamp

Name: The Complete MySQL from Scratch: Bootcamp
Rating: 4.3 (95 reviews)

Become an In-demand SQL Master by creating databases and building reports through real-world project queries

Created byMetla Sudha Sekhar

Last updated 11/2025

English

What you'll learn

Create your own database or interact with existing databases
Write complex SQL queries across multiple tables
Build a web app using Python and MySQL
Answer company performance or sales questions using data
Write complex SQL queries across multiple tables
Model real-world data and generate reports using SQL queries
Learn JOINS, How to JOIN multiple tables in real-world data
Create Backup and Restore Secure database
You will learn How to create MySQL Database Tables
You will learn SQL Query writing using DDL and DML Commands
Prepare analytical reports with ease
Learn What is Generative AI / Gen AI
Participate in Practice test to test your learning skills
Discover and use the top AI tools that every professional should know

Course content

9 sections • 59 lectures • 8h 32m total length

Introduction4:16
Mysql introduction
Course Curriculum Overview5:27
you will know course curriculum overview, how the course is designed and it will help you to reach your career goal
Overview of Databases10:23
you will learn Overview of Databases
What is Source code8:47
in this lecture you are going to learn what are file extensions and what is source code
Learn What is Generative AI / Gen AI14:06
Generative artificial intelligence is artificial intelligence capable of generating text, images, videos, or other data using generative models, often in response to prompts. best ai tools are chatgpt, tabnine for developers, and more
Best Practices for Learning Online Course5:14
You will learn how to learn online courses in a more productive way.

MySQL Installation15:49
Install MySQL from official installers, package installers, or source distributions on Windows or Linux, start the server, and manage databases with MySQL Workbench.
MySQL Workbench Installation9:04
you will learn how to install the workbench, Like studio or editor where to interact and work with MySQL database
Connecting to MySQL using Console9:00
you will learn how to connect mysql database server using MySQL console prompt
DOWNLOAD the Resources for Practice Datasets0:01
DOWNLOAD the Resource files for Practice Datasets as explained in the real-world lectures, I hope these will help you for making easy understand this course journey, also you may find how to get restore these files lecture is also available inside the course curriculum - Happy Learning

Overview of Challenges3:43
you will learn Overview of challenges how you will be assigned and solution
SQL Statement Basic15:30
you will learn SQL statement basic construction
SELECT Statement9:19
you will learn how to write sql statement
SELECT DISTINCT4:51
you will learn select disctinct and its usage
Column AS Statement11:43
you will learn Column AS Statement, how simple you will write
COUNT built-in Method usage11:03
you will learn how to use the built-in method like count method while writing SQL statements
SELECT WHERE Clause – Part One4:36
you will learn select statement with where clause statement preparation
SELECT WHERE Clause – Part Two10:40
you will learn select statement with where clause statement preparation practical explanation
SQL ORDER BY Statement7:41
you will learn orderby clause it usage with example query
SQL Limit Clause Statement8:34
you will learn limit clause query statement
SQL Using BETWEEN with Same Column Data11:18
you will learn between operator to fetching the data rows from database like two dates range so on
How to Apply IN Operator10:40
you will learn how to apply IN operator on SQL statement
Wildcard Characters with LIKE and ILIKE11:11
using wildcard with LIKE and ILIKE operator
Practice Test on SQL

Overview of GROUP BY5:39
you will learn what is Groupby and its usage in realtime data objects
Aggregation Function SUM()8:52
you will learn the usage of aggregation function, in this lecture you will learn SUM() function
Aggregation MIN() and MAX()5:29
you will learn how to write and use aggregation functions of MIN and MAX while writing SQL query it self
GROUP BY - Part One9:13
you will learn group by functionality on SQL statement
GROUP BY – Part Two11:45
you will learn group by practice session how to grouping the data rows from a group of tables
HAVING Statement5:04
you will learn having clause and its usage

Overview of JOINS3:36
you will learn what is join and its concept in SQL database
Introduction to JOINS4:01
introductions to joins and types of joins are available mostly you learn
AS Statement3:04
what is as statement and its usage on table name applying as statement of Alias names
INNER Join18:29
you will learn a very simple example of inner join
Full Outer Join11:11
you will learn full outer join how to prepare using union in MySQL
Left Outer Join7:53
you will learn left outer join in SQL statements
Right Outer Join7:45
you will learn right outer join
Union6:44
you will learn union statement on sql query

Basic of Advanced SQL Commands3:37
in this session, you will learn basic of advanced SQL commands and its usage for next lecture easy understanding
Timestamps12:22
you will learn timestamp default function and its usage
Extract from Timestamp9:58
you will learn how to extract date and independent data items from time stamp
Mathematical Functions11:39
you will learn how to use mathematical functions
String Functions22:15
you will learn advanced built-in sql string functions
SubQuery13:25
you will lean inner loop query like subquery with a very simple example

Basic of Database and Tables6:09
you will learn basic of database and tables of database server
Data Types10:29
you will learn column datatypes which mysql will supports
Primary Keys and Foreign Keys5:33
you will learn primary and foreign key constraints from this lecture
Create Table in SQL Script13:12
you will learn how to create a table using SQL scripting language of DDL command
Insert Statement in MySQL10:46
you will learn preparation of SQL Insert statement to insert the data rows in to a specific table columns
Update Statement in MySQL7:08
you will learn update query statement applying a table instered data rows
Delete4:08
you will learn a query statement of delete query
Alter Table9:30
you will lean alterations of you already created table, like modification of column name or its data type and adding columns, removing columns and many
Drop Table5:20
you will learn how to drop a table permanently from database
Check Constraint7:54
you will learn how to drop a table
NOT NULL Constraint7:54
you will learn not null constraints in database
UNIQUE Constraint9:14
you will learn unique constrain and its usage with realtime example

Requirements

No SQL and No previous programming language experience required, but it won't hurt :)
No software is required in advance of the course (all software used in the course is free)
All you need is a working computer for this course; PC, Mac, and Linux users are all welcome.

Description

Master the art of database management with "The Complete MySQL from Scratch: Bootcamp." This comprehensive course is designed to take you from a complete beginner to a confident MySQL user, equipping you with the skills needed to manage, query, and optimize relational databases effectively.

Starting with the basics, you’ll learn what databases are, why they’re essential, and how MySQL fits into the tech landscape. From setting up your MySQL environment to writing your first SQL query, this course provides step-by-step guidance on every aspect of MySQL. You'll explore key topics like creating and managing databases, designing tables, data types, and normalization principles.

update: Learn the top AI tools every professional needs to boost productivity

As you progress, you’ll dive into advanced topics such as complex joins, subqueries, stored procedures, indexing, and optimizing database performance. You’ll integrate MySQL with programming languages like Python and PHP, preparing you to build robust, data-driven applications in future learnings.

The course is rich with hands-on exercises, real-world projects, and practical use cases to ensure you can apply your skills in professional settings. By the end of the bootcamp, you’ll have a strong foundation in MySQL, empowering you to handle database challenges in careers like data analysis, web development, and beyond.

Join now to start your journey in mastering MySQL from scratch!

Who this course is for:

Who is interested in learning SQL to help with their current job or to find a new role. SQL is one of today's most in-demand skills
Anyone looking to answer complex business problems and generate reports using large sets of data
Business owners, people in sales, or in marketing roles who are interested in understanding company data Analysis.
Developers who are looking to build applications (e.g. social media network, ecommerce site) using MySQL
Anyone who wants to build business intelligence and analytical reports

The Complete MySQL from Scratch: Bootcamp

What you'll learn

Explore related topics

Course content

Course Introduction6 lectures • 48min

Future Essential AI Tools for Every Professional1 lecture • 5min

SQL Environment Setup4 lectures • 34min

SQL Statement Basics13 lectures • 2hr 1min

GROUP BY Statements6 lectures • 46min

JOINS8 lectures • 1hr 3min

Advanced SQL Commands / Statements6 lectures • 1hr 13min

Creating Database and Tables12 lectures • 1hr 37min

Databases and Tables3 lectures • 24min

Requirements

Description

Who this course is for: