Call us : (+91) 9177166122

Microsoft SQL Server ( T-SQL) Online Training Course

Microsoft SQL Server ( T-SQL)

               SQL SERVER COURSE CONTENTS

1)  Database Concepts
  •  Introduction to storage Techniques
  •  Database and Datamodels
  •  History of DBMS
  •  Files and databases
  •  Various DBMS Products
  •  Data Models
  •  E-R Diagrams
  •  Cardinality
 

2)  Introduction to SQL Server
  • History
  • Features of SQL Server 2008
   • Tools of SQL Server
  • SQL Server Management Studio
  • Command Prompt Utilities
  • Other tools
  • SQL Server  databases

3)  Working with Databases
  • Creating Database
  • Creating Tables
  • Managing Databases
  • Database objects
  • T-SQL Features and Commands

4)  Data types and Operators
  • Datatypes in Sql Server
  • Operators in Sql Server


5)  Sub-languages used in Sql Server
  • Working with DDL commands
  • Creating Tables
  • Types of Columns
  • Data types
  • Altering Table structure
  • Renaming Tables
  • Dropping Tables

6)  Manipulating Data
  • Working with DML Commands
  • Types of Insertion
  • Inserting/ Deleting/Updating data
  • Working with WHERE clause
  • Identity function
  • Working  with Truncate Command
  • Truncate or delete

7)  Retrieving Data
  • Working with SELECT Command
  • Sql CLAUSES
  • Distinct
  • Order by
  • Top
  • Into
  • Group by and Having
  • Rollup and Cube

8)  Data Integrity
  • Enforcing Data Integrity
  • Data integrity Constraints
  • Domain Integrity Constraints
  • Referential Integrity Constraints
  • Working with On Delete Cascade, On Update  Cascade
  • Managing Constraints

9)  System Functions
  • Uses of Functions
  • Types of System Functions
  • Scalar
  •  Aggregate
  • Ranking

10)  Joins
  • Working with JOINS
  • Inner joins
  • Self Join
  • Cross Join
  • Outer Join
  • SET Operators

11)  Sub Queries
  • Working
  • with Sub Queries
  • Non-correlated Sub Queries
  • Correlated Sub Queries
  • Limitations of Sub Queries
  • Working with  CTEs
  • Recursive Sub Queries

12)  Views
  • Working with Views
  • Advantages of Views
  • Types of Views
  • Simple and Complex
  • Indexed and Partitioned
  • View restrictions

13)  Indexes
  • Advantages of Indexes
  • Types
  • Clustered, Non-clustered
  • Managing Indexes

14)  Database Objects
  • Schemas
  • Synonyms
  • Sequence
  • Merge concept
  • Creating Login and Username

15)  T-SQL Programming
  • Fundamental Concepts
  • Variable Declarations
  • Procedure capabilities  of T-SQL

16)  Cursors
  • Types of cursors
  • Advantages of Cursors
  • Working with Cursors

17)  User Defined Functions
  • Working with User Defined Functions
  • Types of Functions
  • Scalar and Table valued Functions
  • Difference between Functions and SP

18)  Stored Procedures
  • Advantages of SP
  • Life Cycle
  • Types  of SP
  • Creating SP
  • Working with Parameters
  • Input/Output  parameters
  • Optional parameters
  • RETURN Statement
  • Exception Handling in S.P
  • Try/Catch block
  • Transaction Handling in SP
  • Using Recursion in SP

19)  Triggers
  • Triggers
  • Advantages of Triggers
  • Types of Triggers
  • For/After Triggers
  • DML, DDL
  • Instead of Triggers
  • Working with Magic Tables
  • Logon Triggers  in SP2
  • Trigger Limitations
  • Managing Triggers

20)  Partition Tables