Information Technologies Trainings
IT Training Taxo Menu
This Oracle Database 12c: Clusterware Administration training will explore general cluster
concepts and Oracle Clusterware architecture. Work with expert Oracle University
instructors through interactive instruction and hands-on exercises to reinforce your
learning.In this course, you will be introduced to Oracle Database Exadata Cloud Service.
This Oracle Database 12c: Data Guard Administration Ed 1 training teaches you how to
use Oracle Data Guard. Learn how it protects your Oracle database against planned and
unplanned downtimes. In this course, you will be introduced to Oracle Database Exadata
This Database Program with PL/SQL training shows you how to develop stored
procedures, functions, packages and database triggers. You’ll learn to manage PL/SQL
program units and dependencies, while using of some of the Oracle-supplied packages
This Database SQL & PL/SQL Fundamentals training teaches you the fundamentals of
relational databases, SQL & PL/SQL programming language. Learn to write queries
against single and multiple tables, manipulate data in tables & create database objects.
In the Oracle Database 18c: High Availability New Features course, students will learn
about new software features and improvements found in Oracle Clusterware, Oracle
ASM, Real Application Clusters, and Oracle Data Guard.
The course provides the Oracle Database 19c new features and enhancements
related to database overall, security, availability, performance, data warehousing,
and diagnosability. In the lessons, you learn the new and enhanced features of Oracle
Database 19c amongst different areas such as database overall, security, availability,
performance, big data and warehousing, and diagnosability.
In the Oracle Database Security: Preventive Controls course, students learn how they can
use Oracle Database Security products and technologies to meet the security, privacy and
compliance requirements of their organization. The current regulatory environment of
the Sarbanes-Oxley Act, HIPAA, the UK Data Protection Act, and others, requires better
security at the database level. Students learn how to secure the access to their databases
and how to use the Oracle Database Security products and technologies that enhance
data access and confidentiality. The course provides suggested Oracle solutions for
This course provides detailed information on the architecture of an Oracle Database
instance and database, enabling you to effectively manage your database resources. You
learn how to create database storage structures appropriate for the business applications
supported by your database. In addition, you learn how to create users and administer
database security to meet your business requirements. Basic information on backup and
recovery techniques is presented in this course. To provide an acceptable response time
to users and manage resources effectively, you learn how to monitor your database and
Students learn how to use Oracle Database automatic tuning features such as SQL Tuning
Advisor, SQL Access Advisor, Automatic Workload Repository and Automatic Database
Diagnostic Monitor, and practice these tuning methods. The course focuses on the tuning
tasks expected of a DBA: reactive tuning of SQL statements, maintaining SQL statement
and operation performance, and tuning the Oracle Database Instance components.
This course provides experienced MySQL DBAs with knowledge of how and why server settings affect performance, and when and how to tune them. It teaches students how to monitor their MySQL server and identify areas that impact performance, such as slow queries and replication lag, and how to diagnose and fix these issues.