logo
ISO 9001:2015 Certified Training Center
Free consultation ||                      +911202406480, +91-8826330653
   info@shimpyinfotech.com, shimpyinfotech@gmail.com

SQL

ShimpyInfotech is giving Best/ Top training in Ghaziabad. And institute has well experienced trainer. MYSQL is an open source relational database management system (RDBMS) based on Structured Query Language (SQL).

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
  1. Data Types
  2. Qualifier
  3. Enum
  4. 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 SQL training modules.