0

ecommerce/course.login

ecommerce/course.or, ecommerce/course.create_accountCreate an account in checkout page
Web Developpement

MySQL

Learn the basics of MySQL during this introductory course.

4.2
(392 ratings) 1597 students



Enroll now


What you will learn

Understanding MySQL architecture and installation of MySQL
Learning database design
Learn different data types

Who should take this training

Prerequisites

  • A computer

Target audience

  • Anyone new to databases Web developers

About this training

During this introduction MySQL beginner course, discover the fundamental concepts of working with MySQL. Your instructor will discuss the MySQL architecture, installation of MySQL, and designing a database.

Course Language : EN
On-demand video
Full lifetime access to videos
Downloadable resources
Assignments
Certificate of Completion
Enroll now

Training options

Only Videos

$ 30

  • Full lifetime access to videos
  • Downloadable resources
  • Certificate of Completion
  • Hours of Individual Coaching

Blended

$ 290

  • Full lifetime access to videos
  • Downloadable resources
  • Certificate of Completion
  • 10 Hours of Individual Coaching
Save 10%

Blended

$ 520 $ 495

  • Full lifetime access to videos
  • Downloadable resources
  • Certificate of Completion
  • 20 Hours of Individual Coaching
Save 20%

Blended

$ 810 $ 648

  • Full lifetime access to videos
  • Downloadable resources
  • Certificate of Completion
  • 30 Hours of Individual Coaching

Course Content

1. Introduction
1. Course Outline and Intro to MySQL and Database 10:11 mins
2. MySQL Architecture and Installation of MySQL 15:55 mins
3. Installation Demo – Part 1 03:36 mins
4. Installation Demo – Part 2 09:38 mins
2. Database Design
1. Database Design 08:46 mins
2. MySQL Workbench Download 07:35 mins
3. Database Table and Constraints 09:40 mins
4. Database Designing and Normalization – Part 1 11:52 mins
5. Database Designing and Normalization – Part 2 08:11 mins
6. Storage and Data Types 05:25 mins
7. Data Types Demo 11:20 mins
8. ACID and Transactions 09:44 mins
9. Locks, Deadlocks, Isolation Levels and Logging 07:16 mins
10. Isolation Levels and Locking Demo 12:44 mins
11. Locking Mechanism Demo and MySQL ACID Support 06:23 mins
3. Administration
1. Responsibilities of a Database Administrator 03:42 mins
2. Creating a User and Limiting Access to a Database; Basic Table Maintainance Function 10:35 mins
3. Protecting your Database; How to Perform Database Backup 07:44 mins
4. Performance Monitoring 10:50 mins
4. Indexing for Performance
1. InnoDB Indexing and Clustered vs. Unclustered Index 14:18 mins
2. Query and Where Clause 05:28 mins
3. Impact of Indexing on Database Performance 10:33 mins
4. Performance Optimization 07:49 mins
5. SQL for Developers
1. Char vs. Varchar Data Types; Create, Alter and Drop Keywords; Views and Triggers 13:17 mins
2. Data Definition Language; How to Create Database Objects 12:27 mins
3. SQL Select Statements 07:48 mins
4. SQL Select Statements Demo 10:19 mins
5. Joins 05:37 mins
6. Combining Related Table Using Joins 16:07 mins
7. Insert, Update and Delete Commands 06:08 mins
8. Insert, Update, and Delete Commands Demo 08:48 mins
6. jQuery Analysis and Optimization
1. Query Optimization 03:41 mins
2. Query Optimization Demo 06:40 mins
7. Data Replication
1. Database Replication 06:39 mins
2. Setting Up Replication in MySQL 04:58 mins
3. Data Encryption 05:14 mins
4. Column-Level Database Encryption Demo 04:45 mins
5. High Availability 10:43 mins
8. Conclusion

Request more information

Similar courses

Join our mail list for news