EventsIT  SQL Server 2012 Performance Tuning

SQL Server 2012 Performance Tuning

Senin - Kamis, 14 - 17 Mei 2018, pukul 09:00 - 16:30 WIB
Hotel di Jakarta Selatan, Jakarta
Bonus : Souvenir dan Flashdisk


Description

The SQL Server 2012: Performance Tuning - Design, Internals, & Architecture berdurasi 4 hari training 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.

Goals

Peserta mampu memahami cara memaksimalkan kinerja SQL Server dari berbagai aspek dan fitur yang ada di SQL Server

Participants

- Database Developer
- System Developer
- DBA

Prerequisites

SQL Server DBA fundamental

Details

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.

Day 4: Query Optimization
This lesson provides in-depth information for understanding the end results of query optimization and execution plan creation in SQL Server 2012. Students will learn how to understand query plans and identify queries that

Duration : 4 Days (24 hours)

per peserta : Rp 7.500.000,-
Facilities : Full AC Room with Proyektor/LCD, Lunch / day, 2x Coffee break / day, Certificate, Training Modules, Softcopy Module & Training Kit

Course Leader :

Silahkan login untuk mengirim komentar

List Komentar : 0

SQL Server 2012 Performance Tuning

Schedule
Events IT:

AutoCad 2011 Basic

Jakarta, 21 - 22 Juni 2018 93 clicks

Libre Office 4.0 - Impress

Jakarta, 22 Juni 2018 105 clicks

Basic Computer Networking

Bandung, 25 - 26 Juni 2018 108 clicks
Training Service
Public Training
Rose
rose@tds-solution.com
HP & WA : 0813 8201 2413

Sumi
sumi@tds-solution.com
HP & WA : 0812 1311 0749

Telp.:
021-78847514
021-78847549

Stats

indobokep borneowebhosting video bokep indonesia videongentot bokeper entotin bokepsmu videomesum bokepindonesia informasiku