Introduction to SQL training helps you write subqueries, combine multiple queries into a single query using SET operators and report aggregated data using group functions. Learn this and more through hands-on exercises.

Learn Advanced Features of SQL:

This course will help you understand the advanced features of SQL. Learning 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. Some of the date-time functions available in the Oracle Database are also covered. This course also discusses how to use the regular expression support in SQL through expert instruction.

Module Objectives:

• Identify the major structural components of the Oracle Database

• Write SELECT statements that include queries

• Retrieve row and column data from tables

• Run data manipulation statements (DML) in Oracle Database

• Create tables to store data

• Utilize views to display data Control database access to specific objects

• Manage schema objects

• Display data from multiple tables using the ANSI SQL 99 JOIN syntax

• Manage objects with data dictionary views

• Write multiple-column sub-queries

• Employ SQL functions to retrieve customized data

Module Topics:

• Introduction

• Retrieving Data using the SQL SELECT Statement

• Restricting and Sorting Data

• Using Single-Row Functions to Customize Output

• Using Conversion Functions and Conditional Expression

• Reporting Aggregated Data Using the Group Functions

• Displaying Data from Multiple Tables Using Joins

• Using Subqueries to Solve Queries

• Using the SET Operators

• Managing Tables using DML statements

• Introduction to Data Definition Language

• Introduction to Data Dictionary Views

• Creating Sequences, Synonyms, Indexes

• Creating View

• Managing Schema Objects

• Retrieving Data by Using Subqueries

• Manipulating Data by Using Subqueries

• Controlling User Access
• Manipulating Data

In the Oracle Database 12c/19c: Administration course, you’ll learn how to perform administrator and management tasks for Oracle Database 12c. Expert instructors will teach you how these to increase configure, monitor and manage performance.

Benefits to You:

As a DBA you will need to ensure fast, reliable, secure and easy to manage performance of the database, which is done by effectively managing an Oracle instance, configuring the network environment properly, and performing database maintenance on a regular basis.

Prerequisites Requirements

• You should know Oracle SQL very well.

• PL/SQL will be added value for this course, but it is not mandatory.

• Windows Operating system is preferred, but it is not mandatory.

• Minimum 50 GB free space in order to install oracle and doing backup exercises.

• Minimum 8 GB RAM

Module Topics:

Oracle Database 19c - Administration:

• Introduction

• Understanding Oracle Database Instance Configurations

• Understanding Logical and Physical Database Structures

• Understanding Oracle Database Server Architecture

• Managing Users, Roles and Privilege

• Exploring Oracle Database Architecture

• Oracle Database Management Tools

• Exploring Oracle Database Architecture

• Oracle Database Management Tools

• Managing the Database Instance

• Configuring the Oracle Network Environment

• Administering User Security

• Managing Database Storage Structures

• Managing Space

• Managing Undo Data

• Managing Data Concurrency

• Implementing Oracle Database Auditing

• Backup and Recovery: Configuration

• Moving Data

• Database Maintenance

• Managing Performance
• Managing Performance: SQL Tuning

This Oracle Database 12c/19c: Backup and Recovery Workshop will teach you how to evaluate your own recovery requirements. You will develop appropriate strategies for backup, restore and recovery procedures from provided scenarios. In this course, you will be introduced to Oracle Database Cloud Service.

• Develop 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.

• Gain an understanding of the Oracle Database Cloud Service.

Module Objectives:

• Use the Data Recovery Advisor to diagnose and repair failures.

• Use Oracle Flashback Technologies to recover from human error.

• Perform an encrypted database backup and restore.

• Perform tablespace point-in-time recovery.

• Describe additional high availability features such as Oracle Data Guard.

• Gain an understanding of the Oracle Database Cloud Service

• Describe Oracle Database backup methods and recovery operations that can be used to resolve database failure.

• Describe the Oracle Database architecture components related to backup and recovery operations

Module Topics:

• Introduction

• Getting Started

• Configuring for Recoverability

• Using the RMAN Recovery Catalog

• Backup Strategies and Terminology

• Performing Backups

• Improving and planning for effective Backup

• Diagnosing Database Failures

• Restore and Recovery Concepts

• Performing Recovery

• RMAN and Oracle Secure Backup

• Performing RMAN Disk Backups

• Overview of Oracle Data Pump

• Oracle Data pump Export

• Oracle Data Pump Import

• Performing Tape Backups and Restores concept

• Using Flashback Technologies to solve the human error

• Flashback Database/Table

• Oracle Database: Managing Multitenant Architecture 19c

• Creating CDBs and Regular PDBs
• Manage CDBs and PDBs

Module Prerequisites:

Before starting this advance module, you should have already completed Oracle Database Administration (part1) & Database Administration (part-2) with confidence.

Module Objectives:

As a result of completing this module, you will be able to :

• Implement Oracle Dataguard/ physical Standby

• Patch & Opatch on Oracle Database Software

• Linux server to server RMAN backup database restore and recover

Module Topics:

• Oracle Database software Patching

• Opatch & Patching real scenario knowledge sharing

• Server to server RMAN backup restore & recover in Linux Platform

• Data Guard Components

• Types of Data Guard

• Details conceptual & technical knowledge about DG

• Data Guard Transport Method

• Configuration physical Standby or Data Guard and ensure asynchronization with primary

• Differences between Switchover and Failover

• Snapshot Standby configuration and understanding the practical use of different

• Standby Database
• Mock test (viva exam) and check the confidence level of Participants and gap analysis about Administration & Advance features which already done.