Books & Videos

Table of Contents

Chapter: Introduction

What Is Oracle

02m 42s

What You Should Expect From This Course

02m 1s

Download And Install Oracle

04m 51s

Chapter: The Technology - OS, Middleware, And Hardware

Operating Systems

04m 56s

Middleware

03m 37s

Hardware

08m 30s

Chapter: The Technology - Database

What Is A Database?

03m 10s

What Are The Types Of Database?

02m 29s

MySQL

01m 39s

TimesTen

01m 51s

BerkleyDB

01m 4s

NoSQL

01m 25s

Oracle Database Server

01m 17s

Oracle Database Server Editions

07m 17s

Documentation And Software

03m 24s

Chapter: Database Architecture

Operating Systems Supported

01m 20s

Database Server

01m 29s

The Database

01m 11s

Database Instance

01m 24s

Background Memory Processes

04m 31s

User Memory Processes

01m 24s

System Global Area

02m 25s

Program Global Area

01m 44s

Networking

01m 13s

Oracle Net Listener

02m 22s

Real Application Clusters

04m 22s

Chapter: Storage

Blocks

02m 27s

Extents

01m 34s

Segments

01m 49s

Tablespaces

02m 31s

Data Files

01m 17s

Control Files

01m 23s

Redo Log Files

02m 50s

Parameter File

01m 7s

Password File

01m 0s

Fast Recovery Area

01m 5s

Alert Logs

02m 5s

Trace Files

01m 54s

ASM, Grid And Cloud

03m 33s

Chapter: Database Structures

The Data Dictionary

06m 28s

Schemas And Users

03m 6s

Tables

07m 14s

Partitions

07m 23s

Temp Tables

03m 27s

B-tree Indexes

08m 8s

Index Organized Tables (IOT)

03m 6s

Bitmap Indexes

04m 13s

Function Based Indexes

05m 17s

Views

03m 39s

Primary And Unique Keys

05m 5s

Foreign Keys

04m 40s

Check Constraints

03m 24s

Synonyms

02m 21s

Table Clusters

01m 26s

Sequences

03m 8s

Object Statistics

01m 40s

Performance Views

03m 40s

Chapter: Oracle IDEs

Oracle SQL Plus

03m 24s

SQL Developer - Chapter 7

06m 50s

Oracle Universal Installer (OUI)

02m 6s

Oracle Enterprise Manager (OEM)

03m 45s

Oracle Database Configuration Assistant (ODCA)

06m 30s

Chapter: Structured Query Language (SQL)

What Is SQL

05m 53s

Select

05m 17s

Insert

05m 27s

Update

03m 46s

Joins

05m 4s

Deletes

02m 17s

Merge

03m 34s

Aggregates

02m 21s

SQL Analytics

05m 45s

Optimizer And Explain Plan

05m 39s

Transactions And Concurrency

06m 19s

Chapter: PL/SQL

What Is PL/SQL

08m 0s

Anonymous Blocks

01m 18s

Procedures

04m 46s

Functions

05m 40s

Packages

07m 35s

Object Types

08m 48s

Dynamic SQL

07m 7s

Application Express (ApEx)

06m 54s

Chapter: XML

What Is XML

01m 43s

What Is XMLDB

01m 17s

XMLType

02m 44s

SQL/XML

05m 25s

XQuery

02m 46s

XML Repository

03m 14s

XML Storage Models

01m 59s

Chapter: Analysis Tasks With Oracle Data Modeler

Data Modelling

02m 51s

The Conceptual Model

03m 4s

The Logical Model

05m 8s

The Physical Model

04m 3s

Deploying A Data Model

03m 0s

Reverse Engineering

02m 39s

Chapter: Database Tasks

Backup And Recovery

03m 22s

Startup And Shutdown An Instance

05m 20s

The Listener

04m 48s

Create And Remove Users

10m 3s

Monitor Sessions

05m 7s

Monitor Resources

03m 10s

Monitoring Space Usage

01m 44s

Adding Space

04m 29s

Freeing Space

03m 31s

Replication And Streams

04m 38s

Database Scheduling

05m 35s

Chapter: Data Import/Export

SQL Loader

04m 1s

External Tables

04m 17s

Data Pump

03m 58s

SQL Plus

02m 28s

SQL Developer - Chapter 13

06m 26s

ETL Tools

02m 24s

Chapter: Database Security

Database Security

03m 16s

Data Control Language (DCL)

03m 55s

System And Object Privileges

03m 35s

Roles

05m 55s

DBA And Developer Access

02m 48s

Virtual Private Database (VPD)

05m 53s

Fine Grained Auditing (FGA)

04m 30s

Transparent Data Encryption (TDE)

05m 34s

SQL Injection

06m 28s

Chapter: Very Large Databases (VLDB)

VLDB

08m 35s

OLAP

02m 38s

Data Mining

04m 31s

Chapter: About The Author

About The Author

02m 55s