---

mysql Course Content

---

MYSQL – INTRODUCTION

• What is a Database?
• RDBMS Terminology
• MySQL Database

MYSQL – INSTALLATION

• Installing MySQL on Linux/UNIX
• Installing MySQL on Windows
• Verifying MySQL Installation
• Post-installation Steps
• Running MySQL at Boot Time

MYSQL – ADMINISTRATION

• Running and Shutting down MySQL Server
• Setting Up a MySQL User Account
• Administrative MySQL Command

MYSQL – PHP SYNTAX

MYSQL – CONNECTION

• MySQL Connection Using MySQL Binary
• MySQL Connection Using PHP Script

MYSQL – CREATE DATABASE

• Create Database Using mysqladmin
• Create a Database Using PHP Script

MYSQL – DROP DATABASE

• Drop a Database using mysqladmin
• Drop Database using PHP Script

MYSQL – SELECT DATABASE

• Selecting MySQL Database from the Command Prompt
• Selecting a MySQL Database Using PHP Script

MYSQL – DATATYPES

• Numeric Data Types
• Date and Time Types
• String Types

MYSQL – CREATE TABLES

• Creating Tables from Command Prompt
• Creating Tables Using PHP Script

MYSQL – DROP TABLES

• Dropping Tables from the Command Prompt
• Dropping Tables Using PHP Script

MYSQL – INSERT QUERY

• Inserting Data from the Command Prompt
• Inserting Data Using a PHP Script

MYSQL – SELECT QUERY

• Fetching Data from a Command Prompt
• Fetching Data Using a PHP Script
• Releasing Memory

MYSQL – WHERE CLAUSE

• Fetching Data from the Command Prompt
• Fetching Data Using a PHP Script

MYSQL – UPDATE QUERY

• Updating Data from the Command Prompt
• Updating Data Using a PHP Script

MYSQL – DELETE QUERY

• Deleting Data from the Command Prompt
• Deleting Data Using a PHP Script

MYSQL – LIKE CLAUSE

• Using the LIKE clause at the Command Prompt
• Using LIKE clause inside PHP Script

MYSQL – USING JOIN

• Using Joins at the Command Prompt
• Using Joins in a PHP Script
• MySQL LEFT JOIN

MYSQL – NULL VALUES

• Using NULL values at the Command Prompt
• Handling NULL Values in a PHP Script

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
• Dropping, Adding or Repositioning a Column
• Altering (Changing) a Column Definition or a Name
• 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

MYSQL – CLONE TABLES

MYSQL – DATABASE INFO

• Obtaining and Using MySQL Metadata
• Obtaining the Number of Rows Affected by a Query
• Listing Tables and Databases

MYSQL – USING SEQUENCES

• Using AUTO_INCREMENT Column
• Renumbering an Existing Sequence

MYSQL – HANDLING DUPLICATES

• Preventing Duplicates from Occurring in a Table
• Counting and Identifying Duplicates
• Eliminating Duplicates from a Query Result
• Removing Duplicates Using Table Replacement.

MYSQL – SQL INJECTION

• Preventing SQL Injection
• The LIKE Quandary

MYSQL – DATABASE IMPORT

• Importing Data with LOAD DATA
• Importing Data with mysqlimport
• Handling Quotes and Special Characters