Looking for Global training? Go to https://firebrand.training/en or stay on the current site (Suomi)
On this accelerated 1-day course, you'll gain the knowledge you need to update your SQL skills to SQL Server 2017 - 50% faster than traditional training.
Your expert Microsoft Certified Trainer (MCT), will guide you through new capabilities and components of SQL Server 2017
You'll also learn about new and enhanced features of:
You'll be immersed in the Microsoft Official Curriculum (MOC) through our unique Lecture | Lab | Review technique, which combines theory and practical skills to help you retain information faster.
If you're a database professional with experience of SQL server 2016, looking to update your skills to SQL Server 2017, this course is ideal for you.
This course also prepares existing SQL Server 2016 MCSAs who want to prepare for the Upgrade exam for the SQL Server 2017 certification.
Module Goal: Describe key capabilities and components of SQL Server 2017
Lessons
After completing this module, you'll be able to:
This module introduces the performance enhancements provided by Adaptive Query Processing and Automatic Tuning, as well as the scalability and availability enhancements provided by new Availability Group architectures, including Read-Scale Availability Groups and Availability Groups with SQL Server on Linux
Lessons
Lab: Performance and availability - adaptive query processing
After completing this module, you'll be able to:
SQL Server 2017 introduces SQL Graph which enables you to define the relationships between your data items in a table rather than calculating them during a query, reducing the query cost and simplifying your data structure.
Lessons
Lab: SQL Graph
After completing this module, you'll be able to:
This module describes what’s new in SQL Server reporting and BI.
Lessons
Lab: Reporting and BI
After completing this module, you'll be able to:
This module introduces new and enhanced features in SQL Server Analysis Services, with particular emphasis on the tabular data model.
Lessons
Lab: Ragged hierarchies
After completing this module, you'll be able to:
This module introduces new and enhanced data analytics features.
Lessons
Lab: Data analytics with Python
After completing this module, you'll be able to:
Organisations want the best value from a mixture of cloud services and their existing investment in on-premises hardware and software. This module covers a comparison between the features of Microsoft Azure SQL Database and Microsoft SQL Server 2017, as well as new features that make it easier for you to migrate databases from on-premises SQL Server instances to Azure SQL Database.
Lessons
Lab: Managed Instances
After completing this module, you'll be able to:
This module covers the features of SQL Server on Linux, as well as the process for deploying SQL Server on Linux and using Docker.
Lessons
Lab: SQL Server in Docker containers
After completing this module, you'll be able to:
You'll receive the following Microsoft Official Curriculum (MOC):
Your accelerated course includes:
Before attending this course, you should have experience with:
We interview all applicants for the course on their technical background, degrees and certifications held, and general suitability. If you get through this screening process, it means you stand a great chance of passing.
Firebrand Training is an immersive training environment. You must be committed to the course. The above prerequisites are guidelines, but many students with less experience have other background or traits that have enabled their success in accelerated training through Firebrand Training.
If you have any doubts as to whether you meet the pre-requisites please call 09 - 31 587 431 and speak to one of our enrolment consultants, who can help you with a training plan.
We've currently trained 134.561 students in 12 years. We asked them all to review our Accelerated Learning. Currently,
96,40% have said Firebrand exceeded their expectations:
"The training for PL-100 is an intense course, jam-packed with references, resources delivered by a super knowledgeable instructor. Would recommend having a sound base knowledge of Microsoft Power Platform before attending. MS Learn provides topics for PL-100 and also a study guide for the exam which is very useful when preparing for exam."
Jessica Brooks, Kenvue. (3/1/2024 (Wednesday) to 4/1/2024 (Thursday))
"Training facilities were great and the hotel onsite is nice."
Anonymous. (18/12/2023 (Monday) to 20/12/2023 (Wednesday))
"It''s the best way to learn without any distraction. Training, eat, sleep, shower."
Anonymous. (13/12/2023 (Wednesday) to 15/12/2023 (Friday))
"When learning with Firebrand, everything is taken care of for you. This allows you to pour everything into absorbing and understanding your course content amongst peers."
ML, Griggster Limited. (3/10/2023 (Tuesday) to 6/10/2023 (Friday))
"Perfect instructor with much knowledge and the ability to bring it to the people. Thank you. The topic is huge but I would have expected a little bit more working together in the system."
Reinhard Decker, VAT Vakuumventile AG. (10/10/2023 (Tuesday) to 13/10/2023 (Friday))
Start |
Finish |
Status |
Location |
Book now |
---|---|---|---|---|
27/11/2023 (Monday) |
27/11/2023 (Monday) |
Finished - Leave feedback |
- |
|
1/4/2024 (Monday) |
1/4/2024 (Monday) |
Wait list |
Nationwide |
|
13/5/2024 (Monday) |
13/5/2024 (Monday) |
Limited availability |
Nationwide |
|
24/6/2024 (Monday) |
24/6/2024 (Monday) |
Open |
Nationwide |
|
5/8/2024 (Monday) |
5/8/2024 (Monday) |
Open |
Nationwide |
|
16/9/2024 (Monday) |
16/9/2024 (Monday) |
Open |
Nationwide |
|