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.

Course Objectives:

• Identify the major structural components of the Oracle Database 12c

• Write SELECT statements that include queries

• Retrieve row and column data from tables

• Run data manipulation statements (DML) in Oracle Database 12c

• 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

Course 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 Expressions

• 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 Views

• Managing Schema Objects

• Retrieving Data by Using Subqueries

• Manipulating Data by Using Subqueries

• Controlling User Access

• Manipulating Data

• Managing Data in Different Time Zone

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

Course Topics:

• Oracle Database 12c/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: Concepts

• Backup and Recovery: Configuration

• Performing Database Backups

• Performing Database Recovery

• Moving Data

• Database Maintenance

• Managing Performance

• Managing Performance: SQL Tuning

This Oracle Database 12c: 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.

Course 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

Course Topics:

• Introduction

• Getting Started

• Configuring for Recoverability

• Using the RMAN Recovery Catalog

• Backup Strategies and Terminology

• Performing Backups

• Improving Your Backups

• Using RMAN-Encrypted Backups

• Diagnosing Database Failures

• Restore and Recovery Concepts

• Performing Recovery, Part 1

• Performing Recovery, Part 2

• RMAN and Oracle Secure Backup

• Performing Tape Backups and Restores

• Using Flashback Technologies

• Flashback Database

• Oracle Database: Managing Multitenant Architecture 19c

• Creating CDBs and Regular PDBs

• Manage CDBs and PDBs

• Oracle Cloud Infrastructure