Karlebovej 91, 3400 Hillerød | Krajbjergvej 3, 8541 Skødstrup
70 22 29 29
08:30 - 17:00

MCSE SQL 2016: Data Management & Analytics inkl. MCSA Database Admin (70-764 & 70-765 & 70-767)

  • apr 08
    mandag 08/04/2019 - fredag 28/06/2019
    09:00 - 16:00 Hillerød
    Hold-info
    Hold
    20764
    man 08 apr 09:00 - fre 12 apr 16:00 Hillerød
    20765
    man 20 maj 09:00 - fre 24 maj 16:00 Hillerød
    20767
    man 24 jun 09:00 - fre 28 jun 16:00 Hillerød
    • Pakkepris - Kr.43,950.00 ekskl. MOMS
    • Kr.62,400.00 ekskl. MOMS
    Ekskl. moms
Er der ingen af disse datoer som passer dig? Foreslå en anden dato

Kursusinfo

  • Dette kursus varer 15 dage
  • Der medfølger kursusmateriale til dette kursus
  • Dette kursus koster 18 klip på dit klippekort.
  • Fuld forplejning (Morgenmad, frokost, kage, kaffe og sodavand ad libitum)
  • Fuld beståelsesgaranti er inkluderet i prisen - Læs mere her
  • Eksamen er inkluderet i prisen
  • Med i prisen hører Practice Test
  • Du har i alt adgang til din kursus-pc i 3 uger

Varighed

Dette kursus varer 15 dage

Materialer

Der medfølger kursusmateriale til dette kursus

Klip på klippekort

Dette kursus koster 18 klip på dit klippekort.

Forplejning

Fuld forplejning (Morgenmad, frokost, eftermiddagskage samt kaffe og sodavand ad libitum)

Garanti for beståelse

Fuld beståelsesgaranti er inkluderet i prisen - Læs mere her

Eksamen

Alle eksamensforsøg er inkluderet i prisen

Practice Tests

Med i prisen hører Practice Test

Remote adgang

Du har i alt adgang til din kursus-pc i 3 uger

Microsoft Vouchers

15 vouchers + 9.950 kr. for Certificeringspakken.
Læs mere her

Download PDF

Hen PDF om kurset her

MCSE: Data Management and Analytics er en ny titel fra Microsoft. Titlen er frigivet i september 2016 og opnås ved at bestå i alt 3 eksamener (2 obligatoriske og 1 valgfri). 

Vi har hos Skillshouse sammensat et spændende MCSE kursusforløb baseret på de nye SQL Server 2016 Database Administration kurser, som også giver dig titlen; Microsoft MCSA SQL Server 2016 Database Administration og som valgfri kursus valgt "Implementing a SQL Data Warehouse" kursus med eksamensnummer 70-767. Men, husk, at du sagtens kan vælge et af de andre valgfri kurser i stedet for - se mere længere nede i teksten. 

Opbygningen af MCSE kursusforløbet betyder, at du sparer tid i forhold til de traditionelle kurser og samtidigt foregår undervisningen via masser af hands-on og best practices, som sikrer, bedre indlærring og derved bedre brug af dine nye færdigheder. 

Kort fortalt:

  • Du sparer mere end 17.000,-
  • Garanteret beståelse og alle de eksamensforsøg du skal bruge 
  • Alt er inkluderet inkl. autoriseret Microsoft kursusmateriale.
  • Undervisningen foretages af Microsoft Certified Trainer (MCT)
  • Fuld forplejning og selvfølgelig alle de colaer og Red Bull du kan drikke 🙂

Undervisningen er fra 09.00 til 16.00 

Sammensæt din egen MCSE: Data Management and Analytics
Du kan "næsten" sammensætte din MCSE: Data Management and Analytics som du ønsker det, dog er der 2 obligatoriske certificeringer som du skal tage og herefter skal du vælge 1 valgfri certificering. Dvs. 3 certificeringer i alt.  Du kan få et nemt overblik ved at downloade vores brochure øverst på denne side. 

Obligatoriske certificeringer som begge skal bestås: 

- Administering a SQL Database Infrastructure (eksamen: 70-764)
- Provisioning SQL Databases (eksamen: 70-765)

Når disse 2 certificeringer er bestået har du opnået titlen: Microsoft MCSA SQL Server 2016 Database Administration. 

Her efter skal du bestå 1 af nedenstående certificeringer for at opnå titlen: MCSE: Data Management and Analytics

 

Course Outline for Administering a SQL Database Infrastructure

Module 1: Authenticating and Authorizing Users
This module covers SQL Server security models, logins, and users.

Lessons
Authenticating connections to SQL Server
Authorizing logins to access databases
Authorization across servers
Partially contained databases

Lab : Authenticating Users
After completing this module, you will be able to:
Describe server level security
Describe database level security
Describe multi-server authentication
Describe partially contained databases

Module 2: Assigning Server and Database Roles
This module covers fixed server roles, user-defined server roles, fixed database roles, and user-defined database roles.

Lessons
Working with server roles
Working with Fixed database roles
Creating user-defined database roles

Lab : Assigning server and database roles
After completing this module, you will be able to:
Describe server roles
Describe fixed database roles
Describe user-defined database roles

Module 3: Authorizing Users to Access Resources
This module covers permissions and the assignment of permissions.

Lessons
Authorizing user access to objects
Authorizing users to execute code
Configuring permissions at the schema level

Lab : Authorizing users to access resources
After completing this module, you will be able to:
Describe how to authorize user access to objects
Describe how to authorize users to execute code
Describe how to configure permissions at the schema level

Module 4: Protecting Data with Encryption and Auditing
This module covers SQL Server Audit.

Lessons
Options for auditing data access in SQL Server
Implementing SQL Server audit
Managing SQL Server audit
Protecting data with encryption

Lab : Using Auditing and Encryption
After completing this module, you will be able to:
Describe options for auditing data access.
Implement SQL Server Audit.
Manage SQL Server Audit.
Describe how to use custom audit events.
Implement encryption

Module 5: SQL Server Recovery Models
This module describes the concept of the transaction log and SQL Server recovery models. It also introduces the different backup strategies available with SQL Server.

Lessons
Backup strategies
Understanding SQL Server transaction login
Planning a SQL Server backup strategy

Lab : Understanding SQL Server recovery models
After completing this module, you will be able to:
Describe the various backup strategies.
Describe how database transaction logs function.
Plan a SQL Server backup strategy.

Module 6: Backup of SQL Server Databases
This module describes SQL Server Backup and the backup types

Lessons
Backing up databases and transaction logs
Managing database backups
Working with backup options

Lab : Backing up SQL Server databases
After completing this module, you will be able to:
Perform backups of SQL Server databases and transaction logs.
Manage database backups.
Describe the advanced backup options.
Describe how to backup to the Azure Windows Blob Store.

Module 7: Restoring SQL Server Databases
This module describes the restoration of databases.

Lessons
Understanding the restore process
Restoring databases
Working with point-in-time recovery
Restoring system databases and individual files

Lab : Restoring SQL Server User Databases
After completing this module, you will be able to:
Explain the database restore process.
Describe the concept of point in time recovery.
Describe the advanced concepts of restoring.

Module 8: Automating SQL Server Management
This module describes how to use SQL Server Agent for automation. It also explains the benefits of using master and target servers to centralize the administration of automation.

Lessons
Automating SQL Server management
Working with SQL Server agent
Managing SQL Server agent jobs
Multi-server management

Lab : Automating SQL Server Management
After completing this module, you will be able to:
Describe methods for automating SQL Server Management.
Configure jobs, job step types, and schedules.
Manage SQL Server Agent jobs.
Configure master and target servers.

Module 9: Configuring Security for SQL Server Agent
This module describes the considerations for SQL Server Agent security, including proxy accounts and credentials.

Lessons
Understanding SQL Server Agent Security
Configuring credentials
Configuring proxy accounts

Lab : Configuring Security for SQL Server Agent
After completing this module, you will be able to:
Describe the security context for SQL Server Agent jobs.
Configure credentials.
Configure proxy accounts.

Module 10: Monitoring SQL Server with Alerts and Notifications
This module covers the configuration of database mail, alerts and notifications.

Lessons
Configuration of database mail
Monitoring SQL Server errors
Configuring operators, alerts, and notifications
Alerts in Azure SQL database

Lab : Monitoring SQL Server with Alerts and Notifications
After completing this module, you will be able to:
Configure database mail.
Monitor SQL Server errors.
Configure operators, alerts and notifications.

Module 11: Introduction to Managing SQL Server by using PowerShell
This module introduces PowerShell for SQL Server.

Lessons
Configure SQL Server using PowerShell
Administer SQL Server using PowerShell
Maintain the SQL Server environment using PowerShell
Managing Azure SQL Server databases using PowerShell

Lab : Administering SQL Server using PowerShell
After completing this module, you will be able to:
Configure SQL Server using PowerShell
Manage day-to-day SQL Server Administration with PowerShell
Maintain the SQL Server environment using PowerShell.

Module 12: Tracing Access to SQL Server
This module describes how to use SQL Profiler and SQL Trace stored procedures to capture information about SQL Server. The module also describes how to use Distributed Replay to capture trace information from multiple servers, and how to monitor locking.

Lessons
Capturing activity using SQL Server profiler
Improving performance with the database engine tuning advisor
Working with tracing options
Distributed replay
Monitoring locks

Lab : Tracing Access to SQL Server
After completing this module, you will be able to:
Configure SQL Profiler traces and review captured traces.
Use the Database Engine Tuning Advisor.
Understand SQL Server advanced tracing concepts.
Use Distributed Replay.
Monitor Locking.

Module 13: Monitoring SQL Server
This module explains how to use Distributed Management Views to monitor SQL Server. It also describes configuration of data collection and the SQL Server Utility.

Lessons
Monitoring activity
Capturing and managing performance data
Analyzing collected performance data
SQL Server utility

Lab : Monitoring SQL Server
After completing this module, you will be able to:
Monitor activity within SQL Server
Configure data collection.
View reports from data collection.
Configure a SQL Server Utility (UCP)

Module 14: Troubleshooting SQL Server
This module explains the SQL Server troubleshooting methodology and discusses the most common issues that can arise when working with SQL Server systems.

Lessons
SQL Server troubleshooting methodology
Resolving service related issues
Resolving login and connectivity issues
Troubleshooting common issues

Lab : Troubleshooting Common Issues
After completing this module, you will be able to:
Explain the SQL Server troubleshooting methodology.
Resolve service-related issues.
Resolve login and connectivity issues

Module 15: Importing and Exporting Data
This module covers the use of the import/export wizards and explains how they relate to SSIS. The module also introduces BCP and BULK INSERT.

Lessons
Transferring data to/from SQL Server
Importing and exporting table data
Using BCP and BULK INSERT to import data
Deploying and upgrading data-tier applications

Lab : Importing and Exporting Data
After completing this module, you will be able to:
Transfer data.
Import and export table data.
Use BCP and BULK INSERT to import data.
Use DACs to import and export database applications

Course Outline for Provisioning SQL Databases

Module 1: SQL Server 2016 Components
Describe the SQL Server platform, SQL Server services, and SQL Server configuration options.

Lessons
Introduction to the SQL Server Platform
Overview of SQL Server Architecture
SQL Server Services and Configuration Options

Lab : SQL Server Versions ( Discussion session)
After completing this module, you will be able to:
Describe the SQL Server platform and architecture
Describe the SQL Server services and configuration..

Module 2: Installing SQL Server 2016
This modules describes the process to install SQL Server 2016.

Lessons
Considerations for installing SQL Server
TempDB Files
Installing SQL Server 2016
Automating Installation

Lab : Installing SQL Server
After completing this module, you will be able to:
Describe the considerations when installing SQL Server 2016
Be able to install SQL Server
Be able to automate the installation

Module 3: Upgrading SQL Server to SQL Server 2016
This module describes how you go about upgrading your current SQL Server installation to SQL Server 2016.

Lessons
Upgrade Requirements
Upgrade SQL Server Services
Migrating SQL Server Data and Applications

Lab : Upgrading SQL Server
After completing this module, you will be able to:
Describe the requirements for upgrading to SQL Server 2016
Describe how to upgrade SQL Server services
Be able to migrate SQL Server Data and Applications

Module 4: Deploying SQL Server on Microsoft Azure
This module describes the options available to run SQL Server on Azure.

Lessons
SQL Server Virtual Machines in Azure
Deploying an Azure SQL Database
Migrating an On-Premise Database to an Azure SQL Database

Lab : Migrating SQL Server with Azure
After completing this module, you will be able to:
Describe how SQL Server Virtual Machines work in Azure
Describe how to deploy and Azure SQL database
Describe how to migrate and on-premise database to Azure

Module 5: Working with Databases
This module describes the preinstalled system databases, the physical structure of databases and the most common configuration options related to them.

Lessons
Overview of SQL Server Databases
Creating Databases
Database Files and Filegroups
Moving Database Files
Buffer Pool Extension

Lab : Managing Database Storage
After completing this module, you will be able to:
Be able to create SQL Server databases
Describe database files and filegroups
Be able to move database files
Describe the buffer pool extension

Module 6: Database Storage Options
At the end of this module you will be able to describe the database storage options.

Lessons
SQL Server storage Performance
SMB Fileshare
SQL Server Storage in Azure
Stretch Databases

Lab : Implementing Stretch Database
After completing this module, you will be able to:
Explain the elements impacting storage performance
Describe SMB fileshare
Describe SQL Server storage in Azure
Describe Stretch Databases

Module 7: Performing Database Maintenance
This module covers database maintenance.

Lessons
Ensuring Database Integrity
Maintaining Indexes
Automating Routine Database Maintenance

Lab : Performing Ongoing Database Maintenance
After completing this module, you will be able to:
Describe how to ensure database integrity
Be able to maintain indexes
Be able to automate routine database maintenance

Course Outline: Implementing a SQL Data Warehouse

Module 1: Introduction to Data Warehousing
Describe data warehouse concepts and architecture considerations.

Lessons
Overview of Data Warehousing
Considerations for a Data Warehouse Solution

Lab : Exploring a Data Warehouse Solution
After completing this module, you will be able to:
Describe the key elements of a data warehousing solution
Describe the key considerations for a data warehousing solution

Module 2: Planning Data Warehouse Infrastructure
This module describes the main hardware considerations for building a data warehouse.

Lessons
Considerations for Building a Data Warehouse
Data Warehouse Reference Architectures and Appliances

Lab : Planning Data Warehouse Infrastructure
After completing this module, you will be able to:
Describe the main hardware considerations for building a data warehouse
Explain how to use reference architectures and data warehouse appliances to create a data warehouse

Module 3: Designing and Implementing a Data Warehouse
This module describes how you go about designing and implementing a schema for a data warehouse.

Lessons
Logical Design for a Data Warehouse
Physical Design for a Data Warehouse

Lab : Implementing a Data Warehouse Schema
After completing this module, you will be able to:
Implement a logical design for a data warehouse
Implement a physical design for a data warehouse

Module 4: Columnstore Indexes
This module introduces Columnstore Indexes.

Lessons
Introduction to Columnstore Indexes
Creating Columnstore Indexes
Working with Columnstore Indexes

Lab : Using Columnstore Indexes
After completing this module, you will be able to:
Create Columnstore indexes
Work with Columnstore Indexes

Module 5: Implementing an Azure SQL Data Warehouse
This module describes Azure SQL Data Warehouses and how to implement them.

Lessons
Advantages of Azure SQL Data Warehouse
Implementing an Azure SQL Data Warehouse
Developing an Azure SQL Data Warehouse
Migrating to an Azure SQ Data Warehouse

Lab : Implementing an Azure SQL Data Warehouse
After completing this module, you will be able to:
Describe the advantages of Azure SQL Data Warehouse
Implement an Azure SQL Data Warehouse
Describe the considerations for developing an Azure SQL Data Warehouse
Plan for migrating to Azure SQL Data Warehouse

Module 6: Creating an ETL Solution
At the end of this module you will be able to implement data flow in a SSIS package.

Lessons
Introduction to ETL with SSIS
Exploring Source Data
Implementing Data Flow

Lab : Implementing Data Flow in an SSIS Package
After completing this module, you will be able to:
Describe ETL with SSIS
Explore Source Data
Implement a Data Flow

Module 7: Implementing Control Flow in an SSIS Package
This module describes implementing control flow in an SSIS package.

Lessons
Introduction to Control Flow
Creating Dynamic Packages
Using Containers

Lab : Implementing Control Flow in an SSIS Package
Lab : Using Transactions and Checkpoints
After completing this module, you will be able to:
Describe control flow
Create dynamic packages
Use containers

Module 8: Debugging and Troubleshooting SSIS Packages
This module describes how to debug and troubleshoot SSIS packages.

Lessons
Debugging an SSIS Package
Logging SSIS Package Events
Handling Errors in an SSIS Package

Lab : Debugging and Troubleshooting an SSIS Package
After completing this module, you will be able to:
Debug an SSIS package
Log SSIS package events
Handle errors in an SSIS package

Module 9: Implementing an Incremental ETL Process
This module describes how to implement an SSIS solution that supports incremental DW loads and changing data.

Lessons
Introduction to Incremental ETL
Extracting Modified Data
Temporal Tables

Lab : Extracting Modified Data
Lab : Loading Incremental Changes
After completing this module, you will be able to:
Describe incremental ETL
Extract modified data
Describe temporal tables

Module 10: Enforcing Data Quality
This module describes how to implement data cleansing by using Microsoft Data Quality services.

Lessons
Introduction to Data Quality
Using Data Quality Services to Cleanse Data
Using Data Quality Services to Match Data

Lab : Cleansing Data
Lab : De-duplicating Data
After completing this module, you will be able to:
Describe data quality services
Cleanse data using data quality services
Match data using data quality services
De-duplicate data using data quality services

Module 11: Using Master Data Services
This module describes how to implement master data services to enforce data integrity at source.

Lessons
Master Data Services Concepts
Implementing a Master Data Services Model
Managing Master Data
Creating a Master Data Hub

Lab : Implementing Master Data Services
After completing this module, you will be able to:
Describe the key concepts of master data services
Implement a master data service model
Manage master data
Create a master data hub

Module 12: Extending SQL Server Integration Services (SSIS)
This module describes how to extend SSIS with custom scripts and components.

Lessons
Using Custom Components in SSIS
Using Scripting in SSIS

Lab : Using Scripts and Custom Components
After completing this module, you will be able to:
Use custom components in SSIS
Use scripting in SSIS

Module 13: Deploying and Configuring SSIS Packages
This module describes how to deploy and configure SSIS packages.

Lessons
Overview of SSIS Deployment
Deploying SSIS Projects
Planning SSIS Package Execution

Lab : Deploying and Configuring SSIS Packages
After completing this module, you will be able to:
Describe an SSIS deployment
Deploy an SSIS package
Plan SSIS package execution

Module 14: Consuming Data in a Data Warehouse
This module describes how to debug and troubleshoot SSIS packages.

Lessons
Introduction to Business Intelligence
Introduction to Reporting
An Introduction to Data Analysis
Analyzing Data with Azure SQL Data Warehouse

Lab : Using Business Intelligence Tools
After completing this module, you will be able to:
Describe at a high level business intelligence
Show an understanding of reporting
Show an understanding of data analysis
Analyze data with Azure SQL data warehouse

 

Lignende kurser

MCSA: BI Reporting (70-779 & 70-778) 13 maj
MCSA SQL Server 2016 Business Intelligence Development (70-767 & 70-768) 25 mar
Performance Tuning and Optimizing SQL Databases (10987) 25 mar
Provisioning SQL Databases MOC 20765 (70-765) 08 apr
Data Analysis Fundamentals using Excel (MOC 10994) Skriv dig op som interesseret til dette kursus