| Course Name |
Hours |
CEUs |
Content |
| 20767 - Implementing a SQL Data Warehouse |
35.00 |
3.50 |
|
Description: This five-day instructor-led course provides students with the knowledge and skills to provision a Microsoft SQL Server 2016 database. The course covers SQL Server 2016 provision both on-premise and in Azure, and covers installing from new and migrating from an existing install.
Audience profile
The primary audience for this course are database professionals who need to fulfil a Business Intelligence Developer role. They will need to focus on hands-on work creating BI solutions including Data Warehouse implementation, ETL, and data cleansing.
# of Days:
|
| 20768 - Developing SQL Data Models |
21.00 |
2.10 |
|
Description: The focus of this 3-day instructor-led course is on creating managed enterprise BI solutions. It describes how to implement both multidimensional and tabular data models and how to create cubes, dimensions, measures, and measure groups. This course helps you prepare for the Exam 70-768.
Audience profile
The primary audience for this course are database professionals who need to fulfil BI Developer role to create enterprise BI solutions. Primary responsibilities will include:
Implementing multidimensional databases by using SQL Server Analysis Services
Creating tabular semantic data models for analysis by using SQL Server Analysis Services
The secondary audiences for this course are power information workers/data analysts.
# of Days:
|
| 55268AC - Microsoft Power Automate/Flow for End Users |
7.00 |
0.70 |
|
Description: This course delivers an instructor-led product showcase for Microsoft Flow from start to finish in an engaging and practical way. Flow is a diverse product, turning business processes into automated, consistent and visual workflows. Flow is designed to interweave the various products in Office 365 as well as connect to other on-premises and web-based solutions. This course will give you the confidence to select the right actions and workflow logic for your business workflows.
# of Days:
|
| Articulate Storyline: Advanced (V3/360) |
14.00 |
1.40 |
|
Description: Articulate Storyline advanced provides students with the knowledge and hands-on practice they
need to develop and build advanced interactions, extend the functionality of Storyline, and have a
better understanding of Storyline project workflow.
This class is for those who are familiar with the basic features of Storyline such as creating slides,
layers, triggers, working with timelines, importing text, characters, videos, creating simple tests and
other basic functions and would like to gain deeper knowledge of Storyline. This class builds upon
fundamental skills in Storyline Essentials by providing students with hands-on practice extending
Storyline capabilities, and customizing the learner experience. In this class we will explore many
media features in depth including best practices for audio and video, animations, storyline variables,
conditional triggers, cue points, and student reporting. Additionally, in this class we cover Scenariobased Learning and Instructional Path Models.
# of Days:
|
| Certified ScrumMaster (CSM) |
14.00 |
1.40 |
|
Description: The Certified ScrumMaster (CSM) course is a two-day, entry-level course taught by a Certified Scrum Trainer. The CSM course is designed to cover all the basics of Scrum so you can begin to fulfill the ScrumMaster role.
In the CSM course, you will learn about:
Scrum basics and core values
How the Scrum framework compares to other methods, such as waterfall
How to identify when to use Scrum
A Scrum teams three roles and responsibilities
Scrum meetings, including the Sprint Review, Sprint Retrospective and Release Planning
Sprint Backlog and Product Backlog
Scrum artifacts, including the Product Backlog, Sprint Backlog and Burndown Charts
Upon completing this course:
Qualification for Certified ScrumMaster (CSM) Certification after passing a short certification exam
Two year membership in the Scrum Alliance
14 PDUs from PMI (Project Management Institute)
PMI-ACPSM: This course counts as 14 of the 21 contact hours for the PMI-ACP certification
# of Days:
|
| CompTIA: Security+ Certification |
35.00 |
3.50 |
|
Description: Security+ Certification is the primary course you will need to take if your job responsibilities include securing network services, network devices and network traffic. It is also the main course you will take to prepare for the CompTIA Security+ examination. Topics covered include: identification of security threats, hardening internal systems and services, hardening internetwork devices and services, securing network communications, managing a PKI, managing certificates, enforcing an organizational security policy monitoring the security infrastructure.
# of Days:
|
| Excel 2016 Data Analysis |
7.00 |
0.70 |
|
Description: In this course, you will cover creating and modifying table elements, adding and deleting records and fields, and using Data forms and Slicers with table data. You will import data from Access and Excel objects as well as text file types. Proper data management will be discussed to determine structure requirements, sorting, filtering, using flash fill, auto filter and advanced filtering features. The database functions will allow the user to extract data from a large list of content with precision based on specific criteria. Finally, the data modeling features will examine how to take spreadsheet data and create one to many relationships which will expand the functionality of a pivot table for a greater understanding of the data.
# of Days:
|
| Excel 2016 Formulas |
6.00 |
0.60 |
|
Description: In this course, you will cover how to: build a formula, use function formulas, work with range names in a formula, use Logical and Lookup function formulas, use Financial function formulas, use the Concatenate function formula, work with the Date, Proper, Upper and Lower function formulas, create a function formulas from scratch work with data tables.
# of Days:
|
| Excel 2016 Level 2 for Windows |
7.00 |
0.70 |
|
Description: In this course, you will cover how to work with large worksheets in Microsoft Excel 2016, and use multiple worksheets and workbooks efficiently. You will sort and filter data, use conditional formatting, and create and format tables and charts. You will learn how to protect worksheets and files, as well as referring to data in other workbooks thru 3D formulas. Finally, you will create names, customize a template, and work with comments and clipart.
# of Days:
|
| Excel 2019 Level 2 |
7.00 |
0.70 |
|
Description: In this course, you will cover how to work with large worksheets in Microsoft Excel 2019, and use multiple worksheets and workbooks efficiently. You will sort and filter data, use conditional formatting, and create and format tables and charts. You will learn how to protect worksheets and files, as well as referring to data in other workbooks thru 3D formulas. Finally, you will create names, customize a template, and work with comments and graphics.
# of Days:
|
| Intermediate Python 3.x |
28.00 |
2.80 |
|
Description: This 4 day course picks up where Introduction to Python 3.x leaves off, covering some topics in more detail, and adding many new ones, with a focus on enterprise development. This is a hands-on programming class. All concepts are reinforced by informal practice during the lecture followed by lab exercises. Many labs build on earlier labs, which helps students retain the earlier material.
# of Days:
|
| Microsoft Project 2016 Level 1 |
7.00 |
0.70 |
|
Description: Microsoft Project 2016 Level 1 is designed to familiarize you with the basic features and functions of Microsoft Project Professional 2016 so you can use it effectively and efficiently in a real-world environment.
In this course you will cover the critical knowledge and skills a project manager needs to create a project plan with Microsoft Project 2016 during the planning phase of a project. In other words, if your supervisor assigns you to lead a project, this course will enable you to draft a project plan with Project 2016 and share it with your supervisor (and others) for review and approval.
# of Days:
|
| Microsoft Project 2016 Level 2 |
7.00 |
0.70 |
|
Description: Welcome to Microsoft Project 2016: Part 2. This course is designed to familiarize you with the advanced features and functions of Microsoft Project Professional 2016 so that you can use it effectively and efficiently in a real-world environment.
In Microsoft Project 2016: Part 1, you learned the basic features of Microsoft Project 2016 during the planning phase of a project. Microsoft Project 2016: Part 2 covers the advanced knowledge and skills a project manager needs to update a project plan in Project 2016 during the execution, monitoring, and controlling phases of a project. In other words, once your project plan is approved by the project sponsor, this course will enable you to manage the project so that it is completed on time, within budget, and according to scope.
# of Days:
|
| SAFe: Leading SAFe/SAFe Agilist (SA@) |
14.00 |
1.40 |
|
Description: During this two-day course, attendees will gain the knowledge necessary to lead a Lean-Agile
enterprise by leveraging the Scaled Agile Framework (SAFe), and its underlying principles
derived from Lean, systems thinking, Agile development, product development flow, and
DevOps. They will develop a skillset thats in demand worldwideand empower their
enterprises to succeed in a disruptive marketplacewhen they become a Certified SAFe 5.0
Agilist (SA).
# of Days:
|
| SQL Level 1 for Windows |
7.00 |
0.70 |
|
Description: In this course you will cover how to: connect to the SQL Server database and execute a simple query, include a search condition in a simple query, use various functions to perform calculations on data, organize data, retrieve data by combining information from multiple tables present query results in a report.
# of Days:
|
| SQL Level 2 for Windows |
7.00 |
0.70 |
|
Description: In this course you will cover advanced techniques for querying a database including how to: code subqueries to generate query output, manipulate table data by inserting, updating and deleting records in a table, create a simple table, create tables with constraints, modify the table structure, and delete tables, create views, manipulate data through views, modify the view structure and drop views index data.
# of Days:
|
| Tableau Advanced |
14.00 |
1.40 |
|
Description: This two day course is designed to provide you with the skills required to become a Tableau power user. The course is designed for the professional who has solid working experience with Tableau and wants to take it to the next level. You should have a deep understanding of all the fundamental concepts of building worksheets and dashboards, but may scratch your head when working with more complex issues.
# of Days:
|
| Time Management Skills |
7.00 |
0.70 |
|
Description: Also called Time Management Skills One Day Workshop
The Time Management Skills workshop will help managers, supervisors, team leaders or team members learn how to implement effective time management. During this one-day workshop participants will cover the following topics: Principles of time management, time management plans, technology and time management, increasing productivity, avoiding information overload, organizing your office learning to communicate effectively.
# of Days:
|
| Visio 2016 Level 1 for Windows |
7.00 |
0.70 |
|
Description: From the earliest eras of human existence, visual images have been used to represent knowledge, data, and information. Beginning with the Paleolithic cave paintings and continuing to todays most complex computer networks, these images leverage the ability of the human brain to rapidly perceive patterns and trends from visual representations.
In todays workplace, visual diagrams are an essential part of communication, from road maps to sales flows to process charts. Microsoft Visio provides you with an intuitive, customizable tool to easily create a professional-looking visual product by using its extensive gallery of shapes. By following the exercises in this course, you will create visually engaging diagrams, maps, and drawings, using graphical elements to make information easier to comprehend.
In this course, you will design, modify, and manage basic diagrams. As well as:
Identify the basic elements of Visio and their use.
Create a workflow diagram.
Build organization charts.
Design a floor plan.
Build a cross-functional flowchart.
Design a network diagram.
Style a diagram.
# of Days:
|
| Word 2016 Level 1 for Windows |
7.00 |
0.70 |
|
Description: Microsoft Word 2016 is designed to help you move smoothly through the task of creating professional-looking documents. Its rich features and powerful tools can make your work easy, and even fun. In this course, youll learn how to use Word 2016 to create and edit simple documents; format documents; add tables and lists; add design elements and layout options; and proof documents.
This course covers Microsoft Office Specialist exam objectives to help students prepare for the Word 2016 Exam and the Word 2016 Expert Exam. In this course, you will learn fundamental Word 2016 skills:
Navigate and perform common tasks in Word, such as opening, viewing, editing, saving, and printing documents, and configuring the application.
Format text and paragraphs.
Perform repetitive operations efficiently using tools such as Find and Replace, Format Painter, and Styles.
Enhance lists by sorting, renumbering, and customizing list styles.
Create and format tables.
Insert graphic objects into a document, including symbols, special characters, illustrations, pictures, and clip art.
Format the overall appearance of a page through page borders and colors, watermarks, headers and footers, and page layout.
Use Word features to help identify and correct problems with spelling, grammar, readability, and accessibility.
# of Days:
|
| Word 2016 Level 2 for Windows |
7.00 |
0.70 |
|
Description: After you master the basics of using Microsoft Word 2016 such as creating, editing, and saving documents; navigating through a document; and printing, youre ready to move on to tackling the more advanced features. These features enable you to create complex and professional documents with a consistent look and feel. They also enable you to automate tedious tasks such as preparing a letter to send to every customer of your organization.
Creating professional-looking documents can help you give your organization a competitive edge. Implementing time-saving features such as document templates and automated mailings helps your organization reduce expenses. Mastering these techniques will make you a valued employee in your organization.
This course covers Microsoft Office Specialist exam objectives to help students prepare for the Word 2016 Exam and the Word 2016 Expert Exam. In this course, you will learn to create and modify complex documents and use tools that allow you to customize those documents.
You will:
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.
# of Days:
|
| Word 2016 Level 3 for Windows |
7.00 |
0.70 |
|
Description: Microsoft Word 2016 enables you to do far more than simple word processing. Word includes advanced image manipulation tools, collaboration features, cross-referencing and linking tools, entry forms and data collection, security features, and tools to automate document production.
This course covers Microsoft Office Specialist exam objectives to help students prepare for the Word 2016 Exam and the Word 2016 Expert Exam. You will:
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.
# of Days:
|