Class on Demand Introduction to Oracle 11g Database Administration LiveLessons (Download)

Class on Demand Introduction to Oracle 11g Database Administration LiveLessons (Download)

Class on Demand Introduction to Oracle 11g Database Administration LiveLessons (Download)

B&H # CLINO11GDBA MFR # 9780133259384
Class on Demand Introduction to Oracle 11g Database Administration LiveLessons (Download)


Show MoreLess


Now Viewing:

No Longer Available
Free Store Pick Up

You can order this item today and pick it up at the B&H NYC Superstore during regular business hours.

Store Schedule Get Directions

Product Highlights

  • Instructor: Michael McLaughlin
  • 1Description

Introduction to Oracle Database 11g Administration LiveLessons from Class on Demand is a complete introductory training course covering the basic architecture, roles, and processes of being an Oracle Database Administrator.

Oracle Ace, author, and Brigham Young University-Idaho instructor, Michael McLaughlin teaches the basics of administering an Oracle database. Viewers will learn how to install the Oracle Database 11g software, work with SQL, understand how storage management works, manage users and security, manage schema objects, perform recovery and backup, and administer alerts, metrics, and advanced tuning. Throughout these LiveLessons, the DB console, which is the Oracle Enterprise Manager (OEM), is used to teach how to administer a database. By the end of these LiveLessons, viewers will be prepared to continue their studies on the path to becoming a DBA.

Table of Contents

Lesson 1: Introduction to Databases | Learning Objectives
Lesson 1.1: Introduction to Databases | Relational databases
Lesson 1.2: Introduction to Databases | SQL
Lesson 1.3: Introduction to Databases | Relationships
Lesson 1.4: Introduction to Databases | Connections and Sessions
Lesson 2: Installing Oracle Database | Learning Objectives
Lesson 2.1: Installing Oracle Database | Installing Oracle
Lesson 2.2: Installing Oracle Database | Database configuration assistants
Lesson 2.3: Installing Oracle Database | Configuration tables
Lesson 2.4: Installing Oracle Database | Oracle Enterprise Manager (OEM)
Lesson 3: Instance Management | Learning Objectives
Lesson 3.1: Instance Management | SQL*Plus
Lesson 3.2: Instance Management | SQL developer
Lesson 3.3: Instance Management | SGA
Lesson 3.4: Instance Management | Starting and stopping OEM
Lesson 3.5: Instance Management | Database parameters
Lesson 3.6: Instance Management | Memory Management
Lesson 4: Storage Management | Learning Objectives
Lesson 4.1: Storage Management | Control files
Lesson 4.2: Storage Management | Redo log files
Lesson 4.3: Storage Management | Tablespace
Lesson 4.4: Storage Management | Undo data
Lesson 5: Managing Users and Security | Learning Objectives
Lesson 5.1: Managing Users and Security | Users and tablespaces
Lesson 5.2: Managing Users and Security | Privileges
Lesson 5.3: Managing Users and Security | Roles and profiles
Lesson 6: Managing Schema Objects | Learning Objectives
Lesson 6.1: Managing Schema Objects | Schemas
Lesson 6.2: Managing Schema Objects | Creating tables
Lesson 6.3: Managing Schema Objects | Constraints
Lesson 6.4: Managing Schema Objects | Indexes, views, and stored programs
Lesson 7: Backup and Recovery | Learning Objectives
Lesson 7.1: Backup and Recovery | Oracle database recovery features
Lesson 7.2: Backup and Recovery | Types of recovery
Lesson 7.3: Backup and Recovery | Backup policies for configuration
Lesson 8: Administration and Upgrade | Learning Objectives
Lesson 8.1: Administration and Upgrade | OEM Advisors
Lesson 8.2: Administration and Upgrade | Configuring and using alerts and metrics
Lesson 8.3: Administration and Upgrade | Automatic Database Diagnostic Monitor (ADDM)
Lesson 8.4: Administration and Upgrade | Other Available Advisors
Table of Contents
  • 1Description
Runtime 3:05:31
Be the first to review this item
See any errors on this page? Let us know.