I – ORACLE DATABASES : ADMINISTRATION WORKSHOP

UNDERSTANDING ORACLE DATABASE ARCHITECTURE

– Understand the configurations of Oracle database instances

– Understand the memory and process structures of Oracle databases

– Understand the logical and physical structures of databases

– Understand the architecture of the Oracle database server

MANAGING DATABASE INSTANCES

– Starting Oracle database instances

– Using data dictionary views

– Stopping Oracle database instances

– Using Dynamic Performance Views

– Using the Automatic Diagnostic Repository (ADR)

– Using Alert Log and Trace Files

– Managing initialization parameter files

MANAGING USERS, ROLES AND PRIVILEGES

– Assigning quotas to users

– Apply the principle of least privilege

– Create and assign profiles

– Administration of user authentication methods

– Manage users, privileges and roles for Oracle databases

STORAGE MANAGEMENT

– Manage resumable space allocation

– Collapse segments

– Deferring segment creation

– Use of space-saving features

– Deploying Oracle Database Space Management Features

– Managing different types of segments

– Using Table and Row Compression

– Understanding block space management

MOVING DATA

– Using external tables

– Using Oracle Data Pump

– Using SQL*Loader

ACCESSING ORACLE DATABASES WITH TOOLS PROVIDED BY ORACLE

– Using the Database Configuration Assistant (DBCA)

– Using Oracle Enterprise Manager Cloud Control

– Using Oracle Enterprise Manager Database Express

– Using SQL Developer

– Using SQL Plus

CONFIGURING ORACLE NET SERVICES

– Using Oracle Net Services Administration Tools

– Configuring Communication Between Database Instances

– Configuring the Oracle Net Listener

– Connecting to an Oracle Database Instance

– Comparing dedicated and shared server configurations

– Administration of naming methods

MANAGING TABLESPACES AND DATA FILES

– Viewing information about tablespaces

– Creating, editing and deleting tablespaces

– Manage table data storage

– Implementing Oracle Managed Files

– Moving and renaming data files online

HANDLING UNDOS

– Understanding undo transactions and data

– Storing undo information

– Setting up undo data retention

– Comparing undo data to recovery data

– Understanding temporary undos

II – ORACLE DATABASES: INTRODUCTION TO SQL

DATA RESTRICTION AND SORTING

– Applying precedence rules for operators in an expression

– Restricting the rows returned in an SQL statement

– Using substitution variables

– Using DEFINE and VERIFY commands

USING CONVERSION FUNCTIONS AND CONDITIONAL EXPRESSIONS

– Apply NVL, NULLIF and COALESCE functions to data

– Understand implicit and explicit data type conversion

– Use the TO_CHAR, TO_NUMBER and TO_DATE conversion functions

– Nesting several functions

DISPLAYING DATA ACROSS MULTIPLE TABLES USING JOINS

– Using Auto-Joins

– Using different types of joins

– Using non-joins

– Using external joins

USING SET OPERATORS

– Mapping SELECT statements

– Using the ORDER BY clause in set operations

– Using the INTERSECT operator

– Using the MINUS operator

– Using the UNION and UNION ALL operators

UNDERSTANDING THE DATA DEFINITION LANGUAGE

– Using the data definition language

MANAGING VIEWS

– Managing views

MANAGING DATA IN DIFFERENT TIME ZONES

– Use of CURRENT_DATE, CURRENT_TIMESTAMP and LOCALTIMESTAMP

– Use of INTERVAL data types

RETRIEVING DATA USING THE SELECT STATEMENT

– Using column aliases

– Using the DESCRIBE command

– Using the SQL SELECT statement

– Using the concatenation operator, string literals, the alternate quote operator and the DISTINCT keyword

– Use of arithmetic expressions and NULL values in the SELECT statement

USING THE SINGLE LINE OPTION TO CUSTOMIZE OUTPUT

– Manipulating strings with character functions in SQL SELECT and WHERE clauses

– Performing arithmetic calculations with date data

– Manipulating numbers with ROUND, TRUNC and MOD functions

– Manipulating dates using the date function

CARRYING OVER AGGREGATED DATA USING GROUP FUNCTIONS

– Restrict group results

– Creating data groups

– Using group functions

USING SUBQUERIES TO SOLVE QUERIES

– Using Single Row Subqueries

– Using subqueries on multiple rows

MANAGING TABLES USING DATA MANIPULATION LANGUAGE (DML) STATEMENTS

– Managing database transactions

– Using the data manipulation language

– Controlling transactions

MANAGING SEQUENCES, SYNONYMS AND INDEXES

– Managing indexes

– Managing synonyms

– Sequence management

SCHEMA MANAGEMENT

– Create and use temporary tables

– Managing constraint

Duration: 16 days

PRE-REQUISITES

Have some experience or exposure to Oracle database administration technology.