MYSQL – INTRODUCTION

• 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