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

Home

Courses

Microsoft SQL Server Training

SQL Server 2014 Performance Tuning and Optimisation 55144BC Training

Poole

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 Poole 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.

Poole is located within the county of Dorset with a population of around 140,000 inhabitants. The city is east of Dorchester and Bournemouth. The city used to been known as a port for transporting exports of the wool trade. Poole has been given a certificate of a Blue flag beach, which indicates the beach is clean and safe. Its natural history harbour is a huge tourist attraction as well as the lighthouse arts centre. There is a rate of around 4.3% unemployed people living within Poole.

The Arts University Bournemouth has its main campus within Poole, concentrating on performance, design, art and media. The university has around, 2,800 undergraduates and 74 post graduates. The college also offers short programmes for 16 year olds, Saturday art school for 9 to 18 year olds and summer courses.

Nearby Locations include:

Waterloo
Sandbanks
Sandford Holiday Park
Beacon Hill
Upton
Lytchett Minster
Hamworthy
Oakdale
Canford Cliffs
Lytchett Matravers
Parkstone
Branksome
Canford Heath
Holton Heath
Branksome Park
Nuffield Industrial Estate
Southbanks
Organford
Holton Heath Trading Park
East Holton

Address

Poole

T: 01344203999

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 Poole. 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 Poole, 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

Experience the most sought-after learning style with The Knowledge Academy's Microsoft SQL Server Training | SQL Server 2014 Performance Tuning And Optimisation 55144BC Training in Poole. Available in 490+ locations across 190+ countries, our hand-picked Classroom venues offer an invaluable human touch. Immerse yourself in a comprehensive, interactive experience with our expert-led Microsoft SQL Server Training | SQL Server 2014 Performance Tuning And Optimisation 55144BC Training in Poole sessions.

Highly experienced trainers

Boost your skills with our expert trainers, boasting 10+ years of real-world experience, ensuring an engaging and informative training experience

State of the art training venues

We only use the highest standard of learning facilities to make sure your experience is as comfortable and distraction-free as possible

Small class sizes

Our Classroom courses with limited class sizes foster discussions and provide a personalised, interactive learning environment

Great value for money

Achieve certification without breaking the bank. Find a lower price elsewhere? We'll match it to guarantee you the best value

Learn more in our FAQs

Streamline large-scale training requirements with The Knowledge Academy's In-house/Onsite at your business premises. Experience expert-led classroom learning from the comfort of your workplace and engage professional development.

Tailored learning experience

Leverage benefits offered from a certification that fits your unique business or project needs

Maximise your training budget

Cut unnecessary costs and focus your entire budget on what really matters, the training.

Team building opportunity

Our offers a unique chance for your team to bond and engage in discussions, enriching the learning experience beyond traditional classroom settings

Monitor employees progress

The course know-how will help you track and evaluate your employees' progression and performance with relative ease

Learn more in our FAQs

What our customers are saying

Microsoft SQL Server Training | SQL Server 2014 Performance Tuning And Optimisation 55144BC Training in Poole 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 Poole over others?

The Knowledge Academy in Poole 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 Poole?

The training fees for SQL Server 2014 Performance Tuning and Optimisation 55144BC Trainingin Poole starts from £3295

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

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 Poole?

Please see our Microsoft SQL Server Training courses available in Poole

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 01344203999 and speak to our training experts, we should be able to help you with your requirements.

Book now