Advanced T-SQL Querying, Programming and Tuning for SQL ServerSQTSQLFLFast LaneFL-SQTSQL1.0<p>Für die Teilnahme an diesem Kurs ist es empfehlenswert mindestens ein Jahr T-SQL-Abfrage-und Programmiererfahrung in Bereich SQL Server zu besitzen</p><p>Dieser Kurs ist für:</p>
<p>T-SQL Programmierer, DBAs, Architects & Analysten und jene Personen, die bei SQL Server 2005, 2008 und 2012 T-SQL Code schreiben oder überprüfen müssen.</p><h5>Logic Query Processing </h5><ul>
<li>Logical Query Processing Order</li><li>Logical Query Processing Example</li><li>Phase Details</li><li>Set Operations</li></ul><h5>Query Tuning </h5><ul>
<li>Internals and Index Tuning</li><li>Temporary Tables</li><li>Set vs. Cursors</li><li>Query Tuning with Query Revisions</li></ul><h5>Multi-Table Queries, Ranking and Offset Functions</h5><ul>
<li>Subqueries and Table Expressions</li><li>Window Ranking and Offset Functions</li><li>Joins</li><li>Set Operatiors</li></ul>
<h5>Aggregating and Pivoting Data</h5><ul>
<li>Window Aggregate Functions</li><li>Pivoting and Unpivoting Data</li><li>Custom Aggregations</li><li>Grouping Sets</li></ul><h5>TOP, OFFSET-FETCH and APPLY </h5><ul>
<li>TOP and OFFSET-FETCH</li><li>APPLY</li></ul><h5>Data Modification </h5><ul>
<li>Inserting Data</li><li>Sequences</li><li>Deleting Data</li><li>Updating Data</li><li>Merging Data</li><li>The OUTPUT Clause</li></ul><h5>Working with Date and Time </h5><ul>
<li>Date and Time Datatypes</li><li>Date and Time Functions</li><li>Date and Time Challenges</li><li>Date amd Time Querying Problems</li></ul><h5>Programmable Objects </h5><ul>
<li>Dynamic SQL</li><li>Views and Inline Table Functions</li><li>User Defined Functions</li><li>Stored Procedures</li><li>Triggers</li><li>Transactions and Concurrency</li><li>Exception Handling</li></ul><h5>Graphs, Trees and Hierarchies</h5><ul>
<li>Graphs, Described</li><li>Materialized Paths (Custom, Using the HIERARCHYID datatype)</li><li>Nested Sets</li><li>Nested Iterations (Loops, Recursive Queries)</li></ul>Für die Teilnahme an diesem Kurs ist es empfehlenswert mindestens ein Jahr T-SQL-Abfrage-und Programmiererfahrung in Bereich SQL Server zu besitzenDieser Kurs ist für:
T-SQL Programmierer, DBAs, Architects & Analysten und jene Personen, die bei SQL Server 2005, 2008 und 2012 T-SQL Code schreiben oder überprüfen müssen.Logic Query Processing
- Logical Query Processing Order
- Logical Query Processing Example
- Phase Details
- Set Operations
Query Tuning
- Internals and Index Tuning
- Temporary Tables
- Set vs. Cursors
- Query Tuning with Query Revisions
Multi-Table Queries, Ranking and Offset Functions
- Subqueries and Table Expressions
- Window Ranking and Offset Functions
- Joins
- Set Operatiors
Aggregating and Pivoting Data
- Window Aggregate Functions
- Pivoting and Unpivoting Data
- Custom Aggregations
- Grouping Sets
TOP, OFFSET-FETCH and APPLY
- TOP and OFFSET-FETCH
- APPLY
Data Modification
- Inserting Data
- Sequences
- Deleting Data
- Updating Data
- Merging Data
- The OUTPUT Clause
Working with Date and Time
- Date and Time Datatypes
- Date and Time Functions
- Date and Time Challenges
- Date amd Time Querying Problems
Programmable Objects
- Dynamic SQL
- Views and Inline Table Functions
- User Defined Functions
- Stored Procedures
- Triggers
- Transactions and Concurrency
- Exception Handling
Graphs, Trees and Hierarchies
- Graphs, Described
- Materialized Paths (Custom, Using the HIERARCHYID datatype)
- Nested Sets
- Nested Iterations (Loops, Recursive Queries)5 Tage2850.002850.009890.002850.00