Books & Videos

Table of Contents

Chapter: Introduction

Introduction

02m 25s

Chapter: Lesson 1: Introduction to Databases

Learning objectives

00m 33s

1.1 Relational databases

09m 27s

1.2 SQL

06m 4s

1.3 Relationships

04m 25s

1.4 Connections and sessions

03m 49s

Chapter: Lesson 2: Installing Oracle Database

Learning objectives

00m 53s

2.1 Installing Oracle

21m 36s

2.2 Database configuration assistants

17m 19s

2.3 Configuration tables

03m 56s

2.4 Oracle Enterprise Manager (OEM)

09m 57s

Chapter: Lesson 3: Instance Management

Learning objectives

00m 36s

3.1 SQL*Plus

11m 16s

3.2 SQL developer

07m 23s

3.3 SGA

02m 57s

3.4 Starting and stopping OEM

03m 3s

3.5 Database parameters

02m 42s

3.6 Memory Management

02m 37s

Chapter: Lesson 4: Storage Management

Learning objectives

00m 22s

4.1 Control files

01m 37s

4.2 Redo log files

02m 20s

4.3 Tablespace

03m 5s

4.4 Undo data

01m 47s

Chapter: Lesson 5: Managing Users and Security

Learning objectives

00m 24s

5.1 Users and tablespaces

02m 59s

5.2 Privileges

04m 15s

5.3 Roles and profiles

02m 56s

Chapter: Lesson 6: Managing Schema Objects

Learning objectives

00m 32s

6.1 Schemas

04m 4s

6.2 Creating tables

09m 59s

6.3 Constraints

02m 42s

6.4 Indexes, views, and stored programs

14m 37s

Chapter: Lesson 7: Backup and Recovery

Learning objectives

00m 27s

7.1 Oracle database recovery features

01m 26s

7.2 Types of recovery

02m 35s

7.3 Backup policies for configuration

05m 7s

Chapter: Lesson 8: Administration and Upgrade

Learning objectives

00m 33s

8.1 OEM Advisors

02m 50s

8.2 Configuring and using alerts and metrics

01m 53s

8.3 Automatic Database Diagnostic Monitor (ADDM)

01m 31s

8.4 Other Available Advisors

02m 32s

Chapter: Summary

Summary

01m 46s