MySQL for Beginners Ed 3

•  Instructor-led training: 4 days with hands-on lab practice 
•  Virtual instructor-led training: 4 days of web-based classes with hands-on lab practice 
•  E-learning: Equivalent of 4 days of instruction with hands-on lab practice

• Explain MySQL storage engines
• Explain database transactions
• Obtain database metadata
• Describe MySQL GUI tools
• Monitor database performance
• Perform database backup and recovery
• Export and import database data
• Describe the features and benefits of MySQL
• Explain the basics of relational databases
• Design an effective database
• Build a database and tables by using SQL Modify or delete database entities
• Query data with the SELECT command
• Join data from multiple tables
• Perform nested subqueries
• Use built-in MySQL functions

· Features and Benefits of MySQL

· MySQL Products and Service

· Community vs. Enterprise

· MySQL Certification Program

· MySQL Certification Program

· MySQL Website

· MySQL Architecture

· Install and Start MySQL

Database Basics

· SQL Language and MySQL

· Database Design

· Database Modeling

· Keys

· Normalization

· Data Types

· What is NULL?

· Viewing Database Structure

 Database Creation

· Create a New Database Structure

· Creating a Database

· Creating a Table

Basic Queries

· The SELECT Command

· MySQL Query Browser

· Troubleshooting

Database Maintenance

· Delete an Entire Database

· Maintaining Tables

· Maintaining Columns

· Indexes and Constraints

· Data Manipulation

Delete/Modify Table row Data

· The INSERT Command

· The REPLACE Command

· The UPDATE Statement

· The DELETE Command

Functions

· Simple Functions

· Grouping With Functions

Joining Tables

· Combining Multiple Tables

· Inner Joins

· Outer Joins

Exporting/Importing Data

· Exporting Data

· Importing Data

Sub queries

· What is a Sub query?

· Categories of Sub queries

· Sub query Types

· Placing Sub queries

· Other Sub query Uses

· Other Sub query Uses

Supplementary Information

· Creating VIEWs

· Transactions

· Storage Engines

· Retrieving Metadata