Introduction to MySQL Databases Course

33 Lessons
145 Students
Certificate of completion

Track:

Programming

What is the difference between SQL and MySQL? In a nutshell, SQL is a language for querying databases and MySQL is an open source database product. SQL is used for accessing, updating and maintaining data in a database and MySQL is an RDBMS that allows users to keep the data that exists in a database organized .

To Register in Course you have to watch at least 30 Second of any lesson

What You'll Learn

Write complex SQL queries to retrieve and manipulate data in MySQL databases using SELECT, JOIN, and WHERE clauses
Design and implement normalized database schemas to optimize data organization and integrity in MySQL
Apply best practices for database security, user management, and access control in MySQL environments
Perform data backup, recovery, and maintenance tasks to ensure database reliability and availability
Utilize MySQL commands and tools for database installation, configuration, and performance tuning
Create and manage indexes to improve query performance and database efficiency in MySQL
Develop stored procedures, functions, and triggers to automate tasks and enforce data integrity in MySQL
Analyze and troubleshoot common MySQL database issues related to performance, security, and data consistency
Implement data import/export techniques to migrate data between MySQL databases and external sources
Evaluate different MySQL storage engines and configurations to optimize database performance and scalability

Course Content

33 Lessons • 3 h 40 m total

MySQL Database Tutorial 1 Introduction to Databases

7:32

MySQL Database Tutorial 2 Getting a MySQL Server

4:34

MySQL Database Tutorial 3 Creating a Database

9:37

MySQL Database Tutorial 4 SHOW and SELECT

6:36

MySQL Database Tutorial 5 Basic Rules for SQL Statements

4:15

MySQL Database Tutorial 6 Getting Multiple Columns

5:11

MySQL Database Tutorial 7 DISTINCT and LIMIT

5:48

MySQL Database Tutorial 8 Sorting Results

6:56

MySQL Database Tutorial 9 Sort Direction

4:18

MySQL Database Tutorial 10 Basic Data Filtering and WHERE

4:56

MySQL Database Tutorial 11 Advanced Filtering Using AND and OR

6:59

MySQL Database Tutorial 12 Are you IN or are you NOT IN

6:17

MySQL Database Tutorial 13 How Search Engines Work

6:27

MySQL Database Tutorial 14 More on Wildcards

3:14

MySQL Database Tutorial 15 Regular Expressions

7:33

MySQL Database Tutorial 16 Creating Custom Columns

8:44

MySQL Database Tutorial 17 Functions

6:14

MySQL Database Tutorial 18 More on Aggregate Functions

7:57

MySQL Database Tutorial 19 GROUP BY

7:20

MySQL Database Tutorial 20 Subqueries

6:09

MySQL Database Tutorial 21 Another Subquery Example

7:11

MySQL Database Tutorial 22 How to Join Tables

8:29

MySQL Database Tutorial 23 Outer Joins

8:08

MySQL Database Tutorial 24 UNION

5:22

MySQL Database Tutorial 25 Full Text Searching

7:05

MySQL Database Tutorial 26 INSERT INTO

8:07

MySQL Database Tutorial 27 How to Insert Multiple Rows

8:41

MySQL Database Tutorial 28 UPDATE DELETE

7:48

MySQL Database Tutorial 29 CREATE TABLE

7:05

MySQL Database Tutorial 30 NOT NULL AUTO INCREMENT

7:07

MySQL Database Tutorial 31 ALTER DROP RENAME TABLE

6:05

MySQL Database Tutorial 32 Views

8:49

MySQL Database Tutorial 33 Final Video

3:48

How to Get The Certificate

You must have an Account on the platform.
Complete all lessons.
Watch at least 50% of Lesson Duration.
Get your Certificate free 🎉 !

4.7 (44 reviews)

Overall rating

5.0 73%
4.0 27%
3.0 0%
2.0 0%
1.0 0%

Reviews

5186_Vishalini E

· 3mos ago

best

Sri Varshini R

· 11mos ago

Very Good course with super explanation. The added advantage is we can get a certificate after completion of the full course

Tanveer Hussain

· 1yr ago

good

Mazahir Ali

· 1yr ago

Good

Aftab Majeed

· 1yr ago

Good

Mashi Gujjar

· 1yr ago

Its informative

Usman Abbas

· 1yr ago

Excelente

Kaganzi Trevor

· 1yr ago

Thank You

Ian

· 1yr ago

Good Coarse

Mugamba Douglas

· 1yr ago

its nice

Issa Nsengiyumva

· 1yr ago

informative

SHAMIM NAMATOVU

· 1yr ago

THANK YOU

Introduction to MySQL Databases Course Description

What is the difference between SQL and MySQL? In a nutshell, SQL is a language for querying databases and MySQL is an open source database product. SQL is used for accessing, updating and maintaining data in a database and MySQL is an RDBMS that allows users to keep the data that exists in a database organized .

Focus on Learning, Not Ads

Experience the full power of Mindluster with Premium.
No distractions, just pure education.

Get Mindluster Premium

Cancel your subscription anytime