MySQL Database Training for Beginners
3.9 (339 ratings)
Course Ratings are calculated from individual students’ ratings and a variety of other signals, like age of rating and reliability, to ensure that they reflect course quality fairly and accurately.
6,154 students enrolled

MySQL Database Training for Beginners

Learn MySQL and Take Your Web Development to the Next Level.
3.9 (339 ratings)
Course Ratings are calculated from individual students’ ratings and a variety of other signals, like age of rating and reliability, to ensure that they reflect course quality fairly and accurately.
6,154 students enrolled
Created by Simon Sez IT
Last updated 6/2018
English
English [Auto-generated]
Current price: $51.99 Original price: $74.99 Discount: 31% off
5 hours left at this price!
30-Day Money-Back Guarantee
This course includes
  • 5.5 hours on-demand video
  • 1 article
  • Full lifetime access
  • Access on mobile and TV
  • Certificate of Completion
Training 5 or more people?

Get your team access to 4,000+ top Udemy courses anytime, anywhere.

Try Udemy for Business
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
Expand all 41 lectures 05:37:58
+ Introduction
5 lectures 40:19
Essential Information for a Successful Training Experience
01:01
Installation Demo - Part 1
03:35
Installation Demo - Part 2
09:37
+ Database Design
11 lectures 01:38:50
Database Design
08:46
MySQL Workbench Download
07:34
Database Table and Constraints
09:39
Database Designing and Normalization - Part 1
11:51
Database Designing and Normalization - Part 2
08:10
Storage and Data Types
05:25
Data Types Demo
11:20
ACID and Transactions
09:44
Locks, Deadlocks, Isolation Levels and Logging
07:16
Isolation Levels and Locking Demo
12:43
Locking Mechanism Demo and MySQL ACID Support
06:22
+ Administration
4 lectures 32:48
Creating a User and Limiting Access to a Database; Basic Maintainance Function
10:34
Protecting your Database; How to Perform Database Backup
07:44
Performance Monitoring
10:49
+ Indexing for Performance
5 lectures 38:50
Course Review
00:43
InnoDB Indexing and Clustered vs. Unclustered Index
14:17
Query and Where Clause
05:28
Impact of Indexing on Database Performance
10:33
Performance Optimization
07:49
+ SQL for Developers
8 lectures 01:20:27
Data Definition Language; How to Create Database Objects
12:27
SQL Select Statements
07:48
SQL Select Statements Demo
10:19
Joins
05:36
Combining Related Table Using Joins
16:06
Insert, Update and Delete Commands
06:08
Insert, Update, and Delete Commands Demo
08:47
+ Query Analysis and Optimization
2 lectures 10:19
Query Optimization
03:40
Query Optimization Demo
06:39
+ Data Replication
5 lectures 32:16
Setting Up Replication in MySQL
04:57
Data Encryption
05:13
Column-Level Database Encryption Demo
04:44
High Availability
10:43
+ Conclusion
1 lecture 04:08
Closing
04:08
MySQL Quiz
40 questions
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