Unlock the power of databases with my MySQL course! Whether you're new to databases or looking to level up your skills, we've got you covered. You will learn how to create, manage, and manipulate data using MySQL. Discover the secrets of keys, learn to write queries like a pro, and automate tasks with triggers. No jargon, just practical knowledge.
? Test Database Link: https://github.com/bytebase/employee-sample-database
✏️ Course developed by @KeepItTechie
⭐️ Contents ⭐️
⌨️ (0:00:34) Introduction
⌨️ (0:01:03) MySQL Overview
⌨️ (0:01:49) Installation
⌨️ (0:05:08) Login to MySQL
⌨️ (0:06:47) Exploring MySQL
⌨️ (0:08:06) Show Databases
⌨️ (0:08:53) Create Database
⌨️ (0:10:01) Use Database
⌨️ (0:10:51) Create Table
⌨️ (0:14:38) Describe Table
⌨️ (0:15:21) Drop Table
⌨️ (0:16:15) Show Table
⌨️ (0:16:45) Drop Database
⌨️ (0:17:35) Install Test Database
⌨️ (0:24:10) Create User Accounts
⌨️ (0:27:34) Change Account Password
⌨️ (0:28:26) List All Accounts
⌨️ (0:29:27) Drop User Accounts
⌨️ (0:30:15) Grant Privileges
⌨️ (0:36:27) Revoke Privileges
⌨️ (0:38:38) Show Granted Privileges
⌨️ (0:39:15) Query
⌨️ (0:39:59) Select Query
⌨️ (0:43:58) Where Clause
⌨️ (0:46:31) Order By
⌨️ (0:48:51) Like
⌨️ (0:50:00) Insert Query
⌨️ (0:52:36) Update Query
⌨️ (0:54:31) Delete Query
⌨️ (0:55:27) Primary Key
⌨️ (0:56:50) Foreign Key
⌨️ (1:04:25) Inner Join
⌨️ (1:07:57) Left Join
⌨️ (1:09:13) Right Join
⌨️ (1:13:10) View
⌨️ (1:22:53) Index
⌨️ (1:27:40) Sub Query
⌨️ (1:29:43) Stored Procedure
⌨️ (1:34:46) Trigger
⌨️ (1:45:55) Processlist
⌨️ (1:47:08) Backup Database
⌨️ (1:51:03) Restore Database
⌨️ (1:54:08) Outro
? Thanks to our Champion and Sponsor supporters:
? davthecoder
? jedi-or-sith
? 南宮千影
? Agustín Kussrow
? Nattira Maneerat
? Heather Wcislo
? Serhiy Kalinets
? Justin Hual
? Otis Morgan
? Oscar Rahnama
--
Learn to code for free and get a developer job: https://www.freecodecamp.org
Read hundreds of articles on programming: https://freecodecamp.org/news