Looking for Global training? Go to https://firebrand.training/en or stay on the current site (Nederland)
U kunt nu leren hoe een Microsoft SQL Server database te ontwikkelen en te onderhouden, en een Microsoft MCSE: Data Platform certificaat behalen in amper zes dagen. Dit is 45% sneller dan bij een traditionele training.
Microsoft heeft zijn cursusmateriaal geüpdatet, om informatie over SQL Server 2014 te kunnen aanbieden. Dit is een aanvulling op het materiaal voor SQL Server 2012 die reeds deel uitmaakt van het curriculum. Wat u leert tijdens deze cursus is van toepassing op zowel SQL Server 2012 als 2014. U zult ook praktische ervaring opdoen met de nieuwe tools en mogelijkheden van SQL Server 2014, zoals:
Bekijk nu de prijzen om erachter te komen hoeveel je kunt besparen als je tweemaal zo snel traint.
Andere versnelde trainingsaanbieders vertrouwen sterk op colleges, onafhankelijke zelftesten en studeren.
Effectieve technische instructies moeten zeer gevarieerd en interactief zijn om het aandachtsniveau hoog te houden, kameraadschap en teamwerk tussen de studenten en de instructeur te bevorderen en kennis te verankeren door praktisch leren.
Deze informatie is verstrekt als een nuttig hulpmiddel voor kandidaten die een opleiding overwegen. Cursussen inclusief certificering worden geleverd met een certificeringsgarantie. Slaag de eerste keer of train opnieuw gratis (je betaal voor de accommodatie en examens bij jouw terugkeer). Wij kunnen geen garanties geven over persoonlijke successen of voordelen van het behalen van certificering.
This module introduces database development and the key tasks that a database developer would typically perform.
Lessons
Lab : Introduction to Database Development
After completing this module, you will be able to:
This module explains how to design, create, and alter tables. Also it focusses on working with schemas.
Lessons
Lab : Designing and Implementing Tables
After completing this module, you will be able to:
This module explains how to enforce data integrity, and implement domain integrity to maintain high quality data. Also it focusses on implementing Entity and Referential Integrity.
Lessons
Lab : Ensuring Data Integrity through Constraints
After completing this module, you will be able to:
This module describes the concept of an index and discusses selectivity, density and statistics. It covers appropriate data type choices and choices around composite index structures.
Lessons
Lab : Implementing Indexes
After completing this module, you will be able to:
This module explains covering indexes and the INCLUDE clause as well as the use of padding, hints and statistics. The module also covers the use of the Database Engine Tuning Advisor and index-related dynamic management views to assess indexing strategies.
Lessons
Lab : Designing Optimised Index Strategies
After completing this module, you will be able to
This module explains columnstore indexes and how to use them to maximise the performance and scalability of database applications.
Lessons
Lab : Using Columnstore Indexes
After completing this module, you will be able to:
This module introduces Views, and explains how to create and manage Views. Also it focuses on the performance consideration for Views.
Lessons
Lab : Designing and Implementing Views
After completing this module, you will be able to:
This module describes the potential advantages of the use of stored procedures along with guidelines on creating them.
Lessons
Lab : Designing and Implementing Stored Procedures
After completing this module, you will be able to:
This module explains how to design and implement user-defined functions that enforce business rules or data consistency, and modify and maintain existing functions written by other developers.
Lessons
Lab : Designing and Implementing User-Defined Functions
After completing this module, you will be able to:
This module, explains what DML triggers are and how they enforce data integrity. Also it focusses on the different types of triggers available, and how to define triggers in a database.
Lessons
Lab : Responding to Data Manipulation via Triggers
After completing this module, you will be able to:
This module covers the creation of in-memory tables and native stored procedures and discusses the advantages and disadvantages of using in-memory tables.
Lessons
Lab : In-Memory OLTP
After completing this module, you will be able to:
This module explains how to use CLR integrated code to create user-defined database objects that are managed by the .NET Framework.
Lessons
Lab : Implementing Managed Code in SQL Server 2014
After completing this module, you will be able to:
This module introduces XML and shows how XML data can be stored within SQL Server and then queried, including queries written in a language called XQuery.
Lessons
Lab : Storing and Querying XML Data in SQL Server 2014
After completing this module, you will be able to:
This module introduces Spatial Data, and explains how to work with SQL Server Spatial Data Types.
Lessons
Lab : Working with SQL Server Spatial Data
After completing this module, you will be able to:
As organisations grow to enterprise scale, their IT infrastructure requirements become more complex and the network environment often includes an increasing number of servers, client computers, network segments, and other components. Because data is fundamental to most IT operations, careful thought must be given to the provisioning and management of databases across the enterprise.
Lessons
Lab : Assessing an Existing Enterprise Data Infrastructure
After completing this module, you will be able to:
When an enterprise infrastructure includes multiple database servers, it can be useful to standardise and enforce configuration settings in order to ensure compliance and manageability. This module discusses Policy-Based Management in SQL Server, and describes how it can be used together with enterprise configuration management tools such as Microsoft System Center to aid enterprise database server management.
Lessons
Lab : Planning and Implementing Policy-Based Management
After completing this module, you will be able to:
This module describes Data Collector and the SQL Server Utility Control Point (UCP), two features of SQL Server 2014 that enable you to perform in-depth health monitoring across the enterprise.
Lessons
Lab : Monitoring SQL Server Health
After completing this module, you will be able to:
This module provides an overview of the benefits of consolidating database workloads by using SQL Server 2014, and describes the different options for implementing a consolidation strategy. It also describes how you can manage a consolidated infrastructure in various scenarios.
Lessons
Lab : SQL Server Consolidation
After completing this module, you will be able to:
Cloud computing has risen to prominence very rapidly within the world of IT, and many organisations have implemented or are planning to implement cloud-based solutions that encompass all or part of their infrastructure. This module describes some of the fundamental concepts of cloud computing and outlines how to include SQL Server 2014 in a private cloud infrastructure.
Lessons
Lab : Preparing a SQL Server Installation in a Virtual Machine Template
After completing this module, you will be able to:
Maintaining highly available database services is vital in a 24 hour operating environment. SQL Server 2014 includes many features that can help organisations to deliver the levels of service they require to drive their businesses. This module explains the different ways that you can implement high availability by using SQL Server 2014. It also describes how to use log shipping to promote resilience for individual user databases.
Lessons
Lab : Using Log Shipping
After completing this module, you will be able to:
SQL Server 2014 is closely integrated with the Windows Server Failover Clustering feature in Windows Server 2012 and Windows Server 2012 R2, enabling you to create enterprise-class clustering solutions that can deliver comprehensive high availability and disaster recovery solutions. This module explains how Windows Server Failover Clustering and SQL Server AlwaysOn Failover Cluster Instances work, and describes how to implement clustering to protect service availability.
Lessons
Lab : Implementing an AlwaysOn Failover Cluster Instance
After completing this module, you will be able to:
SQL Server 2014 includes AlwaysOn Availability Groups to provide high availability for groups of databases. This module describes AlwaysOn Availability Groups in SQL Server 2014, explains the key concepts of AlwaysOn Availability Groups, and describes how you can use them to maintain highly available databases.
Lessons
Lab : Implementing and Testing an AlwaysOn Availability Group
After completing this module, you will be able to:
This module describes the planning considerations for high availability and disaster recovery, and provides common implementation scenarios for on-premises, hybrid, and Microsoft Azure environments.
Lessons
Lab : Planning High Availability and Disaster Recovery
After completing this module, you will be able to:
SQL Server replication enables you to copy and distribute data and database objects to other computers and locations in your enterprise, which can improve availability and scalability. This module provides an overview of SQL Server replication and explains the agents used to implement replication. It also describes some common replication scenarios, how to design an appropriate replication system for your requirements, and how to monitor and troubleshoot replication.
Lessons
Lab : Planning and Implementing Replication
After completing this module, you will be able to:
U legt de volgende twee examens af:
Bent u reeds houder van een SQL Server 2008 certificaat? Als dat het geval is, kan het zijn dat u minder examens hoeft af te leggen om uw certificaat te behalen. Bel ons op 024-8457770 om hier meer over te weten te komen.
Jouw versnelde cursus omvat:
Naast uw Professionele ervaring, moet u in het bezit zijn van de volgende Microsoft certificaten: (MCSA: SQL Server):
Weet je niet zeker of je aan de vereisten voldoet? Maak je geen zorgen. Jouw trainingsadviseur bespreekt jouw achtergrond met je om te begrijpen of deze cursus geschikt is voor je.
Wereldwijd heeft Firebrand in haar 10-jarig bestaan al 134561 studenten opgeleid! We hebben ze allemaal gevraagd onze versnelde opleidingen te evalueren. De laatste keer dat we onze resultaten analyseerden, bleek 96.41% ons te beoordelen als 'boven verwachting'
"The instructor was brilliant. I have attended a couple of courses, but the instructor in this class was outstanding."
Jim Otieno, Ministry of Defence. (26/10/2015 (Maandag) t/m 31/10/2015 (Zaterdag))
"Our instructors knowledge seemed to know no bounds. She was an excellent communicator, and fully engaged students throughout the course. She also worked tirelessly to meet the needs and requests of the students in order for them to understand the material and effectively prepare them for the certification exams. It was a great pleasure attending her class!"
Robert Andrew Rauch. (26/10/2015 (Maandag) t/m 31/10/2015 (Zaterdag))
"Hard work, but worth it!"
S.A., Software Developer. (20/10/2014 (Maandag) t/m 25/10/2014 (Zaterdag))
"Firebrand is very fast but at the same time allows you to learn the subjects in an enjoyable manner."
Anoniem (20/10/2014 (Maandag) t/m 25/10/2014 (Zaterdag))
"good facilities, good instructor."
P.S.. (20/10/2014 (Maandag) t/m 25/10/2014 (Zaterdag))
Start datum |
Eind datum |
Status |
Locatie |
Nu boeken |
---|---|---|---|---|
19/2/2024 (Maandag) |
24/2/2024 (Zaterdag) |
Beëindigde cursus - Geef feedback |
- |
|
24/6/2024 (Maandag) |
29/6/2024 (Zaterdag) |
Wachtlijst |
Landelijk |
|
5/8/2024 (Maandag) |
10/8/2024 (Zaterdag) |
Beperkte beschikbaarheid |
Landelijk |
|
16/9/2024 (Maandag) |
21/9/2024 (Zaterdag) |
Open |
Landelijk |
|
28/10/2024 (Maandag) |
2/11/2024 (Zaterdag) |
Open |
Landelijk |
|
9/12/2024 (Maandag) |
14/12/2024 (Zaterdag) |
Open |
Landelijk |
|