Filter by Topic
Filter by Vendor
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 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.
Oracle 19c Database Tuning (TTOR21519)
Course Description: Dive into the world of database optimization with …
What you'll learn
Develop a solid understanding of Oracle 19c Database Architecture: By the end of this course, you'll be comfortable with the components of Oracle's database system, from Instance Definitions to Datafile Definitions.
Master the Query Optimizer: You'll gain a firm grasp of SQL Parsing, Optimizing Terms, and Query Plan Generation. You'll learn how to build efficient queries that provide the data you need without unnecessary strain on your systems.
Get comfortable with Tuning Container and Pluggable Databases: You'll learn how to optimize and manage pluggable databases, enhancing the performance of your data operations.
Explore Oracle Tuning Features: We'll get you familiar with Oracle's Heat Map and delve into the 19c Compression Levels and Types, boosting your database's efficiency.
Learn to Evaluate Execution Plans: You'll become proficient in defining SQL execution plans and using the Automatic Workload Repository, allowing you to monitor and improve the performance of your queries.
Gain hands-on experience with Oracle Tuning Tools: You'll practice with tools like the Enterprise Manager and Automatic Database Diagnostic Monitor, equipping you to handle real-world tuning tasks with confidence.
55298-A: Introduction to SharePoint 2019
Course Description: This Introduction to SharePoint 2019 class is for …
What you'll learn
Learn to navigate a SharePoint 2019 Team Site.
Learn to create SharePoint lists.
Learn to customize SharePoint Lists.
Learn to create SharePoint libraries.
Learn to manage library document versions.
Learn to create SharePoint list and library views.
Learn to integrate Office Outlook and Excel applications with SharePoint 2019.
Understand the versions of SharePoint
Understand the SharePoint site hierarchy.
Understand Team Site layout.
Understand navigation with a Team Site.
Understand List Templates.
Work with default lists in a Team Site.
Create a new list from a List Template.
Create a custom list.
Add columns to a list.
Control and validate input into list fields.
Create new libraries using library templates.
Add columns to a library.
Check out documents for editing.
Delete and restore documents from document libraries.
Enable versioning on a library.
Revert a library document to an earlier version.
Use default views built into lists and libraries.
Create shared views.
Configure views.
Set the default view for a list or library.
Create a list from an Excel spreadsheet.
Create an alert in Outlook.
Understand what Site Templates are.
Understand different types of Site Templates that come “Out of the Box” with different versions
Create a new site using Site Templates.
Create a Project site.
Create a Team site.
Create a Community site.
Create a Blog site.
Manage the sites listed in the Top Link Bar.
