Duration: 45 days

Online  Fee: 15,000

Classroom Fee: 6000

 

Introduction of SQL Server

Features of SQL Server

Different Versions of SQL Server

DBMS Concepts

  • What is Database?
  • What is DBMS?
  • What is RDBMS?
  • Different types of database models?

SQL Language

  • Introduction of SQL
  • Data types of SQL
  • Role of SQL in DBMS
  • Naming rules in SQL server

DML Commands

Insert

  • Insertion of data
  • Copying of rows from table to table
  • Select
  • Combination Statements

Data integrity Constraints

  • Domain integrity
  • Entity integrity
  • Referential integrity
  • On delete cascade
  • On update cascade

Joins & Sub Queries

  • Equi join
  • Non-equi joins
  • Natural join
  • Self join
  • Outer join
  • Cross join
  • Simple queries
  • Sub queries

Functions

  • Single row functions
  • Multi row functions

Update

  • Data updating
  • Updating data using sub quires

Delete

  • Deleting data
  • Deleting data using sub quires

DDL commands

  • Create, alter drop
  • Rename
  • Truncate

DCL commands

  • Grant
  • Revoke

TCL commands

  • Commit
  • Roll back
  • Save transaction

Index

  • Unique index
  • Non-unique index

View

  • Simple view
  • Complex view
  • Read only views

Synonym

  • Private synonym
  • Public synonym
  • What is t-SQL?
  • Operators & data types in t-SQL

Flow control statements

  • If …else
  • Switch case
  • Nested if …else

Condition based loops

  • While loop
  • For loop
  • Do-while loop

Embedded SQL

Usage of select statement

Cursor

  • Implicit cursor
  • Declaring cursors
  • Explicit cursor
  • Advantages of cursor

Sub programs

  • Stored procedures
  • Difference between function and procedure
  • Advantage of stored procedure

Triggers

  • DML Triggers (After | Instead of )
  • DDL Triggers

Security

  • Windows Authentication
  • Magic Tables
  • SQL Server Authentication
  • Creating Login
  • Database Permissions
  • Dropping Login