Curriculum for the course MySQL Course for Beginners
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/newsWatch Online Full Course: MySQL Course for Beginners
Click Here to watch on Youtube: MySQL Course for Beginners
This video is first published on youtube via freecodecamp. If Video does not appear here, you can watch this on Youtube always.
Udemy MySQL Course for Beginners courses free download, Plurasight MySQL Course for Beginners courses free download, Linda MySQL Course for Beginners courses free download, Coursera MySQL Course for Beginners course download free, Brad Hussey udemy course free, free programming full course download, full course with project files, Download full project free, College major project download, CS major project idea, EC major project idea, clone projects download free
Comments
Post a Comment