Microsoft

Microsoft SQL Server Development Online Training 

SQL Server 2012

• Introduction to SQL Server
• SQL Server Databases
• Types of DatabasesSystem 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