Course Category: Oracle

Module 1: Introduction to Oracle Data Guard Module 2: Networking for Oracle Data Guard Module 3: Creating a Physical Standby Database by Using SQL and RMAN Commands Module 4: Oracle Data Guard Broker: Overview Module 5: Creating a Data Guard Broker Configuration Module 6: Creating a Physical Standby Database by…

Module 1: Introduction Module 2: Auditing Using Unified Audit Module 3: Controlling Data Access Using Privileges and Profiles Module 4: Controlling Data Access Using Privilege Analysis Module 5: Redacting Data Module 6: Encrypting Data Module 7: Controlling Data Access Using Transparent Sensitive Data Protection Module 8: Making Data Available by…

Module 1: Grid Infrastructure Overview and Review Module 2: RAC Databases Overview & Architecture Module 3: Installing and Configuring Oracle RAC Module 4: Oracle RAC Administration Module 5: Upgrading and Patching Oracle RAC Module 6: Managing Backup and Recovery for RAC Module 7: RAC Global Resource Management and Cache Fusion…

Module 1: Partitioning Concepts Module 2: Implementing Partitioned Tables Module 3: Implementing Partitioned Indexes Module 4: Maintenance of Partitioned Tables and Indexes Module 5: Partitioning Administration and Usage Module 6: Partitioning and Workload Types Module 7: Oracle Database Cloud Service: Overview

Module 1: Parallel execution concepts Module 2: Using Manual DOP Module 3: Using Auto DOP Module 4: Using Statement Queuing Module 5: In-Memory Parallel Execution Module 6: Parallel Execution and Data Loading Module 7: Troubleshoot situations when parallel processing does not proceed as desired Module 8: Managing a Mixed Workload…

Module 1: Introduction to Grid Infrastructure Module 2: Oracle Clusterware Architecture Module 3: Flex Cluster Architecture Module 4: Grid Infrastructure Pre-Installation Tasks Module 5: Installing Grid Infrastructure Module 6: Managing Cluster Nodes Module 7: Traditional Clusterware Management Module 8: Policy-Based Cluster Management Module 9: Patching Grid Infrastructure Module 10: Troubleshooting…

Module 1: Introduction Module 2: Basic Tuning Diagnostics Module 3: Using Automatic Workload Repository Module 4: Defining the Scope of Performance Issues Module 5: Using Metrics and Alerts Module 6: Using Baselines Module 7: Using AWR-Based Tools Module 8: Real-Time Database Operation Monitoring Module 9: Monitoring Applications Module 10: Identifying…

Global Data Services Overview Overview Of Global Data Services Global Data Services Framework Global Services Global Connection Load Balancing Global Runtime Connection Load Balancing Failover of Global Services Global Data Services Framework Installing a Global Service Manager Creating the Global Data Services Catalog Adding a Global Service Manager to the…

Oracle Database 12c Overview Oracle Database 12c Introduction Oracle Database Architecture Overview Oracle Database Instance Configurations Oracle Database Memory Structures Process Structures Database Storage Architecture Logical and Physical Database Structures Container and Pluggable Database Overview Installing Oracle Grid Infrastructure for a Standalone Server Overview of Oracle Grid Infrastructure for a…

Course Introduction Course Objectives Course Agenda Schemes used in this course Classroom account information Overview of SQL Developer 4.0 Review the Oracle Database 12c SQL and PL/SQL documentation and additional resources SQL Language Enhancements SQL Row Limiting Clause Invisible and Hidden Columns Enhanced DDL capabilities using ONLINE keyword Additional features…

Course Overview  Course Objectives, Course Agenda and Class Account Information Describe the Human Resources (HR) Schema Identify the Appendices Used in this Course Understanding the Oracle Database Environment  Understanding the Oracle Database Environment Understanding the Oracle Instance Processing a SQL Statement Understanding Data Flow During SQL Statement Processing Understanding Read…

Introduction to Oracle Database Retrieve Data using the SQL SELECT Statement Learn to Restrict and Sort Data Usage of Single-Row Functions to Customize Output Invoke Conversion Functions and Conditional Expressions Aggregate Data Using the Group Functions Display Data From Multiple Tables Using Joins Use Sub-queries to Solve Queries The SET…

Introduction Retrieve Data using the SQL SELECT Statement Restricted and Sorted Data Usage of Single-Row Functions to Customize Output Conversion Functions and Conditional Expressions Aggregated Data Using the Group Functions Display Data From Multiple Tables Usage of Subqueries to Solve Queries SET Operators Data Manipulation DDL Statements to Create and…

Module 1: Introduction Module 2: Introduction to SQL Tuning Module 3: Using Application Tracing Tools Module 4: Understanding Basic Tuning Techniques Module 5: Optimizer Fundamentals Module 6: Generating and Displaying Execution Plans Module 7: Interpreting Execution Plans and Enhancements Module 8: Optimizer: Table and Index Access Paths Module 9: Optimizer…

Module 1: Java Platform Overview Module 2: Java Syntax and Class Review Module 3: Encapsulation and Subclassing Module 4: Overriding Methods, Polymorphism, and Static Classes Module 5: Abstract and Nested Classes Module 6: Interfaces and Lambda Expressions Module 7: Collections and Generics Module 8: Collections Streams, and Filters Module 9:…

Module 1: Introduction Module 2: The Broker Tool Application Module 3: JavaFX Overview Module 4: Generics and JavaFX Collections Module 5: UI Controls, Layouts, Charts, and CSS Module 6: Visual Effects, Animation, Web View, and Media Module 7: JavaFX Tables and Client GUI Module 8: JavaFX Concurrency and Binding Module…

Module 1: Examining Object-Oriented Concepts and Terminology Module 2: Introducing Modeling and the Software Development Process Module 3: Creating Use Case Diagrams Module 4: Creating Use Case Scenarios and Forms Module 5: Creating Activity Diagrams Module 6: Determining the Key Abstractions Module 7: Constructing the Problem Domain Model Module 8:…

Functional Programming Functional Interfaces and Lambda Expressions Collections Streams, and Filters Built-in Functional Interfaces Modular Programming Introduction to Modular Programming in Java Services in a Modular Application Migration to a Modular Application Streams and Parallel Streams Concurrency Parallel Streams Terminal Operations: Collectors Creating Custom Streams Java API Programming and Secure…

What is a Java Program Key features of the Java language Java technology and development environment Running and testing a Java program Creating a Java Main class Java classes The Main method Adding a Main method Data in the Cart Introducing variables Working with strings Working with numbers Manipulating numeric…

Module 1: Functional Programming Module 2: Modular Programming Module 3: Streams and Parallel Streams Module 4: Java API Programming and Secure Coding Concepts Module 5: Collections and Generics Module 6: Exception Handling and Assertions

Module 1: What is a Java Program Module 2: Creating a Java Main class Module 3: Data in the Cart Module 4: Managing Multiple Items Module 5: Working with conditions Module 6: Describing Objects and Classes Module 7: Manipulating and Formatting the Data in Your Program Module 8: Creating and…

Module 1: Java Platform Overview Module 2: Java Syntax and Class Review Module 3: Encapsulation and Subclassing Module 4: Java Class Design Module 5: Advanced Class Design Module 6: Inheritance with Java Interfaces Module 7: Generics and Collections Module 8: String processing Module 9: Exceptions and Assertions Module 10: I/O…

Module 1: Course Introduction Module 2: Introducing Lambda Expressions Module 3: A Case for Lambda Expressions Module 4: Filtering Collections with Lambdas Module 5: Using Built in Lambda Types Module 6: Collection Operations with Lambda Module 7: Parallel Streams Module 8: Lambda Cookbook Module 9: Method Enhancements Module 10: Using…

Module 1: Introduction Module 2: Introduction to Oracle XML Module 3: Introduction to Oracle XML DB Module 4: Storing XML Data in Oracle XML DB Module 5: Using XML Schema with Oracle XML DB Module 6: Oracle XML DB Manageability Module 7: Partitioning XMLType Tables Module 8: Using XQuery to…