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 shimpyinfotech@gmail.com to experience the best SQL training modules.

Quick links

• Home
• About Us
• Contact

Courses