Microsoft SQL Server Training | SQL Server 2014 Performance Tuning And Optimisation 55144BC Training in Hong Kong

Home

Courses

Microsoft SQL Server Training

SQL Server 2014 Performance Tuning and Optimisation 55144BC Training

Hong Kong

Learn about the SQL 2014 architecture and its features for enhanced performance.
Attain in-depth knowledge of the database engine, transactions, and concurrency.
Understand SQL performance tools for effective monitoring and troubleshooting.

Dates & Prices Dates & Prices

Course information

SQL Server 2014 Performance Tuning and Optimisation 55144BC Training Course Outline

Module 1: SQL 2014 Architecture

New Cardinality Estimator
Memory-Optimised Tables
Understanding Performance for Developers
Understanding Start-up Parameters
Start-up Stored Procedures
Database Structures
Instant File Initialisation
How SQL Stores Data?
How SQL Locates Data?

Lab: SQL 2014 Architecture

Configuring Compatibility Level
Start-up Parameter
Start-up Stored Procedure
Instant File Initialisation

Module 2: Database Engine

Four Important Concepts
Temporary Tables Internals
Concurrency
Transactions
Isolation Levels
SQL Server Locking Architecture
SQL and Storage Area Networks (SAN)
SQL on VMs
SQLIO Utility
Partitioned Tables and Indexes

Lab: Database Engine

Table-Valued Parameter
Transactions
Vertically Partitioned Table Using Code
Partitioning with Filegroups
Partitioning Wizard

Module 3: SQL Performance Tools

Resource Governor
Activity Monitor
Live Query Statistics
Monitoring SQL with Transact-SQL
Dynamic Management Objects (DMOs) and Performance Tuning

Lab: SQL Performance Tools

Resource Governor
Activity Monitor
sp_who2
Performance DMVs

Module 4: Query Optimising and Operators

Tuning Process
Performance Monitor Tool
SQL Query Processing Steps
Understanding Execution Plans
SET STATISTICS TIME and SET STATISTICS IO
Data Access Operators
Troubleshooting Queries

Lab: Query Optimising and Operators

Performance Monitor (perfmon)
Estimated vs Actual Plans and XML Plans
Viewing a Non-Trivial Execution Plan
SET STATISTICS TIME and SET STATISTICS IO
Data Access Operators
DMVs
View Information About Extended Events
Wizard Templates
Creating a Session Without a Wizard
Configuring MDW and Viewing Reports

Module 5: Understanding Indexes

Introduction to Indexes
Index Types by Storage
Index Types by Column Designation
Creating and Altering Indexes
Metadata
Data Management Views for Indexing
Database Engine Tuning Advisor
Index Data Management Objects
SQL Server Fragmentation
Patterns
Index Storage Strategies
Indexed Views
Monitoring Indexes
Index Dynamic Management Objects (DMOs)

Lab: Understanding Indexes

Create Indexes
Index Metadata
Database Tuning Advisor
Missing Index DMOs
Fragmentation and Page Splits
Data Compression
Indexed Views
DMO Index Stats

Module 6: Understanding Statistics

Statistics
Cardinality Estimator
Incremental Statistics
Computed Columns Statistics
Filtered Statistics
Maintenance

Lab: Understanding Statistics

Statistics Objects
Histogram
New Vs Old Cardinality Estimator
Incremental Statistics
Computed Columns
Filtered Statistics
Ascending Keys
Statistics Maintenance Plan

Module 7: In-Memory Database

Architecture
Tables and Indexes
Natively Compiled Stored Procedures
Restrictions
Analyse Migrate Report Tool
In-Memory Data Management Views (DMV)

Lab: In-Memory Database

Creating an In-Memory Enabled Database with Code and SSMS
Creating a Memory-Optimised Table
View Hash Index
Natively Compiled Stored Procedure
AMR Tool
In-Memory DMVs

Module 8: SQL Profiler and SQL Trace

SQL Trace
SQL Trace Architecture
SQL Server Profiler

Lab: SQL Profiler and SQL Trace

SQL Trace Default Template
SQL Profiler Tuning Template
Create a Template for Slow Running Queries
Identifying Long Running Queries
Using Profiler to Detect Deadlocks
Use Profiler to Detect a Blocked Process

Module 9: Query Issues and Hints

Query Hints
Plan Guides
Plan To Freeze
Join Orders

Lab: Query Issues and Hints

Create and Test a Plan Guide
Allow SQL Profiler to Help Create a Plan
Plan To Freeze

Who should attend this SQL Server 2014 Performance Tuning and Optimisation 55144BC Training?

The SQL Server 2014 Performance Tuning and Optimisation 55144BC Course is intended for database professionals and IT personnel responsible for managing and maintaining SQL Server 2014 databases. This course is particularly suitable for:

Database Administrators
SQL Server Developers
Systems Administrators
Database Analysts
IT Managers
Database Architects
Application Developers

Prerequisites of the SQL Server 2014 Performance Tuning and Optimisation 55144BC Training

There are no formal prerequisites for attending SQL Server 2014 Performance Tuning and Optimisation 55144BC Course.

SQL Server 2014 Performance Tuning and Optimisation 55144BC Training Course Overview

The SQL Server 2014 Performance Tuning and Optimisation 55144BC Course provides an in-depth understanding of performance tuning and optimisation techniques crucial for managing SQL Server environments efficiently. This course is designed to equip participants with the skills necessary to enhance database performance, ensuring robust and reliable database systems.

Proficiency in SQL Server performance tuning is essential for Database Administrators, Developers, and IT Professionals who manage SQL Server databases. Mastering these skills is vital for optimising query performance, reducing server load, and ensuring high availability and scalability of database applications. Professionals in these roles should aim to develop expertise in SQL Server performance tuning to maintain efficient database systems.

This comprehensive 4-day training course will empower delegates with the knowledge and practical skills needed to identify and resolve performance issues in SQL Server 2014. Through hands-on exercises and expert-led discussions, participants will learn to apply best practices and advanced techniques to optimise SQL Server performance, leading to improved system efficiency and productivity.

Course Objectives

To understand the fundamentals of SQL Server performance tuning and optimisation
To identify and analyse performance bottlenecks in SQL Server 2014
To implement indexing strategies to enhance query performance
To utilise SQL Server Profiler and Extended Events for monitoring
To apply best practices for SQL Server configuration and maintenance
To optimise SQL Server memory and CPU usage

After completing this course, delegates will be able to effectively tune and optimise SQL Server 2014 for enhanced performance and efficiency, ensuring high availability and scalability of database applications, leading to improved overall system performance and reliability.

What's Included in this SQL Server 2014 Performance Tuning and Optimisation 55144BC Training?

World-Class Training Sessions from Experienced Instructors
SQL Server 2014 Performance Tuning and Optimisation 55144BC Certificate
Digital Delegate Pack

Why choose us

Our Hong Kong venue

Includes..

Free Wi-Fi

To make sure you’re always connected we offer completely free and easy to access wi-fi.

Air conditioned

To keep you comfortable during your course we offer a fully air conditioned environment.

Full IT support

IT support is on hand to sort out any unforseen issues that may arise.

Video equipment

This location has full video conferencing equipment.

Hong Kong is an autonomous territory of the People’s Republic of China and can be located on the southern coast of China. Hong Kong has a population of around 7 million people. The education system in Hong Kong is mostly based around the English system and it is overseen by the Education Bureau and the Social Welfare Department. One of the earliest schools in Hong Kong was Li Ying College established in 1075. The education level begins with preschool education that is payable education, paid by pupil’s parents. The primary and secondary education is mandatory for every child in Hong Kong to attend from the age of 6 to 18. Higher education remains exclusive in Hong Kong and adult education is a growing sector in Hong Kong, with two non-profit school running evening courses. The University of Hong Kong was founded in 1911 and is the oldest tertiary (higher education) institution in Hong Kong and is organised into 10 academic faculties with English as the main language of instruction. The Education Bureau in Hong Kong also provides educational services for immigrant children from mainland China and other countries. Hong Kong also has 175 internal schools.

Address

62/F & 66/F
The Center
99 Queens Road
Central
Hong Kong

T: +852 2592 5349

Ways to take this course

Experience live, interactive learning from home with The Knowledge Academy's Online Instructor-led Microsoft SQL Server Training | SQL Server 2014 Performance Tuning And Optimisation 55144BC Training in Hong Kong. Engage directly with expert instructors, mirroring the classroom schedule for a comprehensive learning journey. Enjoy the convenience of virtual learning without compromising on the quality of interaction.

Learn more in our FAQs

Unlock your potential with The Knowledge Academy's Microsoft SQL Server Training | SQL Server 2014 Performance Tuning And Optimisation 55144BC Training in Hong Kong, accessible anytime, anywhere on any device. Enjoy 90 days of online course access, extendable upon request, and benefit from the support of our expert trainers. Elevate your skills at your own pace with our Online Self-paced sessions.

Learn more in our FAQs

What our customers are saying

Microsoft SQL Server Training | SQL Server 2014 Performance Tuning And Optimisation 55144BC Training in Hong Kong FAQs

What is SQL Server Performance Tuning?

SQL Server Performance Tuning involves optimising SQL queries, databases, and server configurations to enhance system efficiency, reduce response time, and ensure smooth database operations. It focuses on improving performance metrics through adjustments in indexing, queries, and server resources.

What is the significance of the 55144BC code in the course title?

The 55144BC code refers to the official Microsoft course code for this SQL Server 2014 Performance Tuning and Optimisation Training. It helps identify this specific course within Microsoft's catalogue of training modules.

What are the common techniques for troubleshooting SQL Server 2014 performance issues?

Common techniques include analysing query execution plans, optimising indexes, monitoring resource bottlenecks, tuning memory usage, and using performance monitoring tools to identify areas that affect SQL Server performance.

Do you offer 24/7 support for the SQL Server 2014 Performance Tuning and Optimisation Training?

Yes, 24/7 support is available throughout this SQL Server 2014 Performance Tuning and Optimisation Course. Delegates can access help for any technical issues, queries regarding course materials, or assistance with accessing the training platform at any time.

What is the duration of this course?

The SQL Server 2014 Performance Tuning and Optimisation Course spans across 4 days. For self-paced courses, the duration may vary based on the delegate's schedule, allowing flexibility to complete the training at their own pace.

What will I learn in this SQL Server 2014 Performance Tuning and Optimisation 55144BC Training Course?

You will learn key performance tuning strategies, how to troubleshoot bottlenecks, optimise queries and indexing, improve database design, and monitor SQL Server performance for better resource management from this SQL Server 2014 Performance Tuning and Optimisation 55144BC Course.

What is the focus of the SQL Server 2014 Performance Tuning and Optimisation 55144BC Training?

The SQL Server 2014 Performance Tuning and Optimisation 55144BC Course focuses on improving database performance by tuning SQL queries, indexes, memory, and disk usage, as well as troubleshooting performance issues using advanced diagnostic tools.

What prerequisites are needed for the SQL Server 55144BC Training?

There are no formal prerequisites for attending SQL Server 2014 Performance Tuning and Optimisation 55144BC Course. However, a basic knowledge of SQL Server administration, experience writing SQL queries, and a fundamental understanding of database structures and performance management will be beneficial.

What certification or credits do delegates receive after completing the course?

Upon successful completion of this SQL Server 55144BC Training, delegates will receive a certificate of completion and may earn continuing education credits (CEUs) toward professional certifications, depending on the provider.

Will this training cover both performance tuning and troubleshooting in SQL Server 2014?

Yes, the SQL Server 55144BC Training covers both performance tuning and troubleshooting, equipping delegates with the knowledge to identify, analyse, and resolve performance bottlenecks in SQL Server 2014.

Is the course relevant for those working with later versions of SQL Server, such as 2016 or 2019?

While the SQL Server 2014 Performance Tuning and Optimisation 55144BC Course focuses on SQL Server 2014, many of the performance tuning and troubleshooting techniques are applicable to later versions like SQL Server 2016 and 2019.

Who should attend this SQL Server 55144BC Course?

Database Administrators, SQL Developers, IT Professionals responsible for managing SQL Server databases, and anyone interested in improving their SQL Server performance skills should attend this SQL Server 2014 Performance Tuning and Optimisation 55144BC Course.

Do I need any prior qualifications to undertake this training course?

While no formal qualifications are required, a solid understanding of SQL Server fundamentals and experience with SQL queries are recommended to fully benefit from the SQL Server 2014 Performance Tuning and Optimisation 55144BC Course.

What are the career prospects after completing this 55144BC SQL Server 2014 Performance Tuning and Optimisation Training?

This training can lead to roles such as SQL Server Database Administrator, Database Performance Analyst, SQL Developer, or Database Consultant, with an increased focus on performance tuning and optimisation.

What is included in this training?

The SQL Server 2014 Performance Tuning and Optimisation 55144BC Training includes instructor-led sessions, practical exercises, course materials, access to SQL Server performance tools, and preparation for real-world troubleshooting and optimisation scenarios.

Do you provide self-paced SQL Server 2014 Performance Tuning and Optimisation Online Training?

Yes, self-paced training options are available for this SQL Server 55144BC Certification Course, allowing delegates to complete the course at their own pace. This is ideal for individuals with busy schedules who prefer flexible learning.

Do you provide corporate training for this 55144BC SQL Server 2014 Performance Tuning and Optimisation Online Course?

Yes, corporate training is available for this SQL Server 55144BC Certification Course, which can be customised to address the specific needs and performance goals of an organisation’s SQL Server environment.

Who should I contact if I am unable to access my training online?

If you are unable to access your SQL Server 2014 Performance Tuning and Optimisation Training Course, you should contact The Knowledge Academy’s customer support team. They can help troubleshoot technical issues and provide alternative access to the course materials.

Are there any difficulty levels for this SQL Server 2014 Performance Tuning Training?

The SQL Server 2014 Performance Tuning Course is designed for intermediate to advanced learners who have prior experience with SQL Server. It assumes a basic understanding of database management and SQL queries.

Will I receive a certification upon completing the SQL Server 2014 Performance Tuning and Optimisation 55144BC Training?

Yes, upon completing this SQL Server 2014 Performance Tuning and Optimisation Course, you will receive a certificate of completion that demonstrates your proficiency in SQL Server 2014 performance tuning and optimisation.

Is there a difference between SQL Tuning Training & SQL Optimisation Training?

SQL Tuning focuses on improving the efficiency of SQL queries, while SQL Optimisation is a broader process that involves tuning the overall system, including database design, indexing, memory, and server configurations to improve performance.

Why choose The Knowledge Academy in Hong Kong over others?

The Knowledge Academy in Hong Kong offers globally recognised courses, expert trainers, flexible learning formats (online, in-person, and self-paced), and 24/7 support. This SQL Server 2014 Performance Tuning and Optimisation 55144BC Training Course provides a comprehensive learning experience, preparing you for practical application in your career.

What is the cost/training fees for SQL Server 2014 Performance Tuning and Optimisation 55144BC Training in Hong Kong?

The training fees for SQL Server 2014 Performance Tuning and Optimisation 55144BC Trainingin Hong Kong starts from HKD26995

Which is the best training institute/provider of SQL Server 2014 Performance Tuning and Optimisation 55144BC Training in Hong Kong?

The Knowledge Academy is the Leading global training provider for SQL Server 2014 Performance Tuning and Optimisation 55144BC Training.

What are the best Microsoft SQL Server Training courses in Hong Kong?

Please see our Microsoft SQL Server Training courses available in Hong Kong

Why choose us

Best price in the industry

You won't find better value in the marketplace. If you do find a lower price, we will beat it.

Trusted & Approved

Microsoft Gold Learning Partner

Many delivery methods

Flexible delivery methods are available depending on your learning style.

High quality resources

Resources are included for a comprehensive learning experience.

"Really good course and well organised. Trainer was great with a sense of humour - his experience allowed a free flowing course, structured to help you gain as much information & relevant experience whilst helping prepare you for the exam"

Joshua Davies, Thames Water

Looking for more information on Microsoft SQL Server Training?

Back to course information

Upcoming classes
Package deals

Get a custom course package

We may not have any package deals available including this course. If you enquire or give us a call on +852 2592 5349 and speak to our training experts, we should be able to help you with your requirements.

Book now