- Type Learning
- Level Advanced
- Time Days
- Cost Paid
SQLskills IETS - SQL Server 2012
Issued by
SQLskills
This badge shows attendance of the SQLskills Immersion Event on Advanced Transact-SQL. IETS covers how to properly phrase SQL queries and use the right T-SQL constructs and data types for best performance, enforced by viewing and comparing query plans. You’ll also learn best practices to solve problems in your own application, including data modification statements, summarization, windowing, and complex problem solving with hierarchies and entity attribute values.
- Type Learning
- Level Advanced
- Time Days
- Cost Paid
Skills
- CASE Expressions
- Data Types In SQL Server
- Derived Tables
- EAV Design Patterns
- Hierarchical Data
- Joins
- Optimizing Stored Procedures
- Optimizing Transactions
- Optimizing User-defined Functions
- Reading Query Plans
- SQL Server Database Structures
- SQL Server Internals
- Subqueries
- Summarization And Analysis
- Writing Effective Queries