Database Management with MySQL → Course Review and Further Learning

Beginners Class 30

What is SQL? SQL stands from Structured Query Language. It is used to communicate with several relational databases such as MySQL, Oracle and MS SQL Server. Using SQL queries, you can fetch, update, delete and manipulate data that is stored in the form of rows and columns. SQL became the de facto standard programming language for relational databases after they emerged in the late 1970s and early 1980s. It can also permit users to perform specific tasks on tables, procedures, and views. Wishing you the best of learning experience. For any question or assistance kindly contact me on: awesome8emmanuel@gmail.com
- Lecture1.1
  
  1.1 Course Introduction 05 min
- Lecture1.2
  
  1.2 MySQL Download and Installation 07 min
- Lecture1.3
  
  1.3 The Workbench Overview 10 min
- Lecture1.4
  
  1.4 The SELECT Statement 09 min
- Lecture1.5
  
  1.5 The Select Clause 11 min
- Lecture1.6
  
  1.6 The WHERE Clause 08 min
- Lecture1.7
  
  1.7 The ORDER BY Clause 07 min
- Lecture1.8
  
  1.8 The LIMIT Clause 04 min
- Lecture1.9
  
  1.9 The AND, OR and NOT Operator 07 min
- Lecture1.10
  
  1.10 The IN Operators 05 min
- Lecture1.11
  
  1.11 The BETWEEN Operator 03 min
- Lecture1.12
  
  1.12 The LIKE Operator 13 min
- Lecture1.13
  
  1.13 The REGEXP Operator 15 min
- Lecture1.14
  
  1.14 The NULL Operator 05 min
- Lecture1.15
  
  1.15 Inner Join 15 min
- Lecture1.16
  
  1.16 Joining Across Database 07 min
- Lecture1.17
  
  1.17 Self Join 07 min
- Lecture1.18
  
  1.18 Joining Multiple Tables 15 min
- Lecture1.19
  
  1.19 Outer joins 10 min
- Lecture1.20
  
  1.20 Outer Joins Between Multiple Tables 11 min
- Lecture1.21
  
  1.21 Self Outer Join 03 min
- Lecture1.22
  
  1.22 The USING Clause 10 min
- Lecture1.23
  
  1.23 Natural and Cross Joins 08 min
- Lecture1.24
  
  1.24 Unions 14 min
- Lecture1.25
  
  1.25 Inserting a Single Row(Column Attributes) 17 min
- Lecture1.26
  
  1.26 Inserting a Multiple Rows 07 min
- Lecture1.27
  
  1.27 Create a Copy of a Table 09 min
- Lecture1.28
  
  1.28 Updating a Single Row 08 min
- Lecture1.29
  
  1.29 Updating a Multiple Rows 06 min
- Lecture1.30
  
  1.30 Exporting Query Output 12 min
Advance Class 16
- Lecture2.1
  
  2.31 Creating a Database and Table 16 min
- Lecture2.2
  
  2.32 Importing Excel file to MySQL Database 11 min
- Lecture2.3
  
  2.33 SubQueries in MySQL 08 min
- Lecture2.4
  
  2.34 SubQuery across tables 07 min
- Lecture2.5
  
  2.35 VIEWS in MySQL Part 1 12 min
- Lecture2.6
  
  2.36 VIEWS in MySQL Part 2 12 min
- Lecture2.7
  
  2.37 Stored Procedure 1 07 min
- Lecture2.8
  
  2.38 Stored Procedure 2 06 min
- Lecture2.9
  
  2.39 Stored Procedure 3 08 min
- Lecture2.10
  
  2.40 Trigger in MySQL 10 min
- Lecture2.11
  
  2.41 Introduction to Function in MySQL 07 min
- Lecture2.12
  
  2.42 String Functions in MySQL 14 min
- Lecture2.13
  
  2.43 The Number Function in MySQL 06 min
- Lecture2.14
  
  2.44 The Date Functions in MySQL 10 min
- Lecture2.15
  
  2.45 Aggregate Function in MySQL 05 min
- Lecture2.16
  
  Course Review and Further Learning 04 min

This content is protected, please login and enroll course to view this content!

Prev 2.45 Aggregate Function in MySQL

24 Comments

Philip Ekow Abedi Blankson

15/07/2022

Thanks so much for such a wonderful class. Very wonderful and easy to learn lectures .I really enjoyed the class.

Obed Holali Attepor

25/08/2022

Had a wonderful time in the class. The videos were clear and understandable.

Obed Holali Attepor

25/08/2022

I enjoyed the class and understood what was thought

ONYILIMBA STANLEY TOCHUKWU

26/09/2022

It was really an awesome class… I enjoyed every single section. would love to learn more from you. still looking for your email address, can you please help me with it ?

Awesome Emmanuel A.

26/09/2022
Reply

Thanks for the compliment.
Here’s my email address

awesome8emmanuel@gmail.com

Afoma

02/11/2022

Awesome! you are an awesome teacher. Never has anyone explained Mysql the way you just did. Thank you!

Ronke ADEGBOYEGA

13/01/2023

Thank you so much for this great course. I definitely learnt a lot.

Arthur Bwalya

06/02/2023

had a wonderful time learning simple and plain language keep up the good work

Onome Mafuru

19/02/2023

Thanks Mr Awesome Emmanuel for dissecting and doing justice to this mySql course.

Abimbola Abiodun Adeniyi

11/03/2023

It was a great experience learning from Mr. Awesome Emmanuel, I enjoyed every session. I enrolled with a zero idea of what database administration is but my Awesome teacher assisted me through it. Your presentation and your response to me when I’m on clear is top-notch. Thank you very much ❤️

Awesome Emmanuel A.

11/03/2023
Reply

My pleasure
Thanks for the compliment

Manuchim Chuku

12/03/2023

Thanks alot sire for the wonderful tutorial, no one could have done a better job than you…Please sire, in your last video(Course Review and Further Learning), you made mention of sharing a link on the description box, but i seem not to find it….I will plead with you to please drop the link…Thanks a lot.

Awesome Emmanuel A.

12/03/2023
Reply

Reach me via my mail
awesome8emmanuel@gmail.com

Esther Orji-Amakonze

30/03/2023

I thought MYSQL will be difficulty to understand but as always, you made the course so easy to understand. Thank you

Ani

01/07/2023

I really enjoyed the class and you made it very easy to comprehend. Welldone Sir👏

Adeleke Adebisola Glory

03/07/2023

Thanks Mr. Awesome. I enjoyed and enjoying all my classes with you.

Anyadioha Uchenna Philip

06/07/2023

I enjoyed this class to the fullest.
Thanks Mr Awesome. I look forward to buying more courses from you. You are a good instructor.
Now you made feel like I have been wasting money learning from other tech guys. Thanks again bro