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.
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.
DP-100T01-A: Designing and Implementing a Data Science Solution on Azure
360° Microsoft Azure data science certification Course The Microsoft Azure …
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.
