E-1712510
Querying Microsoft SQL Server 2014 haladó • E-learning
Tananyag hossza
3 óra 56 perc
Elérhető képzési nyelvek
- Magyar
Képzési forma
Személyre szabott ajánlatot szeretnél?
Kollégáink készséggel állnak rendelkezésedre, hogy segítsenek a neked megfelelő megoldás kialakításában.Tematika
Module 0: Querying Microsoft SQL Server 2014 - Overview
- Overview: Querying Microsoft SQL Server 2014 - Overview
Module 11: Using Table Expressions
- Overview: Using Table Expressions
- Lesson 1: Using Views
- Lesson 2: Using Inline TVFs
- Lesson 3: Using Derived Tables
- Lesson 4: Using CTEs
- Lab 11: Using Table Expressions
Module 12: Using Set Operators
- Overview: Using Set Operators
- Lesson 1: Writing Queries with the UNION Operator
- Lesson 2: Using EXCEPT and INTERSECT
- Lesson 3: Using APPLY
- Lab 12: Using Set Operators
Module 13: Using Window Ranking, Offset, and Aggregate Functions
- Overview: Using Window Ranking, Offset, and Aggregate Functions
- Lesson 1: Creating Windows with OVER
- Lesson 2: Exploring Window Functions
- Lab 13: Using Window Ranking, Offset, and Aggregate Functions
Module 14: Pivoting and Grouping Sets
- Overview: Pivoting and Grouping Sets
- Lesson 1: Writing Queries with PIVOT and UNPIVOT
- Lesson 2: Working with Grouping Sets
- Lab 14: Pivoting and Grouping Sets
Module 15: Executing Stored Procedures
- Overview: Executing Stored Procedures
- Lesson 1: Querying Data with Stored Procedures
- Lesson 2: Passing Parameters to Stored Procedures
- Lesson 3: Creating Simple Stored Procedures
- Lesson 4: Working with Dynamic SQL
- Lab 15: Executing Stored Procedures
Module 16: Programming with T-SQL
- Overview: Programming with T-SQL
- Lesson 2: Controlling Program Flow
- Lab 16: Programming with T-SQL
Module 17: Implementing Error Handling
- Overview: Implementing Error Handling
- Lesson 1: Implementing T-SQL Error Handling
- Lesson 2: Implementing Structured Exception Handling
- Lab 17: Implementing Error Handling
Module 18: Implementing Transactions
- Overview: Implementing Transactions
- Lesson 1: Transactions and the Database Engine
- Lesson 2: Controlling Transactions
- Lab 18: Implementing Transactions
Appendix A: Improving Query Performance
- Overview: Improving Query Performance
- Lesson 1: Factors in Query Performance
- Lab 19: Improving Query Performance
Appendix B: Querying SQL Server Metadata
- Overview: Querying SQL Server Metadata
- Lesson 1: Querying System Catalog Views and Functions
- Lesson 3: Querying Dynamic Management Objects
- Lesson 2: Executing System Stored Procedures
- Lab 20: Querying SQL Server Metadata