MS SQL DBA Training - Online SQL Server DBA Training

Published time : 14/11/2018 12:08

MS SQL DBA Training - Online SQL Server DBA Training

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

(4.45)

19 Courses

194 Students

2901 Reviews

Ram Niwas Sangwan

I have spent 27 years in IT Industry as an Educationist. I have been a software developer/corporate trainer and an information systems specialist with a record of developing and supporting solutions incorporating a wide range of applications. I have an entrepreneurial-mindset and a track record of success in recognizing opportunities spanning more than 26 years. Developing innovative and creative approaches, I have trained top level executives of companies driving revenue growth and enhancing long-term profitability. I have been motivating my team to ensure project success and on-time delivery. I, have time and again proven my ability at managing multiple priorities in fast-paced environments.
Businessman Leading a team of Professionals in the Area of Digital Marketing, Website Design and Development, Software Development with more than 1200 Satisfied Client. Currently I am managing My Own Production Servers with more than 500 Live Websites and Launching my Dream Project www.theskillpedia.com after working on for more than 4 Years.