MS SQL DBA Training – Online SQL Server DBA Training

Advanced MSSQL Training Course for Professionals

MS SQL DBATraining

The MS SQL DBA Training Course is designed for professionals with at least 3 Years of working experience as MSSQL DBA.

Part 1. Database and Table Partitions

Session 1. Creating Data Types, Tables and partitioned tables

  • Database partitions
  • Manage data partitions
  • Types of partitioning,
  • Partition Function & Schema
  • Switching data from one partition to another
  • Create new data types.
  • Create new tables.
  • Create partitioned tables.

Part 2 Indexing

Session 2. Introduction to Indexing

  • Core Indexing Concepts
  • Single Column and Composite Indexes
  • SQL Server Table Structures
  • Working with Clustered Indexes
  • Creating Tables with Clustered Indexes
  • Improving Performance through Nonclustered Indexes

Session 3. Advanced Indexing

  • Execution Plan Core Concepts
  • Common Execution Plan Elements
  • Working with Execution Plans
  • Designing Effective Nonclustered Indexes
  • Performance Monitoring
  • Exploring Existing Index Statistics
  • Creating Covering Indexes
  • Columnstore Indexes
  • Partitioned indexes

Part 3. Performance Tuning

Session 4. SQL Server Performance Tuning

  • Checking index fragmentation and maintaining them
  • SQL Server Database statistics
  • SQL Server Profiler
  • SQL Server traces

Session 5. Memory use

  • Dynamic memory allocation
  • Memory consumers
  • Monitoring memory consumption

Session 6. Data types and tables

  • Importance of data type selection
  • Storage cost
  • Variable versus fixed length
  • Implicit and explicit data type conversions

Part 4 Query optimization and execution plans

Session 7. Statistics

  • Heaps
  • Monitoring allocation units
  • Delayed durability
  • In-memory OLTP
  • Execution context
  • Execution plans
  • Plan cache and plan reuse
  • Plan recompilation
  • Parameterization
  • Query store

Session 8. Query tuning

  • Query plan operators
  • How to measure query cost
  • Common query tuning techniques
  • Optimizing Indexes
November 14, 2018

0 responses on "MS SQL DBA Training - Online SQL Server DBA Training"

Leave a Message

Featured Testimonial

I recommend The Skill Pedia to all those who are looking for a career in Information Technology as Linux Administrator. Trust me, you won't need a certificate after the training, though that would be an added advantage.Read more

Michael John

Certified Engineer

Popular Courses

About The SkillPedia

The Skill Pedia is a platform for online training. It offers great learning experience for learners by offering features such as Interactive Videos, Interaction with Trainer, Assignments, Rich Audio Visuals and Handouts.

The Course Completion Certificate generated automatically based on your performance after the course is complete is an edge.

For Trainers, it is a platform for sharing your Skills which may be in the form of videos, slides, handouts, e-books or even consulting and get up to 85% of the fee you decide for the course.

The Skill Pedia - Learn or Teach a Skill

TheSkillPedia Tweets

top
WhatsApp chat

SPECIAL OFFER!

This Offer is Limited!  Avail 50% Discount on all Courses!

You have successfully subscribed to the newsletter

There was an error while trying to send your request. Please try again.

The Skill Pedia will use the information you provide on this form to be in touch with you and to provide updates and marketing.
X