Follow Us:

SQL Server Training in Chennai


Course Duration

40 HOURS Sign in with Facebook Sign in with Facebook

Course Contents

SQL Server
    What is SQL
    Why SQL?
    SQL Commands
  • DDL - Data Definition Language
  • DML - Data Manipulation Language
  • DCL - Data Control Language
  • DQL - Data Query Language
  • SQL RDBMS Concepts
  • What is field?
  • What is record, or row?
  • What is column?
  • What is NULL value?
  • SQL Syntax
  • SQL SELECT Statement
  • SQL DISTINCT Clause
  • SQL WHERE Clause
  • SQL AND/OR Clause
  • SQL IN Clause
  • SQL BETWEEN Clause
  • SQL Like Clause
  • SQL ORDER BY Clause
  • SQL GROUP BY Clause
  • SQL COUNT Clause
  • SQL HAVING Clause
  • SQL CREATE TABLE Statement
  • SQL DROP TABLE Statement
  • SQL CREATE INDEX Statement
  • SQL DROP INDEX Statement
  • SQL DESC Statement
  • SQL TRUNCATE TABLE Statement
  • SQL ALTER TABLE Statement
  • SQL ALTER TABLE Statement (Rename)
  • SQL INSERT INTO Statement
  • SQL UPDATE Statement
  • SQL DELETE Statement
  • SQL CREATE DATABASE Statement
  • SQL DROP DATABASE Statement
  • SQL USE Statement
  • SQL COMMIT Statement
  • SQL ROLLBACK Statement
  • SQL Data Types
  • Exact Numeric Data Types
  • Approximate Numeric Data Types
  • Date and Time Data Types
  • Character Strings Data Types
  • Unicode Character Strings Data Types
  • Binary Data Types
  • Misc Data Types
  • SQL Operators
  • What is an Operator in SQL?
  • SQL Arithmetic Operators
  • SQL Comparison Operators
  • SQL Logical Operators
  • SQL Expressions
  • SQL - Boolean Expressions
  • SQL - Numeric Expression
  • SQL - Date Expressions
  • SQL Joins
  • INNER JOIN
  • LEFT JOIN
  • RIGHT JOIN
  • FULL JOIN
  • SELF JOIN
  • CARTESIAN JOIN
  • SQL Unions Clause
    SQL NULL Values
    SQL Alias Syntax
    SQL Indexes
  • The CREATE INDEX Command
  • Single-Column Indexes
  • Unique Indexes
  • Composite Indexes
  • Implicit Indexes
  • The DROP INDEX Command
  • SQL TRUNCATE TABLE
    SQL - Using Views
  • Creating Views
  • The WITH CHECK OPTION
  • Updating a View
  • Inserting Rows into a View
  • Deleting Rows into a View
  • Dropping Views
  • SQL HAVING CLAUSE
    SQL Transactions
    Transaction Control
  • The COMMIT Command
  • The ROLLBACK Command
  • The SAVEPOINT Command
  • The RELEASE SAVEPOINT Command
  • The SET TRANSACTION Command
  • SQL Wildcard Operators
    SQL Date Functions
    SQL Temporary Tables
    SQL Sub Queries
  • Subqueries with the SELECT Statement
  • Subqueries with the INSERT Statement
  • Subqueries with the UPDATE Statement
  • SQL – Handling Duplicates
    SQL – Injection
    SQL – Useful Functions
    SQL – Stored Procedures
    SQL – Triggers
    SQL – Cursor
    SQL – Exception Handling
Register Now

You will Learn How To :

Course Benefits :

Register Now

Please use the form below to make your career excellent.