MySQL Database Training for Beginners

Learn MySQL and Take Your Web Development to the Next Level.
4.1 (59 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.
4,777 students enrolled
Instructed by Simon Sez IT Development / Databases
$50
Take This Course
  • Lectures 41
  • Contents Video: 5.5 hours
    Other: 0 mins
  • Skill Level Intermediate Level
  • Languages English
  • Includes Lifetime access
    30 day money back guarantee!
    Available on iOS and Android
    Certificate of Completion
Wishlisted Wishlist

How taking a course works

Discover

Find online courses made by experts from around the world.

Learn

Take your courses with you and learn anywhere, anytime.

Master

Learn and practice real-world skills and achieve your goals.

About This Course

Published 12/2013 English

Course 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 are the requirements?

  • A computer

What am I going to get from this course?

  • 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

What is the target audience?

  • Web developers
  • Anyone new to databases

What you get with this course?

Not for you? No problem.
30 day money back guarantee.

Forever yours.
Lifetime access.

Learn on the go.
Desktop, iOS and Android.

Get rewarded.
Certificate of completion.

Curriculum

Section 1: Introduction
Course Outline and Intro to MySQL and Database
Preview
10:11
IMPORTANT - Read this to ensure the best video quality!
Article
MySQL Architecture and Installation of MySQL
Preview
15:55
Installation Demo - Part 1
03:35
Installation Demo - Part 2
09:37
Section 2: Database Design
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
Section 3: Administration
Responsibilities of a Database Administrator
Preview
03:41
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
Section 4: Indexing for Performance
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
Section 5: SQL for Developers
Char vs. Varchar Data Types; Create, Alter and Drop Keywords; Views and Triggers
Preview
13:16
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
Section 6: Query Analysis and Optimization
Query Optimization
03:40
Query Optimization Demo
06:39
Section 7: Data Replication
Database Replication
Preview
06:39
Setting Up Replication in MySQL
04:57
Data Encryption
05:13
Column-Level Database Encryption Demo
04:44
High Availability
10:43
Section 8: Conclusion
Closing
04:08
MySQL Quiz
40 questions

Students Who Viewed This Course Also Viewed

  • Loading
  • Loading
  • Loading

Instructor Biography

Simon Sez IT, Software training to help you succeed

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.

Ready to start learning?
Take This Course