Click here to schedule your

free consultation

Microsoft

Overview Of MICROSOFT Certification Training Course

IT DIKSHA Will give you hands-on Training about all Microsoft Courses. IT DIKSHA Experienced Trainers will coach you with deep knowledge and provide corporate-level training.

Benefits of Taking the MICROSOFT Certification Courses

You should know that the scope of the MICROSOFT Courses from IT DIKSHA will help you to
  • Develop professional expertise.
  • Help you prepare for the upcoming IT professional job market trends.
  • Increase the visibility of your resume.
  • Validate your expertise and credibility.
  • Increase your earning potential.
  • Help expand your professional network.

Related job roles

Microsoft Server Support Engineer
Microsoft Server Architect
Microsoft Server system administrator
Microsoft Server system integration specialist
Microsoft Server infrastructure specialist
Microsoft Server consultant

Why Should You Learn MICROSOFT

  • The average salary of a Microsoft Engineer in India is Rs 8 Lakhs Per year
  • Entry-level positions start at Rs 4 Lacks per year
  • You are in demand – You can continue to work in India or pursue work overseas, Microsoft skills will be high on the list of priorities for organizations.
  • The pay is very good – Earning opportunities are endless because of the demand and need for good and skilled MICROSOFT Engineers.

Training Course

Certification

Job Roles

Prerequisites

Education should be Diploma in any discipline or any degree (BCom, BSc, BA, BE, etc…) and one Should have a basic knowledge of Windows 10 Usage. If you need to get more information about the course or learning benefits, kindly contact this number +91 8217557175

Microsoft Courses

Training and LAB Sessions will be provided in accordance with the specified modules or chapters.
After completing this training and receiving your OEM certification, you will be hired in the market.

Module 1: Deploying Exchange Server

Overview of Exchange Server
Exchange Server architecture
Requirements for Exchange Server
Deploying Exchange Server Exchange Server
Exchange Server Management Tools
Lab Deploying Exchange Server

Module 2: Managing Exchange Server 2016 storage

Exchange Server mailbox databases
Exchange Server storage
Configuring Exchange Server mailbox databases and storage
Lab : Configuring Exchange Server storage

Module 3: Managing recipient objects

Managing user mailboxes
Managing other types of mailboxes
Managing other recipients objects
Configuring policies and adress lists
Lab : Managing recipient objects
Lab : Configuring address lists and policies

Module 4: Managing recipients and
Exchange servers by using Exchange
Server cmdlets

Overview of the Exchange Management Shell
Managing Exchange Servers by using Exchange Management Shell cmdlets
Managing Exchange servers by using scripts
Lab : Managing Exchange Server and recipient objects by using Exchange Management Shell

Module 5: Implementing client
connectivity

Configuring client access services
Managing client access services
Client connectivity in Exchange Server
Configuring Outlook on the web
Configuring mobile messaging
Lab : Configuring client access services
Lab : Deploying and configuring client access services on Exchange Server

Module 6: Managing high availability
in Exchange Server

High availability on Exchange Server
Configuring highly available mailbox databases
Configuring high availability of Client Access services
Lab : Implementing DAGs
Lab : Implementing and testing high availability

Module 7: Implementing disaster
recovery for Exchange Server

Implementing Exchange Server backup
Implementing Exchange Server recovery
Lab : Backing up Exchange Server data
Lab : Restoring Exchange Server data

Module 8: Configuring and managing
message transport

Overview of message transport
Configuring message transport
Managing transport rules
Lab : Configuring and managing message transport

Module 9: Configuring message security

Deploying and managing an Edge Transport server for message security
Implementing an antivirus solution for Exchange Server
Implementing an antispam solution for Exchange Server
Lab : Configuring message security in Exchange Server

Module 10: Monitoring and troubleshooting
Exchange Server

Monitoring Exchange Server
Troubleshooting Exchange Server
Lab : Monitoring and troubleshooting Exchange Server

Module 11: Securing and maintaining Exchange Server

Securing Exchange Server by using RBAC
Configuring audit logging in Exchange Server
Maintaining Exchange Server
Lab : Securing and maintaining Exchange Server

Module 12: Implementing and managing Exchange Online deployments

Overview of Exchange Online and Office 365
Managing Exchange Online
Lab : Managing Exchange Online
Training and LAB Sessions will be provided in accordance with the specified modules or chapters.
After completing this training and receiving your OEM certification, you will be hired in the market.

Module 1: Planning Exchange Server deployments

New features in Exchange Server 2019
Gathering business requirements for an Exchange Server deployment
Planning for an Exchange Server deployment
Planning the migration of Unified Messaging to Cloud Voicemail
Evaluating an existing messaging infrastructure
Identifying requirements
Discussion: Deployment design for Exchange Server 2019

Module 2: Planning and deploying Exchange Server Mailbox services

Planning Exchange Server hardware requirements
Planning Exchange Server for virtualization and Microsoft Azure integration
Planning and implementing public folders
Planning mailbox server configuration and location
Planning for mailbox databases
Implementing mailbox databases
Planning and implementing public folders

Module 3: Planning message transport

Designing message routing
Designing transport services
Designing the message-routing perimeter
Designing transport compliance
Planning for a redundant and secure message transport
Planning for transport compliance
Implementing transport compliance

Module 4: Planning and deploying client access

Module 5: Designing and implementing high availability

Planning high availability for Exchange Server
Planning for load balancing
Planning for site resilience
Planning high availability and site resilience
Creating a site-resilient DAG
Validating site resilience
Creating a lagged database copy
Recovering data from a lagged database copy

Module 6: Maintaining Exchange Server

Using Managed Availability to improve high availability
Implementing DSC
Using Windows PowerShell to investigate and configure Managed Availability
Implementing DSC

Module 7: Designing messaging security

Planning messaging security
Designing and implementing AD RMS and Azure RMS
Planning messaging security
Implementing AD RMS
Integrating AD RMS with Exchange Server
Creating a message transport rule to protect email

Module 8: Designing and implementing message retention and archiving

Overview of archiving and messaginng records management
Designing In-Place Archiving
Designing and implementing message retention
Implementing message retention and archiving

Module 9: Designing and implementing messaging compliance

Designing and implementing data loss prevention policies
Designing and implementing In-Place Hold
Designing and implementing In-Place eDiscovery
Designing messaging compliance
Implementing data loss prevention
Implementing In-Place eDiscovery
Comparing messaging policy and compliance options

Module 10: Designing and implementing messaging coexistence

Designing and implementing federation
Designing coexistence between Exchange organizations
Designing and implementing cross-forest mailbox moves
Implementing message-routing coexistence
Migrating user mailboxes

Module 11: Upgrading to Exchange Server 2019

Planning an upgrade from previous Exchange Server versions
Implementing the upgrade from previous Exchange Server versions
Documenting the Exchange Server 2013 organization
Deploying Exchange Server 2019
Upgrading from Exchange Server 2013 to Exchange Server 2019
Removing Exchange Server 2013

Module 12: Planning a hybrid Exchange Server deployment

Basics of a hybrid deployment
Planning and implementing a hybrid deployment
Implementing Azure AD Connect
Implementing a hybrid deployment
Implementing advanced functionality for hybrid deployments
Creating a plan for hybrid Exchange deployment
Training and LAB Sessions will be provided in accordance with the specified modules or chapters.
After completing this training and receiving your OEM certification, you will be hired in the market.

Module 1: Plan for Microsoft Intune

Plan Licensing and product requirements and capabilities
Mobile device management strategy cloud vs hybrid
Identity strategy – Users / Groups
Physical device considerations BYOD / CYOD
Use of the Intune Portals
License assignment

Module 2: Compliance

Compliance in Intune
Create a compliance policy
Using multiple compliance policies

Module 3: Configuration

Configuration in Intune
Android
Android for Work
iOS
Mac OS X
Windows
Software
Computer Management
Common device settings

Module 4: Managing Applications and Updates

Module 4 discusses mobile application management without enrollment on iOS and Android devices. In addition it covers the ability to sideload and deeplink apps and the use of the Intune Software publisher.

Module 5: Enrolling Devices, Alerts, Troubleshooting and Reporting

Enrolling devices
IOS Certificates
Alerts overview
Device alerts
Policy alerts
Service alerts
Reporting
Troubleshooting

Module 6: Monitoring and Reporting

Module 6 discusses monitoring and reporting using Microsoft Intune

Module 7: Intune as Part of the Enterprise Mobility and Security Product Suite

Azure Active Directory
Azure Information Protection
Microsoft Cloud App Security
Microsoft Advanced Threat Analytics
Microsoft Identity Manager
Lab: Implementing Microsoft Intune
Training and LAB Sessions will be provided in accordance with the specified modules or chapters.
“After completing this training and receiving your OEM certification,” you will be hired in the market.

Course Outline

Describe the new features of Microsoft Dynamics CRM 2016.
Install and configure CRM 2016 and configure it for optimal performance.
Implement Microsoft SQL Server clustering and high availability tactics.
Identify the minimum role requirements and system capacity requirements.
Evaluate and troubleshoot server/client deployment configuration problems.
Establish a secure communication infrastructure for each system.
Customize and configure the CRM 2016 security model.
Create custom entities, modules, and web services using the SDK.”
Design workflows and business processes that interact with the CRM data.
Use the CRM 2016 interface to enter, maintain and edit customer data.”
Identify and analyze data and performance metrics.
Utilize and customize the web portal of the CRM 2016 system.
Training and LAB Sessions will be provided in accordance with the specified modules or chapters.
“After completing this training and receiving your OEM certification, you will be hired in the market.”

 Module 1: Creating a Microsoft 
Excel Workbook

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
Ribbons & Groups

 Module 2: Entering Data in Microsoft 
Excel Worksheets

Adding and Deleting Cells
Adding a Hyperlink
Add WordArt to a Worksheet
Using AutoComplete
Entering Text and Using AutoComplete
Entering Numbers and Dates
Using the Fill Handle
Entering Numbers and Dates”

Module 3: Using Formulas in 
Microsoft Excel

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
Working with Formulas”

 Module 4: Working with Rows 
and Columns

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”
Working with Rows and Columns

 Module 5: Finalizing Microsoft 
Excel worksheets

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
Preparing to Print”

Module 6: Advanced Excel Functions

Using Named Ranges in Formulas
Using Formulas That Span Multiple Worksheets
Entering a Formula Using Data in Multiple Worksheets
Using the IF Function
Using the PMT Function
Using the LOOKUP Function
Using the CONCAT Function
Using the TRANSPOSE Function
Using the PROPER, UPPER, and LOWER Functions
Using the PROPER Function
Using the LEFT, Right,Mid”

Module 7: Data Tools

Converting a List to a Table
Removing Duplicates from a List
Sorting Data in a List
Filtering Data in a List
Adding Subtotals to a List”

Module 8: Visualizing your Data

inserting Charts
Using the Chart Recommendation Feature
Editing Charts
Using Chart Tools
Using the Quick Analysis Tool
Add and Format Objects”

Module 9: Advance tools

Pivot table
Lookup
Flash Fill
Remove Duplicates
Consolidate
Conditional Formatting
Training and LAB Sessions will be provided in accordance with the specified modules or chapters.
“After completing this training and receiving your OEM certification, you will be hired in the market.”

Module 1: An Introduction to Power BI

Lessons
What is business intelligence?
Introducing Power BI
Power BI tools and services
Power BI Report Server
Power BI (Online)
Power BI Desktop
Case studies
Support and information
Data stories

“After completing this module, students will be able to:”

Understand the concepts of business intelligence.
Have an overview of Power BI.
Be aware of the selection of tools available in the Power BI suite.
Know where to go to for support on updates, where to ask questions and which communities to join.

Module 2: Requirements Gathering

Lessons
Welcome to House Rules Board Games
Beginning a BI project
Grain statements
Data discovery
Refining information
Modelling data
Building reports
Roles
Publishing
Creating dashboards
Choosing workspaces
Create and share a report in Power BI

“After completing this module, students will be able to:”

Understand the requirements for a business intelligence project.
Be aware of the stages of a project and which tools to use.
Know how to create a basic report and dashboard in Power BI web.

Module 3: Extract, transform and
load data

Lessons
Creating a project with Power BI desktop
Pinning an active project
What is in a PBIX file?
Connecting to data sources
Managing data connections
Refine data with Power Query
Applied steps
M code language
Designing your query
Choose columns
Rename columns
Moving columns
Formatting columns
Replacing values
Expanding related columns
Star schemas
Merge columns
Split columns
Custom and conditional columns

“After completing this module, students will be able to:”

Start a new Power BI project using Power BI desktop.
Connect to a range of data sources.
Maintain data connections.
Design a query to refine their data.

Module 4: Creating a data model

Lessons
Understanding relationships
Cardinality
Cross filter direction
Hiding tables and columns
Formatting columns
Introducing DAX
Designing calculated columns
Creating measures
Adding lookup tables
Structuring data with dimensional hierarchies
Roles and row level security

“After completing this module, students will be able to:”

Format columns.
Review and manage table relationships.
Use DAX to create columns and measures.
Design data hierarchies.
Work with geographical data.
Implement row level security.

Module 5: Designing Reports

Lessons
Adding pages and navigation buttons
Using shapes, text, and images”
Creating a theme
Adding visualizations
Using filters and slicers
Controlling filters
Adding drill throughs
Adding custom visualizations
Configure phone layouts
Report tips

“After completing this module, students will be able to:”

Create pages in a report and design navigational buttons.
Add visualizations to a report.
Configure visualizations.
Implement filters and slicers.
Download new custom visualisations.

Module 6: Using workspaces and
dashboards

Lessons
Power BI licensing
My workspaces
App workspaces
Premium capacity workspaces
Creating a new workspace
Publishing a project
Parallels with Microsoft Excel
Publishers and viewers
Reconnecting with data sources
Introducing the on-premises data gateway
Scheduling the data refresh frequency
Assigning security roles
Creating and populating dashboards
Customising dashboard tiles
Creating tiles using Q&A and quick insights
Creating a mobile dashboard
Sharing reports and dashboards
Publishing apps in a workspace
Publishing content to websites

“After completing this module, students will be able to:”
Publish your project and understand what licenses are required.
Configure a published data model to refresh periodically.
Understand what features Power BI shares with Microsoft Excel.
Use the on-premises data gateway.
Designate roles for row level security.
Create desktop and mobile dashboards.
Share reports and dashboards.
Publish apps and feature your reports on websites.
Training and LAB Sessions will be provided in accordance with the specified modules or chapters.
“After completing this training and receiving your OEM certification, you will be hired in the market.”

Module 01: Introduction to SQL
Server 2022

Overview of SQL Server 2022
SQL Server Components & Architecture
SQL Server Instances, Editions and version.

Module 02: Installing and Configuring
SQL Server 2022

Installing SQL Server
Considerations for Installing SQL Server
Installation changes/ Feature Selection /New Tab

Module 03: SQL Server Security

Authentication and authorization
Managing users and logins
Controlling access to objects with permissions
Auditing database activity

Module 04: Data Protection with
Encryption and Management

Protecting Data with Encryption and Auditing
Always Encrypted with Secure Enclave
Dynamic Data Masking
Database Ledger
Data Classification and Function
Row Level Security

Module 05: SQL Server 2022
Storage Engine Capabilities

Tempdb Performance Critical for Scalability
Shrink DB With Low Priority
Accelerate Database Recovery Improvements
Current Buffer Pool Scan Operations

Module 06: SQL Server Backup
and Recovery

Types of backups: full, differential, and transaction log backups”
Planning backup and recovery strategies
Performing backups and restores
Monitoring backup and recovery performance
Improved backup metadata

Module 07 : SQL Server High Availability
and Disaster Recovery

Introduction to high availability and disaster recovery
Configuring database mirroring
Configuring log shipping
Configuring Always On availability groups

Module 08 : SQL Server Performance
Tuning and Optimization

Identifying performance bottlenecks
Query tuning techniques
Index tuning
Server configuration and resource allocation

Module 09 : Automating SQL Server Management

Automating SQL Server management
Working with SQL Server Agent
Managing SQL Server Agent Jobs
Multi-Server management

Module 10: Monitoring SQL Server
with Alerts and Notifications

Monitoring SQL Server errors
Configuring Database Mail
Operators, Alerts, and Notifications

Module 11: Working Examples with data Integration

Transferring Data to and from SQL Server
Importing and Exporting Table Data
Using bcp and BULK INSERT to Import Data

Module 12: SQL Server 2022: The cloud-connected database

Business continuity through Azure SQL Managed Instance
Azure Synapse Link for SQL Server
Azure Purview integration
Extending cloud-connected

Module 13: Monitoring SQL Server Using Tools

Extend Events Concepts
Working with Extended Events
Working with Windows Performance Counter
Working with Activity Monitor

Module 14: Common Issues and solutions with tips and tricks

Troubleshooting Techniques
Connectivity Issues
Service-Related Issues
Common Errors and solutions

Module 15: DB Management

Accelerated Database Recovery (ADR) improvements
Max server memory calculations
Improved snapshot backup support
Shrink database WAIT_AT_LOW_PRIORITY
Asynchronous auto update statistics concurrency

Module 16: Advanced SQL Server Topics

System page latch concurrency enhancements
Ordered clustered column store index
Improved column store segment elimination
Virtual log file growth
Training and LAB Sessions will be provided in accordance with the specified modules or chapters.
“After completing this training and receiving your OEM certification, you will be hired in the market.”

 Module 1: Microsoft Teams Overview

Lab : Manage roles and create teams
Prepare team roles and licenses
Create new team”

” Module 2: Implement Microsoft Teams 
Governance, Security and Compliance”

Implement Governance and Lifecycle Management for Microsoft Teams
Implementing Security for Microsoft Teams
Implementing Compliance for Microsoft Teams
Lab : Configure Security and Compliance for teams and content
Implement Governance and Lifecycle Management for Microsoft Teams
Implementing security for Microsoft Teams
Implementing compliance for Microsoft Teams”

Module 3: Prepare the environment for a 
Microsoft Teams deployment

Upgrade from Skype for Business to Microsoft Teams
Plan and configure network settings for Microsoft Teams
Deploy and Manage Microsoft Teams endpoints
Lab : Environment preparation for Teams
Calculate networking capabilities
Evaluate configuration profiles
Provide team resources”

Module 4: Deploy and manage teams

Create and manage teams
Manage membership
Manage access for external users
Lab : Manage teams
Manage team resources
Manage sharing and access”

 Module 5: Manage collaboration in 
Microsoft Teams

Manage chat and collaboration experiences
Manage settings for Teams apps”
Lab : Modify collaboration settings for Teams
Configure channel and message policies
Manage app settings for team”

Module 6: Manage communication in 
Microsoft Teams

Manage Live event and meetings experiences
Manage phone numbers
Manage Phone System for Microsoft Teams”
Training and LAB Sessions will be provided in accordance with the specified modules or chapters.
“After completing this training and receiving your OEM certification, you will be hired in the market.”

Module 1: Windows Server
Administration Overview

Lessons
Introducing Windows Server
Windows Server Core Overview
Windows Server administration principles and tools overview

“After completing this module, students will be able”

Describe Windows Server as well as techniques for deployment, servicing and activation.
Describe Windows Server Core, its specifics and ways to administer it.

Module 2: Identity Services in Windows Server

Lessons
AD DS Overview
Deploying Windows Server domain controllers
Azure AD overview
Implementing Group Policy
Active Directory Certificate Services overview

“After completing this module, students will be able to:”

Describe AD DS in a Windows Server environment.
Deploy domain controllers in AD DS.
Describe Azure AD and benefits of integrating Azure AD with AD DS

Module 3: Network Infrastructure
services in Windows Server

Lessons
Deploying and managing DHCP
Deploying and managing DNS service
Deploying and managing IPAM
Remote Access Services in Windows Server

“After completing this module, students will be able to:”

Describe, deploy and configure DHCP service.
Deploy, configure and manage DNS.
Describe, deploy and manage IPAM.

Module 4: File Servers and Storage
management in Windows Server

Lessons
Volumes and File Systems in Windows Server
Implementing sharing in Windows Server
Implementing Storage Spaces in Windows Server
Implementing Data Deduplication
Implementing iSCSI
Deploying Distributed File System

“After completing this module, students will be able to:”

Implement sharing in Windows Server
Deploy Storage Spaces technology
Implement the data deduplication feature
Implement iSCSI based storage
Deploy and manage Distributed File System (DFS)

Module 5: Hyper-V virtualization and
containers in Windows Server

Lessons
Hyper-V in Windows Server
Configuring VMs
in Windows Server
Containers in Windows Server
Overview of Kubernetes

“After completing this module, students will be able to:”

Describe the key features of Hyper-V in Windows Server.
Describe VM settings and deploy and configure VMs in Hyper-V.
Explain the use of security technologies for virtualization.
Describe and deploy containers in Windows Server.
Explain the use of Kubernetes on Windows.

Module 6: High Availablity in
Windows Server

Lessons
Planning for failover clustering implementation
Creating and configuring failover cluster
Overview of stretch clusters
High availability and disaster recovery solutions with Hyper-V VMs

After completing this module, students will be able to:”

Describe failover clustering and the considerations for implementing it.
Create and configure failover clusters.
Describe stretch clusters.
Describe options to achieve high availability with Hyper-V VMs.

Module 7: Disaster recovery in
Windows Server

Lessons
Hyper-V Replica
Backup and restore infrastructure in Windows Server

“After completing this module, students will be able to:”

Describe and implement Hyper-V Replica.
Describe Azure Site Recovery.
Describe and implement Windows Server backup.
Describe the Azure Backup service.

Module 8: Windows Server security

Lessons
Credentials and privileged access protection
Hardening Windows Server
JEA in Windows Server
Securing and analyzing SMB traffic
Windows Server update management

“After completing this module, students will be able to:”

Describe credentials used in Windows Server.
Explain how to implement privileged access protection.
Describe methods and technologies to harden security in Windows Server.
Describe and configure Just Enough Administration (JEA).
Secure SMB traffic in Windows Server.
Describe Windows Update and its deployment and management options.

Module 9: RDS in Windows Server

Lessons
Overview of RDS
Configuring a session-based desktop deployment
Overview of personal and pooled virtual desktops

“After completing this module, students will be able to:”

Describe Remote Desktop Services (RDS) in Windows Server.
Describe and deploy session-based desktops.
Describe personal and pooled virtual desktops.

Module 10: Remote access and web
services in Windows Server

Lessons
Implementing VPNs
Implementing Always On VPN
Implementing NPS
Implementing Web Server in Windows Server

“After completing this module, students will be able to:”

Describe VPN options in Windows Server.
Describe Always On VPN functionality.
Describe and configure NPS.
Describe and configure Web Server (IIS).

Module 11: Server and performance
monitoring in Windows Server

Lessons
Overview of Windows Server monitoring tools
Using Performance Monitor
Monitoring event logs for troubleshooting

“After completing this module, students will be able to:”

Describe monitoring tools in Windows Server.
Describe performance monitoring and use it in Windows Server.
Describe event logging and perform event logging monitoring for troubleshooting purposes

Module 12: Upgrade and migration in
Windows Server

Lessons
AD DS migration
Storage Migration Service
Windows Server migration tools

“After completing this module, students will be able to:”

Describe tools to use for AD DS migration.
Describe the Storage Migration Service.
Describe Windows Server migration tools and their usage scenarios.