SQL Server 2012 Development Online Training

Module 01: Logical Query Processing

• Logical Query Processing Order

• Logical Query Processing Example

• Phase Details

• Set Operations

Module 02: Query Tuning

• Internals and Index Tuning

• Temporary Tables

• Sets vs. Cursors

• Query Tuning with Query Revisions

Module 03: Multi-Table Queries, Ranking, and Offset Functions

• Subqueries and Table Expressions

• Window Ranking and Offset Functions

• Joins

• Set Operators

Module 04: Aggregating and Pivoting Data

• Window Aggregate Functions

• Pivoting and Unpivoting Data

• Custom Aggregations

• Grouping Sets

Module 05: TOP, OFFSET-FETCH, APPLY

• TOP and OFFSET-FETCH

• APPLY

Module 06: Data Modification

• Inserting Data

• Sequences

• Deleting Data

• Updating Data

• Merging Data

• The OUTPUT Clause

Module 07: Working with Date and Time

• Date and Time Datatypes

• Data and Time Functions

• Data and Time Challenges

• Data and Time Querying Problems

Module 08: Programmable Objects

• Dynamic SQL

• Views and Inline Table Functions

• User Defined Functions

• Stored Procedures

• Triggers

• Transactions and Concurrency

• Exception Handling

Module 09: Graphs, Trees and Hierarchies

• Graphs, Described

• Materialized Paths

  1. Custom

  2. Using the HIERARCHYID datatype

• Nested Sets

• Nested Iterations

  1. Loops

  2. Recursive Queries

Balas Info

Balas Info  is a Pioneer in Online training started by proven industry experts with an aim to provide Quality Training in the latest IT Technologies.

We Offer You
World Class Interactive Learning
Industry Savvy Trainers
Learn Right From Your Place
Customized Curriculum
Highly Affordable Courses
Guaranteed Placement Assistance