MySQL Database Training for Beginners
4.3 (127 ratings)
Instead of using a simple lifetime average, Udemy calculates a course's star rating by considering a number of different factors such as the number of ratings, the age of ratings, and the likelihood of fraudulent ratings.
5,309 students enrolled
Wishlisted Wishlist

Please confirm that you want to add MySQL Database Training for Beginners to your Wishlist.

Add to Wishlist

MySQL Database Training for Beginners

Learn MySQL and Take Your Web Development to the Next Level.
4.3 (127 ratings)
Instead of using a simple lifetime average, Udemy calculates a course's star rating by considering a number of different factors such as the number of ratings, the age of ratings, and the likelihood of fraudulent ratings.
5,309 students enrolled
Created by Simon Sez IT
Last updated 1/2017
English
Current price: $10 Original price: $50 Discount: 80% off
1 day left at this price!
30-Day Money-Back Guarantee
Includes:
  • 5.5 hours on-demand video
  • 1 Article
  • Full lifetime access
  • Access on mobile and TV
  • Certificate of Completion
What Will I 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
View Curriculum
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.

Who is the target audience?
  • Web developers
  • Anyone new to databases
Students Who Viewed This Course Also Viewed
Curriculum For This Course
41 Lectures
05:38:10
+
Introduction
5 Lectures 40:35

Essential Information for a Successful Training Experience
01:17


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
About the Instructor
Simon Sez IT
4.4 Average rating
10,255 Reviews
293,209 Students
114 Courses
300,000+ Students | Wordwide Use 180 Countries |120+ 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 80+ courses and 4,500+ 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 300,000 Udemy students in over 180 countries, Simon Sez IT is the preferred eLearning choice for individuals and businesses everywhere.