Dr. Abdul Kalam

11Th President of India

"There is no end to education. It is not that you read a book, pass an examination, and finish with education. The whole of life, from the moment you are born to the moment you die, is a process of learning. "


Duration : 16 weeks
Fees :
  • Introduction

    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



    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


    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


    Storage Engines

    Retrieving Metadata