3 Days
Module 1: Querying Data with the SQL SELECT Statement
Module 2: Restricting and Sorting Data
Module 3: Using Single-Row Functions
Module 4: Conditional Expressions and Conversion Functions
Module 5: Grouping Data – Group Functions
Module 6: Joining Multiple Tables (JOINS)
Module 7: Subqueries
Module 8: Using Set Operators
Module 9: DML Operations
Module 10: DDL Operations
3 Days
Module 1: PL/SQL Identifiers
Module 2: Writing Executable Statements
Module 3: Control Structures
Module 4: Explicit Cursors
Module 5: Exception Handling
Module 6: Procedures and Functions
Module 7: Packages
3 Days
Module 1: SQL Statement Processing
Module 2: Optimizer
Module 3: Interpreting the Execution Plan
Module 4: Application Tracing
Module 5: Table and Index Operations
Module 6: Optimizer Operators and Join Methods
Module 7: Star Transformation
Module 8: Using Hints
Module 9: Optimizer Statistics
Module 10: SQL Tuning Advisor
Module 11: SQL Access Advisor
Module 12: SQL Plan Management
3 Days
Module 1: PL/SQL Programming Concepts: Review
Module 2: Designing PL/SQL Code
Module 3: Overview of Collections
Module 4: Using Collections
Module 5: Manipulating Large Objects
Module 6: Using Advanced Interface Methods
Module 7: Performance and Tuning
Module 8: Improving Performance with Caching
Module 9: Analyzing PL/SQL Code
Module 10: Profiling and Tracing PL/SQL Code
3 Days
Module 1: PL/SQL Identifiers
Module 2: Writing Executable Statements
Module 3: Control Structures
Module 4: Explicit Cursors
Module 5: Exception Handling
Module 6: Procedures and Functions
Module 7: Packages
5 Days
Module 1: Basic Tuning Diagnostics
Module 2: Using Automatic Workload Repository
Module 3: Defining the Scope of Performance Issues
Module 4: Using Metrics and Alerts
Module 5: Using Baselines
Module 6: Using AWR-Based Tools
Module 7: Real-Time Database Operation Monitoring
Module 8: Monitoring Applications
Module 9: Identifying Problem SQL Statements
Module 10: Influencing the Optimizer
Module 11: Reducing the Cost of SQL Operations
Module 12: Using SQL Performance Analyzer and Database Replay
Module 13: SQL Performance Management
Module 14: Tuning Memory, I/O
4 Days
Module 1: Using Enterprise Manager and RMAN
Module 2: Configurations Required for Database Recoverability
Module 3: Using the RMAN Recovery Catalog
Module 4: Performing Backups
Module 5: Restore and Recovery
Module 6: Performing Recovery
Module 7: Using Data Recovery Advisor
Module 8: Flashback Technologies
Module 9: RMAN Performance Tuning
5 Days
Module 1: Oracle Data Guard
Module 2: Creating a Physical Standby Database
Module 3: Oracle Data Guard Broker
Module 4: Creating a Logical Standby Database
Module 5: Creating a Snapshot Standby Database
Module 6: Oracle Active Data Guard
Module 7: Configuring Data Protection Modes
Module 8: Role Transitions
Module 9: Monitoring Data Guard Configuration
5 Days
Module 1: Oracle Grid Infrastructure Concepts
Module 2: Oracle Clusterware Architecture
Module 3: Grid Infrastructure Pre-installation Preparation
Module 4: Grid Infrastructure Installation
Module 5: Creating a Cluster Database
Module 6: Adding/Removing Cluster Nodes
Module 7: Oracle Clusterware Management
Module 8: Grid Infrastructure Upgrades and Patching
Module 9: Backup and Recovery on RAC
Module 10: Monitoring the RAC Database
5 Days
Module 1: Oracle Database Architecture
Module 2: Oracle Enterprise Linux Installation
Module 3: Linux Operating System Configuration
Module 4: Oracle 11g R2 Grid Infrastructure Software Installation
Module 5: Oracle 11g R2 Database RDBMS Software Installation and Configuration
Module 6: Oracle Net Services
Module 7: User Account Management
Module 8: Introduction to Oracle Database Administration
5 Days
Module 1: Oracle Database Performance Management
Module 2: Database Backup and Recovery with RMAN
Module 3: Flashback Technology
Module 4: Oracle ASM
Module 5: Data Pump (Export/Import)
Module 6: Automating Database Tasks
Module 7: Oracle Resource Management
3 Days
Module 1: Oracle GoldenGate Architecture
Module 2: Installation and Configuration
Module 3: Switchover and Various Test Scenarios
Module 4: Monitoring Oracle GoldenGate Configuration
5 Days
Module 1: What is PostgreSQL?
Module 2: PostgreSQL Cluster Structure
Module 3: PostgreSQL System Architecture
Module 4: PostgreSQL Data Dictionary
Module 5: Installation
Module 6: Command Line Tools
Module 7: Creating Databases in PostgreSQL and SQL Fundamentals
Module 8: PostgreSQL Configuration File
Module 9: PostgreSQL Security and Access File
Module 10: Users and Authorization
Module 11: The Schema Concept in PostgreSQL
Module 12: Creating Tablespaces
Module 13: Importing and Exporting Data via Dumps
5 Days
Module 1: The COPY Command in PostgreSQL
Module 2: PostgreSQL Maintenance and Autovacuum
Module 3: Transaction and Lock Concepts
Module 4: Partitioning
Module 5: Backup and Recovery
Module 6: Archive Mode & WAL Shipping
Module 7: Streaming Replication & Hot/Warm Standby
4 Days
Module 1: MongoDB Architecture and Installation
Module 2: MongoDB Compass and CRUD Operations
Module 3: Schema Design and Data Modeling
Module 4: Administration
Module 5: Scalability and Availability
Module 6: Indexing and Aggregation Framework
Module 7: Application Development and MongoDB Tools
Module 8: Additional MongoDB Concepts
5 Days
Module 1: Authentication
Module 2: Authorization and Encryption
Module 3: Auditing
Module 4: Replication
Module 5: Sharding
5 Days
Module 1: Introduction
Module 2: Exadata Database Machine Overview
Module 3: Exadata Storage Server Features: Overview
Module 4: Key Capabilities of Exadata Database Machine
Module 5: Exadata Database Machine Initial Configuration
Module 6: Exadata Storage Server Configuration
Module 7: I/O Resource Management
Module 8: Recommendations for Optimizing Database Performance
Module 9: Using Smart Scan
Module 10: Consolidation Options, Migrating Databases to Exadata Database Machine
Module 11: Bulk Data Loading using Oracle DBFS
Module 12: Configuring Enterprise Manager Cloud Control 12c to Monitor Exadata Database Machine, Exadata Storage Servers, Database Servers,Infiniband Network
Module 13: Backup and Recovery
Module 14: Exadata Database Machine Maintenance Tasks
Module 15: Patching Exadata Database Machine
5 Days
Module 1: Introduction to SQL Server
Module 2: SQL Server Installation
Module 3: Database Operations
Module 4: The Concept of Indexes in SQL Server
Module 5: Views
Module 6: Stored Procedures
Module 7: User-Defined Functions
Module 8: The Concept of Transactions / OLTP Systems
Module 9: Triggers
Module 10: DDL Triggers
Module 11: Server Triggers
