Microsoft Courses

$345.00

Microsoft Office Word 2019: Part 3

26 Lessons

8 hours

Expert

What you'll learn

Use images in a document.

Create custom graphic elements.

Collaborate on documents.

Add reference marks and notes.

Secure a document.

Create and manipulate forms.

Create macros to automate tasks.

Intermediate

DP-300T00: Administering Microsoft Azure SQL Solutions

$2,595.00

DP-300T00: Administering Microsoft Azure SQL Solutions

22 Lessons

32 hours

Intermediate

What you'll learn

Plan, deploy and configure Azure SQL offerings

Monitor database performance and tune a database and queries for optimum performance

Plan and configure a High Availability Solution

Intermediate

PL-900T00: Microsoft Power Platform Fundamentals

$1,195.00

PL-900T00: Microsoft Power Platform Fundamentals

43 Lessons

Intermediate

What you'll learn

Describe Microsoft Power Platform components

Describe Microsoft Dataverse, Connectors and AI builder

Describe cross-cloud scenarios across M365, Dynamics 365, Microsoft Azure and 3rd party services

Identify benefits and capabilities of Microsoft Power Platform

Identify the basic functionality and business value Microsoft Power Platform components

Implement simple solutions with Power Apps, Power Automate, Power BI, and Power Virtual Agents

Identify when to use each Microsoft Power Platform component application to create business solution

Learn the value of using Microsoft Power Platform to create business solutions

Learn the components and features of Microsoft Power Platform

Descibe the difference between Dataverse and Common Data Model

Explain use cases and limitations of business rules and process flows

Explain what environments, tables, columns, and relationships are in Dataverse

Learn how other organizations digitize their processes using Power Apps

See Power Apps in action and learn options for making your first app

Learn about what Power Apps is and its business value

See how Power Automate works and looks from the user’s perspective

Build a simple flow

Learn the business value and features of Power Automate

See how Power BI works and looks from the user’s perspective

Learn how to build a simple Power BI dashboard

Describe the business value and features of Power BI

Describe the business value and features of Power Virtual Agents

Build a basic chatbot

Learn essential components that make up Power Virtual Agents and chatbots

Intermediate

Microsoft Office Access 2019: Part 2

$345.00

Microsoft Office Access 2019: Part 2

18 Lessons

8 hours

Intermediate

What you'll learn

Provide input validation features to promote the entry of quality data into a database.

Organize a database for efficiency and performance, and to maintain data integrity.

Improve the usability of Access tables.

Create advanced queries to join and summarize data.

Use advanced formatting and controls to improve form presentation.

Use advanced formatting and calculated fields to improve reports.

Intermediate

PL-600 Power Platform Solution Architect

$2,095.00

PL-600 Power Platform Solution Architect

24 hours

Intermediate

What you'll learn

Becoming a Solution Architect/Getting to know your customer

Conceptualizing the design from requirements

Project governance and working as a team

Power Platform Architecture

Data Modeling

Analytics and artificial intelligence

Power Apps Architecture

Application Lifecycle Management (ALM)

Power Automate Architecture

Security Modeling

Integration

Dynamics 365 Applications Architecture

Power Virtual Agents architecture

Robotic Process Automation

Testing and Go Live

Intermediate

Microsoft Office OneNote 2016

$345.00

Microsoft Office OneNote 2016

17 Lessons

8 hours

Intermediate

What you'll learn

In this course, you will develop digital note-taking skills by creating, modifying, and managing OneNote notebooks that work with other Microsoft Office programs.

Navigate and customize the OneNote interface and environment.

Add and format text, images, audio, links, and drawing objects to a notebook.

Embed Excel spreadsheets and attach other files to a notebook.

Categorize, organize, and search notebook content.

Check spelling in, print, and password-protect notebooks.

Use Outlook and OneDrive to send and share notebook content.

Export notebook content and manage notebook history and backups.

Intermediate

PL-300: Microsoft Power BI Data Analyst

Gora

$1,995.00

PL-300: Microsoft Power BI Data Analyst

51 Lessons

24 hours

Intermediate

Intermediate

55205-A: Mastering Microsoft Project 2016

$1,395.00

55205-A: Mastering Microsoft Project 2016

24 hours

Intermediate

What you'll learn

Understand the discipline of project management as it applies to using Microsoft Project 2016.

Create a Work Breakdown Structure.

Identify Task Types & Relationships.

Define Resources within Project.

Make Work Package Estimates.

Create an Initial Schedule.

Create a Resource Leveled Schedule.

Create Projects from templates, Excel files.

Create Global templates.

Create formulas and graphical indicators.

The steps to record a macro.

Format Output and Print Reports.

Integrate Multiple Projects.

Set up a Project with a Calendar, Start date, and scheduling method.

Understand Manually Schedule vs. Auto Schedule.

Manage multiple projects.

Be able to create a master project list with shared resources.

Have a fundamental understanding of how Microsoft Project will help them track their projects.

Understand what is new in Project 2016 and how it will increase their productivity.

Learn how the ribbon will help them get the most of out of this productivity tool.

Learn how to quickly change views and see what is going on with their projects.

Understand the 5 essential steps in building a successful project plan.

Prepare a new project plan and set the date and other basic information.

Enter detailed project information.

Understand how to sequence tasks.

Understand and define basic resource types.

Assign resources to tasks.

Understand the benefits of baselining a project or specific tasks.

Understand the basics of how to track project progress.

Create a new project using a template, Excel, a SharePoint Tasks List or a new Project file.

Establish one or more calendars to constrain resource availability.

Configure Microsoft Project to calculate the schedule from the Start Date forward or from the Finish Date backward.

Understand how to turn on Manually Schedule and Auto Schedule.

Understand when to use Manually Schedule.

Understand the limitations of Manually Scheduling.

Build and use summary and subordinate tasks.

Understand and use milestones.

How to organize the WBS.

How to format the WBS.

Develop WBS outlines.

Assign completion criteria.

Evaluate the WBS.

Understand and use WBS outlines.

Understand how to link Project artifacts to their projects.

Understand how to create notes on tasks.

Understand the different types of task relationships.

Understand and use various methods to create relationships.

Determine and display task sequence.

Understand how to use Lag, Lead and Delay.

Define the different types of resources.

Define individual resources that will be used on the project.

Record the cost(s) of using each type of resource.

Record the limit of availability for each type of resource by establishing a resource calendar and defining the maximum units of that resource.

Assign values for resources, duration and work.

Understand task types.

Understand Effort Driven scheduling.

Understand material resources and their costs to a project plan.

Identify the critical path.

Understand difference between slack and slippage.

Calculate float.

How to leverage constraints.

How to get the benefit from the Task Inspector, and the impact of changes on a project schedule.

Adjust a project schedule to account for limited resources.

View the overall cost and schedule of a project.

Identify resources that are over- allocated for a project schedule.

Use multiple ways to adjust tasks and assignments to remove over- allocation for any resource.

Set a baseline.

Enter and manage project performance data.

Pick a tracking method.

Perform variance analysis.

Sync Projects results with SharePoint.

Create standardized views, with the power of sorting, filtering and grouping.

Customize a variety of standard reports.

Learn how to use Visual Reports.

Export reports in a variety of formats.

Use common resources among multiple projects.

Link tasks between multiple projects.

Create a consolidated view of multiple projects and shared resources.

Take advantage of the advance features of Microsoft Project.

Be able to create a Macro.

Share common settings among all future projects.

Expert

Microsoft Office Access 2019: Part 3

$345.00

Microsoft Office Access 2019: Part 3

23 Lessons

8 hours

Expert

What you'll learn

Share data across applications.

Use action, unmatched, and duplicate queries to manage data.

Create complex reports and forms.

Use macros to improve user interface design.

Use VBA to extend database capabilities.

Perform database management tasks such as backup, compacting, repairing, performance analysis, checking object dependencies, and documenting.

Implement security strategies and distribute a database to multiple users.

Intermediate

55316: Administering A SQL Database

$2,995.00

55316: Administering A SQL Database

107 Lessons

40 hours

Intermediate

What you'll learn

Authenticate and authorize users

Assign server and database roles

Authorize users to access resources

Use encryption and auditing features to protect data

Describe recovery models and backup strategies

Backup and Restore SQL Server databases

Automate database management

Configure security for the SQL Server agent

Manage alerts and notifications

Managing SQL Server using PowerShell

Trace access to SQL Server

Monitor a SQL Server infrastructure

Troubleshoot a SQL Server infrastructure

Import and export data

Trending

Featured

Expert

Microsoft Office Excel (2019-2016-2013): Advanced

$345.00

Microsoft Office Excel (2019-2016-2013): Advanced

17 Lessons

8 hours

Expert

What you'll learn

Work with multiple worksheets and workbooks.

Share and protect workbooks.

Automate workbook functionality.

Use Lookup functions and formula auditing.

Forecast data.

Create sparklines and map data.

Intermediate

AZ-305T00: Designing Microsoft Azure Infrastructure Solutions

$2,595.00

AZ-305T00: Designing Microsoft Azure Infrastructure Solutions

26 Lessons

32 hours

Intermediate

What you'll learn

Design a governance solution.

Design a compute solution.

Design an application architecture.

Design storage, non-relational and relational.

Design data integration solutions.

Design authentication, authorization, and identity solutions.

Design network solutions.

Design backup and disaster recovery solutions.

Design monitoring solutions.

Design migration solutions.

Featured

Intermediate

Microsoft Office Word 2019: Part 2

$345.00

Microsoft Office Word 2019: Part 2

26 Lessons

8 hours

Intermediate

What you'll learn

Organize content using tables and charts.

Customize formats using styles and themes.

Insert content using Quick Parts.

Use templates to automate document formatting.

Control the flow of a document.

Simplify and manage long documents.

Use mail merge to create letters, envelopes, and labels.

Free

Intermediate

Implementing A SQL Data Warehouse

Free

Implementing A SQL Data Warehouse

40 hours

Intermediate

What you'll learn

Describe the key elements of a data warehouse solution

Considerations for building a data warehouse

Implementing a logical design for a data warehouse

Implement a physical design for a data warehouse

Create Columnstore indexes

Implementing an Azure SQL Data Warehouse

Describe the key features of SSIS

Implement a data flow by using SSIS

Implement control flow by using tasks and precedence constraints

Create dynamic packages that include variables and parameters

Debug SSIS packages

Describe the considerations of implement an ETL Solution

Implement Data Quality Services

Implement a Master Data Service model

Describe how you can use custom components to extend SSIS

Deploy SSI projects

Describe BI and common BI scenarios

Start Learning

Intermediate

55232-A: Writing Analytical Queries for Business Intelligence

$1,495.00

55232-A: Writing Analytical Queries for Business Intelligence

24 hours

Intermediate

What you'll learn

Identify independent and dependent variables and measurement levels in their own analytical work scenarios.

Identify variables of interest in relational database tables.

Choose a data aggregation level and data set design appropriate for the intended analysis and tool.

Use TSQL SELECT queries to produce ready-to-use data sets for analysis in tools such as PowerBI, SQL Server Reporting Services, Excel, R, SAS, SPSS, and others.

Create stored procedures, views, and functions to modularize data retrieval code.

Describe the purpose of analytical queries

Describe the function of TSQL data retrieval in an analytics/business intelligence environment

Describe the primary functions of the database engine

Discuss TSQL as a declarative language

Identify variables of interest in database tables

Write basic SELECT queries

Implement column expressions in SELECT queries

Implement column and table aliases

Describe data types and Implement data type conversions

Implement built-in functions

Use WHERE and ORDER BY clauses in SELECT queries

Discuss and describe the conceptual flow of JOIN operations

Implement INNER and OUTER JOIN operations on two or more tables

Describe the order of operations of SELECT clauses

Combine JOIN operations with WHERE and ORDER BY

Describe the row granularity of result sets

Discuss and implement aggregate functions to achieve required row granularity

Use GROUP BY to calculate aggregate values for groups

Use HAVING to filter records in the result set by aggregate value

Combine GROUP BY and HAVING with WHERE and ORDER BY

Describe and discuss the rationale of creating intermediate results sets within SELECT queries

Implement non-correlated and correlated subqueries

Implement derived tables

Implement Common Table Expressions

Create intermediate to advanced TSQL queries to retrieve result sets for analysis

Identify scenarios in which views, table-valued functions, and stored procedures simply data retrieval

Compare and contrast views, table-valued functions, and stored procedures

Create views, table-valued functions, and stored procedures

Describe the security requirement for creating database objects

Implement views, table-valued functions, and stored procedures for users with read-only access to source data

Describe the properties of database connection strings

Run queries from, and return results to, Excel, PowerBI, and RStudio

Export query results to external text files using the SSMS results pane, the bcp utility, and the Import/Export Wizard

Beginner

Microsoft Office Access 2019: Part 1

$345.00

Microsoft Office Access 2019: Part 1

19 Lessons

8 hours

Beginner

What you'll learn

Navigate within the Access application environment, create a simple database, and customize Access configuration options.

Organize and manage data stored within Access tables.

Use queries to join, sort, and filter data from different tables.

Use forms to make it easier to view, access, and input data.

Create and format custom reports.

Intermediate

AI-102T00: Designing & Implementing An Azure AI Solution

$2,595.00