SQL SERVER TRAINING IN HYDERABAD SQL SERVER CONTENT INTRODUCTION TO DATA STORE Different ways of Storing Data BOOKS and PAPERS Data Files DataBase INTRODUCTION TO DBMS Understanding data storage in HDBMS Understanding data storage in NDBMS Introduction to RDBMS Understanding CODD Rules Understanding SEQUEL Introduction to SQL SERVER Data Definition Language Using Constraints 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 Views 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
Posted on: Mon, 01 Sep 2014 05:27:34 +0000
Trending Topics
Recently Viewed Topics
© 2015