SQL Certification Training Course

Course Content

Getting Started with MySQL and Installing MySQL

 MySQL Overview

 Basics of Relational Databases

 Entities and Relationships

 SQL Language and MySQL

 SQL data definition language and data manipulation language

 MySQL Client/Server Model

 MySQL Connectors

 Installation of the MySQL server

 Starting and stopping MySQL server

 Using the MySQL client

 MySQL Workbench

Designing Your Database and Understand Data Types

 Database Modeling

 Keys and Normalization

 Database Design

 Viewing and Evaluating a Database

 Data Types and Database Design

 Numeric, Temporal and String Data Types

 Character Set and Collation Support

 Data Type Considerations

 Meaning of NULL

Creating Databases and Tables

 Creating a Database

 Creating a Table

 Showing How a Table Was Created

 Table Options

 Column Options

 Indexes, Keys, and Constraints

 Deleting database and tables

 Creating New Table Using an Existing Table

 Creating a Temporary Table

 Copying an Existing Table Structure

 Adding, removing and modifying table columns and indexes

Querying and Modifying Table Data

 The SELECT Statement

 Creating Views

 Querying Data from an Application

 Exporting and Importing a Delimited File

 Troubleshooting: Authorization Levels

 Manipulating Data and inserting records

 Replacing and updating existing records

 Deleting records

 Exporting and importing a script

 Multistatement Transactions

 Modifying Data from an Application

Joining Tables and Functions

 Querying Multiple Tables

 Joining Tables with SELECT

 Inner Joins

 Outer Joins

 Table Name Aliases

 Functions in MySQL Expressions

 Using Functions

 String Functions

 Date and time functions

 Numeric Functions

 Aggregate Functions

 Spaces in Function Names

MySQL Architecture and Administration Basics

 Architectural Overview

 Understand how MySQL Transmits Data and Processes Requests

 Understand how MySQL Stores Data and Uses Memory

 Tablespaces, Redo and Undo Logs

 Plug-in Interface

Configuring & Monitoring MySQL Server

 Server Configuration Options

 Option Files and System Variables

 Launching Multiple Servers on the Same Host

 Monitoring Tools & Techniques

 MySQL Enterprise Audit

 MySQL Enterprise Monitor

 Monitoring User Activity

User Management

 Creating and Modifying User Accounts

 Configuring Passwords

 Authentication Plug-Ins

 Granting Permissions & Grant Tables

Security

 Understanding Security Risks

 Network Security & Secure Connections

 Password & Operating System Security

Backup Tools & Technique

 Understanding Backups & Backup Techniques

 Creating a Backup Strategy

 MySQL Backup Tools

 Raw Backup Methods