IT Online Training and Placements in USA.

Databases Online Training

SQL Server Tuning, Oracle DBA, Oracle forms and Reports.

 

Courses » Database Courses » SQL Server Tuning Online Training

 

SQL Server Tuning Online Training

 

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