+91 9008553112
info@parkus.in
  1. INTRODUCTION
  • Scope of data
  • DBMS introduction
  • Use of RDBMS
  • Difference between DBMS and RDBMS
  • Use of constraints
  1. RETRIEVING DATA
  • Syntax of select query
  • Customizing the display using alias
  • Literal character strings
  • Concatenating the text values
  • Arithmetic operations
  • Using where clause
  • Comparison operators
  • Logical operators
  • Range operators
  • In and Not In keywords
  • Like keyword
  • Handling null values
  • Using Order by clause
  • Top keyword
  • Using Distinct
  1. FUNCTIONS IN SQL SERVER
  • String functions
  • Date functions
  • Mathematical functions
  • Ranking functions
  • System functions
  1. AGGREGATE FUNCTIONS
  • Avg
  • Sum
  • Count
  • Min
  • Max
  1. SUMMARIZING AND GROUPING DATA
  • Group by clause
  • Having clause
  • Group by sets
  • Compute and compute by class
  • Pivot class
  1. JOINS
  • Inner join
  • Outer join
  • Equi join
  • Self join
  • Cross join
  1. USING SUB QUERIES
  • Inner and outer query
  • Using IN key word in sub query
  • Using EXISTS keyword in sub query
  • Using ANY key word in sub query
  • Using ALL key word in sub query
  • Aggregate functions in sub query
  • Nested sub query
  • Correlated sub query
  • Apply keyword in sub query
  • Cross apply and outer apply in sub query
  1. COMBINE AND COMPARE THE RESULT SETS
  • Union operator
  • Intersect operator
  • Except operator
  1. CREATE AND MANAGE TABLE
  • Create table
  • View the structure of the table
  • Identity column
  • Constraints information
  • Cascading integrity referential constraints
  • IN, LIKE and BETWEEN keywords in check constraints
  • Modifying table
  • Renaming table and drop table
  1. MANIPULATING DATA USING DML STATEMENTS
  • Insert
  • Guidelines to inserting data
  • Different kind of syntaxes to insert data
  • Inserting partial data
  • Copying data from one table to another table
  • Updating the table data
  • Deleting data
  • Using output clause
  • Using merge
  1. CREATE AND MANAGING INDEXES
  • Introduction to indexes
  • Creating clustered index
  • Creating non clustered index
  • Difference between clustered and non clustered indexes
  • Filtered index
  • Disabling index
  • Enabling index
  • Renaming index
  • Dropping index
  • Optimizing index
  1. CREATE AND MANAGE VIEW
  • Introduction
  • What is view
  • Advantages of view
  • How to create view
  • Guidelines to create view
  • Alter view
  • Rename view
  • Drop view
  1. BATCHES AND CONSTRUCTS
  • What is batches
  • Using variables
  • Creating batches
  • Displaying user defined messages
  • .else constructs
  • Case
  • While
  1. EXCEPTION HANDLING
  • Try catch block in exception handling
  • Pre defined functions in catch
  • Using try catch block in batches
  • Raise error in exception handling
  1. STORED PROCEDURE
  • What is stored procedure
  • Syntax to create stored procedure
  • How to create stored procedure
  • How to execute stored procedure
  • Alter stored procedure
  • Drop stored procedure
  • Parameters in stored procedure
  1. USER DEFINED FUNCTIONS
  • What is function
  • Syntax to create function
  • Types of user defined functions
  • Creating scalar function
  • Creating table valued function
  1. TRIGGERS
  • What is trigger
  • Types of trigger
  • DML trigger
  • DDL trigger
  • Recursive trigger
  • Creating trigger syntax
  • Alter trigger
  • Delete trigger
  • Enable and disable trigger
  1. TRANSACTIONS
  • What is transaction
  • Types of transaction
  • Implement transaction
  • Auto commit transaction
  • Implicit transaction
  • Explicit transaction
  • Reverting transaction