SQL Server

Introduction To DBMS

  • File Management System And Its Drawbacks
  • Database Management System (DBMS) And Data Models
  • Physical Data Models
  • Logical Data Models
  • Hierarchical Data Model (HDBMS)
  • Network Data Model (NDBMS)
  • Relational Data Model (RDBMS)
  • Object Data Model (ODBMS)
  • Object Relational Data Model (ORDBMS)
  • Conceptual Data Models
  • Entity – Relationship (E-R) Model

Introduction To SQL Server

  • Advantages And Drawbacks Of SQL Server Compared To Oracle And DB2
  • Connecting To Server
  • Server Type
  • Server Name
  • Authentication Modes
  • Sql Server Authentication Mode
  • Windows Authentication Mode
  • Login And Password
  • Sql Server Management Studio And Tools In Management Studio
  • Object Explorer
  • Object Explorer Details
  • Query Editor
  • TSQL (Transact-Structured Query Language)

Introduction To TSQL

  • History And Features Of TSQL
  • Types Of TSQL Commands
  • Data Definition Language (DDL)
  • Data Manipulation Language (DML)
  • Data Query Language (DQL)
  • Data Control Language (DCL)
  • 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 TSQL
  • Table
  • Creating Table
  • Altering Table
  • Deleting Table

Data Manipulation Language

  • 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

Data Query Language (DQL)

  • Select
  • Where Clause
  • Order By Clause
  • Distinct Keyword
  • Isnull() Function
  • Column Aliases
  • Predicates
  • Between … And
  • In
  • Like
  • Is Null

Built In Functions

  • 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)

Set Operators

  • Union
  • Intersect
  • Except

Joins

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

Sub Queries

  • Single Row Sub Queries
  • Multi Row Sub Queries
  • Any Or Some
  • ALL
  • Nested Sub Queries
  • Co-Related Sub Queries
  • Exists And Not Exists

Indexes

  • Clustered Index
  • NonClustered Index
  • Create , Alter And Drop Indexes
  • Using Indexes

Security

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

Views

  • Purpose Of Views
  • Creating , Altering And Dropping Indexes
  • Simple And Complex Views
  • Encryption And Schema Binding Options In Creating Views

Transaction Management

  • Introduction
  • Begin Transaction
  • Commit Transaction
  • Rollback Transaction
  • Save Transaction
  • Role Of Log File In Transaction Management
  • Implicit Transactions

TSQL Programming

  • Drawbacks Of TSQL That Leads To TSQL Programming
  • Introduction To TSQL Programming
  • Control Statements In TSQL Programming
  • Conditional Control Statements
  • If Case
  • Looping Control Statements
  • While

Cursors

  • Working With Cursors
  • Types Of Cursors
  • Forward_Only And Scroll Cursors
  • Static, Dynamic And Keyset Cursors
  • Local And Global Cursors

Stored Sub Programs

  • 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
  • CLR Integration
  • What Is CLR Integration And The Steps For Implementing It
  • A Simple Example With CLR Integration
  • Working With XML Data Type
  • Backup And Restore Of Database
  • Attach And Detach Of Database
  • Normalization

Importent Details

  • 10 November, 2020
  • 10.00AM - 10.00PM
  • Starts From

  • April 06, 2020
  • 16:50:01