Filter by Topic
Filter by Vendor
55205-A: Mastering Microsoft Project 2016
Course Description: This three-day, instructor-led course is intended for individuals …
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.
55232-A: Writing Analytical Queries for Business Intelligence
Course Description: This three-day instructor led course is about writing …
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
MS-700T00-A: Managing Microsoft Teams
Course Description: The Managing Microsoft Teams course is designed for …
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.
55054-A: Mastering Microsoft Project 2013
Course Description: This three-day, instructor-led course is intended for individuals …
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.
Oracle Database 19c Backup and Recovery (TTOR21619)
Geared for DBAs and other technical support staff, Oracle Database …
What you'll learn
Implement backup and recovery settings and perform backup operations to the media of your choice.
Move data between databases and files
Use Oracle Database recovery processes to recover from media and other failures.
Diagnose and repair data failures
Use flashback technologies and data duplication to complement backup and recovery procedures
Secure the availability of their database using backup and recovery strategies
Oracle 19C Database Multitenant Architecture (TTOR20719)
Oracle 19c Database Multitenant Architecture is a hands-on, three-day course …
What you'll learn
<b>CDB Management Skills</b>: Gain expertise in managing Container Databases (CDBs), including setup, configuration, and maintenance.
<b>PDB Operations Proficiency</b>: Develop the ability to efficiently handle Pluggable Database (PDB) operations like creation, cloning, and management.
<b>Database Security Measures</b>: Learn to implement and manage security protocols in both CDBs and PDBs, ensuring data integrity and compliance.
<b>Backup and Recovery Techniques</b>: Master the techniques for performing backups and recoveries of CDBs and PDBs, ensuring data safety and continuity.
<b>Performance Optimization</b>: Acquire skills to optimize the performance of databases within the Oracle Multitenant environment, including tuning and resource allocation.
<b>Data Movement and Storage Management</b>: Understand and apply methods for effective data movement and storage management in a Multitenant architecture.
Oracle 19c Database Administration I (Oracle 19c DBA I) (TTOR20519)
Oracle 19C Database Administration I (Oracle DBA I) is a …
What you'll learn
How to use tools to access an Oracle Database
Generate database creation scripts by using DBCA
How to create a container database (CDB) by using the CREATE DATABASE command
Learn about Startup and shut down Oracle databases
Initialization parameter files and initialization parameters
Tools that are used to administer Oracle Net Services
How to use the Oracle Connection Manager Control utility to administer Oracle Connection Manager
How to create a new PDB from the PDB seed
Logical and physical storage structures in an Oracle database
Usage of Oracle Database features that save space
Explanation of DML and undo data generation
Learn about general architecture of Oracle Data Pump and SQL*Loader
How to use SQL*Loader to load data from a non-Oracle database (or user files)
<b>Bonus Content / Time Permitting:</b> Explanation of maintenance windows
<b>Bonus Content / Time Permitting:</b> Employ basic monitoring procedures and manage performance
Oracle 19c PL/SQL Fundamentals (TTOR12019)
Oracle 19c PL/SQL Fundamentals is a three-day, hands-on technical course …
What you'll learn
Using PL/SQL programming language for database applications and development.
Incorporating PL/SQL modules within the application architecture from the initial design and planning phase.
The essentials of building executable PL/SQL program units.
Each of the major segments of a working program and how these interact with each other during program execution.
Important error or exception handling capabilities of the language.
How database-resident program units can be used as part of the overall database application architecture.
Applying these new skills to the development of PL/SQL packages.
Advanced database programming capabilities and benefits.
How database triggers can be used as part of an advanced database application design.
