Database Management with MySQL

What you'll learn

Understand basic concepts of how a database stores information via tables.
Understand SQL syntax used with MySQL.
How to retrieve and manipulate data from one or more tables.
How to filter data based upon multiple conditions.

How to Update and insert data into the existing tables.
Understand how the relationships between tables will affect the SQL.
Understand the advantages of stored procedures along with storing data using variables and functions.
Boost your employability through innovative and independent learning.

Description

Course Content

Reviews

Database management skill is highly demanding and significant today as companies across the world are gathering massive amounts of data for their growth. This simplified 7 hours of practical training gives you the very foundation needed to become a database administrator using SQL(Structured Query Language).
Currently, SQL consistently ranks high in the most-requested tech skills, and learning it will add great value to your array of skills.

This course is ideal for freshers, programmers, software developers, data analysts, and testing professionals who want to learn SQL. It’s also ideal for marketing professionals and salespeople who want to better understand their company’s data.

Key Features:

✅ In-depth coverage of SQL fundamentals.

✅ Covers all of the important query tools and SQL commands.

✅ Easy to under SQL coding style.

✅ Industry-recognized course completion certificate.

✅ Lifetime access to self-paced learning.

KEY QUESTIONS:

What are the course requirements?

Access to a laptop or computer, No prerequisite required for you to partake in the course. You will be taught from the basics to the advanced level.

Will the certificate be issued?

Yes, a certificate of completion will be issued at the end of the course at No charge.

Expand all

Beginners Class

30 lectures

1.1 Course Introduction

5 minutes

1.2 MySQL Download and Installation

7 minutes

1.3 The Workbench Overview

10 minutes

1.4 The SELECT Statement

9 minutes

1.5 The Select Clause

11 minutes

1.6 The WHERE Clause

8 minutes

1.7 The ORDER BY Clause

7 minutes

1.8 The LIMIT Clause

4 minutes

1.9 The AND, OR and NOT Operator

7 minutes

1.10 The IN Operators

5 minutes

1.11 The BETWEEN Operator

3 minutes

1.12 The LIKE Operator

13 minutes

1.13 The REGEXP Operator

15 minutes

1.14 The NULL Operator

5 minutes

1.15 Inner Join

15 minutes

1.16 Joining Across Database

7 minutes

1.17 Self Join

7 minutes

1.18 Joining Multiple Tables

15 minutes

1.19 Outer joins

10 minutes

1.20 Outer Joins Between Multiple Tables

11 minutes

1.21 Self Outer Join

3 minutes

1.22 The USING Clause

10 minutes

1.23 Natural and Cross Joins

8 minutes

1.24 Unions

14 minutes

1.25 Inserting a Single Row(Column Attributes)

17 minutes

1.26 Inserting a Multiple Rows

7 minutes

1.27 Create a Copy of a Table

9 minutes

1.28 Updating a Single Row

8 minutes

1.29 Updating a Multiple Rows

6 minutes

1.30 Exporting Query Output

12 minutes

Advance Class

16 lectures

2.31 Creating a Database and Table

16 minutes

2.32 Importing Excel file to MySQL Database

11 minutes

2.33 Sub Queries in MySQL

8 minutes

2.34 Sub Query across tables

7 minutes

2.35 VIEWS in MySQL Part 1

12 minutes

2.36 VIEWS in MySQL Part 2

12 minutes

2.37 Stored Procedure 1

7 minutes

2.38 Stored Procedure 2

6 minutes

2.39 Stored Procedure 3

8 minutes

2.40 Trigger in MySQL

10 minutes

2.41 Introduction to Function in MySQL

7 minutes

2.42 String Functions in MySQL

14 minutes

2.43 The Number Function in MySQL

6 minutes

2.44 The Date Functions in MySQL

10 minutes

2.45 Aggregate Function in MySQL

5 minutes

Course Review and Further Learning

4 minutes

Anyadioha Uchenna Philip

Rating |

The truth is that I already enrolled and finished studying Database Management with MySQL in a Tech company before a fellow student mentioned AQskill to me. Ever since I visited and bought courses, I feel I have not been useful all this year. Kudos to AQskill and Mr Awesome. I will say I'm getting more value than what I paid Thanks Mr Awesome and thanks to your team. You guys are simply Awesome indeed

Olowookere Oluwatobi Lawrence

Rating |

I could't believe I paid just a token to get this course, your method of teaching, delivery and execution are top notch Sir. You are a gem and a great teacher. Please the link you promised is no where to be found Sir Thank you very much Sir.

Ochekpo Oloche

Rating |

The learning journey has been incredible, I do commend your efforts, please if you could include assignment or practical to work on. Also I would love you guys to consider AWS Cloud computing as part of your courses

Fadilat Omoolowo

Rating |

Abumere Obaweki

Rating |

This is a very rewarding course. The lectures were of high standard and the course delivery was excellent. I commend the school. I congratulate myself for being part of this course. Thank you.

Fashakin Mary Oluwatoyin

Rating |

The training has been great so far and explanatory enough. I started as a beginner and have learnt a lot on SQL during the course. It has been a great one, kudos to the tutor.

Michael bassey

Rating |

i paid over 46$ to learn this course on another platform yet i was only proud of the certificate, but I'm i did this course with Awesome, because I'm full of the knowledge now

Martins Nwokolo

Rating |

This guy is indeed awesome. I have struggling to get started with MySQL but he broke it down and made the course enjoyable. Thanks for the good job, Awesome.

Nana Abaasah

Rating |

I am really enjoying it. I like the simplicity with which each session is explained to my understanding. I am going to take other courses after this one.

SUNDAY LAWAL

Rating |

This is incomparable to other platforms that i have received lectures. This is absolutely fantastic and very practical. Please keep it up. Great job

Are the videos downloadable ?

The videos are efficiently compressed for quick downloads at any time.

How do I access the course videos and materials?

Once your payment is complete, you will have full access to the course lessons and materials. You can download and watch them at your convenience, and our team will provide full support and assistance throughout your learning journey.

How can I obtain my certificate after completing the course?

Once you have completed the course, you can easily download your certificate directly from your dashboard.

Anyadioha Uchenna Philip

Rating |

Olowookere Oluwatobi Lawrence

Rating |

Ochekpo Oloche

Rating |

Fadilat Omoolowo

Rating |

Abumere Obaweki

Rating |

This is a very rewarding course. The lectures were of high standard and the course delivery was excellent. I commend the school. I congratulate myself for being part of this course. Thank you.

Fashakin Mary Oluwatoyin

Rating |

The training has been great so far and explanatory enough. I started as a beginner and have learnt a lot on SQL during the course. It has been a great one, kudos to the tutor.

Michael bassey

Rating |

i paid over 46$ to learn this course on another platform yet i was only proud of the certificate, but I'm i did this course with Awesome, because I'm full of the knowledge now

Martins Nwokolo

Rating |

This guy is indeed awesome. I have struggling to get started with MySQL but he broke it down and made the course enjoyable. Thanks for the good job, Awesome.

Nana Abaasah

Rating |

I am really enjoying it. I like the simplicity with which each session is explained to my understanding. I am going to take other courses after this one.