Database Management with MySQL

This course teaches everything you need to know from the very basic to the advanced level on how to become a Database ...

4.8

(10 reviews)

1376 students enrolled

MySQL

Awesome Emmanuel

3days 10hours left

₦4,000

70%

~~₦13,300~~

Course Features

46 Lessons(7 Hours)

1376 students

Lifetime access to course

Certificate of completion

Skill Level: All Levels

Rated: 4.8

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.

Rate our course

☆ ☆ ☆ ☆ ☆

COURSE DESCRIPTION

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.

FREQUENTLY ASKED QUESTIONS

Are the videos downloadable?

The videos are highly compressed and downloadable.

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.

How will I get access to the Course videos and Materials?

Once payment is completed. The course lessons and materials will be available to you instantly.

Will the certificate be issued?

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

Reviews

See all

Anyadioha Uchenna Philip

Database Management with MySQL

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

Database Management with MySQL

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

Fadila

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

Fadila

Abumere Obaweki

Database Management with MySQL

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.

Course content

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

Student Feedback

4.8

10 reviews

80%

20%

Reviews

Anyadioha Uchenna Philip

Database Management with MySQL

Olowookere Oluwatobi Lawrence

Database Management with MySQL

Ochekpo Oloche

Fadila

Fadilat Omoolowo

Fadila

Abumere Obaweki

Database Management with MySQL

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

Database Management with MySQL

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.

Martins Nwokolo

Martins

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

Feedback

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

database management

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

Areola Olushola Michael

Excellent trainer

I am in love with the way the trainer presented and taught this course. Anyone can easily understand what is taught.

3days 10hours left

₦4,000

70%

~~₦13,300~~

Course Features

46 Lessons(7 Hours)

1376 students

Lifetime access to course

Certificate of completion

Skill Level: All Levels

Rated: 4.8