Introduction To Data Store
›› Different ways of storing Data
›› Books and Papers
›› Data Files
›› Database
Introduction To DBMS
›› Understanding data storage in HDMS
›› Understanding data storage in NDBMS
›› Introduction to RDBMS
›› Understanding CODD Rules
›› Understanding SEQUEL
Introduction To SQL Server
›› Data Definition Language
›› Using Constrains
›› Not Null, Unique, Primary, Check
›› Referential Integrity and Self Referential Integrity
›› Using Cascading Rules
›› Performing DML Operations
›› Writing Queries using
›› Functions
›› Single Row and Group
›› Operators
›› Conditional, Logical and Set
›› Clauses
›› Where, Group By, Having and
›› Order By
›› Sub – Queries
›› Correlated Sub – Queries
›› Joins
›› Transaction Control Language
›› Creating tables from existing tables
›› Managing Security with Data Control Language
›› User creation
›› Controlling the permission by Grant, Revoke and Deny
›› Creating Views
›› Understanding the Data Storage Architecture
›› Creating Indexes
›› Disadvantages of SQL and Introduction to Pl/SQL
›› Writing Programs using PL/SQL
›› Understanding Cursors
›› Types of Cursors
Introduction To Sub-Programs
›› Writing procedures
›› Handling Errors in Procedures
›› Transaction Management in Procedures
›› Writing User-Defined Functions
›› Disadvantages of Functions
›› Writing Triggers
›› Types of Triggers
DML and DDL Triggers (SQL Server 2012)
›› Overview of new features in SQL Server 2012
