Filter by Topic
Filter by Vendor
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.
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
DP-203T00-A: Data Engineering on Microsoft Azure
Course Description: In this course, the student will learn about …
What you'll learn
Explore compute and storage options for data engineering workloads in Azure
Design and Implement the serving layer
Understand data engineering considerations
Run interactive queries using serverless SQL pools
Explore, transform, and load data into the Data Warehouse using Apache Spark
Perform data Exploration and Transformation in Azure Databricks
Ingest and load Data into the Data Warehouse
Transform Data with Azure Data Factory or Azure Synapse Pipelines
Integrate Data from Notebooks with Azure Data Factory or Azure Synapse Pipelines
Optimize Query Performance with Dedicated SQL Pools in Azure Synapse
Analyze and Optimize Data Warehouse Storage
Support Hybrid Transactional Analytical Processing (HTAP) with Azure Synapse Link
Perform end-to-end security with Azure Synapse Analytics
Perform real-time Stream Processing with Stream Analytics
Create a Stream Processing Solution with Event Hubs and Azure Databricks
Build reports using Power BI integration with Azure Synpase Analytics
Perform Integrated Machine Learning Processes in Azure Synapse Analytics
AZ-500T00-A: Microsoft Azure Security Technologies
Course Description: This course provides IT Security Professionals with the …
What you'll learn
Implement enterprise governance strategies including role-based access control, Azure policies, and resource locks.
Implement an Azure AD infrastructure including users, groups, and multi-factor authentication.
Implement Azure AD Identity Protection including risk policies, conditional access, and access reviews.
Implement Azure AD Privileged Identity Management including Azure AD roles and Azure resources.
Implement Azure AD Connect including authentication methods and on-premises directory synchronization.
Implement perimeter security strategies including Azure Firewall.
Implement network security strategies including Network Security Groups and Application Security Groups.
Implement host security strategies including endpoint protection, remote access management, update management, and disk encryption.
Implement container security strategies including Azure Container Instances, Azure Container Registry, and Azure Kubernetes.
Implement Azure Key Vault including certificates, keys, and secretes.
Implement application security strategies including app registration, managed identities, and service endpoints.
Implement storage security strategies including shared access signatures, blob retention policies, and Azure Files authentication.
Implement database security strategies including authentication, data classification, dynamic data masking, and always encrypted.
Implement Azure Monitor including connected sources, log analytics, and alerts.
Implement Azure Security Center including policies, recommendations, and just in time virtual machine access.
Implement Azure Sentinel including workbooks, incidents, and playbooks.
AZ-120T00-A: Planning and Administering Microsoft Azure for SAP Workloads
Course Description: This course teaches IT Professionals experienced in SAP …
