Looking for Global training? Go to https://firebrand.training/en or stay on the current site (Suomi)
Part of the BPP Education Group
09 - 31 587 431
Microsoft - Updating Your SQL Server Skills to Microsoft SQL Server 2014
Overview
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.
8 syytä, miksi kannattaa hankkia SQL Server 2014 Firebrand Trainingiltä:
- Koulutuksen saaminen kestää vain 3 päivän.
- Hintaan sisältyy kaikki.Kertamaksu kattaa kaikki kurssimateriaalit, kuljetuksen, majoituksen ja ateriat ja tarjoaa kustannustehokkaimman tavan hankkia SQL Server 2014 koulutus. Ilman mitään lisäkustannuksia.
- Suorita tutkinto ensimmäisellä kerralla tai kertaa koulutus ilmaiseksi. Tämä on takuumme. Olemme varmoja, että läpäiset SQL Server 2014 -kurssin ensimmäisellä kerralla. Mutta jos näin ei käy, voit tulla takaisin vuoden kuluttua ja maksaa vain majoituksesta ja kokeista. Kaikki muu on ilmaista.
- Opit enemmän.Päivä perinteisen koulutuksen tarjoajan kanssa on yleensä klo 9–17, mihin sisältyy pitkä lounastauko. Firebrand Trainingiltä saat vähintään 12 tuntia päivässä keskittynyttä ja häiriötöntä laatukoulutusaikaa opettajasi kanssa.
- Opit SQL Server 2014 nopeammin. Yhdistämme 3 eri oppimistyyliä (visuaalisen|kuuloon perustuvan|kosketukseen perustuvan) tarjotaksemme materiaalin tavalla joka varmistaa, että opit nopeammin ja helpommin.
- Opiskelet huippujen kanssa.Olemme kouluttaneet ja sertifioineet 134.561 ammattilaista ja olemme kumppaneita kaikkien alan suurien nimien kanssa ja olemme saaneet lukuisia palkintoja, mm. Microsoftin Danmarki Vuoden koulutuspartneri 2010, 2011, 2012 ja 2013, Institue of IT Trainingin ”Training Company of the Year 2006, 2007, 2008” Englannissa, ISC(2):n ”Highest Performing Affiliate of the Year 2009 & 2010 – EMEA” sekä EC-Councilin ”Accredited Training Centre of the Year 2010 og 2011”, ”Newcomer of the Year 2011” ja ”Instructors Circle of Excellence”.
- Opit enemmän kuin pelkän teorian. Olemme kehittäneet SQL Server 2014 kurssia edelleen käyttämällä laboratorioita, esimerkkitapauksia ja harjoittelukokeita varmistaaksemme, että osaat soveltaa uutta tietoa työympäristöön.
- Opit parhailta. Ohjaajamme SQL Server 2014 kurssilla ovat alan parhaita. He tarjoavat ainutlaatuisen yhdistelmän asiantuntemusta, kokemusta ja intohimoa opetukseen.
Oletko valmis kurssin? Ota VAPAA testi mitata ja arvioida osaamisen tasoa.
Benefits
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.
Curriculum
Introduction to SQL Server 2014
Learn key features of SQL Server 2014.
- Overview of SQL Server 2014
- SQL Server 2014 Editions and Components
- Installing SQL Server 2014
- Enhancements to SQL Server Management Studio
What’s New in SQL Server Database Development
Find out more about enhancements to Transact-SQL and other database development features since SQL Server 2008.
- Transact-SQL Enhancements
- New and Enhanced Transact-SQL Functions
- Enhancements to Spatial Data Support
- Storing and Querying Documents with SQL Server 2014
In-Memory Database Capabilities
Learn how SQL server 2014 enables you to leverage in-memory technologies to enhance database performance.
- The Buffer pool Extension
- Columnstore Indexes
- Memory-Optimized Tables
Scripting SQL Server 2014
How to use dynamic management views and PowerShell to script administrative tasks in SQL server 2014.
- New and Enhanced Dynamic Management Views
- Using PowerShell to Manage SQL Server
Implementing Security in Microsoft SQL Server 2014
Learn about the enhancements to security features since SQL Server 2008.
- Security Management Enhancements
- Contained Databases
High Availability and Data Recovery Enhancements
Learn about the enhancements to SQL Server availability and data recovery features since SQL Server 2008.
- Always On High Availability
- Enhancements to Data Recovery
New and Enhanced Features in SQL Server Integration Services
Learn about enhancements to SQL Server Integration Services since SQL Server 2008.
- Using the CDC Control Task for Incremental Data Loads
- Deploying and Operating SSIS Packages
Data Quality Services
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.
- Introduction to Data Quality
- Using Data Quality Services to Cleanse Data
- Using Data Quality Services to Match Data
Master Data Services
Learn about Master Data Services, its key configuration options and how to import and export data.
- Introduction to Master Data Services
- Implementing a Master Data Services Model
- Using the Master Data Services Add-in for Excel
SQL Server 2014 Reporting Services
Learn about the new and enhanced features in SQL Server Reporting Services.
- Reporting Services Overview
- Reporting Services and Microsoft SharePoint Server
- Introduction to Data Alerts
Implementing an Analysis Services Tabular Data Model
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.
- Introduction to Analysis Services Tabular Data Model Projects
- Creating a Tabular Model
- Using an Analysis Services Tabular Data Model in the Enterprise
Self-Service BI with Microsoft Excel
Learn about the self-service BI capabilities that can be delivered through Microsoft Excel 2013 and related technologies.
- PowerPivot for Excel
- PowerPivot for SharePoint Server
- Power Query
- Power View
- Power Map
- Power BI for Office 365
Introduction to Cloud Data Solutions
Some of the key Microsoft technologies that you can use to implement a cloud solution for data.
- Overview of Cloud Computing
- Windows Azure Services for Data
Windows Azure SQL Database
An introduction to Windows Azure SQL Database, a Platform-as-a-Service (PaaS) solution for cloud-based relational database storage.
- Introduction to Windows Azure SQL Database
- Windows Azure SQL Database Security
- Implementing and Managing Databases
SQL Server in Windows Azure Virtual Machines
How you can use Windows Azure virtual machines in which SQL Server is installed to create a cloud-based solution for data.
- Introduction to Windows Azure Virtual Machines
- Windows Azure Virtual Machine Connectivity and Security
- Creating Databases in a Windows Azure Virtual Machine
Implementing Big Data Solutions
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.
- Introduction to Big Data
- Windows Azure HDInsight
- Consuming HDInsight Results in Excel
- Obtaining Data from the Windows Azure Marketplace
What's Included
Microsoft Official Curriculum
- MOC 10977B: Updating your SQL Server Skills to Microsoft SQL Server 2014.
Prerequisites
Before attending this course, you must have:
- Experience of building and managing database, data warehouse, and business intelligence (BI) solutions with SQL Server 2008
- Familiarity with the Windows Server 2012 operating system and networking
- Familiarity with Microsoft Excel, Microsoft SharePoint Server 2013 and financial accounting is recommended.
Arvioinnit
Olemme kouluttaneet kymmenen vuoden aikana yli 134.561 opiskelijaa. Heitä kaikkia on pyydetty arvioimaan pikakurssimme. Tällä hetkellä 96,41% on sitä mieltä, että Firebrand on ylittänyt heidän odotuksensa:
"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 (Keskiviikko) - 4/1/2024 (Torstai))
"Training facilities were great and the hotel onsite is nice."
Anonymous. (18/12/2023 (Maanantai) - 20/12/2023 (Keskiviikko))
"It's the best way to learn without any distraction. Training, eat, sleep, shower."
Anonymous. (13/12/2023 (Keskiviikko) - 15/12/2023 (Perjantai))
"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 (Tiistai) - 6/10/2023 (Perjantai))
"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 (Tiistai) - 13/10/2023 (Perjantai))
Kurssipäivämäärät
|
Alkaa |
Loppuu |
Saatavuus |
Sijainti |
Rekisteröidy |
|---|---|---|---|---|
|
19/2/2024 (Maanantai) |
21/2/2024 (Keskiviikko) |
Päättynyt - Jätä palautetta |
- |
|
|
24/6/2024 (Maanantai) |
26/6/2024 (Keskiviikko) |
Odotuslista |
Maanlaajuinen |
|
|
5/8/2024 (Maanantai) |
7/8/2024 (Keskiviikko) |
Rajoitettu määrä paikkoja |
Maanlaajuinen |
|
|
16/9/2024 (Maanantai) |
18/9/2024 (Keskiviikko) |
Paikkoja saatavilla |
Maanlaajuinen |
|
|
28/10/2024 (Maanantai) |
30/10/2024 (Keskiviikko) |
Paikkoja saatavilla |
Maanlaajuinen |
|
|
9/12/2024 (Maanantai) |
11/12/2024 (Keskiviikko) |
Paikkoja saatavilla |
Maanlaajuinen |
|