MySQL Course for Beginners

This beginner course introduces MySQL installation, database and table management, user accounts and privileges, SQL queries, joins, views, indexes, stored procedures, triggers, and database backup and restoration.

Syllabus

⌨️ Introduction
⌨️ MySQL Overview
⌨️ Installation
⌨️ Login to MySQL
⌨️ Exploring MySQL
⌨️ Show Databases
⌨️ Create Database
⌨️ Use Database
⌨️ Create Table
⌨️ Describe Table
⌨️ Drop Table
⌨️ Show Table
⌨️ Drop Database
⌨️ Install Test Database
⌨️ Create User Accounts
⌨️ Change Account Password
⌨️ List All Accounts
⌨️ Drop User Accounts
⌨️ Grant Privileges
⌨️ Revoke Privileges
⌨️ Show Granted Privileges
⌨️ Query
⌨️ Select Query
⌨️ Where Clause
⌨️ Order By
⌨️ Like
⌨️ Insert Query
⌨️ Update Query
⌨️ Delete Query
⌨️ Primary Key
⌨️ Foreign Key
⌨️ Inner Join
⌨️ Left Join
⌨️ Right Join
⌨️ View
⌨️ Index
⌨️ Sub Query
⌨️ Stored Procedure
⌨️ Trigger
⌨️ Processlist
⌨️ Backup Database
⌨️ Restore Database
⌨️ Outro