MySQL Course for Beginners
Unlock the ability of databases with my MySQL course! Whether or not you are new to databases or seeking to degree up your abilities, we have got you lined. You’ll discover ways to create, handle, and manipulate knowledge utilizing MySQL. Uncover the secrets and techniques of keys, study to write down queries like a professional, and automate duties with triggers. No jargon, simply sensible data.
💻 Check Database Hyperlink:
✏️ Course developed by @KeepItTechie
⭐️ Contents ⭐️
⌨️ (0:00:34) Introduction
⌨️ (0:01:03) MySQL Overview
⌨️ (0:01:49) Set up
⌨️ (0:05:08) Login to MySQL
⌨️ (0:06:47) Exploring MySQL
⌨️ (0:08:06) Present Databases
⌨️ (0:08:53) Create Database
⌨️ (0:10:01) Use Database
⌨️ (0:10:51) Create Desk
⌨️ (0:14:38) Describe Desk
⌨️ (0:15:21) Drop Desk
⌨️ (0:16:15) Present Desk
⌨️ (0:16:45) Drop Database
⌨️ (0:17:35) Set up Check Database
⌨️ (0:24:10) Create Person Accounts
⌨️ (0:27:34) Change Account Password
⌨️ (0:28:26) Record All Accounts
⌨️ (0:29:27) Drop Person Accounts
⌨️ (0:30:15) Grant Privileges
⌨️ (0:36:27) Revoke Privileges
⌨️ (0:38:38) Present Granted Privileges
⌨️ (0:39:15) Question
⌨️ (0:39:59) Choose Question
⌨️ (0:43:58) The place Clause
⌨️ (0:46:31) Order By
⌨️ (0:48:51) Like
⌨️ (0:50:00) Insert Question
⌨️ (0:52:36) Replace Question
⌨️ (0:54:31) Delete Question
⌨️ (0:55:27) Major Key
⌨️ (0:56:50) International Key
⌨️ (1:04:25) Internal Be part of
⌨️ (1:07:57) Left Be part of
⌨️ (1:09:13) Proper Be part of
⌨️ (1:13:10) View
⌨️ (1:22:53) Index
⌨️ (1:27:40) Sub Question
⌨️ (1:29:43) Saved Process
⌨️ (1:34:46) Set off
⌨️ (1:45:55) Processlist
⌨️ (1:47:08) Backup Database
⌨️ (1:51:03) Restore Database
⌨️ (1:54:08) Outro
🎉 Due 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
—
Study to code without spending a dime and get a developer job:
Learn a whole bunch of articles on programming:
source
Sending a huge shoutout to all of you embarking on this course! Wishing you an amazing learning journey ahead. Much love and gratitude to the wonderful freeCodeCamp community!
Are u doing this kind of stuff on linux ?
499999 wow that is the entire japanese defense force 😅😅😅
this so funny i query the entire employee.sql using * it's more 500k and running still i thought it's just a few hundreds 🤣🤣
21:05 i have problem this doesn't work on windows command prompt mysql < employee.sql
Hey, I got a serious question: 1:07:14 How is it that your queries are being run in under 0.2 seconds despite selecting the whole database? For me, the CLI is printing every row and taking a LOT of time. How do you think I could solve this?
awesome teacher, down to earth, chill and direct to point no talking bs.. love it would subscribe to a paid content by him for sure
your my hero.!
1:03:16 it took me 22 seconds xD
Do I need to be on Linux to fallow this course?
Can I use Windows instead of linux?, I am using windows and did my undergrad in non tech domain. Please help.
love this
damn i actually missed a class on this today i mean i know sql but still dope that this is free
Please, where can I download the linux server on my windows laptop for me to run the codes shown at the beginning of the course OR do I just run the code on the CLI of my laptop.
I am a beginner and new to process
Please is that linux terminal you're using?
I love the video
Who is still using MySQL ? Great for PHP developers!
Wow how could you give out such precious content for free!!!! ❤
I’m so excited to have the opportunity to learn advanced concepts on DBM for free. Thanks to free code camp
Do you need linux for this course?
Thonsad 5:00
Great course! All important is explained perfect. Indexing, triggers, procedures, dump, everything. I have made quick refresh. 🙂
Thank you so much 👋👌👍✌️
The three most popular software programs right now are MySQL, SQL Server and Postgre SQL. What are the differences between them? And which one should I choose to use?