MySQL Database Training for Beginners
What you'll learn
- Understanding MySQL architecture and installation of MySQL
- Learning database design
- Administration of a database
- Using indexing for database performance
- Discover SQL for Developers
- Understanding query analysis and optimization
- Setting up replication in MySQL
Course content
Introduction5 lectures • 40min
- Course Outline and Intro to MySQL and DatabasePreview10:11
- Essential Information for a Successful Training Experience01:01
- MySQL Architecture and Installation of MySQLPreview15:55
- Installation Demo - Part 103:35
- Installation Demo - Part 209:37
Database Design11 lectures • 1hr 39min
Administration4 lectures • 33min
Indexing for Performance5 lectures • 39min
SQL for Developers8 lectures • 1hr 20min
Query Analysis and Optimization2 lectures • 10min
Data Replication5 lectures • 32min
Conclusion1 lecture • 4min
Requirements
- A computer
Description
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 certificate of completion, and quiz.
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
Who this course is for:
- Web developers
- Anyone new to databases
Instructor
![Simon Sez IT](data:image/svg+xml,%3Csvg xmlns="http://www.w3.org/2000/svg" viewBox="0 0 64 64"%3E%3C/svg%3E){kind=avatar}
- 4.4 Instructor Rating
- 42,269 Reviews
- 459,012 Students
- 166 Courses
Since 2008, individuals, small businesses, and Fortune 500 companies with thousands of employees have benefited from the easy and hands-on software training offered by Simon Sez IT. With over 5,000 video tutorials on a range of software programs, Simon Sez IT ensures stress-free eLearning and enhanced employee productivity - no matter whether you are implementing new software or a technological upgrade for your workplace. With over 430,000 Udemy students in over 180 countries, Simon Sez IT is the preferred online learning choice for individuals and businesses everywhere.