Microsoft

Sort By:  
Administering Microsoft® SQL Server® Databases (Administering SQL Server 2014 )

COURSE OVERVIEW

This course provides students with the knowledge and skills to maintain a Microsoft SQL Server 2014 database. The course focuses on teaching individuals how to use SQL Server 2014 product features and tools related to maintaining a database. Note: This course is designed for customers who are interested in learning SQL Server 2012 or SQL Server 2014.  It covers the new features in SQL Server 2014, but also the important capabilities across the SQL Server data platform.

TARGET AUDIENCE

The primary audience for this course is individuals who administer and maintain SQL Server databases. These individuals perform database administration and maintenance as their primary area of responsibility, or work in environments where databases play a key role in their primary job. The secondary audience for this course is individuals who develop applications that deliver content from SQL Server databases.

COURSE OBJECTIVES

  • Describe core database administration tasks and tools.
  • Install and configure SQL Server 2014.
  • Configure SQL Server databases and storage.
  • Plan and implement a backup strategy.
  • Restore databases from backups.
  • Import and export data.
  • Monitor SQL Server.
  • Trace SQL Server activity.
  • Manage SQL Server security.
  • Audit data access and encrypt data.
  • Perform ongoing database maintenance.
  • Automate SQL Server maintenance with SQL Server Agent Jobs.
  • Configure Database Mail, alerts and notifications.

COURSE CONTENT

  • Module 1:
  • Introduction to SQL Server 2014 Database Administration
  • Database Administration Overview
  • Introduction to the SQL Server Platform
  • Database Management Tools and Techniques
  • Lab : Using SQL Server Administrative Tools
  • Using SQL Server Management Studio
  • Using the sqlcmd Utility
  • Using Windows PowerShell with SQL Server

  • Module 2:
  • Installing and Configuring SQL Server 2014
  • Planning SQL Server Installation
  • Installing SQL Server 2014
  • Post-Installation Configuration
  • Lab : Installing SQL Server 2014
  • Preparing to Install SQL Server
  • Installing SQL Server
  • Performing Post-Installation Configuration

  • Module 3:
  • Working with Databases and Storage
  • Introduction to Data Storage with SQL Server
  • Managing Storage for System Databases
  • Managing Storage for User Databases
  • Moving Database Files
  • Configuring the Buffer Pool Extension
  • Lab : Managing Database Storage
  • Configuring tempdb Storage
  • Creating Databases
  • Attaching a Database

  • Module 4:
  • Planning and Implementing a Backup Strategy
  • Understanding SQL Server Recovery Models
  • Planning a Backup StrategyBacking up Databases and Transaction Logs
  • Using Backup Options
  • Ensuring Backup Reliability
  • Lab : Backing Up SQL Server Databases
  • Backing Up Database
  • Performing Database, Differential, and Transaction Log Backups
  • Performing a Partial Backup

  • Module 5:
  • Restoring SQL Server 2014 Databases
  • Understanding the Restore Process
  • Restoring Databases
  • Advanced Restore Scenarios
  • Working with Point-in-Time Recovery
  • Lab : Restoring SQL Server Databases
  • Restoring a Database BackupRestoring Database, Differential, and Transaction Log Backups
  • Performing a Piecemeal Restore

  • Module 6:
  • Importing and Exporting Data
  • Introduction to Transferring Data
  • Importing and Exporting Table Data
  • Copying or Moving a Database
  • Lab : Importing and Exporting Data
  • Using the SQL Server Import and Export Wizard
  • Using the bcp Utility
  • Using the BULK INSERT Statement
  • Using the OPENROWSET Function

  •  Module 7:
  • Monitoring SQL Server 2014
  • Introduction to Monitoring SQL Server
  • Dynamic Management Views and Functions
  • Performance Monitor
  • Lab : Monitoring SQL Server 2014
  • Collecting Baseline Metrics
  • Monitoring a Workload

  • Module 8:
  • Tracing SQL Server Activity
  • Tracing SQL Server Workload Activity
  • Using Traces
  • Lab : Tracing SQL Server Workload Activity
  • Capturing a Trace in SQL Server Profiler
  • Generating Database Tuning Recommendations
  • Using SQL Trace

  • Module 9:
  • Managing SQL Server Security
  • Introduction to SQL Server Security
  • Managing Server-Level Security
  • Managing Database-Level Principals
  • Managing Database PermissionsLab : Managing SQL Server Security
  • Managing Server-Level Security
  • Managing Database-Level Security
  • Testing Database Access

  • Module 10:
  • Auditing Data Access and Encrypting Data
  • Auditing Data Access in SQL Server
  • Implementing SQL Server Audit
  • Encrypting Databases
  • Lab : Auditing Data Access and Encrypting Data
  • Implementing Auditing
  • Implementing Transparent Database Encryption

  • Module 11:
  • Performing Ongoing Database Maintenance
  • Ensuring Database Integrity
  • Maintaining Indexes
  • Automating Routine Database Maintenance
  • Lab : Performing Ongoing Database Maintenance
  • Managing Database Integrity
  • Managing Index Fragmentation
  • Implementing a Maintenance Plan

  • Module 12:
  • Automating SQL Server 2014 Management
  • Automating SQL Server Management
  • Implementing SQL Server Agent Jobs
  • Managing SQL Server Agent Jobs
  • Managing Job Step Security Contexts
  • Managing Jobs on Multiple Servers
  • Lab : Automating SQL Server Management
  • Creating a Job
  • Scheduling a Job
  • Configuring Job Step Security Contexts

  • Module 13:
  • Monitoring SQL Server 2014 by Using Alerts and Notifications
  • Monitoring SQL Server Errors
  • Configuring Database Mail
  • Configuring Operators, Alerts, and Notifications
  • Lab : Monitoring SQL Server by Using Alerts and Notifications
  • Configuring Database Mail
  • Implementing Operators and Notifications
  • Implementing Alerts

COURSE PREREQUISITES

  • This course requires that you meet the following prerequisites:
  • Basic knowledge of the Microsoft Windows operating system and its core functionality.
  • Working knowledge of Transact-SQL.
  • Working knowledge of relational databases.
  • Some experience with database design.
  • Students who attend this training can meet the prerequisites by attending the following courses, or obtaining equivalent knowledge and skills:
  • 20461C: Querying Microsoft SQL Server 2014

Schedule for Administering Microsoft SQL Server 2014 Databases Training
CourseExam
Administering Microsoft SQL Server 2014 Databases70-462

2 Hours Daily 3 Times a Week

Total Duration 6 Months

₵2,200.00
Introduction to Microsoft Excel 2013 (Microsoft Excel 2013)
Overview

About this course

In this Introduction to Microsoft Excel 2013 training class, students will create and edit basic worksheets and workbooks. This course is designed for students who want to gain the necessary skills to create, edit, format, and print basic Microsoft Excel 2013 worksheets. This course helps prepare students to take the MOS: Microsoft Office Excel 2013 certification exam 420.

Audience profile

Students who have little or no familiarity with Microsoft Excel 2013 or more experienced Excel users who want to learn the topics covered in this course in the 2013 interface.

At course completion

  • Create basic worksheets using Microsoft Excel 2013.
  • Perform calculations in an Excel worksheet.
  • Modify an Excel worksheet.
  • Modify the appearance of data within a worksheet.
  • Manage Excel workbooks.
  • Print the content of an Excel worksheet.

Course Outline

Module 1: Creating a Microsoft Excel Workbook
This module explains how to get started creating Microsoft Excel workbooks.

Lessons

  • Starting Microsoft Excel
  • Creating a Workbook
  • Saving a Workbook
  • The Status Bar
  • Adding and Deleting Worksheets
  • Copying and Moving Worksheets
  • Changing the Order of Worksheets
  • Splitting the Worksheet Window
  • Closing a Workbook


Lab : Creating a Microsoft Excel Workbook

  • Start Microsoft Excel.
  • Create a Microsoft Excel workbook.
  • Save a Microsoft Excel workbook.
  • Work with the Status Bar.
  • Add and delete Microsoft Excel worksheets.
  • Copy and move worksheets.
  • Split the worksheet window.
  • Close a Microsoft Excel workbook.


Module 2: The Ribbon
The Ribbon is the display you see at the top of the Microsoft Excel window. It is your primary interface with Excel. It allows you to access most of the commands available to you in Excel. The Ribbon is composed of three parts: Tabs, Groups and Commands. In this lesson, you will learn about all three.

Lessons

  • Tabs
  • Groups
  • Commands


Lab : Exploring the Ribbon

  • Work with tabs.
  • Work with groups.
  • Work with commands.
  • Understand which groups and commands are found on which tabs.


Module 3: The Backstage View (The File Menu)
This module explains how to work with the Backstage View (The File Menu).

Lessons

  • Introduction to the Backstage View
  • Opening a Workbook
  • New Workbooks and Excel Templates
  • Printing Worksheets
  • Adding Your Name to Microsoft Excel
  • Managing Workbook Versions


Lab : Exercises in This Lesson

  • Open a Microsoft Excel workbook.
  • Start a new Microsoft Excel workbook.
  • Use Microsoft Excel templates.
  • Print a Microsoft Excel workbook.
  • Personalize your copy of Microsoft Excel.


Module 4: The Quick Access Toolbar
This module explains how to work with the Quick Access Toolbar.

Lessons

  • Adding Common Commands
  • Adding Additional Commands with the Customize Dialog Box
  • Adding Ribbon Commands or Groups
  • Placement


Lab : Customize the Quick Access Toolbar

  • Add common commands to the Quick Access Toolbar.
  • Add additional commands to the Quick Access Toolbar.
  • Move the Quick Access Toolbar.


Module 5: Entering Data in Microsoft Excel Worksheets
This module explains how to enter data.

Lessons

  • Entering Text
  • Expand Data across Columns
  • Adding and Deleting Cells
  • Adding an Outline
  • Adding a Hyperlink
  • Add WordArt to a Worksheet
  • Using AutoComplete
  • Entering Numbers and Dates
  • Using the Fill Handle


Lab : Exercises in This Lesson

  • Enter text in Microsoft Excel worksheets.
  • Add or delete cells in worksheets.
  • Add an outline for your data.
  • Enter a hyperlink in a worksheet.
  • Use AutoComplete.
  • Enter numbers and dates in Microsoft Excel worksheets.
  • Use the Fill Handle to add data to cells.


Module 6: Formatting Microsoft Excel Worksheets
This module explains how to format Microsoft Excel Worksheets.

Lessons

  • Selecting Ranges of Cells
  • Hiding Worksheets
  • Adding Color to Worksheet Tabs
  • Adding Themes to Workbooks
  • Adding a Watermark
  • The Font Group
  • The Alignment Group
  • The Number Group


Lab : Exercises in This Lesson

  • Understand the various ways you can format Microsoft Excel worksheets.
  • Select a range of cells within a worksheet.
  • Hide worksheets.
  • Add color to workbook tabs.
  • Add themes to worksheets.
  • Add bold, italics, and underlining to text.
  • Add borders to cells.
  • Change text and cell colors.
  • Change the font and font size.
  • Align text.
  • Wrap text.
  • Indent text.
  • Merge and center text.
  • Change number formats.
  • Change date formats.
  • Show decimals.


Module 7: Using Formulas in Microsoft Excel
This is the math lesson, and whether you love or hate math, by the end of this lesson you will agree that Excel makes math easy. We will start by explaining some of the basic concepts you need to understand regarding how Excel does math and then will get into entering formulas.

Lessons

  • Math Operators and the Order of Operations
  • Entering Formulas
  • AutoSum (and Other Common Auto-Formulas)
  • Copying Formulas and Functions
  • Relative, Absolute, and Mixed Cell References


Lab : Working with Formulas

  • Use math operators and the order of operations.
  • Enter basic formulas.
  • Use AutoSum to sum data with one click.
  • Use absolute, relative, and mixed cell references.
  • Copy formulas and functions.


Module 8: Working with Rows and Columns
This module explains how to work with rows and columns.

Lessons

  • Inserting Rows and Columns
  • Deleting Rows and Columns
  • Transposing Rows and Columns
  • Setting Row Height and Column Width
  • Hiding and Unhiding Rows and Columns
  • Freezing Panes


Lab : Working with Rows and Columns

  • Insert rows and columns in Microsoft Excel worksheets.
  • Delete rows and columns in Microsoft Excel worksheets.
  • Transpose rows and columns.
  • Change row heights.
  • Change column widths.
  • Hide and unhide rows and columns.
  • Freeze panes.


Module 9: Editing Worksheets
This module explains how to edit worksheets.

Lessons

  • Find
  • Find and Replace
  • Using the Clipboard
  • Managing Comments


Lab : Exercises in This Lesson

  • Locate information in your worksheet using Find.
  • Use Find and Replace to quickly replace data with other data.
  • Use the Cut, Copy, Paste, and Format Painter commands to edit worksheets.


Module 10: Finalizing Microsoft Excel Worksheets
This module explains how to finalize Microsoft Excel Worksheets.

Lessons

  • Setting Margins
  • Setting Page Orientation
  • Setting the Print Area
  • Print Scaling (Fit Sheet on One Page)
  • Printing Headings on Each Page/Repeating Headers and Footers
  • Headers and Footers


Lab : Preparing to Print

  • Set margins in Microsoft Excel worksheets.
  • Set the page orientation to portrait or landscape.
  • Set the print area in a worksheet.
  • Scale a worksheet so that all data prints on one page.
  • Add headers and footers to a worksheet.


Module 11: Microsoft Excel 2013 New Features
Excel 2013 provides some new features to make working with spreadsheets easier and more efficient.

Lessons

  • One Workbook Per Window Feature
  • Using Flash Fill


Lab : Using Flash Fill

  • Learn about the one workbook per window feature.
  • Learn how to use Flash Fill.

Target Audience

 JHS And SHS or Above


Prerequisites

Before attending this course, students must have:

  • Familiarity with using a personal computer, mouse, and keyboard.
  • Comfortable in the Windows environment.
  • Ability to launch and close programs; navigate to information stored on the computer; and manage files and folders.


Price Includes International Curriculum Courseware And Very Active Real-Time Labs.

Introduction to Microsoft Excel 2013: Course Content / Exam(s)

Schedule for Introduction to Microsoft Excel 2013
Course#Course ContentsExam#Exam
Course 55130AIntroduction to Microsoft Excel 2013420Introduction to Microsoft Excel 2013

2 Hours Daily 3 Times a Week

Total Duration 3 Months

 Our Services

₵1,200.00
Microsoft Office 2013 (MS Office 2013)

SkyWatch Technology Institute offers a course on Microsoft Office 2013, which is a software package for the Microsoft Windows operating system. The Office 2013 course includes MS Word, MS Excel, MS PowerPoint, MS Outlook and MS Access. With Office 2013, students will be able to share files easily. Students will also get to insert and format Graphics in Word 2013.

Schedule for Microsoft Office 2013 Training Boot Camp
Course ContentsExam
Microsoft Office Word 201377-418
Microsoft Office Excel 201377-420
Microsoft Office PowerPoint 201377-422
Microsoft Office Outlook 201377-423
Microsoft Office Access 201377-424
Total

2 Hours Daily 3 Times a Week

Total Duration 4 Months


Prerequisites

Before attending this course, students need to have:

  • Basic computer skills
  • Hands-on experience in creating and managing documents, spreadsheets, presentations, tables and emails.
Recommended Courses and Certification:
  • Advanced Excel 2013
₵1,400.00
Introduction to Microsoft Excel 2016 (Microsoft Excel 2016)
Overview

About this course

In this Introduction to Microsoft Excel 2016 training course, students will create and edit basic worksheets and workbooks. This course is designed for students who want to gain the necessary skills to create, edit, format, and print basic Microsoft Excel 2016 worksheets.

Audience profile

This course is intended for students who have little or no familiarity with Microsoft Excel 2016 or more experienced Excel users who want to learn the topics covered in this course in the 2016 interface.

After course completion

After completing this course, students will be able to:

  • Create basic worksheets using Microsoft Excel 2016.
  • Perform calculations in an Excel worksheet.
  • Modify an Excel worksheet.
  • Modify the appearance of data within a worksheet.
  • Manage Excel workbooks.
  • Print the content of an Excel worksheet.
  • Learn how to use handy features new in 2016.

Course Outline
Module 1: Creating a Microsoft Excel Workbook
This module explains how to create workbooks in Microsoft Excel.

Lessons

  • Starting Microsoft Excel
  • Creating a Workbook
  • Saving a Workbook
  • The Status Bar
  • Adding and Deleting Worksheets
  • Copying and Moving Worksheets
  • Changing the Order of Worksheets
  • Splitting the Worksheet Window
  • Closing a Workbook

Lab : Creating a Microsoft Excel Workbook

  • Creating a Microsoft Excel Workbook

After completing this module, students will be able to:

  • Start Microsoft Excel.
  • Create a Microsoft Excel workbook.
  • Save a Microsoft Excel workbook.
  • Add and delete Microsoft Excel worksheets.
  • Copy and move worksheets.
  • Split the worksheet window.
  • Close a Microsoft Excel workbook.

Module 2: The Ribbon
This module explains how to work with the Ribbon.

Lessons

  • Tabs
  • Groups
  • Commands

Lab : Exploring the Ribbon

  • Exploring the Ribbon

After completing this module, students will be able to:

  • Work with tabs.
  • Work with groups.
  • Work with commands.
  • Understand which groups and commands are found on which tabs.

Module 3: The Backstage View (The File Menu)
This module explains how to work with the Backstage View aka the File menu.

Lessons

  • Introduction to the Backstage View
  • Opening a Workbook
  • New Workbooks and Excel Templates
  • Printing Worksheets
  • Adding Your Name to Microsoft Excel
  • Managing Workbook Versions

Lab : The Backstage View (The File Menu)

  • Open a Workbook
  • Select, Open and Save a Template Agenda
  • Print a Worksheet

After completing this module, students will be able to:

  • Open a Microsoft Excel workbook.
  • Start a new Microsoft Excel workbook.
  • Use Microsoft Excel templates.
  • Print a Microsoft Excel workbook.
  • Personalize your copy of Microsoft Excel.

Module 4: The Quick Access Toolbar
This module explains how to work with the Quick Access Toolbar.

Lessons

  • Adding Common Commands
  • Adding Additional Commands with the Customize Dialog Box
  • Adding Ribbon Commands or Groups
  • Placement

Lab : The Quick Access Toolbar

  • Customize the Quick Access Toolbar

After completing this module, students will be able to:

  • Add common commands to the Quick Access Toolbar.
  • Add additional commands to the Quick Access Toolbar.
  • Move the Quick Access Toolbar.

Module 5: Entering Data in Microsoft Excel Worksheets
This module explains how to how to enter data in Excel worksheets.

Lessons

  • Entering Text
  • Expand Data across Columns
  • Adding and Deleting Cells
  • Adding an Outline
  • Adding a Hyperlink
  • Add WordArt to a Worksheet
  • Using AutoComplete
  • Entering Numbers and Dates
  • Using the Fill Handle

Lab : Entering Data in Microsoft Excel Worksheets

  • Entering Text and Using AutoComplete
  • Entering Numbers and Dates

After completing this module, students will be able to:

  • Enter text in Microsoft Excel worksheets.
  • Add or delete cells in worksheets.
  • Add an outline for your data.
  • Enter a hyperlink in a worksheet.
  • Use AutoComplete.
  • Enter numbers and dates in Microsoft Excel worksheets.
  • Use the Fill Handle to add data to cells.

Module 6: Formatting Microsoft Excel Worksheets
This module explains how to format Excel worksheets.

Lessons

  • Hiding Worksheets
  • Adding Color to Worksheet Tabs
  • Adding Themes to Workbooks
  • Adding a Watermark
  • The Font Group
  • The Alignment Group
  • The Number Group

Lab : Formatting Microsoft Excel Worksheets

  • Customize a Workbook Using Tab Colors and Themes
  • Working with Font Group Commands
  • Working with Alignment Group Commands
  • Working with Number Group Commands

After completing this module, students will be able to:

  • Select a range of cells within a worksheet.
  • Hide worksheets.
  • Add color to workbook tabs.
  • Add themes to worksheets.
  • Apply bold, italics, and underlining to text.
  • Add borders to cells.
  • Change text and cell colors.
  • Change the font and font size.
  • Align text.
  • Wrap text.
  • Indent text.
  • Merge and center text.
  • Change number formats.
  • Change date formats.

Module 7: Using Formulas in Microsoft Excel
This module explains how to use formulas in Excel.

Lessons

  • Math Operators and the Order of Operations
  • Entering Formulas
  • AutoSum (and Other Common Auto-Formulas)
  • Copying Formulas and Functions
  • Relative, Absolute, and Mixed Cell References

Lab : Using Formulas in Microsoft Excel

  • Working with Formulas

After completing this module, students will be able to:

  • Enter basic formulas.
  • Use AutoSum to sum data with one click.
  • Understand absolute, relative, and mixed cell references.
  • Copy formulas and functions.

Module 8: Working with Rows and Columns
This module explains how to work with rows and columns.

Lessons

  • Insert lesson titles in a bulleted list.
  • Inserting Rows and Columns
  • Deleting Rows and Columns
  • Transposing Rows and Columns
  • Setting Row Height and Column Width
  • Hiding and Unhiding Rows and Columns
  • Freezing Panes

Lab : Working with Rows and Columns

  • Working with Rows and Columns
  • After completing this module, students will be able to:
  • Insert rows and columns in Microsoft Excel worksheets.
  • Delete rows and columns in Microsoft Excel worksheets.
  • Transpose rows and columns.
  • Change row heights.
  • Change column widths.
  • Hide and unhide rows and columns.
  • Freeze panes

Module 9: Editing Worksheets
This module explains how to edit worksheets.

Lessons

  • Find
  • Find and Replace
  • Using the Clipboard
  • Managing Comments

Lab : Editing Worksheets

  • Using Find and Replace
  • Using the Clipboard

After completing this module, students will be able to:

  • Locate information in your worksheet using Find.
  • Use Find and Replace to quickly replace data with other data.
  • Use the Cut, Copy, Paste and Format Painter commands to edit worksheets.
  • Manage comments.

Module 10: Finalizing Microsoft Excel Worksheets
This module explains how to finalize worksheets.

Lessons

  • Setting Margins
  • Setting Page Orientation
  • Setting the Print Area
  • Print Scaling (Fit Sheet on One Page)
  • Printing Headings on Each Page/Repeating Headers and Footers
  • Headers and Footers

Lab : Finalizing Microsoft Excel Worksheets

  • Preparing to Print

After completing this module, students will be able to:

  • Set margins in Microsoft Excel worksheets.
  • Set the page orientation to portrait or landscape.
  • Set the print area in a worksheet.
  • Scale a worksheet so that all data prints on one page.
  • Add headers and footers to a worksheet.

Module 11: Microsoft Excel Features that Were New in 2013
This module explains how to use some of the features that were new in the 2013 version of Excel.

Lessons

  • One Workbook Per Window Feature
  • Using Flash Fill

Lab : Microsoft Excel Features that Were New in 2013

  • Using Flash Fill

After completing this module, students will be able to:

  • Use the one workbook per window feature.
  • Use Flash Fill.

Module 12: Features New in 2016
This module explains how to use two new features in 2016.

Lessons

  • Tell Me
  • Smart Lookup

Lab : None

  • None

After completing this module, students will be able to:

  • Use the Tell Me feature.

Use the Smart Lookup feature.


Target Audience

 JHS And SHS or Above


Prerequisites

Before attending this course, students must have:

  • Experience installing PC hardware and devices.
  • Basic understanding of TCP/IP and networking concepts.
  • Basic Windows and Active Directory knowledge.
  • The skills to map network file shares.
  • Experience working from a command prompt.
  • Basic knowledge of the fundamentals of applications. For example, how client computer applications communicate with the server.
  • Basic understanding of security concepts such as authentication and authorization.
  • An understanding of the fundamental principles of using printers.



Price Includes International Curriculum Courseware And Very Active Real-Time Labs.

Introduction to Microsoft Excel 2016: Course Content / Exam(s)

Schedule for Introduction to Microsoft Excel 2016
Course#Course ContentsExam#Exam
Course 55165AIntroduction to Microsoft Excel 2016Introduction to Microsoft Excel 2016

2 Hours Daily 3 Times a Week

Total Duration 3 Months

 Our Services

₵1,200.00
Implementing a Data Warehouse with Microsoft SQL Server® (MCSA)

This course describes how to implement a data warehouse platform to support a BI solution. Students will learn how to create a data warehouse with Microsoft® SQL Server® 2014, implement ETL with SQL Server Integration Services, and validate and cleanse data with SQL Server Data Quality Services and SQL Server Master Data Services. Note: This course is designed for customers who are interested in learning SQL Server 2012 or SQL Server 2014. It covers the new features in SQL Server 2014, but also the important capabilities across the SQL Server data platform.

 

TARGET AUDIENCE

This course is intended for database professionals who need to fulfil a Business Intelligence Developer role.  They will need to focus on hands-on work creating BI solutions including Data Warehouse implementation, ETL, and data cleansing.

COURSE OBJECTIVES

  • Describe data warehouse concepts and architecture considerations.
  • Select an appropriate hardware platform for a data warehouse.
  • Design and implement a data warehouse.
  • Implement Data Flow in an SSIS Package.
  • Implement Control Flow in an SSIS Package.
  • Debug and Troubleshoot SSIS packages.
  • Implement an ETL solution that supports incremental data extraction.
  • Implement an ETL solution that supports incremental data loading.
  • Implement data cleansing by using Microsoft Data Quality Services.
  • Implement Master Data Services to enforce data integrity.
  • Extend SSIS with custom scripts and components.
  • Deploy and Configure SSIS packages.
  • Describe how BI solutions can consume data from the data warehouse.

COURSE CONTENT

  • Module 1: Introduction to Data Warehousing
  • Overview of Data Warehousing
  • Considerations for a Data Warehouse Solution
  • Lab : Exploring a Data Warehousing Solution
  • Module 2: Data Warehouse Hardware Considerations
  • Considerations for building a Data Warehouse
  • Data Warehouse Reference Architectures and Appliances
  • Lab : Planning Data Warehouse Infrastructure
  • Module 3: Designing and Implementing a Data Warehouse
  • Logical Design for a Data Warehouse
  • Physical design for a data warehouse
  • Lab : Implementing a Data Warehouse Schema
  • Module 4: Creating an ETL Solution with SSIS
  • Introduction to ETL with SSIS
  • Exploring Data Sources
  • Implementing Data Flow
  • Lab : Implementing Data Flow in an SSIS Package
  • Module 5: Implementing Control Flow in an SSIS Package
  • Introduction to Control Flow
  • Creating Dynamic Packages
  • Using Containers
  • Managing Consistency
  • Lab : Implementing Control Flow in an SSIS Package
  • Lab : Using Transactions and Checkpoints
  • Module 6: Debugging and Troubleshooting SSIS Packages
  • Debugging an SSIS Package
  • Logging SSIS Package Events
  • Handling Errors in an SSIS Package
  • Lab : Debugging and Troubleshooting an SSIS Package
  • Module 7: Implementing an Incremental ETL Process
  • Introduction to Incremental ETL
  • Extracting Modified Data
  • Loading Modified data
  • Lab : Extracting Modified DataLab : Loading Incremental Changes
  • Module 8: Enforcing Data Quality
  • Introduction to Data Quality
  • Using Data Quality Services to Cleanse Data
  • Using Data Quality Services to Match data
  • Lab : Cleansing DataLab : De-duplicating data
  • Module 9: Using Master Data Services
  • Master Data Services Concepts
  • Implementing a Master Data Services Model
  • Managing Master Data
  • Creating a Master Data Hub
  • Lab : Implementing Master Data Services
  • Module 10: Extending SQL Server Integration Services
  • Using Scripts in SSIS
  • Using Custom Components in SSIS
  • Lab : Using Custom Components and Scripts
  • Module 11: Deploying and Configuring SSIS Packages
  • Overview of SSIS Deployment
  • Deploying SSIS Projects
  • Planning SSIS Package Execution
  • Lab : Deploying and Configuring SSIS Packages
  • Module 12: Consuming Data in a Data Warehouse
  • Introduction to Business Intelligence
  • Introduction to Reporting
  • An Introduction to Data Analysis
  • Lab : Using Business Intelligence Tools

COURSE PREREQUISITES

This course requires that you meet the following prerequisites:

  • At least 2 years’ experience of working with relational databases, including:
  • Designing a normalized database.
  • Creating tables and relationships.
  • Querying with Transact-SQL.
  • Some exposure to basic programming constructs (such as looping and branching).

An awareness of key business priorities such as revenue, profitability, and financial accounting is desirable.

Price Includes International Curriculum Courseware And Very Active Real-Time Labs.

Implementing a Data Warehouse with Microsoft SQL Server Content / Exam(s)

Schedule for Implementing a Data Warehouse with Microsoft SQL Server
Course#Course ContentsExam#
20463DImplementing a Data Warehouse with Microsoft SQL Server70-463

2 Hours Daily 3 Times a Week

Total Duration 3 Months

₵1,500.00
MCSA: Windows Server 2016 Training & Certification Courses (MCSA 2016)

Overview

The MCSA: Windows Server 2016 Training and Certification Course is an intermediate level certification that enables candidates to monitor and manage Windows Server 2016 operating system, client-server structure, network infrastructure, virtualization, domain management and security implementation, among others. The course provides a variety of hands-on lab training and allows candidates to control and manage multiple servers and clients simultaneously. This course is the first step towards your path to becoming a Microsoft Certified Solutions Expert (MCSE).

Audience:  Earning this MCSA certification will help entry-level IT personnel to make a mark in the industry as a network or computer systems administrator or as a computer network specialist. The MCSA windows server 2016 certification course is recommended for the following professionals:-

  • Network Administrators
  • Computer Network Specialist
  • Computer Support Specialist
  • Windows Server Administrators

Windows Server 2016: MCSA Course Objectives

Upon completion of the course, you will be able to:

  • Installation, Storage, and Compute with Windows Server 2016
  • Networking with Windows Server 2016
  • Identity with Windows Server 2016
  • Install and configure Windows Server 2016
  • Install Nano Server and be able to update and implement the migration strategy
  • Implement data deduplication
  • Implement Active Directory Federation Services (AD FS)
  • Explain various stage options
  • Understand how to manage disks and volumes
  • Explain enterprise storage solutions and implement the appropriate solution to given situations
  • Execute remote access
  • Install and configure Microsoft Hyper-V
  • Manage Windows and Hyper-V containers
  • Understand disaster recovery technologies in Windows Server 2016
  • Plan, create and execute a failover cluster
  • Configure and implement Network Load Balancing (NLB)
  • Manage virtual machine installations

Price Includes International Curriculum Courseware And Very Active Real-Time Labs.

Windows Server 2016: MCSA Course Content / Exam(s)

Schedule for MCSA: Windows Server 2016
Course#Course ContentsExam#
20740CInstallation, Storage, and Compute with Windows Server 201670-740
20741BNetworking with Windows Server 201670-741
20742BIdentity with Windows Server 201670-742

2 Hours Daily 3 Times a Week

Total Duration 4 Months

Prerequisites

A strong working knowledge of:
  • CompTIA N+ certification knowledge
  • CompTIA A+ certification knowledge
  • Have two years’ IT work experience and a possess a basic familiarity of Linux and/or Unix.
Recommended Courses and Certification:
₵2,000.00
Querying Microsoft SQL Server® (Querying SQL Server)

This 3 Months instructor led course provides students with the technical skills required to write basic Transact-SQL queries for Microsoft SQL Server 2014. This course is the foundation for all SQL Server-related disciplines; namely, Database Administration, Database Development and Business Intelligence. The main purpose of the course is to prepare people for the exam "70-461: Writing Queries Using Microsoft® SQL Server® 2014 Transact-SQL." This exam will be the underlying exam for all SQL Server-related disciplines; namely, Database Administration, Database Development and Business Intelligence. As such, the primary target audience for this course is: Database Administrators, Database Developers and BI professionals. Note: This course is designed for customers who are interested in learning SQL Server 2012 or SQL Server 2014. It covers the new features in SQL Server 2014, but also the important capabilities across the SQL Server data platform.


TARGET AUDIENCE

This course is intended for Database Administrators, Database Developers, and Business Intelligence professionals. The course will very likely be well attended by SQL power users who aren’t necessarily database-focused or plan on taking the exam; namely, report writers, business analysts and client application developers.

COURSE OBJECTIVES

  • Describe the basic architecture and concepts of Microsoft SQL Server 2014.
  • Understand the similarities and differences between Transact-SQL and other computer languages.
  • Write SELECT queries
  • Query multiple tables
  • Sort and filter data
  • Describe the use of data types in SQL Server
  • Modify data using Transact-SQL
  • Use built-in functions
  • Group and aggregate data
  • Use subqueries
  • Use table expressions
  • Use set operators
  • Use window ranking, offset and aggregate functions
  • Implement pivoting and grouping sets
  • Execute stored procedures
  • Program with T-SQL
  • Implement error handling
  • Implement transactions

COURSE CONTENT

  • Module 1: Introduction to Microsoft SQL Server 2014
  • The Basic Architecture of SQL Server
  • SQL Server Editions and Versions
  • Getting Started with SQL Server Management Studio
  • Lab : Working with SQL Server 2014 Tools

  • Module 2: Introduction to T-SQL Querying
  • Introducing T-SQL
  • Understanding Sets
  • Understanding Predicate Logic
  • Understanding the Logical Order of Operations in SELECT statements
  • Lab : Introduction to Transact-SQL Querying

  • Module 3: Writing SELECT Queries
  • Writing Simple SELECT Statements
  • Eliminate Duplicates with DISTINCT
  • Using Column and Table Aliases
  • Write Simple CASE Expressions
  • Lab : Writing Basic SELECT Statements

  • Module 4: Querying Multiple Tables
  • Understanding Joins
  • Querying with Inner Joins
  • Querying with Outer Joins
  • Querying with Cross Joins and Self Joins
  • Lab : Querying Multiple Tables

  • Module 5: Sorting and Filtering Data
  • Sorting Data
  • Filtering Data with Predicates
  • Filtering with the TOP and OFFSET-FETCH
  • Working with Unknown Values
  • Lab : Sorting and Filtering Data

  • Module 6: Working with SQL Server 2014 Data Types
  • Introducing SQL Server 2014 Data Types
  • Working with Character Data
  • Working with Date and Time Data
  • Lab : Working with SQL Server 2014 Data Types

  • Module 7: Using DML to Modify Data
  • Inserting Data
  • Modifying and Deleting Data
  • Lab : Using DML to Modify Data

  • Module 8: Using Built-In Functions
  • Writing Queries with Built-In Functions
  • Using Conversion Functions
  • Using Logical Functions
  • Using Functions to Work with NULL
  • Lab : Using Built-In Functions

  • Module 9: Grouping and Aggregating Data
  • Using Aggregate Functions
  • Using the GROUP BY Clause
  • Filtering Groups with HAVING
  • Lab : Grouping and Aggregating Data

  • Module 10: Using Subqueries
  • Writing Self-Contained Subqueries
  • Writing Correlated Subqueries
  • Using the EXISTS Predicate with Subqueries
  • Lab : Using Subqueries

  • Module 11: Using Table Expressions
  • Using Views
  • Using Inline Table-Valued Functions
  • Using Derived Tables
  • Using Common Table Expressions
  • Lab : Using Table Expressions

  • Module 12: Using Set Operators
  • Writing Queries with the UNION Operator
  • Using EXCEPT and INTERSECT
  • Using APPLY
  • Lab : Using Set Operators

  • Module 13: Using Window Ranking, Offset, and Aggregate Functions
  • Creating Windows with OVER
  • Exploring Window Functions
  • Lab : Using Window Ranking, Offset and Aggregate Functions

  • Module 14: Pivoting and Grouping Sets
  • Writing Queries with PIVOT and UNPIVOT
  • Working with Grouping Sets
  • Lab : Pivoting and Grouping Sets

  • Module 15: Querying data with Stored Procedures
  • Writing Queries with PIVOT and UNPIVOT
  • Passing Parameters to Stored Procedures
  • Creating Simple Stored Procedures
  • Working with Dynamic SQL
  • Lab : Executing Stored Procedures

  • Module 16: Programming with T-SQL
  • T-SQL Programming Elements
  • Controlling Program Flow
  • Lab : Programming with T-SQL

  • Module 17: Implementing Error Handling
  • Using TRY / CATCH Blocks
  • Working with Error Information
  • Lab : Implementing Error Handling

  • Module 18: Implementing Transactions
  • Transactions and the Database Engine
  • Controlling Transactions
  • Lab : Implementing Transactions

  • Module 19: Appendix 1: Improving Query Performance
  • Factors in Query Performance
  • Displaying Query Performance Data
  • Lab : Improving Query Performance

  • Module 20: Appendix 2: Querying SQL Server Metadata
  • Querying System Catalog Views and Functions
  • Executing System Stored Procedures
  • Querying Dynamic Management Objects
  • Lab : Querying SQL Server Metadata

COURSE PREREQUISITES

  • Working knowledge of relational databases.
  • Basic knowledge of the Microsoft Windows operating system and its core functionality

Price Includes International Curriculum Courseware And Very Active Real-Time Labs.

2 Hours Daily 3 Times a Week

Total Duration 4 Months


₵1,800.00
Microsoft Certified: Data Analyst Associate (Microsoft Certified: Data Analyst Associate)

Microsoft Certified: Data Analyst Associate

Data Analysts enable businesses to maximize the value of their data assets by using Microsoft Power BI.
As a subject matter expert, Data Analysts are responsible for designing and building scalable data models, cleaning and transforming data, and enabling advanced analytic capabilities that provide meaningful business value through easy-to-comprehend data visualizations.


Note: This certification will not be available until April 2, 2020. This information is not final and there may be minor changes once the certification is released.

Job role: Data Analyst

Required exams: DA-100

 

Skills measured

  • Prepare the data
  • Model the data
  • Visualize the data
  • Analyze the data
  • Deploy and maintain deliverables


NOTE: The bullets that appear below each of the skills measured are intended to illustrate how
we are assessing that skill. This list is not definitive or exhaustive.

NOTE: In most cases, exams do NOT cover preview features, and some features will only be
added to an exam when they are GA (General Availability).

Prepare the Data

Get data from different data sources

  • identify and connect to a data source
  • change data source settings
  • select a shared dataset or create a local dataset
  • select a storage mode
  • choose an appropriate query type
  • identify query performance issues
  • use the Common Data Service (CDS)
  • use parameters

Profile the data

  • identify data anomalies
  • examine data structures
  • interrogate column properties
  • interrogate data statistics

Clean, transform, and load the data

  • resolve inconsistencies, unexpected or null values, and data quality issues
  • apply user-friendly value replacements
  • identify and create appropriate keys for joins
  • evaluate and transform column data types
  • apply data shape transformations to table structures
  • combine queries
  • apply user-friendly naming conventions to columns and queries
  • leverage Advanced Editor to modify Power Query M code
  • configure data loading
  • resolve data import errors

Microsoft Certified: Data Analyst Associate – Skills

Measured

 

NOTE: The bullets that appear below each of the skills measured are intended to illustrate how

we are assessing that skill. This list is not definitive or exhaustive.

NOTE: In most cases, exams do NOT cover preview features, and some features will only be

 

Model the Data

Design a data model

  • define the tables
  • configure table and column properties
  • define quick measures
  • flatten out a parent-child hierarchy
  • define role-playing dimensions
  • define a relationship's cardinality and cross-filter direction
  • design the data model to meet performance requirements
  • resolve many-to-many relationships
  • create a common date table
  • define the appropriate level of data granularity

Develop a data model

  • apply cross-filter direction and security filtering
  • create calculated tables
  • create hierarchies
  • create calculated columns
  • implement row-level security roles
  • set up the Q&A feature

Create measures by using DAX

  • use DAX to build complex measures
  • use CALCULATE to manipulate filters
  • implement Time Intelligence using DAX
  • replace numeric columns with measures
  • use basic statistical functions to enhance data
  • create semi-additive measures

Optimize model performance

  • remove unnecessary rows and columns
  • identify poorly performing measures, relationships, and visuals
  • improve cardinality levels by changing data types
  • improve cardinality levels through summarization
  • create and manage aggregations

Visualize the Data

Create reports

  • add visualization items to reports
  • choose an appropriate visualization type
  • format and configure visualizations
  • import a custom visual
  • configure conditional formatting
  • apply slicing and filtering
  • add an R or Python visual
  • configure the report page
  • design and configure for accessibility

Create dashboards

  • set mobile view
  • manage tiles on a dashboard
  • configure data alerts
  • use the Q&A feature
  • add a dashboard theme
  • pin a live report page to a dashboard
  • configure data classification

Enrich reports for usability

  • configure bookmarks
  • create custom tooltips
  • edit and configure interactions between visuals
  • configure navigation for a report
  • apply sorting
  • configure Sync Slicers
  • use the selection pane
  • use drillthrough and cross filter
  • drilldown into data using interactive visuals
  • export report data

Analyze the Data

Enhance reports to expose insights

  • apply conditional formatting
  • apply slicers and filters
  • perform top N analysis
  • explore statistical summary
  • use the Q&A visual
  • add a Quick Insights result to a report
  • create reference lines by using Analytics pane

  • use the Play Axis feature of a visualization

Perform advanced analysis

  • identify outliers
  • conduct Time Series analysis
  • use groupings and binnings
  • use the Key Influencers to explore dimensional variances
  • use the decomposition tree visual to break down a measure
  • apply AI Insights

Deploy and Maintain Deliverables

Manage datasets

  • configure a dataset scheduled refresh
  • configure row-level security group membership
  • providing access to datasets
  • configure incremental refresh settings
  • endorse a dataset

Create and manage workspaces

  • create and configure a workspace
  • recommend a development lifecycle strategy
  • assign workspace roles
  • configure and update a workspace app
  • publish, import, or update assets in a workspace

Certification exams

  • Exam DA-100: Analyzing Data with Microsoft Power BI (beta)

    Languages: English

    Retirement date: none

    This exam measures your ability to accomplish the following technical tasks: prepare the data; model the data; visualize the data; analyze the data; and deploy and maintain deliverables.


Price Includes International Curriculum Courseware And Very Active Real-Time Labs.

Recommended Courses and Certification:
₵1,700.00
MCSA: Windows Server 2012 R2 Certification Training (MCSA)

Windows Server 2012 R2 is the core of Microsoft's Cloud vision that integrates global scale cloud infrastructure into your enterprise IT.
MCSA Windows Server 2012 Training introduces users to various new capabilities in storage, networking, virtualization, VDI, information access, protection etc.
This MCSA certification will not only cover the essentials of the latest version of Windows Server, but also take you through its complete administration and advanced services.
Users will also gain in-depth knowledge of latest management tools available for performing post deployment tasks on Windows Server 2012 R2.

This MCSA certification allows participants to design, configure, implement and manage Windows Server deployments on desktops and devices in an enterprise environment. The skills learnt in this MCSA course will also help users reduce their IT costs and maximize business value. MCSA training is the first step towards earning the coveted MCSE credential.

Audience: This Windows Server 2012 Certification is ideal for professionals who wish to work as computer support specialists, network or system administrators, so that they can maximize business value and reduce IT costs.

Windows Server 2012: MCSA Course Objectives

  • Installing, configuring and implementing a Windows Server 2012 infrastructure
  • Implementing and administering Active Directory Domain Services
  • Incorporating identity management, federated services, rights management, certification services and business continuity.
  • Installing and configuring Desired State Configuration (DSC) for Windows Powershell
  • Implementing features such as IPv4, IPv6, DNS, DHCP, local storage, group policy etc.
  • Using Hyper-V to incorporate server virtualization
  • Managing User and service accounts in this Windows Server certification
  • Implementing Network Access Protection, Network Policy Server, encryption, and advanced auditing
  • Migrating roles from previous versions of Windows Server
  • Managing remote access, file services and updates
  • Implementing advanced services such as Dynamic Access Control, Network Load Balancing, Failover Clustering and disaster recovery.
  • Optimizing resource utilization by employing Features on Demand and configuring NIC teaming
Price Includes International Curriculum Courseware And Very Active Real-Time Labs.

Windows Server 2012: MCSA Course Content / Exam(s)

Schedule for MCSA: Windows Server 2012 R2
Course#Course ContentsExam#Exam
20410Installing and Configuring Windows Server 2012 R270-410Installing and Configuring Windows Server 2012 R2
20411Administering Windows Server 2012 R270-411Administering Windows Server 2012 R2
20412Configuring Advanced Windows Server 2012 Services R270-412Configuring Advanced Windows Server 2012 Services R2

2 Hours Daily 3 Times a Week

Total Duration 4 Months


Prerequisites

  • Ideally, you should have successfully completed the "CompTIA Network+ Support Skills" course and have around 24 months' experience of networking support or IT administration. It is not necessary that you pass the Network+ exam before completing Security+ certification, but it is recommended. Specifically, it is recommended that you have the following skills and knowledge before starting this course:

    • Know the function and basic features of the components of a PC.
    • Use Windows Server to create and manage files and use basic administrative features (Explorer, Control Panel, Server Manager, and Management Consoles).
    • Operate the Linux OS using basic command-line tools.
    • Know basic network terminology and functions (such as OSI Model, Topology, Ethernet, Wi-Fi, switches, routers).
    • Understand TCP/IP addressing, core protocols, and troubleshooting tools.
Recommended Courses and Certification:
₵1,700.00
Protecting Modern Desktops and Devices (MD-101T03-A)
Overview
About this course

Every day, more organizations are asking IT to support mobility in the workforce. Modern environments require the Desktop Administrator be able to manage and support phones, tablets, and computers, whether it be owned by the organization or personally owned by the employee. At the same time, IT must still be able to protect the data that these devices access.  In this course, the student will be introduced to the key concepts of security in modern management. This course covers authentication, identities, and access, as well as about how to protect these categories. The student will be introduced to Azure Active Directory and learn how to use Microsoft Intune to protect devices and data with compliance policies. Finally, this course will cover key capabilities of Azure Information Protection and Windows Defender Advanced Threat Protection and how to implement these capabilities.

Audience profile

The Modern Desktop Administrator deploys, configures, secures, manages, and monitors devices and client applications in an enterprise environment. Responsibilities include managing identity, access, policies, updates, and apps. The MDA collaborates with the M365 Enterprise Administrator to design and implement a device strategy that meets the business needs of a modern organization.

The Modern Desktop Administrator must be familiar with M365 workloads and must have strong skills and experience of deploying, configuring, and maintaining Windows 10 and non-Windows devices. The MDA role focuses on cloud services rather than on-premises management technologies.

At course completion

After completing this course, learners should be able to:

  • Describe the benefits and capabilities of Azure AD.
  • Manage users using Azure AD with Active Directory DS.
  • Implement Windows Hello for Business.
  • Configure conditional access rules based on compliance policies.
  • Describe the various tools used to secure devices and data.
  • Implement Windows Defender Advanced Threat Protection.

Course details
Course Outline

Module 1: Managing Authentication in Azure ADIn this module, students well be introduced to the concept of directory in the cloud with Azure AD. Students will learn the similarities and differences between Azure AD and Active Directory DS and how to synchronize between the two. Students will explore identity management in Azure AD and learn about identity protection using Windows Hello for Business, as well as Azure AD Identity Protection and multi-factor authentication. The module will conclude with securely accessing corporate resources and introduce concepts such as Always On VPN and remote connectivity in Windows 10.

Lessons
  • Azure AD Overview
  • Managing identities in Azure AD
  • Protecting identities in Azure AD
  • Managing device authentication
  • Enabling corporate access

Lab : Practice Lab - Managing objects and authentication in Azure AD
  • Enabling and configuring Azure AD Premium with Enterprise Mobility + Security (EMS) tenant
  • Creating user and group objects with UI and Windows PowerShell
  • Configuring Self-service password reset (SSPR) for user accounts in Azure AD
  • Joining a device to Azure AD
After completing this module, students will be able to:
  • Describe the capabilities of Azure AD.
  • Manage users using Azure AD with Active Directory DS.
  • Implement Windows Hello for Business.
  • Join devices to Azure AD.
  • Describe methods of enabling access from external networks.

Module 2: Managing Devices and Device Policies
In this module, students will be introduced to managing device security with Intune. Students will discover how Intune can use device profiles to manage configuration of devices to protect data on a device. Students will learn how to create and deploy compliance policies and use compliance policies for conditional access. The module concludes with monitoring devices enrolled in Intune.


Lessons
  • Microsoft Intune Overview
  • Managing devices with Intune
  • Implement device compliance policies

Lab : Practice Lab - Managing devices
  • Configuring Microsoft Intune for device management
  • Configuring compliance policies and device profiles
  • Enrolling Windows 10 devices and managing compliance

After completing this module, students will be able to:

  • Describe mobile device management with Intune.
  • Create and assign device profiles to protect data on devices.
  • Deploy compliance and conditional access policies.
  • Use Intune to monitor device compliance.

Module 3: Managing Security 
In this module, students will learn about data protection. Topics will include Windows & Azure Information Protection, and various encryption technologies supported in Windows 10. This module also covers key capabilities of Windows Defender Advanced Threat Protection and how to implement these capabilities on devices in your organization. The module concludes using Windows Defender and using functionalities such as antivirus, firewall and Credential Guard.

Lessons
  • Implement device data protection
  • Managing Windows Defender ATP
  • Managing Windows Defender in Windows 10

Lab : Practice Lab - Managing Security in Windows 10
  • Configuring Encrypting File System (EFS)
  • Configuring BitLocker
  • Configuring a WIP policy in Intune
  • Configuring Windows Defender


After completing this module, students will be able to:

  • Describe the methods protecting device data.
  • Describe the capabilities and benefits of Windows ATP
  • Deploy and manage settings for Windows Defender clients.

Module 4: Course Conclusion
Lessons
  • Final Exam

Lab : Graded Lab

Prerequisites

The Modern Desktop Administrator must be familiar with M365 workloads and must have strong skills and experience of deploying, configuring, and maintaining Windows 10 and non-Windows devices. The MDA role focuses on cloud services rather than on-premises management technologies.

Price Includes International Curriculum Courseware And Very Active Real-Time Labs.

Protecting Modern Desktops and Devices: Course Content / Exam(s)

2 Hours Daily 3 Times a week

Total Duration 3 Months

₵1,700.00
Per Page      1 - 10 of 10
  • 1