MySQL

MySQL

  • By
  • Simon Sez IT

Subscription

$159

  • Single License
  • 400+ eBooks and video tutorials
  • Instant access

Share this Product

Get Custom offer

  • 10+ Users
  • For depatments or complete companies
  • Premium analytics

Chapter 1: Introduction

  • Course Outline and Intro to MySQL and Database
  • MySQL Architecture and Installation of MySQL
  • Installation Demo – Part 1
  • Installation Demo – Part 2

Chapter 2: Database Design

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

Chapter 3: Administration

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

Chapter 4: Indexing for Performance

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

Chapter 5: SQL for Developers

  • Char vs. Varchar Data Types; Create, Alter and Drop Keywords; Views and Triggers
  • 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

Chapter 6: Query Analysis and Optimization

  • Query Optimization
  • Query Optimization Demo

Chapter 7: Data Replication

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

Chapter 8: Conclusion