home-banner

SYLLABUS FOR MYSQL

1.My SQL introduction

  • What is a Database
  • RDBMS Terminology
  • MySQL Database

2.MYSQL – INSTALLATION

  • Installing My SQL on Windows
  • Verifying My SQL Installation
  • Post-installation Steps
  • Running My SQL at Boot Time

3.MYSQL – ADMINISTRATION

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

4. MYSQL – PHP SYNTAX

5.MYSQL – CONNECTION

  • My SQL Connection Using My SQL Binary
  • My SQL Connection Using PHP Script

6. MYSQL – CREATE DATABASE

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

7. MYSQL – DROP DATABASE

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

8. MYSQL – SELECT DATABASE

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

9. MYSQL – DATATYPES

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

10. MYSQL – CREATE TABLES

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

11. MYSQL – DROP TABLES

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

12. MYSQL – INSERT QUERY

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

13. MYSQL – SELECT QUERY

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

14. MYSQL – WHERE CLAUSE

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

15. MYSQL – UPDATE QUERY

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

16. MYSQL – DELETE QUERY

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

17. MYSQL – LIKE CLAUSE

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

18. MYSQL – SORTING RESULTS

  • Using ORDER BY clause at the Command Prompt
  • Using ORDER BY clause inside a PHP Script

19. MYSQL – USING JOIN

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

20.MYSQL – NULL VALUES

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

21. MYSQL – REGEXPS

22. MYSQL – DATABASE EXPORTS

  • Exporting Data with the SELECT … INTO OUTFILE Statement
  • Exporting Tables as Raw Data
  • Copying Tables or Databases to Another Host

23.MYSQL – DATABASE IMPORT

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