Most popular
MS-700T00-A: Managing Microsoft Teams
What you'll learn
Understand the discipline of project management as it applies to using Microsoft Project 2013.
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 2013 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 2013.
Be able to create a Macro.
Share common settings among all future projects.
Microsoft Office Excel (2019-2016-2013): Advanced
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.
AZ-305T00: Designing Microsoft Azure Infrastructure Solutions
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.
Microsoft Office Word 2019: Part 2
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
Implementing A SQL Data Warehouse
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
55232-A: Writing Analytical Queries for Business Intelligence
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
Microsoft Office Access 2019: Part 1
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.
AI-102T00: Designing & Implementing An Azure AI Solution
What you'll learn
Describe considerations for AI-enabled application development
Create, configure, deploy, and secure Azure Cognitive Services
Develop applications that analyze text
Develop speech-enabled applications
Create applications with natural language understanding capabilities
Create QnA applications
Create conversational solutions with bots
Use computer vision services to analyze images and videos
Create custom computer vision models
Develop applications that detect, analyze, and recognize faces
Develop applications that read and process text in images and documents
Create intelligent search solutions for knowledge mining.
Microsoft Office Word 2019: Part 3
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.
DP-300T00: Administering Microsoft Azure SQL Solutions
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
Trending
MS-700T00-A: Managing Microsoft Teams
What you'll learn
Understand the discipline of project management as it applies to using Microsoft Project 2013.
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 2013 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 2013.
Be able to create a Macro.
Share common settings among all future projects.
Microsoft Office Excel (2019-2016-2013): Advanced
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.
AZ-305T00: Designing Microsoft Azure Infrastructure Solutions
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.
Microsoft Office Word 2019: Part 2
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
Implementing A SQL Data Warehouse
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
55232-A: Writing Analytical Queries for Business Intelligence
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
Microsoft Office Access 2019: Part 1
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.
AI-102T00: Designing & Implementing An Azure AI Solution
What you'll learn
Describe considerations for AI-enabled application development
Create, configure, deploy, and secure Azure Cognitive Services
Develop applications that analyze text
Develop speech-enabled applications
Create applications with natural language understanding capabilities
Create QnA applications
Create conversational solutions with bots
Use computer vision services to analyze images and videos
Create custom computer vision models
Develop applications that detect, analyze, and recognize faces
Develop applications that read and process text in images and documents
Create intelligent search solutions for knowledge mining.
Microsoft Office Word 2019: Part 3
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.
DP-300T00: Administering Microsoft Azure SQL Solutions
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
All Microsoft Courses
-38%
AZ-900T00-A:Microsoft Azure Fundamentals Training Certification
Demonstrate Your Fundamental Knowledge Of Cloud Concepts With Azure Our …
What you'll learn
Describe cloud computing
Describe the benefits of using cloud services
Describe cloud service types
Describe the core architectural components of Azure
Describe Azure compute and networking services
Describe Azure storage services
Describe Azure identity, access, and security
Describe cost management in Azure
Describe features and tools in Azure for governance and compliance
Describe features and tools for managing and deploying Azure resources
Describe monitoring tools in Azure
-19%
AZ-204T00-A: Developing solutions for Microsoft Azure
Course Description: This course teaches developers how to create end-to-end …
-38%
DP-900T00: Microsoft Azure Data Fundamentals
Course Description: In this course, students will learn the fundamentals …
What you'll learn
Describe core data concepts in Azure.
Explain concepts of relational data in Azure
Identify components of a modern data warehouse in Azure
-22%
AZ-104T00-A: Microsoft Azure Administrator
Course Description: This course teaches IT Professionals how to manage …
-35%
PL-300: Microsoft Power BI Data Analyst
Course Description: This course will discuss the various methods and …
DP-300T00: Administering Microsoft Azure SQL Solutions
Course Description: This course provides students with the knowledge and …
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
Free
Implementing A SQL Data Warehouse
Course Description This course provides students with the knowledge and …
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
55321: SQL Server Integration Services
Course Description This instructor-led course is intended for IT professionals …
What you'll learn
Create sophisticated SSIS packages for extracting, transforming, and loading data
Use containers to efficiently control repetitive tasks and transactions
Configure packages to dynamically adapt to environment changes
Use Data Quality Services to cleanse data
Successfully troubleshoot packages
Create and Manage the SSIS Catalog
Deploy, configure, and schedule packages
Secure the SSIS Catalog
