Learn how to use the enhancements and new features that have been added to SQL Server and the Microsoft data platform since the release of SQL Server 2008. The course focuses on teaching you how to use SQL Server 2014 product features and other Microsoft data platform components.
As a database or business intelligence professional, you'll learn the skills needed to make the most of the the new features of SQL Server 2014. Plus, become familiar with related Microsoft data technologies such as: Windows Azure, Excel 2013 and PowerBI for Office365.
This course gives database and business intelligence (BI) professionals the skills to utilise the new features of SQL Server 2014, and become familiar with related Microsoft data technologies such Windows Azure, Excel 2013 and PowerBI for Office365.
Learn key features of SQL Server 2014.
Find out more about enhancements to Transact-SQL and other database development features since SQL Server 2008.
Learn how SQL server 2014 enables you to leverage in-memory technologies to enhance database performance.
How to use dynamic management views and PowerShell to script administrative tasks in SQL server 2014.
Learn about the enhancements to security features since SQL Server 2008.
Learn about the enhancements to SQL Server availability and data recovery features since SQL Server 2008.
Learn about enhancements to SQL Server Integration Services since SQL Server 2008.
How to use the SQL Server 2014 Data Quality Services (DQS) to provide a computer assisted process for cleansing data values and identifying and removing duplicate data entities.
Learn about Master Data Services, its key configuration options and how to import and export data.
Learn about the new and enhanced features in SQL Server Reporting Services.
Learn about Analysis Services tabular data models and explains how to develop a tabular data model by using the SQL Server Data Tools for BI add-in for Visual Studio.
Learn about the self-service BI capabilities that can be delivered through Microsoft Excel 2013 and related technologies.
Some of the key Microsoft technologies that you can use to implement a cloud solution for data.
An introduction to Windows Azure SQL Database, a Platform-as-a-Service (PaaS) solution for cloud-based relational database storage.
How you can use Windows Azure virtual machines in which SQL Server is installed to create a cloud-based solution for data.
Learn the main features of big data, and the Microsoft technologies that you can use to build big data analytical solutions. In particular, the module focuses on Windows Azure HDInsight and the Windows Azure Marketplace as core elements of the Microsoft solution for big data.
Your accelerated course includes:
Before attending this course, you must have:
Unsure whether you meet the prerequisites? Don’t worry. Your training consultant will discuss your background with you to understand if this course is right for you.
Here's the Firebrand Training review section. Since 2001 we've trained exactly 134561 students and asked them all to review our Accelerated Learning. Currently, 96.41% have said Firebrand exceeded their expectations.
Read reviews from recent accelerated courses below or visit Firebrand Stories for written and video interviews from our alumni.
"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 |
---|---|---|---|---|
19/2/2024 (Monday) |
21/2/2024 (Wednesday) |
Finished - Leave feedback |
- |
|
24/6/2024 (Monday) |
26/6/2024 (Wednesday) |
Wait list |
Nationwide |
|
5/8/2024 (Monday) |
7/8/2024 (Wednesday) |
Limited availability |
Nationwide |
|
16/9/2024 (Monday) |
18/9/2024 (Wednesday) |
Open |
Nationwide |
|
28/10/2024 (Monday) |
30/10/2024 (Wednesday) |
Open |
Nationwide |
|
9/12/2024 (Monday) |
11/12/2024 (Wednesday) |
Open |
Nationwide |
|