SQL SERVER INTRODUCTION TO DATA STORE TRAINING

SQL SERVER CONTENT

INTRODUCTION TO DATA STORE
•Different ways of Storing Data
a.BOOKS and PAPERS
b.Data Files
c.DataBase

INTRODUCTION TO DBMS
•Understanding data storage in HDBMS
•Understanding data storage in NDBMS
•Introduction to RDBMS
a.Understanding CODD Rules
b.Understanding SEQUEL

Introduction to SQL SERVER
•Data Definition Language
•Using Constraints
a.Not Null,Unique,Primary,Check
b.Referential Integrity and Self Referential Integrity
c. using Cascading Rules
•Performing DML Operations
•Writing Queries using
a. Functions
i.Single Row and Group
b.Operators
i.Conditional, Logical and set
c.Clauses
i.Where, Group by, Having and Order By
d.Sub Queries
e.Correlated Sub Queries
f.Joins
g.Transaction Control Language
•Creating tables from existing tables
•Managing Security with Data Control Language
a.User Creation
b.Controlling the permission by Grant,Revoke and Deny
•Creating views
•Understanding the Data Storage Architecture
•Creating Views
•Disadvantages of SQL and Introduction to PL/SQL
a.Writing Programs using PL/SQL
b.Understanding Cursors
c.Types of cursors

INTRODUCTION TO SUB-PROGRAMS
•Writing Procedures
a.Handling Errors in Procedures
b.Transaction Management in Procedures
•Writing User - Defined Functions
a.Disadvantages of Functions
•Writing Triggers
a.Types of Triggers
b.DML and DDL Triggers