The best learning institution

welcome to DRASTI INSTITUTE


SQL SERVER DEVELOPER COURSE CONTENT

  • Login Creation
  • SQL Server Authenticated Login
  • Windows Authenticated Login
  • User Creation
  • Granting Permissions
  • Revoking Permissions
  • Roles

  • Roles
  • Purpose Of Views
  • Creating , Altering and Dropping Indexes
  • Simple and Complex Views
  • Encryption and Schema Binding Options in creating views

  • Encryption and Schema Binding Options in creating views
  • Introduction
  • Begin Transaction
  • Commit Transaction
  • Rollback Transaction
  • Save Transaction
  • Role Of Log File In Transaction Management
  • Implicit Transactions

  • Implicit Transactions
  • Drawbacks Of TSQL that leads to TSQL Programming
  • Control statements In TSQL Programming
  • Conditional Control Statements
  • If
  • Case
  • Looping Control Statements
  • While

  • While
  • Working With Cursors
  • Types Of Cursors
  • Forward Only and Scroll Cursors
  • Static, Dynamic and Keyset Cursors
  • Local and Global Cursors

  • Local and Global Cursors
  • Advantages Of Stored Sub Programs compared to Independent SQL Statements
  • Stored Procedures
  • Creating , Altering and Dropping
  • Optional Parameters
  • Input and Output Parameters
  • Permissions on Stored Procedures
  • User Defined Functions
  • Creating, Altering and Dropping
  • Types Of User Defined Functions
  • Scalar Functions
  • Table Valued Functions
  • Inline Table Valued Functions
  • Multi Statement Table Valued Functions
  • Permissions On User Defined Functions
  • Triggers
  • Purpose of Triggers
  • Differences Between Stored Procedures and User Defined Functions and Triggers
  • Creating, Altering and Dropping Triggers
  • Magic Tables
  • Instead Of Triggers
  • Exception Handling
  • Implementing Exception Handling
  • Adding and removing User Defined Error Messages To And From SQL Server Error Messages
  • List
  • Raising Exceptions Manual

  • Raising Exceptions Manual
  • Backup and Restore of Database
  • Attach and Detach of Database

SQL (Structured Query Language) Attach and Detach of Database
  • Attach and Detach of Database
  • History and Features of SQL
  • Data Definition Language (DDL)
  • Data Manipulation Language (DML)
  • Data Query Language (DQL)
  • Data Control Language (DCL)
  • Transaction Control Language (TCL)
  • Database Creating Database
  • Altering Database
  • Deleting Database
  • Constrains Procedural Integrity Constraints
  • Declarative Integrity Constraints Not Null, Unique, Default and Check constraints
  • Primary Key and Referential Integrity or foreign key constraints
  • Data Types In SQL
  • Table Creating Table
  • Altering Table
  • Deleting Table

  • Deleting Table
  • Insert
  • Identity
  • Creating A Table From Another Table
  • Inserting Rows From One Table To Another
  • Update Computed Columns
  • Delete Truncate
  • Differences Between Delete and Truncate

  • Differences Between Delete and Truncate
  • Select
  • Where clause
  • Order By Clause
  • Distinct Keyword
  • Isnull() function
  • Column aliases
  • Predicates
  • Between And
  • In
  • Like
  • Is Null

  • Is Null
  • Scalar Functions
  • Numeric Functions
  • Character Functions
  • Conversion Functions
  • Date Functions
  • Aggregate Functions Convenient Aggregate Functions
  • Statistical Aggregate Functions
  • Group By and Having Clauses
  • Super Aggregates
  • Over(partition by) Clause
  • Ranking Functions Common Table Expressions (CTE)

  • Ranking Functions Common Table Expressions (CTE)
  • Set Operators
  • Union
  • Intersect
  • Except

  • Except
  • Inner Join
  • Equi Join
  • Natural Join
  • Non-Equi Join
  • Self Join
  • Outer Join Left Outer Join
  • Right Outer Join
  • Full Outer Join
  • Cross Join

  • Cross Join
  • Single Row Sub Queries
  • Multi Row Sub Queries
  • Any or Some
  • ALL
  • Nested Sub Queries
  • Co-Related Sub Queries Exists and Not Exists

  • Co-Related Sub Queries Exists and Not Exists

  Drop us a query

  Contact us : +91-9818721953



 
 
 
 

Activities