Mastering MySQL: From Basics to Advanced

By Warda Haibe Categories: Mysql

About Course

This comprehensive course is designed to take you from a beginner to an advanced level in MySQL. You’ll learn the fundamentals of database management, the intricacies of SQL queries, and advanced database optimization techniques. Whether you’re a developer, data analyst, or aspiring database administrator, this course equips you with the skills to effectively manage and query data using MySQL

Introduction to MySQL and Relational Databases
Relational Database Management System (RDBMS) Overview
Installing and Setting Up MySQL
Using MySQL Workbench and Command Line
Database Design and Creation
Understanding Tables, Columns, Rows, and Keys
Creating and Modifying Databases
Data Types and Their Uses
Primary and Foreign Keys
SQL Basics
Writing Simple Queries
Using SELECT, INSERT, UPDATE, and DELETE Commands
Filtering Data with WHERE Clauses
Sorting and Grouping Data
Advanced SQL Techniques
Subqueries and Joins (INNER, OUTER, LEFT, RIGHT)
Aggregate Functions (SUM, AVG, COUNT, etc.)
Indexes and Their Importance

Course Content

Introduction to MySQL

Introduction to SQL

07:42
SQL CREATE DATABASE

06:02
SQL CREATE TABLE Statement

10:52
SQL INSERT INTO Statement

18:57
SQL SELECT Statement

03:39
SQL SELECT DISTINCT Statement

04:51
SQL WHERE Clause

06:13
SQL AND & OR Operators

08:35
SQL ORDER BY Keyword

06:49
SQL UPDATE Statement

06:17
SQL DELETE Statement

06:17
SQL SELECT TOP Clause

06:17
SQL LIKE Operator

08:02
SQL IN Operator

05:41
SQL BETWEEN Operator

06:03
SQL Aliases

10:12
SQL Joins

02:28
SQL INNER JOIN Keyword SQL

10:20
SQL LEFT JOIN Keyword

03:03
SQL RIGHT JOIN Keyword

03:03
SQL FULL OUTER JOIN Keyword

04:29
SQL UNION Operator

06:25
SQL Creating Backup table

04:06
SQL Constraints SQL

04:44
SQL NOT NULL Constraint

06:57
SQL UNIQUE Constraint

07:59
SQL PRIMARY KEY Constraint

08:30
SQL FOREIGN KEY Constraint

05:52
SQL CHECK Constraint

06:46
SQL DEFAULT Constraint

10:44
SQL CREATE INDEX Statement

04:32
SQL DROP INDEX, DROP TABLE, and DROP DATABASE

05:05
SQL ALTER TABLE Statement

05:59
SQL AUTO INCREMENT

09:41
SQL View Statement

06:31
MySQL Data Types

05:04
SQL Functions

02:34
SQL AVG() Function

04:32
SQL COUNT() Function

03:01
SQL FIRST() & LAST() Function

04:44
SQL MAX() & MIN() Function

05:27
SUM() Function

02:42
SQL UCASE() & LCASE() Function

04:07
SQL GROUP BY Statement

05:32
HAVING

05:02

Add this certificate to your resume to demonstrate your skills & increase your chances of getting noticed.

Student Ratings & Reviews

No Review Yet

About Course

What Will You Learn?

Course Content

Introduction to MySQL

Introduction to SQL

SQL CREATE DATABASE

SQL CREATE TABLE Statement

SQL INSERT INTO Statement

SQL SELECT Statement

SQL SELECT DISTINCT Statement

SQL WHERE Clause

SQL AND & OR Operators

SQL ORDER BY Keyword

SQL UPDATE Statement

SQL DELETE Statement

SQL SELECT TOP Clause

SQL LIKE Operator

SQL IN Operator

SQL BETWEEN Operator

SQL Aliases

SQL Joins

SQL INNER JOIN Keyword SQL

SQL LEFT JOIN Keyword

SQL RIGHT JOIN Keyword

SQL FULL OUTER JOIN Keyword

SQL UNION Operator

SQL Creating Backup table

SQL Constraints SQL

SQL NOT NULL Constraint

SQL UNIQUE Constraint

SQL PRIMARY KEY Constraint

SQL FOREIGN KEY Constraint

SQL CHECK Constraint

SQL DEFAULT Constraint

SQL CREATE INDEX Statement

SQL DROP INDEX, DROP TABLE, and DROP DATABASE

SQL ALTER TABLE Statement

SQL AUTO INCREMENT

SQL View Statement

MySQL Data Types

SQL Functions

SQL AVG() Function

SQL COUNT() Function

SQL FIRST() & LAST() Function

SQL MAX() & MIN() Function

SUM() Function

SQL UCASE() & LCASE() Function

SQL GROUP BY Statement

HAVING

Earn a certificate

Student Ratings & Reviews

Resources

Useful Links

Important Links