Filter by Topic
Filter by Vendor
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.
55293-A: SharePoint End User 2019
Course Description: This SharePoint 2019 End User 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 lists and library views.
Learn to create sub sites using various SharePoint templates
Learn to create and edit Web page content.
Learn to create InfoPath Forms and Form libraries.
Learn to create Site columns and content types.
Learn to integrate Office applications with SharePoint 2019.
Learn to manage basic permissions of SharePoint 2019 resources.
Understand the versions of SharePoint.
Understand SharePoint site hierarchy.
Understand Team Site layout.
Understand navigation within 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.
Understand what Site Templates are.
Understand the 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.
Understand what site pages are.
Understand what wiki pages are.
Understand what Web Parts are.
Add content to the Site Home page.
Create a wiki page library
Add Web Parts.
Manage Web Parts.
Understand what a Form Library is.
Create a Form Library.
Use InfoPath Designer to design a basic form template.
Publish an InfoPath Designer form template to a Form Library
Designate for templates fields as library columns.
Create instances of documents in a Form Library.
Understand Site Columns.
Understand Content Types.
Create Site Columns.
Create Content Types.
Create a document template for a Content Type.
Assign a Content Type to a list or library.
Create new items based on a custom Content Type.
Create a list from an Excel Spreadsheet.
Create an alert in Outlook.
Understand SharePoint groups.
Create SharePoint groups.
Assign permission in SharePoint.
View permission levels.
Manage permission inheritance at the site level.
Manage permission inheritance at the list or library level.
Edit a personal profile.
DevOps Engineering on AWS
Manage a variety of DevOps Philosophies with DevOps Engineering on …
What you'll learn
List the advantages of small DevOps teams
List the roles and responsibilities of the members of a typical small DevOps team
Leverage AWS Cloud9 to write, run and debug your code as well as share your cloud-based IDE with your dev team.
Build continuous integration/continuous delivery (CI/CD) pipelines including testing and security
Develop Git branching strategies and integrate with CI/CD pipeline for various environments
Use AWS CloudFormation to deploy development, test, and production environments for a software development project
Design and implement an infrastructure on AWS that supports DevOps development projects
Build a CI/CD pipeline for AWS CloudFormation templates
Establish collaboration by bringing together the workflows and responsibilities of development and operations
Host secure, highly scalable private Git repositories with AWS CodeCommit
Leverage Amazon Elastic Container Registry (Amazon ECR) to securely store Docker container images and integrate with AWS CodeBuild and Amazon Elastic Container Service (Amazon ECS).
Automate build, test, and packaging code with AWS CodeBuild
Integrate security in the CI/CD pipelines tools and services
Implement common deployment strategies such as “all at once,” “rolling,” and “blue/green”
Automate software deployments to Amazon Elastic Compute Cloud (Amazon EC2), on-premises computes, AWS ECS (Amazon EC2 /AWS Fargate), and AWS Lambda with AWS CodeDeploy
Automate your release pipelines (build, test, deploy) with AWS CodePipeline
Monitor an application and environment using AWS tools and technologies
