Find online courses made by experts from around the world.
Take your courses with you and learn anywhere, anytime.
Learn and practice real-world skills and achieve your goals.
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.
Not for you? No problem.
30 day money back guarantee.
Learn on the go.
Desktop, iOS and Android.
Certificate of completion.
|Section 1: Introduction|
Course Outline and Intro to MySQL and DatabasePreview
IMPORTANT - Read this to ensure the best video quality!
MySQL Architecture and Installation of MySQLPreview
Installation Demo - Part 1
Installation Demo - Part 2
|Section 2: Database Design|
MySQL Workbench Download
Database Table and Constraints
Database Designing and Normalization - Part 1
Database Designing and Normalization - Part 2
Storage and Data Types
Data Types Demo
ACID and Transactions
Locks, Deadlocks, Isolation Levels and Logging
Isolation Levels and Locking Demo
Locking Mechanism Demo and MySQL ACID Support
|Section 3: Administration|
Responsibilities of a Database AdministratorPreview
Creating a User and Limiting Access to a Database; Basic Maintainance Function
Protecting your Database; How to Perform Database Backup
|Section 4: Indexing for Performance|
InnoDB Indexing and Clustered vs. Unclustered Index
Query and Where Clause
Impact of Indexing on Database Performance
|Section 5: SQL for Developers|
Char vs. Varchar Data Types; Create, Alter and Drop Keywords; Views and TriggersPreview
Data Definition Language; How to Create Database Objects
SQL Select Statements
SQL Select Statements Demo
Combining Related Table Using Joins
Insert, Update and Delete Commands
Insert, Update, and Delete Commands Demo
|Section 6: Query Analysis and Optimization|
Query Optimization Demo
|Section 7: Data Replication|
Setting Up Replication in MySQL
Column-Level Database Encryption Demo
|Section 8: Conclusion|
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 80+ courses and 4,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 250,000 Udemy students in over 180 countries, Simon Sez IT is the preferred eLearning choice for individuals and businesses everywhere.