MYSQL Training

MySQL is an open source relational database management system. Information in a MySQL database is stored in the form of related tables. MySQL databases are typically used for web application development (often accessed using PHP).

A MySQL database can be accessed (queried) directly using; C, C++, Eiffel, Java, Perl, PHP and Python computer languages. There is also third party support for connection in a Windows environment.


Course Detail

  • MySQL - Introduction
  • MySQL - Installation
  • MySQL - Administration
  • MySQL - PHP Syntax
  • MySQL - Connection
  • MySQL - Create Database
  • MySQL - Drop Database
  • MySQL - Select Database
  • MySQL - Data Types
  • MySQL - Create Tables
  • MySQL - Drop Tables
  • MySQL - Insert Query
  • MySQL - Select Query
  • MySQL - Where Clause
  • MySQL - Update Query
  • MySQL - Delete Query
  • MySQL - Like Clause
  • MySQL - Sorting Results
  • MySQL - Using Join
  • MySQL - NULL Values
  • MySQL - Regexps
  • MySQL - Transactions
  • MySQL - Alter Command
  • MySQL - Indexes
  • MySQL - Temporary Tables
  • MySQL - Clone Tables
  • MySQL - Database Info
  • MySQL - Using Sequences
  • MySQL - Handling Duplicates
  • MySQL - SQL Injection
  • MySQL - Database Export
  • MySQL - Database Import
  • SQL - Constraints
  • SQL - Using Joins
  • SQL - Unions Clause
  • SQL - NULL Values
  • SQL - Alias Syntax
  • SQL - Indexes
  • SQL - Alter Command
  • SQL - Truncate Table
  • SQL - Using Views
  • SQL - Having Clause
  • SQL - Transactions
  • SQL - Wildcards
  • SQL - Date Functions
  • SQL - Temporary Tables
  • SQL - Clone Tables
  • SQL - Sub Queries
  • SQL - Using Sequences
  • SQL - Handling Duplicates
  • SQL - Injection