0471-6454555
9447387064
9847003556

No1 Training Institute in Kerala

MySQL

Data Backup and Recovery Methods

Introduction Binary Versus Textual Backups Making Binary Backups Making Text Backups Backing Up Log and Status Files Replication as an Aid to Backup MySQL Cluster as Disaster Prevention Data Recovery
TRINITY TECHNOLOGIES

The INFORMATION_SCHEMA Database

INFORMATION_SCHEMA Access Syntax INFORMATION_SCHEMA Versus SHOW Limitations of INFORMATION_SCHEMA
TRINITY TECHNOLOGIES

Data (Table) Maintenance

Types of Table Maintenance Operations SQL Statements for Table Maintenance Client and Utility Programs for Table Maintenance Repairing InnoDB Tables Enabling MyISAM Auto-Repair
TRINITY TECHNOLOGIES

Storage Engines

MySQL Storage Engines The MyISAM Engine The MERGE Engine The InnoDB Engine The MEMORY Engine The FEDERATED Engine The Cluster Storage Engine Other Storage Engines
TRINITY TECHNOLOGIES

Locking

Locking Concepts Explicit Table Locking Advisory Locking
TRINITY TECHNOLOGIES

Character Set Support

Performance Issues Choosing Data Types for Character Columns
TRINITY TECHNOLOGIES

Client Programs for DBA Work

Overview of Administrative Clients mysql mysqladmin mysqlimport mysqldump Client Program Limitations
TRINITY TECHNOLOGIES

Starting, Stopping, and Configuring MySQL

Types of MySQL Distributions Starting and Stopping MySQL Server on Windows Starting and Stopping MySQL Server on Unix Runtime MySQL Configuration Log and Status Files Loading Time Zone Tables Security-Related Configuration Setting the Default SQL Mode Upgrading MySQL
TRINITY TECHNOLOGIES

MySQL Architecture

Client/Server Overview Communication Protocols The SQL Parser and Storage Engine Tiers How MySQL Uses Disk Space How MySQL Uses Memory
TRINITY TECHNOLOGIES

PHP MySQL Interfaces

PHP interfaces CRUD MySQL iConnect Prepared Statements Fetching Results
TRINITY TECHNOLOGIES

MySQL Data Types

Numeric Strings Large Storage Date type Bit Type Boolean Enum Set
TRINITY TECHNOLOGIES

Functions

Strings Functions Numeric Functions Date Time Functions Time zone Aggregate Function Full Text
TRINITY TECHNOLOGIES

Introduction

What is MySQL? Database Terminology Installation of MySQL Configuration of MySQL Administering MySQL through Command-Line Users
TRINITY TECHNOLOGIES

Database & Table

Creating a Database Create a Table
TRINITY TECHNOLOGIES

Database & Table

Creating a Database Create a Table

Introduction

What is MySQL? Database Terminology Installation of MySQL Configuration of MySQL Administering MySQL through Command-Line Users

Functions

Strings Functions Numeric Functions Date Time Functions Time zone Aggregate Function Full Text

MySQL Data Types

Numeric Strings Large Storage Date type Bit Type Boolean Enum Set

PHP MySQL Interfaces

PHP interfaces CRUD MySQL iConnect Prepared Statements Fetching Results

MySQL Architecture

Client/Server Overview Communication Protocols The SQL Parser and Storage Engine Tiers How MySQL Uses Disk Space How MySQL Uses Memory

Starting, Stopping, and Configuring MySQL

Types of MySQL Distributions Starting and Stopping MySQL Server on Windows Starting and Stopping MySQL Server on Unix Runtime MySQL Configuration Log and Status Files Loading Time Zone Tables Security-Related Configuration Setting the Default SQL Mode Upgrading MySQL

Client Programs for DBA Work

Overview of Administrative Clients mysql mysqladmin mysqlimport mysqldump Client Program Limitations

Character Set Support

Performance Issues Choosing Data Types for Character Columns

Locking

Locking Concepts Explicit Table Locking Advisory Locking

Storage Engines

MySQL Storage Engines The MyISAM Engine The MERGE Engine The InnoDB Engine The MEMORY Engine The FEDERATED Engine The Cluster Storage Engine Other Storage Engines

Data (Table) Maintenance

Types of Table Maintenance Operations SQL Statements for Table Maintenance Client and Utility Programs for Table Maintenance Repairing InnoDB Tables Enabling MyISAM Auto-Repair

The INFORMATION_SCHEMA Database

INFORMATION_SCHEMA Access Syntax INFORMATION_SCHEMA Versus SHOW Limitations of INFORMATION_SCHEMA

Data Backup and Recovery Methods

Introduction Binary Versus Textual Backups Making Binary Backups Making Text Backups Backing Up Log and Status Files Replication as an Aid to Backup MySQL Cluster as Disaster Prevention Data Recovery