MySQL Database Training for Beginners
Learn MySQL and Take Your Web Development to the Next Level.
Discover how to use MySQL, a popular choice of database for use in powerful web applications!
During this 5.5-hour MySQL beginner course, discover the fundamental concepts beginner MySQL administrators need to master. Your professional instructor combines practical lectures that ensure you have a solid grasp of the basics.
Follow along as you learn how to install MySQL for the first time. Discover critical concepts for designing a database. Explore how to administrate a MySQL database including limiting access, creating users, database backup and performance monitoring. Then get ready to take your MySQL skills to the next level as you learn SQL for developers, database replication, data encryption and more.
This course includes a quiz and certificate of completion.
What People Are Saying:
★★★★★ “Good overview, good pace. I like the trainer’s manner and style of presenting.” – Rik Williams
★★★★★ “This course is very informative. It could go into a little more detail when looking at the codes because as a beginner I find myself pausing frequently to figure out where the instructor has navigated between query screens. Overall I think this course is very valuable.” -Sam Marotta
★★★★★ “Very thorough Explanation of the basic concepts. A bit dry at times but certainly necessary. Great examples to underline the theory” -Jürg Horisberger
The “IT" in Simon Sez IT stands for “Information Technology." We offer instruction to help learners win when it comes to computer and software technology. Learning software skills in an easy, self-paced way for an affordable price is what Simon Sez IT is all about.
The company was founded in 2008 by Chris “Simon" Calder, Director of IT operations for one of Los Angeles' most prestigious institutions. In this role, Simon saw the need for low-stress software training for hundreds of employees in his company who were facing technological upgrades at work. That's how the idea of Simon Sez IT was born.
Since then, Simon Sez IT has built a rapid and loyal following. At a time when many companies were struggling to survive, Simon Sez IT thrived—providing accessible, low-cost computer and software training to people of all ages, regardless of their computer experience. In our first four years alone, we serviced tens of thousands of satisfied customers in over 180 countries.
Free PreviewDatabase Design (8:46)
StartMySQL Workbench Download (7:34)
StartDatabase Table and Constraints (9:39)
StartDatabase Designing and Normalization - Part 1 (11:51)
StartDatabase Designing and Normalization - Part 2 (8:10)
StartStorage and Data Types (5:24)
StartData Types Demo (11:20)
StartACID and Transactions (9:43)
StartLocks, Deadlocks, Isolation Levels and Logging (7:16)
StartIsolation Levels and Locking Demo (12:43)
StartLocking Mechanism Demo and MySQL ACID Support (6:22)