Microsoft Sql Server Development Online Training

SQL Server 2012

  • Introduction to SQL Server
  • SQL Server Databases
    • Types of Databases
      • System Databases
      • User Databases
    • User Databases
      • Creating Databases using Object Explorer
      • Creating Databases using Query Editor
  • DDL, DQL, DML, TCL, DCL Commands
  • Data Integrities
    • Types of Integrities
      • Pre defined integrities
      • Entity Integrities
      • Domain Integrities
      • Referential Integrities
    • User defined integrities
  • Operators in SQL Server
    • Arithmetic operators
    • Logical operators
    • Comparison operators
    • Range operators
    • List operators
    • Null operator
    • String operators
    • Modified comparison operators
  • Functions in SQL Server
    • Types of Functions
      • Library Functions
      • User defined Functions
  • JOINS
    • Types in Joins
      • Inner join
        • Equi join
        • Non Equi join
      • Outer join
        • Left Outer join
        • Right Outer join
        • Full Outer join
      • Cross / Cartesian join
      • Self join and Natural joins
    • VIEWS
      • Types of Views
      • Creating Views
      • Altering Views
      • Dropping Views
    • SUB QUERIES
      • Nested Sub queries
      • Co-related sub queries
    • Transactions and Locks
      • Types of Transactions
        • Implicit Transactions
        • Explicit Transactions
      • Types of Locks
        • Shared lock
        • Exclusive lock
        • Update lock

T-SQL Programming or Sql server programming

  • STORED PROCEDURES
    • Types of Stored procedures
      • System Stored Procedures
      • User Stored Procedures
        • Creating Stored Procedures
        • Altering Stored Procedures
        • Dropping Stored Procedures
  • TRIGGERS
    • Types of Triggers
      • DML Triggers
      • DDL Triggers
        • Creating Triggers
        • Altering Triggers
        • Dropping Triggers
    • CURSORS
      • Types of Cursors
        • Defining Cursors
        • Fetching rows from Cursor
        • Close Cursor
        • Deallocate cursor
    • INDEXES
      • Types of indexes
        • Clustered indexes
        • Nonclustered indexes
          • Creating indexes
          • Dropping Indexes
    • User Defined Functions (UDF)
      • Types of User Defined Functions
        • Scalar Valued Functions
        • Inline Functions
        • Table Valued Functions