3. Oracle Database Administration I (Based on 1Z0-082)

About Course

This comprehensive course delves into the intricacies of Oracle Database administration, focusing on backup and recovery, deployment and patching, and multitenant architecture. You will gain expertise in implementing robust backup and recovery strategies, deploying and upgrading Oracle databases, and managing multitenant environments effectively.

Course Content

Introduction to SQL

SQL syntax and structure
Data types and operators
Basic SQL statements (SELECT, INSERT, UPDATE, DELETE)

Retrieving Data

Data Manipulation

Joining Tables

Data Definition and Manipulation Language (DDL and DML)

Advanced SQL Topics

Oracle Database Architecture:

Managing Database Instances

User Management

Storage Management

Data Movement

Oracle Tools and Utilities

Networking and Connectivity

Performance Tuning

PL/SQL Development

Student Ratings & Reviews

No Review Yet

About Course

Course Content

Introduction to SQL

SQL syntax and structure

Data types and operators

Basic SQL statements (SELECT, INSERT, UPDATE, DELETE)

Retrieving Data

Using the SELECT statement

Filtering data with WHERE clauses

Sorting data with ORDER BY

Grouping data with GROUP BY and HAVING

Data Manipulation

Single-row functions (numeric, character, date)

Conversion functions

Conditional expressions (CASE, DECODE)

Subqueries

Joining Tables

Inner, outer, and self joins

Equijoins and non-equijoins

Using set operators (UNION, INTERSECT, MINUS)

Data Definition and Manipulation Language (DDL and DML)

Creating, altering, and dropping tables

Managing constraints (primary key, foreign key, unique, check)

Managing sequences, indexes, and views

Using transactions

Advanced SQL Topics

Subqueries (correlated and non-correlated)

Analytical functions

Common table expressions (CTEs)

Oracle Database Architecture:

Database instance and its components

Memory architecture (SGA, PGA)

Logical and physical database structures

Server architecture

Managing Database Instances

Starting and stopping instances

Using Data Dictionary views

Monitoring performance with Dynamic Performance Views

Analyzing the Alert Log and Trace Files

User Management

Creating and managing users

Assigning privileges and roles

Managing profiles and quotas

Storage Management

Tablespaces and datafiles

Managing storage allocation

Using space-saving features

Understanding undo data

Data Movement

Using Oracle Data Pump

Using SQL*Loader

External tables

Oracle Tools and Utilities

Database Configuration Assistant (DBCA)

Oracle Enterprise Manager

SQL Developer

SQL*Plus

Networking and Connectivity

Oracle Net Services configuration

Listener setup

Client-server connections

Dedicated and shared server configurations

Performance Tuning

Basic performance monitoring

Identifying performance bottlenecks

Optimization techniques

PL/SQL Development

Introduction to PL/SQL

PL/SQL data types and variables

Control structures (IF-THEN-ELSE, CASE, LOOPS)

Procedures and functions

Cursors and exception handling

PL/SQL packages

Student Ratings & Reviews

Subscribe to our newsletter