• What is a Database?

• RDBMS Terminology
• MySQL Database

        MYSQL – INSTALLATION

• Installing MySQL on Windows

• Post-installation Steps

        MYSQL – ADMINISTRATION

• Running and Shutting down MySQL Server

• Setting Up a MySQL User Account

• Administrative MySQL Command

         MYSQL – CONNECTION

         MYSQL – CREATE DATABASE

• Create Database Using mysqladmin

          MYSQL – DROP DATABASE

• Drop a Database using mysqladmin

          MYSQL – SELECT DATABASE

• Selecting MySQL Database from the Command Prompt

         MYSQL – DATATYPES

• Numeric Data Types

• Date and Time Types

• String Types

         MYSQL – CREATE TABLES

• Creating Tables from Command Prompt

         MYSQL – DROP TABLES

• Dropping Tables from the Command Prompt

         MYSQL – INSERT QUERY

• Inserting Data from the Command Prompt

        MYSQL – SELECT QUERY

• Fetching Data from a Command Prompt

• Releasing Memory

          MYSQL – WHERE CLAUSE

• Fetching Data from the Command Prompt

           MYSQL – UPDATE QUERY

• Updating Data from the Command Prompt

           MYSQL – DELETE QUERY

• Deleting Data from the Command Prompt

           MYSQL – LIKE CLAUSE

• Using the LIKE clause at the Command Prompt

           MYSQL – SORTING RESULTS

• Using ORDER BY clause at the Command Prompt

           MYSQL – USING JOIN

• Using Joins at the Command Prompt

• MySQL LEFT JOIN

            MYSQL – NULL VALUES

• Using NULL values at the Command Prompt

            MYSQL – REGEXPS

              MYSQL – TRANSACTIONS

• Properties of Transactions

• COMMIT and ROLLBACK

• Transaction-Safe Table Types in MySQL

           MYSQL – ALTER COMMAND

• Dropping, Adding or Repositioning a Column

• Altering (Changing) a Column Definition or a Name

• Altering (Changing) a Column’s Default Value

• Altering (Changing) a Table Type

• Renaming (Altering) a Table

           MYSQL – INDEXES

• Simple and Unique Index

• ALTER command to add and drop INDEX

• ALTER Command to add and drop the PRIMARY KEY

           MYSQL – TEMPORARY TABLES

• What are Temporary Tables?

• Dropping Temporary Tables