Online SQL Training

Table of Contents

Day...............................1

•       What is DB  
•       What is DBMS?
•       What is RDBMS? 
•       Difference between DBMS and RDBMS
  
•       What is SQL Server?
•       Role of SQL Server 
•       Different Types of SQL Servers 
•       SQL Server Data Types 
•       New Data Types of SQL Server 2008
•       SQL Command Types 

Day...............................2

•       Normalization
•       Creating a Database
•       Creating a Tables
•       Creating Primary Key, Foreign Keys, Auto increment
•       Creating a Database diagram
•        Constraints

Day...............................3

•       SQL Operators
•       Simple Queries
•       Joins
•       Sub Queries

Day...............................4

•       About View
•       View Types
•       Types of Views
•       How to create a View
•       Advantages and Disadvantages of Views
•       Arthamatic functions
•       Mathematical Functions

Day...............................5

•       About Stored Procedures
•       How to write Procedures
•       Types of Procedures
•       How to pass parameters to Stored Procedures
•       Altering procedures
•       Deleting  Procedures
•       Advantages and Disadvantages of  Procedures
•       Viewing content  in Procedure
•       String Functions

Day...............................6

•       About Functions
•       Table Valued Functions
•       Scalar –Valued Functions
•       Table Variables and Temporary Tables
•       Advantages and Disadvantages of Functions
•       Aggregate Functions

Day...............................7

•       About Indexes
•       Clustered Indexes
•       Non Clustered Indexes
•       Creating Indexes
•       Modifying, Deleting Indexes
•       Advantages and Disadvantage of Indexes
•       String Functions

Day...............................8

•       About Triggers
•       Type of Triggers
•       Creating, Modifying, Viewing and Deleting Triggers
•       Advantages and Disadvantages of Triggers
•       Help Functions

Day...............................9

•       What is Cursor?
•       Types of Cursors
•       How to use cursor inside Procedures?
•       Advantages of Functions
•       Disadvantages of functions?

Day...............................10

•       Other Functions
•       WILL PROVIDE MATERIAL FOR PRACTICE.

Please Contact me for further details : 

Name       :    Chandra
Email ID   :    mrgaddam@gmail.com
Status       :   Online Training will be provided. Please send me mail for further details.
Place        :    London
Country     :    UK