E-verified  +1 (720) 463-3800 

 

SQL Server Tuning Online Training

 

SQL Server Tuning Online Training Course Content


SQL Server Performance & Tuning Course Content
Performance & Tuning
Sizing & Planning
Monitoring Performance
Analyzing Performance Data
Tuning & Optimising Performance
SQL Server Internals
Windows & SQL Server Architecture
Process & Thread management
Memory Use & Management
I/O Management
Networking
SQL Server Architecture
Data Storage
Transaction Logging
Locking
Indexing
OLTP databases
Data Warehouses
Planning A SQL Server Database Application
Capacity Planning
Sizing Databases
Sizing Servers
System Performance & Tuning
Hardware Resource Tuning
I/O Performance
Database Layout
SQL Server Configuration Options
Monitoring Tools
Performance Monitor
SQL Profiler
DBCC
Optimal Database Design
Database Design
Table Design
Indexes
OLTP databases
Data Warehouses
Index Optimisation
Index Types
Covering Indexes
Index Strategies
Locking
Lock Types
Locking & Granularity
Blocking
Locking & Transactions
Transaction Isolation Levels
Transaction Design
Analysing Locks
Query Optimisation
Query Optimiser
Recompilation
Query Cache
Query Types
Range
Ordering
Grouping
Table joins & Join Algorithms
Analyzing Queries
Query Analyser & Execution Plans
SHOWPLAN
Graphical
Index Statistics
Index Tuning Wizard
Tuning SQL Statements
Comparing Queries
Avoiding Subqueries
Table Hints
Database Application Tuning
Using Stored Procedures & User Defined Functions
Views
Partitioning Data
Derived Data
Minimising Redundant Data With Triggers
Optimising Transactions
Optimising Cursors
Tuning SQL Server Services & Tasks
Replication Services
DTS Packages
Backup & Recovery