For Online Training Aspirants (With Placement)

Name :

Email :

Phone :

Message :


Courses

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

 

FAQ
© Copyright 2013 Tectist., All rights reserved