Filter by Topic
Filter by Vendor
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.
55164-A: Quick Powerful Graphics with Power View, PowerPivot, Power Query, Power Map and Power BI
Course Description: This is a 2-days course designed to teach …
What you'll learn
Navigate the Power View interface.
Utilize Power View reports.
Work with tables.
Understand aggregations.
Utilize matrix.
Configure drill through.
Use cards as a visualization.
Apply filters.
Create charts.
Utilize tiles.
Add slicers to reports.
Utilize themes.
Navigate the PowerPivot interface.
Examine and configure relationships.
Configure calculated columns are calculated fields.
Create PivotTables.
Understand and utilize DAX.
Work with hierarchies.
Manage perspectives.
Navigate the Power Query interface.
Merge datasets.
Manage modifications.
Perform data cleaning.
Navigate the Power Map interface.
Use Bing maps.
Examine map data.
Configure tours, scenes, and layers.
Add time to a presentation.
Navigate the Power BI interface.
Utilize data sources.
Understand querying with natural language.
Successfully log into their virtual machine.
Have a full understanding of what the course intends to cover.
55121-A: Microsoft Project 2013
Course Description: This two-day instructor-led course is intended for IT …
What you'll learn
Understand the terminology.
Understand project management basics.
Understand and utilize the Microsoft Project 2013 Interface.
Create and configure calendars.
Configure scheduling.
Utilize and navigate views.
Create tasks.
Modify tasks.
Delete tasks.
Create resources.
Assign tasks to resources.
Monitor resources and their tasks.
Delete resources.
Track project progress.
Create and configure reports.
Accurately troubleshoot a project.
Close a project.
Share the project using OneDrive.
Share the project using Project Server 2013 or Project Online.
Share and sync the project using SharePoint 2013.
Oracle 11g: Programming with SQL I and II eLearning
Course Description: Oracle Database 11g delivers economies of scale on …
What you'll learn
Concepts and components of an Oracle Database 11g database, how to retrieve information from it using SQL, and the steps for sorting, limiting, modifying, and formatting this information
Steps for writing queries that convert data from one type to another, specify conditions, perform calculations on groups of rows or even tables, and return values from more than one table
Steps for manipulating queries to return the data you need, using subqueries and set operators, and manipulating the actual data using INSERT, UPDATE, DELETE, and other data manipulation language (DML) statements
Steps for creating, defining, and dropping tables, manipulating how their data can be viewed, and using schema objects to generate integers, improve queries, and rename tables
Steps for controlling user access to objects and for maintaining these objects by dropping columns and adding constraints and indexes
Steps for querying data dictionary views to view schema objects and for performing operations on large amounts of data, such as inserting data into multiple tables and merging table rows
Steps for managing data in different time zones in Oracle Database 11g, for managing time intervals, and for using datetime functions
Steps for retrieving data using subqueries and using regular expressions to search for, match, and replace strings
Oracle 11g: Programming with SQL Intro eLearning
Course Description: Oracle Database 11g delivers economies of scale on …
What you'll learn
Concepts and components of an Oracle Database 11g database, how to retrieve information from it using SQL, and the steps for sorting, limiting, modifying, and formatting this information
Steps for writing queries that convert data from one type to another, specify conditions, perform calculations on groups of rows or even tables, and return values from more than one table
Steps for manipulating queries to return the data you need, using subqueries and set operators, and manipulating the actual data using INSERT, UPDATE, DELETE, and other data manipulation language (DML) statements
Steps for creating, defining, and dropping tables, manipulating how their data can be viewed, and using schema objects to generate integers, improve queries, and rename tables
Steps for controlling user access to objects and for maintaining these objects by dropping columns and adding constraints and indexes
Steps for querying data dictionary views to view schema objects and for performing operations on large amounts of data, such as inserting data into multiple tables and merging table rows
Steps for managing data in different time zones in Oracle Database 11g, for managing time intervals, and for using datetime functions
Steps for retrieving data using subqueries and using regular expressions to search for, match, and replace strings
Oracle 12c: New Features for Administrators eLearning
Course Description: In this course, you’ll learn about the new …
What you'll learn
Enterprise Manager Cloud Control
Creating Container Databases (CDB) and Pluggable Databases (PDB)
Managing CDB and PBD, and Data Optimization
Using Automatic Data Optimization, Storage, and Archiving
Managing Security
High Availability and Database Management
Tuning Structured Query Language (SQL) and Using Automatic Database Diagnostic Monitor (ADDM)
Resource Manager, Online Operations, and Automatic Diagnostic Repository (ADR)
Transporting Databases and Managing Data
Oracle Database 11g: RAC Administration eLearning
Course Description: In this course, you will be introduced to …
What you'll learn
Install Oracle Clusterware and RAC
Administer a RAC Database and Oracle Clusterware
RAC Performance Tuning
Configure, Manage, and Use Database Services in a RAC environment
Administer Oracle Clusterware
Diagnose Oracle Clusterware and Node Management
High Availability in RAC
Add/Remove a node to/from a cluster
Patch Oracle Clusterware and RAC software
Oracle11g Admin eLearning
Course Description: Oracle Database 11g delivers economies of scale on …
What you'll learn
Elements of the Oracle Database 11g architecture and the tools and steps required to install the Oracle Database 11g software
Steps for creating a new Oracle Database 11g database and then configuring it and managing the instance
Steps for configuring new Oracle Net Listeners and database connectivity
Steps for maintaining storage structures and automating storage management in Oracle Database 11g and for managing privileges, roles, and other security features for users
Steps for managing schema objects, such as tables, views, and indexes, and recognize ways to use SQL and PL/SQL commands to manipulate data and ensure data concurrency
Steps required to manage undo information, secure an Oracle Database 11g database, and maintain it by monitoring statistics, automated tasks and alert thresholds
Steps for ensuring an Oracle Database 11g database is available to users when needed by monitoring its performance, anticipating and avoiding database failure, setting up instance recovery options, and creating backups
Ways to make use of Oracle Database 11g’s tools for moving and recovering data, reporting on problems, and installing updates to enhance a database
