MySQL 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:
- 5.5 hours of video tutorials
- 39 individual video lectures
- Optional quiz with 40 test questions
- Certificate of Completion
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 100 countries.
PreviewDatabase Design (8:46)
PreviewMySQL Workbench Download (7:34)
PreviewDatabase 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)