Microsoft SQL Server 2008/2012 (MSSQL)
Corso
Online
Hai bisogno di un coach per la formazione?
Ti aiuterà a confrontare vari corsi e trovare l'offerta formativa più conveniente.
Descrizione
-
Tipologia
Corso
-
Metodologia
Online
-
Inizio
Scegli data
This course has been created for delegates already acquainted with SQL in Microsoft SQL Server Environment 2008/2012. The course focuses on set-based querying and query tuning, working with indexes and analyzing execution plans.
The training also covers table expressions, ranking functions and how to deal with partitioned tables.
Sedi e date
Luogo
Inizio del corso
Inizio del corso
Profilo del corso
Good SQL knowledge in Microsoft SQL Server 2008/2012 environment.
Opinioni
Materie
- Server
- Microsoft SQL Server
- SQL
Programma
Module 1. Query Tuning
- Tools for Query Tuning
- Cached Query Execution Plans
- Clearing the Cache
- Analyzing Execution Plans
- Hints
- Using the Database Engine Tuning Advisor
- Index Tuning
- Table and Index Structures
- Index Access Methods
- Indexing Strategies
- Writing Subqueries
- Using Table Expressions
- Using Ranking Functions
- Fundamental Join Types
- Join Algorithm
- Set Operations
- Using INTO with Set Operation
- Using the OVER Clause
- Different types of aggregations (Cumulative, Sliding and Year-To-Date)
- Pivoting and Unpivoting
- Setup Custom Aggregations
- Using GROUPING SETS Subclause
- CUBE and RULLUP Subclauses
- How to materialize Grouping Sets
- SELECT TOP
- Using the APPLY table operator
- TOP n at the Group Level
- Implementing Paging
- Inserting data with Enhanced VALUES Clause
- Using the BULK Rowset Provider
- Using INSERT EXEC
- The Sequence Mechanisms
- DELETE with joins
- UPDATE with joins
- MERGE statement
- The OUTPUT Clause with INSERT
- The OUTPUT Clause with DELETE
- The OUTPUT Clause with UPDATE
- The OUTPUT Clause with MERGE
- Partitioning in SQL Server
- How to write queries on partitioned tables
- How to write queries on partitioned views
Hai bisogno di un coach per la formazione?
Ti aiuterà a confrontare vari corsi e trovare l'offerta formativa più conveniente.
Microsoft SQL Server 2008/2012 (MSSQL)