Student? Switch to our Career Center Site →
Contact Us

55301 Mastering Microsoft Project 2019

This three-day instructor-led course is intended for individuals who are interested in expanding their knowledge base and technical skills about Microsoft Project. The course begins with the basic concepts and leads students through all the functions they’ll need to plan and manage a small to medium-size project, including how to level resources and capture both cost and schedule progress.
Select Class Date
Course Details

Price:

Days:

3

Location:

Virtual

Course Overview

This three-day instructor-led course is intended for individuals who are interested in expanding their knowledge base and technical skills about Microsoft Project. The course begins with the basic concepts and leads students through all the functions they’ll need to plan and manage a small to medium-size project, including how to level resources and capture both cost and schedule progress.
  • Scroll right to view Objectives, Prerequisites, and Agenda

Understand the discipline of project management as it applies to using Microsoft Project 2019. 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.

There are no prerequisites for the MS-55301 Mastering Microsoft Project 2019 course. However, it may be helpful to have taken an introductory project management course before taking this course

SQL Server Security

  • Authenticate logins and authorize users to access databases
  • Configure SQL Server login options
  • Authorization across servers and partially contained databases

Assigning Server and Database Roles

  • Understand fixed and custom database roles
  • Assign and manage server roles

Authorizing Users to Access Resources

  • Use database roles and application roles
  • Implement role-based access to secure data

Protecting Data with Encryption and Auditing

  • Configure SQL Server Audit and manage audit logs
  • Encrypt sensitive data and enforce auditing policies

Recovery Models and Backup Strategies

  • Understand backup strategies for transactional integrity
  • Plan SQL Server recovery using appropriate models

Backing Up SQL Server Databases

  • Perform full and differential database backups
  • Manage backup files and automate backup jobs

Restoring SQL Server Databases

  • Use restore options and perform point-in-time recovery
  • Handle advanced restore scenarios

Automating SQL Server Management

  • Configure SQL Server Agent for scheduled jobs
  • Automate repetitive tasks using job steps and notifications

Configuring Security for SQL Server Agent

  • Set up credentials, proxies, and secure agent access

Monitoring with Alerts and Notifications

  • Create operators and configure alerting
  • Monitor Azure SQL Database events and performance

Managing SQL Server with PowerShell

  • Use PowerShell to configure SQL Server
  • Administer and maintain SQL Server infrastructure
  • Manage Azure SQL using PowerShell

Tracing Access with Extended Events

  • Capture login and query activity
  • Use Extended Events to analyze SQL Server performance

Monitoring SQL Server

  • Monitor usage metrics and server performance
  • Analyze collected data using SQL Server Utility

Troubleshooting SQL Server

  • Resolve service, login, and connectivity issues
  • Apply a troubleshooting methodology for performance

Importing and Exporting Data

  • Import and export data using BCP and BULK INSERT
  • Deploy and manage data-tier applications
Select Class Date
Class Dates & Times
Filters Sort results
Reset Apply
No results found. Clear filters and try again?
— Questions?

Information Request

— Empower Change

Invest in Skills & Equality

Support Diversity, Equity, and Inclusion with Every Purchase.

Great Horizons is a North Carolina Certified HUB Vendor and WOSB. By becoming a patron of our organization, you are not only supporting a historically underutilized business, but a woman-owned small business as well.