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
Comments
Post a Comment
Terima kasih telah mengunjungi halaman website kami, Jika ada pertanyaan terkait informasi di Atas silahkan isi Comment Box di bawah ini, Tim kami akan merespon komentar/ pertanyaan Anda paling lambat 2 x 24 Jam
Untuk respon cepat silahkan hubungi 0838-0838-0001 (Call/Whatsapp)
Regards,
Management,
www.purnamaacademy.com