TRAINING SQL SERVER DATABASE PERFORMANCE TUNNING

SQL Server Database Performance Tunning

Syllabus Overview

Melalui Training ini peserta akan  mampu memahami cara memaksimalkan kinerja SQL Server dari berbagai aspek dan fitur yang ada di Microsoft SQL Server

Class Type : Workshop

Duration : 3 Days (09.00 – 17.00)

Venue  & Price : Click Here ,

Registration : Click Here  (Save up to 20% for Early Bird Registration !)

Description :

SQL Server : Performance Tuning - Design, Internals, & Architecture  dimana training ini membahas lebih jauh tentang aspek SQL Server yang mempengaruhi Application performance. Mempelajari tentang SQL Server Engine seperti Memory Manager dan Task Scheduler, Table dan Index Structure, Locking dan Concurency , Query Optimization dan Programming Efficiency.

Topics Include :

Day 1: Architecture This lesson provides an overview of SQL Server engine internals such as memory management, I/O basics, process scheduling and synchronization with particular focus on performance tuning.

Day 2: Table & Index Structure This lesson takes an in-depth look into the underlying structure of database files, tables and indexes and how they affect performance. Students will come away with the knowledge they need to design databases and implement efficient indexing strategies.

Day 3: Locking & Concurrency This lesson looks into how SQL Server handles concurrency behind-the-scenes. Students will learn the basic concepts of locking, the various isolation levels of SQL Server, how different isolation levels affect concurrency, and the effects of concurrency issues – as well as how to identify and resolve them.  Query Optimization This lesson provides in-depth information for understanding the end results of query optimization and execution plan creation in SQL Server.

Participants :  (Database Administrator. Application Developer, Data Analyst, Software Quatlity Asurance,  , Software Tester, Public)

Speaker  : Purnama Academy Trainer

#sqlservertunning  #performancetunning #sqlservertraining #pelatihan #jakarta  #bandung  #bali  #jadwaltraining #pelatihanIT

Categories: bali, bandung, database, jakarta, SQL Server performance tuning, SQL server training, training