+Using Derived Tables
+Using Common Table Expressions
+Using Views
+Using Inline Table-Valued Functions
+Lab : Using Table Expressions
SQL SERVER EĞİTİMLERİ
+Using Derived Tables
+Using Common Table Expressions
+Using Views
+Using Inline Table-Valued Functions
+Lab : Using Table Expressions
+Creating Windows with OVER
+Exploring Window Functions
+Lab : Using Window Ranking, Offset and Aggregate Functions
+Using PARTITION BY Option
+Writing Moving Average and Cumulative Totals with T-SQL
+Writing Queries with PIVOT and UNPIVOT
+Working with Grouping Sets
+Lab : Pivoting and Grouping Sets
+Using GROUP BY CUBE
+Using GROUP BY ROLLUP
+Transactions and the Database Engine
+Controlling Transactions
+Isolation Levels
+Lab : Implementing Transactions
+Locking Mechanism and Deadlocks
+Enforcing Data Integrity
+Implementing Domain Integrity
+Implementing Entity and Referential Integrity
+Lab : Ensuring Data Integrity through Constraints
+Primary Key and Foreign Key Constraints
+Unique and Check Constraints
+Default Constraint
+Querying with Cross Joins and Self Joins
+Writing Queries That Filter Data
+Using the OFFSET-FETCH Clause
+Using MERGE Command
+Useful Built-in Functions
+Write queries which use CROSS
+APPLY and OUTER APPLY operators
+Using the T-SQL FOR XML Statement
+The Performance-Tuning Process
+The Performance Baseline
+Where to Focus Efforts in Tuning
+SQL Server Query Life Cycle
+What an Index Is
+The Benefits and Overhead of an Index
+General Recommendation for Index Design
+Clustered and Non-Clustered Index Behavior and Comparison
+Advanced Indexing Techniques
+Manage Very Large Indexes
+Special Index Types
+Introduction to Execution Plan Generation and Caching
+Execution Plan General Operators
+Execution Plan Join Operators
+Execution Plan Spool and Paralelizm Operators
+Controlling Execution Plan With Query and Table Hints
+Parameter Sniffing Scenarios
+The role of Statistics in Query Optimization
+The importance of Statistics on Columns with Indexes
+The Computation of Selectivity of a Column for Indexing
+Statistics Maintenance
+Aspects of Query design that affect performance
+How query design use indexes effectively
+The role of optimizer hints on query performance
+The role of database constraints on query performance
+Techniques to reduce the Transaction cost of a query
WhatsApp İletişim