MySQL Database Training for Beginners

Description

In this course, you will :

• 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

Syllabus :

1. Database Design

• Database Design
• MySQL Workbench Download
• Database Table and Constraints
• Database Designing and Normalization
• 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

 

2. Administration

• Creating a User and Limiting Access to a Database; Basic Maintainance Function
• Protecting your Database; How to Perform Database Backup
• Performance Monitoring

 

3. Indexing for Performance

• InnoDB Indexing and Clustered vs. Unclustered Index
• Query and Where Clause
• Impact of Indexing on Database Performance
• Performance Optimization

 

4. SQL for Developers

• Data Definition Language; How to Create Database Objects
• SQL Select Statements
• SQL Select Statements Demo
• Joins
• Combining Related Table Using Joins
• Insert, Update and Delete Commands
• Insert, Update, and Delete Commands Demo

 

5. Query Analysis and Optimization

• Query Optimization
• Query Optimization Demo

 

6. Data Replication

• Setting Up Replication in MySQL
• Data Encryption
• Column-Level Database Encryption Demo
• High Availability

Show more