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