MySQL

MySQL

  • Von
  • Simon Sez IT

Flatrate

149

inkl. 7 % MwSt.

  • Einzellizenz
  • 12,42 pro Monat
  • 20% sparen
  • Verlängert sich automatisch

Teilen Sie dieses Produkt

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