About us

SQL

Structured Query language (SQL) pronounced as "S-Q-L" or sometimes as "See-Quel"is actually the standard language for dealing with Relational Databases. SQL programming can be effectively used to insert, search, update, delete database records.

Download brochure

SQL Syllabus

INTRODUCTION
  1. What is a Database?
  2. RDBMS Terminology
  3. MySQL Database
INSTALLATION
  1. Installing MySQL on Linux/UNIX
  2. Installing MySQL on Windows
  3. Verifying MySQL Installation
  4. Post-installation Steps
  5. Running MySQL at Boot Time
ADMINISTRATION
  1. Running and Shutting down MySQL Server
  2. Setting Up a MySQL User Account
  3. Administrative MySQL Command
PHP SYNTAX
  • Data Types
  • Qualifier
  • Enum
  • Typedef
  • CONNECTION
    1. MySQL Connection Using MySQL Binary
    2. MySQL Connection Using PHP Script
    CREATE DATABASE
    1. Create Database Using mysqladmin
    2. Create a Database Using PHP Script
    DROP DATABASE
    1. Drop a Database using mysqladmin
    2. Drop Database using PHP Script
    SELECT DATABASE
    1. Selecting MySQL Database from the Command Prompt
    2. Selecting a MySQL Database Using PHP Script
    DATATYPES
    1. Numeric Data Types
    2. Date and Time Types
    3. String Types
    CREATE TABLES
    1. Creating Tables from Command Prompt
    2. Creating Tables Using PHP Script
    DROP TABLES
    1. Dropping Tables from the Command Prompt
    2. Dropping Tables Using PHP Script
    INSERT QUERY
    1. Inserting Data from the Command Prompt
    2. Inserting Data Using a PHP Script
    SELECT QUERY
    1. Fetching Data from a Command Prompt
    2. Fetching Data Using a PHP Script
    3. Releasing Memory
    WHERE CLAUSE
    1. Fetching Data from the Command Prompt
    2. Fetching Data Using a PHP Script
    UPDATE QUERY
    1. Updating Data from the Command Prompt
    2. Updating Data Using a PHP Script
    DELETE QUERY
    1. Deleting Data from the Command Prompt
    2. Deleting Data Using a PHP Script
    LIKE CLAUSE
    1. Using the LIKE clause at the Command Prompt
    2. Using LIKE clause inside PHP Script
    SORTING RESULTS
    1. Using ORDER BY clause at the Command Prompt
    2. Using ORDER BY clause inside a PHP Script
    USING JOIN
    1. Using Joins at the Command Prompt
    2. Using Joins in a PHP Script
    3. MySQL LEFT JOIN
    NULL VALUES
    1. Using NULL values at the Command Prompt
    2. Handling NULL Values in a PHP Script
    REGEXPS
    TRANSACTIONS
    1. Properties of Transactions
    2. COMMIT and ROLLBACK
    3. Transaction-Safe Table Types in MySQL
    ALTER COMMAND
    1. Dropping, Adding or Repositioning a Column
    2. Altering (Changing) a Column Definition or a Name
    3. Altering (Changing) a Column's Default Value
    4. Altering (Changing) a Table Type
    5. Renaming (Altering) a Table
    INDEXES
    1. Simple and Unique Index
    2. ALTER command to add and drop INDEX
    3. ALTER Command to add and drop the PRIMARY KEY
    TEMPORARY TABLES
    1. PWhat are Temporary Tables?
    2. Dropping Temporary Tables
    CLONE TABLES
    DATABASE INFO
    1. Obtaining and Using MySQL Metadata
    2. Obtaining the Number of Rows Affected by a Query
    3. Listing Tables and Databases
    USING SEQUENCES
    1. Using AUTO_INCREMENT Column
    2. Renumbering an Existing Sequence
    HANDLING DUPLICATES
    1. Preventing Duplicates from Occurring in a Table
    2. Counting and Identifying Duplicates
    3. Eliminating Duplicates from a Query Result
    4. Removing Duplicates Using Table Replacement
    SQL INJECTION
    1. Preventing SQL Injection
    2. The LIKE Quandary
    DATABASE EXPORTS
    1. Exporting Data with the SELECT INTO OUTFILE Statement
    2. Exporting Tables as Raw Data
    3. Copying Tables or Databases to Another Host
    DATABASE IMPORT
    1. Importing Data with LOAD DATA
    2. Importing Data with mysqlimport
    3. Handling Quotes and Special Characters

    Thus, if you are looking for SQL Training classes, just contact us at info@shimpyinfotech.com to experience the best PHP training modules.