Oracle

This UNIX and Linux Essentials course is designed for users and administrators who are new to the Oracle Linux and Oracle Solaris operating systems. It will help you develop the basic UNIX skills needed to interact comfortably and confidently with the operating system. Learn To: Manage files and directories from the command line and learn to use the vim editing tool. Perform remote connections and file transfers. Customize the user environment and use advanced shell features in shell scripts. Archive and compress files and directories. Understand and manage process control. View and modify file and directory permissions. Benefits to You Learn to work effectively with UNIX and Oracle Linux environments and master the fundamental administrative tasks for these operating systems. These are the first steps to ensuring fast, reliable, secure and easy to manage performance. Optimize database workloads, lower IT costs and deliver a higher quality of service by enabling consolidation onto Oracle Cloud or private clouds.

The Oracle Linux 7: System Administration course covers a range of skills including installation, using the Unbreakable Enterprise Kernel, configuring Linux services, preparing the system for the Oracle Database, monitoring and troubleshooting. This course teaches you how to handle typical issues faced by administrators. You learn to understand the kernel development model and learn about Linux distributions. You hear about Oracle's comprehensive solutions and Oracle's contributions to the Linux community.

This course is designed to provide you with a firm foundation in administration of an Oracle database. In this course you will gain a conceptual understanding of Oracle Database architecture and learn how to manage an Oracle database in an effective and efficient manner. Versions Supported: 19c, 18c, 12c This course provides detailed information on the architecture of an Oracle Database instance and database, enabling you to manage your database resources effectively. 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. This course provides basic information on backup and recovery techniques. To provide an acceptable response time to users and manage resources effectively, you learn how to monitor your database and manage performance.  What You Will Learn The Oracle Database: Administration Workshop course provides you with a firm foundation in administration of an Oracle database. In this course, you will gain a conceptual understanding of Oracle Database architecture and learn how to manage an Oracle database in an effective and efficient manner Learn To: Manage an Oracle Database instance. Configure the Oracle Network environment. Create and manage storage structures. Manage and move data. Create and manage users. Monitor the database and manage performance. Create and manage Database Cloud Service database deployments. Benefits To You You will benefit from this course as you learn detailed information on the architecture of an Oracle Database instance and database, enabling you to manage your database resources effectively. 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. This course provides basic information on backup and recovery techniques. To provide an acceptable response time to users and manage resources effectively, you learn how to monitor your database and manage performance.

In this course, students learn how to perform backup and recovery based on the related Oracle Database architecture components. Various backup, failure, restore, and recovery scenarios are provided so that students learn to evaluate their own recovery requirements and develop an appropriate strategy for backup and recovery procedures. This course includes an interactive workshop, with scenarios that provide participants with opportunities to diagnose and recover from several failure situations.  The student begins by gaining a deeper understanding of possibly the most important job of a DBA - backup and recovery. The concepts and architecture that support backup and recovery, along with implementation in various ways and situations are covered in detail. Students gain knowledge of the Recovery Manager (RMAN) command-line interface for various backup, failure, restore, and recovery scenarios, including data duplication. Extensive hands-on practices and workshop scenarios provide the student with experience in a realistic technical environment. This course includes an interactive workshop that provide participants with opportunities to diagnose and recover from several failure scenarios, based on backup and recovery case studies. After completing this course, students should be able to evaluate their own recovery requirements and develop an appropriate strategy for backup and recovery procedures. Versions Supported: 19c, 18c, 12c Learn To: Develop appropriate backup and recovery procedures to address your business needs. Implement backup and recovery settings and perform backup operations to disk and tape. Employ Oracle Database recovery procedures 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 your database by appropriate backup and recovery strategies. Benefits The student benefits by gaining a deeper understanding of possibly the most important job of a DBA - backup and recovery. The concepts and architecture that support backup and recovery, along with implementation steps in various ways and situations, are presented in detail. Students gain knowledge of the Recovery Manager (RMAN) command-line interface for various backup, failure, restore, and recovery scenarios, including data duplication. Hands-On Lessons Extensive hands-on practices and workshop scenarios provide the student with experience in a realistic technical environment. This course includes an interactive workshop that provide participants with opportunities to diagnose and recover from several failure scenarios, based on backup and recovery case studies. After completing this course, students should be able to evaluate their own recovery requirements and develop an appropriate strategy for backup and recovery procedures.

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 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. Configure and implement Oracle Clusterware enhancments. Use and manage ASM using the new features in this release. Use additional enhancements for Oracle ACFS and ADVM. Leverage Oracle RAC new featuers found in this release. Configure and use Oracle Data Guard new features. Use new Data Guard Broker commands.

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. Learn To : Use the Oracle tuning methodology Use Oracle-supplied tools for monitoring and diagnosing SQL and instance tuning issues Use database advisors to proactively correct performance problems Identify problem SQL statements  Tune SQL performance problems Monitor instance performance by using Enterprise Manager  Tune instance components by primarily using instance parameters 

During this course, you gain a conceptual understanding of the multitenant architecture and learn how to manage an Oracle multitenant container database(CDB) and its different types of pluggable databases (PDB) in an effective and efficient manner.  This Oracle Database: Managing Multitenant Architecture course covers all aspects of the multitenant architecture, providing detailed information on the components of an Oracle multitenant container database and its regular and application pluggable databases. You learn why and how to create and manage a multitenant container database and its regular and application pluggable databases, with storage structures appropriate for the business applications. You practice cold and hot cloning, plugging unplugged pluggable databases in multitenant container databases using various methods. In addition, you learn how to create common and local users and administer database security to meet your business requirements by using encryption, Database Vault and auditing and you will learn how to create a database deployment in the Cloud. Versions Supported: 19c, 18c, 12c Learn To:  Understand the multitenant architecture.   Create and manage a multitenant container database and pluggable databases.   Understand regular and application pluggable databases.   Manage storage within a multitenant container database and pluggable databases.   Manage security within a multitenant container database and regular and application pluggable databases.  Monitor performance and manage resources within a multitenant container database and pluggable databases.  Perform backup, recover and flashback operations on a multitenant container database and regular and application pluggable databases.  Perform particular operations like Oracle Data Pump transportation, loading, encrypting, auditing.  Manage the CDB and PDBs in specific configurations like Data Guard, Database Vault. Benefits To You To provide an acceptable response time to users and manage resources effectively, you learn how to monitor performance and manage resources within the multitenant container database and its pluggable databases, and within each pluggable database. Another important aspect is the data movement between non-CDBs and pluggable databases, and between pluggable databases. It is also important to understand the procedures of upgrading an Oracle Database multitenant container database or an Oracle Database pluggable database. Finally, students discover the way multitenant container database and pluggable databases are created and monitored in the Cloud.

You’ll learn how to create a container database and provision pluggable databases. This Oracle Database: Deploy, Patch and Upgrade Workshop gives you detailed information to help you install Oracle Database software. Expert Oracle instructors will teach you how to create a container database and provision pluggable databases. In this course, you will be introduced to Oracle Database Cloud Service. Learn To: Install Oracle Grid Infrastructure for a Standalone Server. Use Oracle Restart to manage components. Upgrade an existing Oracle Database. Create a container database and provision pluggable databases. Gain an understanding of the Oracle Database Cloud Service. Benefits to You: Ensure fast, reliable, secure and easy to manage performance. Optimize database workloads, lower IT costs and deliver a higher quality of service by enabling consolidation onto database clouds. Gain Hands-On Experience: Get practical experience installing the Oracle Grid Infrastructure software and Oracle Database software by using Oracle Universal Installer. Expert Oracle instructors will teach you how to stop and start Oracle Restart using SRVCTL to manage components.

This course provides an overview of the Oracle Database 18c new features and enhancements related to Multitenant architecture, security, RMAN, general database areas, performance, data warehousing and Sharding. Learn To:  Use new features like Application PDB Fleet and PDB snapshots carousel of the Multitenant architecture. Understand new features like PDB keystores and encryption of sensitive data in Database Replay files of the Security. Benefit from new features like reuse of preplugin backups and duplication of active PDBs into an existing CDB of RMAN. Use new features like private temporary tables and online modification of partitioning and subpartitioning strategy of General Database. Configure and use new features like Automatic In-Memory Management in Performance. Manipulate new features like inline external tables and polymorphic table functions of the Data Warehousing.  Understand enhancements like user-defined sharding method and support for PDBs as shards in Sharding.

This course provides detailed information on the architecture of an Oracle Database instance and database, enabling you to manage your database resources effectively. 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. This course provides basic information on backup and recovery techniques. To provide an acceptable response time to users and manage resources effectively, you learn how to monitor your database and manage performance.

  This Oracle Access Management 12c PS3: Administration Essentials training teaches you how to install, configure and implement a real life deployment of Oracle Access Manager 12c PS3 (12.2.1.3). Work with expert Oracle University instructors to install, troubleshoot, diagnose and more. Learn To:   Install and configure Oracle Access Manager 12c PS3.  Configure servers, data sources and agents.  Set up policy configuration (shared components and application domain).  Manage sign-on, sign-off and sessions. Configure detached credential collector [DCC] Set up auditing, logging and troubleshooting for OAM 12c PS3.  Manage sessions, policy and agents with the REST API.

The Oracle Database 12c: Global Data Services seminar helps you learn about Oracle Database 12c Global Data Services (GDS). Expert Oracle instructors will teach you how to install, configure, administer and use Global Data Services. Learn To: Install Global Data Services. Configure the Global Data Services framework. Administer Global Data Services Clouds. Topics Covered: Global Data Services overview Global Data Services framework Global Services theory Global connection load balancing Global runtime connection load balancing Global Services failover  Benefits to You Ensure fast, reliable, secure and easy to manage performance. Optimize database workloads, lower IT costs and deliver a higher quality of service by enabling consolidation onto database clouds. Explore Global Data Services You'll also learn about the benefits provided by Global Data Services for managing cloud-deployed distributed databases. Furthermore, you'll review best practices for configuring Global Data Services to use Oracle Active Data Guard configuration and Oracle GoldenGate replication.

This Oracle Database 12c: Install and Upgrade Workshop gives you detailed information to help you install Oracle Database 12c software. Expert Oracle instructors will teach you how to create a container database and provision pluggable databases. In this course, you will be introduced to Oracle Database Cloud Service. Learn To: Install Oracle Grid Infrastructure for a Standalone Server. Use Oracle Restart to manage components. Upgrade an existing Oracle Database to Oracle Database 12c. Create a container database and provision pluggable databases. Gain an understanding of the Oracle Database Cloud Service. Benefits to You Ensure fast, reliable, secure and easy to manage performance. Optimize database workloads, lower IT costs and deliver a higher quality of service by enabling consolidation onto database clouds. Gain Hands-On Experience Get practical experience installing the Oracle Grid Infrastructure software and Oracle Database software by using Oracle Universal Installer. Expert Oracle instructors will teach you how to stop and start Oracle Restart using SRVCTL to manage components.

The Oracle Database 12c: SQL and PL/SQL New Features training introduces you to the new features available in Oracle Database 12c. Explore the latest features available in SQL language and feature enhancements in PL/SQL, data types, language performance and data warehousing. In this course, you will be introduced to Oracle Database Exadata Express Cloud Service. Learn To: Understand the FETCH clause to limit the rows returned by a SQL query. Take advantage of the invisible and hidden columns. Make use of the IDENTITY column to automatically generate the number column. Utilize the ACCESSIBLE BY clause to create a white list of PL/SQL units. Grant roles to PL/SQL packages and standalone stored procedures. Understand Synchronous Materialized Views. Identify ways to improve query performance against OLAP cubes. Gain an understanding of the Oracle Database Exadata Express Cloud Service. Benefits to You When you walk away from this course, you will have gained a better understanding of the data warehousing new features available in Oracle Database 12c. This includes maintaining multiple partitions and SQL for pattern matching.

This Oracle Database 12c: Introduction for Experienced SQL Users training teaches you about Oracle Database 12c. Explore the database environment and the Oracle SQL Developer tool.  In this Oracle Database 12c: Introduction for Experienced SQL Users training, you learn about Oracle Database 12c, the database environment and the Oracle SQL Developer tool. Expert Oracle University instructors will teach you how to create and manage tables, synonyms, sequences, indexes and views. Learn To: Describe the Oracle database environment. Use various features of Oracle SQL Developer. Describe and work with the basic elements of Oracle SQL. Become familiar with fundamental database security features. Combine tables using joins and subqueries. Create and manage tables, synonyms, sequences, indexes and views. Implement database security by granting privileges and creating roles. Benefits to You By enrolling in this course, you'll deep dive into fundamental database security features. By learning to create and manage tables, synonyms, sequences, indexes and views in the Oracle Database 12c environment, you'll be able to better leverage your technology investment.

This Introduction to SQL/PLSQL Accelerated course will teach you SQL and PL/SQL programming language concepts. Learn how to write SQL commands, develop stored PL/SQL procedures, functions, packages and database triggers.This accelerated course covers 10 days worth of content in only 5 days. Learn To: Understand the fundamental and core concepts of relational databases. Create reports of sorted and restricted data. Run data manipulation statements (DML). Retrieve row and column data from tables. Control privileges at the object and system level. Create indexes and constraints; alter existing schema objects. Create and query external tables. Create anonymous PL/SQL blocks, functions and procedures. Conditionally control code flow (loops, control structures). Create stored procedures, functions and packages. Conditionally control code flow (loops, control structures). Use PL/SQL packages to group and contain related constructs.  Create triggers to solve business challenges.  Leverage the Oracle supplied PL/SQL packages for various programming tasks. Benefits to You By enrolling in this course, you'll gain expertise in relational database data management as you learn how to effectively use SQL commands against your business data. These features will help you query and manipulate data within the database, use the dictionary views to retrieve metadata and create reports about their schema objects. Extend the functionality of the SQL language with PL/SQL language to write application code. Participate in Hands-On Exercises Through hands-on instruction from expert Oracle instructors, you'll learn to develop stored procedures, functions, packages and more. Hands-on exercises will help reinforce your learning. Course Bundle Note This course is a combination of Oracle Database: Introduction to SQL and Oracle Database: Program with PL/SQL courses.

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. This Oracle Database: SQL and PL/SQL Fundamentals training delivers the fundamentals of SQL and PL/SQL along with the benefits of the programming languages using Oracle Database technology. You'll explore the concepts of relational databases. Learn To: Write queries against single and multiple tables, manipulate data in tables and create database objects. Use single row functions to customize output. Invoke conversion functions and conditional expressions. Use group functions to report aggregated data. Create PL/SQL blocks of application code that can be shared by multiple forms, reports and data management applications. Develop anonymous PL/SQL blocks, stored procedures and functions. Declare identifiers and trap exceptions. Use DML statements to manage data. Use DDL statements to manage database objects. Declare PL/SQL Variables. Conditionally control code flow (loops, control structures). Describe stored procedures and functions. Retrieve row and column data from tables. Benefits to You Ensure fast, reliable, secure and easy to manage performance. Optimize database workloads, lower IT costs and deliver a higher quality of service by enabling consolidation onto database clouds. Hands-On Practices Demonstrations and hands-on practice reinforce the fundamental concepts that you'll learn in this course. By enrolling in this course, you'll begin using Oracle SQL Developer to develop these program units. SQL*Plus is available as optional tools. Course Bundle Note: This course is a combination of Oracle Database: SQL Workshop I and Oracle Database: PL/SQL Fundamentals courses.