MySQL Course for Beginners

Welcome to the MySQL Course.

In this Video Course, learn MySQL and its concept. MySQL is a relational database management system (RDBMS). RDBMS is the basis for SQL and all modern database systems such as MySQL, MS SQL Server, Microsoft Access, Oracle, etc. We have covered MySQL in this course. The course is for beginners and consists of 100+ live running queries, including creating new databases and tables.

The course begins with MySQL Introduction and Features. Then, we have shown how to set up and install it on Windows. We proceed further with creating a new database and table, to perform various operations on it. With that, we have also covered live-running queries in every lesson.

Note: The flow would be step-by-step and the explanations would include a tutorial-like format, to make it easier for beginners to understand a new database and table and its concepts, with live running queries as examples. The course is for working with MySQL on Windows.

Course Highlights

• 42 lessons
• 2 hrs. 23 minutes video with live running examples
• 100+ examples

While learning, you will get an opportunity to work on various hands-on exercises and understand the role of databases in a real-world application.

Course Lessons

Section 1:  MySQL Introduction

1. Introduction & Features
2. SQL vs NoSQL

Section 2: MySQL Installation & Setup

3. Install MySQL on Windows 10
4. Install MySQL on Windows 11

Section 3: Create and Insert

5. Create a Database
6. Create a Table
7. Insert Records

Section 4: Select Records in MySQL

8. SELECT Statement in MySQL
9. SELECT DISTINCT Statement in MySQL
10. WHERE Clause in MySQL

Section 5: Constraints in MySQL

11. Not Null Constraint
12. Primary Key Constraint
13. Foreign Key Constraint
14. Unique Constraint
15. Default Constraint
16. Check Constraint

Section 6: Alter a Table in MySQL

17. Alter the Table and add a new column
18. Alter the Table and drop a column
19. Alter the Table and modify a column

Section 7: Operator in MySQL

20. AND Operator
21. OR Operator
22. NOT Operator
23. IN Operator
24. LIKE Operator
25. BETWEEN Operator

Section 8: Case Statement in MySQL

26. Case Statement

Section 9: Comments in MySQL

27. Add a comment in MySQL

Section 10: Built-in Functions

28. sum() function
29. avg() function
30. count() function
31. max() function
32. min() function

Section 11: MySQL Statements

33. UPDATE Statement
34. DELETE Statement

Section 12: Order Records in MySQL

35. ORDER BY Statement

Section 13: Limit Records in MySQL

36. How to select limited records with the LIMIT Clause

Section 13: MySQL Alias and Auto Increment

37. Alias
38. Auto Increment

Section 14: MySQL Indexes

39. Create, Drop, and Show Indexes

Section 15: MySQL Joins

40. INNER, LEFT, and RIGHT Joins

Section 16: Drop Table and Database

41. DROP TABLE Command
42. DROP DATABASE Command

Hit the Enroll button!