MY SQL Training

My Sql Training Syllabus

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

Book Your Course