MySQL Database Course for Beginners: 3+ Hours of MySQL Training

Take a look at the full course from Simon Sez IT
✅ https://www.simonsezit.com/courses/web-development/mysql-database-training-course-for-beginners/

In this MySQL training course for beginners, we cover the fundamental concepts you need as a MySQL administrator. We start off with installing MySQL for the first time before moving on to exploring how to design and administrate a MySQL database. We also discuss how to run a database backup, performance monitoring, and so much more!

🔥Get a free, 30-day trial to Simon Sez IT ➡️https://bit.ly/3B5o3DK

📝 Use the timestamps below to navigate to different sections of the course. If you already know one of these topics, skip ahead!

00:00:00 – Simon Sez IT Intro
00:00:09 – Course Outline and Intro to MySQL and Database
00:10:20 – MySQL Architecture and Installation of MySQL
00:26:20 – Installation Demo – Part 1
00:29:55 – Installation Demo – Part 2
00:39:33 – Database Design
00:48:19 – MySQL Workbench Download
00:55:55 – Database Table and Constraints
01:05:34 – Database Designing and Normalization – Part 1
01:17:26 – Database Designing and Normalization – Part 2
01:25:36 – Storage and Data Types
01:31:06 – Data Types Demo
01:42:26 – ACID and Transactions
01:52:10 – Locks, Deadlocks, Isolation Levels and Logging
01:59:26 – Isolation Levels and Locking Demo
02:12:09 – Locking Mechanism Demo and MySQL ACID Support
02:18:32 – Responsibilities of a Database Administrator
02:22:18 – Creating a User and Limiting Access to a Database; Basic Table Maintenance Function
02:32:53 – Protecting your Database; How to Perform Database Backup
02:40:37 – Performance Monitoring
02:51:24 – InnoDB Indexing and Clustered vs. Unclustered Index
03:05:41 – Query and Where Clause
03:11:14 – Impact of Indexing on Database Performance
03:21:47 – Performance Optimization

🌍 Get unlimited training with Simon Sez IT’s 150+ courses ⏩ https://www.simonsezit.com/courses/

🚀 Level up your skills with a a free 30 day trial to our complete training library of 8,500+ video ⏩ https://www.simonsezit.com/ssit-first-month-free

🔥 Check out our other free tutorials on Web Development 👉 https://www.youtube.com/playlist?list=PLzj7TwUeMQ3gmi2n_6xmvD-OTnMnD97LP

🔥Check out our Long Training Courses playlist here
👉https://www.youtube.com/playlist?list=PLzj7TwUeMQ3hsADWJd2sJh4o8jATTyaRU

💻Watch more popular tutorials from Simon Sez IT:

✅Microsoft Office 2021 and Office 365 Training Tutorials
👉https://www.youtube.com/playlist?list=PLzj7TwUeMQ3hH_MxteY6LR3OSMHpDkt_j

✅Excel 2021 Tutorials for Beginners playlist
👉https://www.youtube.com/playlist?list=PLzj7TwUeMQ3jqRlmIaj6jb_X9EGQueMDb

✅Simon Sez IT Long Training Courses playlist
👉https://www.youtube.com/playlist?list=PLzj7TwUeMQ3hsADWJd2sJh4o8jATTyaRU

✅PHP Tutorial for Beginners and Advanced 👉 https://www.youtube.com/playlist?list=PLzj7TwUeMQ3hNpTfG8c6skQufGsCc7fjx

💬Stay in touch!
✅SimonSezIT.com: 👉https://www.SimonSezIT.com/
✅StreamSkill.com: 👉https://StreamSkill.com/
✅YouTube Channel: 👉https://www.youtube.com/user/simonsezittraining
✅LinkedIn: 👉https://www.linkedin.com/company/simon-sez-it/

🔔Subscribe to our channel:
👉https://www.youtube.com/simonsezittraining?sub_confirmation=1

If you enjoyed the video, please give a “thumbs up” and subscribe to the channel 👍🏽 😉