Video description
Introduction to Oracle Database 11g Administration
LiveLessonsis 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.
About the Author:
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
Introduction
Introduction
00:02:25
Lesson 1: Introduction to Databases
Learning objectives
00:00:33
1.1 Relational databases
00:09:27
1.2 SQL
00:06:04
1.3 Relationships
00:04:25
1.4 Connections and sessions
00:03:50
Lesson 2: Installing Oracle Database
Learning objectives
00:00:53
2.1 Installing Oracle
00:21:37
2.2 Database configuration assistants
00:17:19
2.3 Configuration tables
00:03:56
2.4 Oracle Enterprise Manager (OEM)
00:09:57
Lesson 3: Instance Management
Learning objectives
00:00:35
3.1 SQL*Plus
00:11:17
3.2 SQL developer
00:07:23
3.3 SGA
00:02:57
3.4 Starting and stopping OEM
00:03:03
3.5 Database parameters
00:02:42
3.6 Memory Management
00:02:38
Lesson 4: Storage Management
Learning objectives
00:00:22
4.1 Control files
00:01:37
4.2 Redo log files
00:02:20
4.3 Tablespace
00:03:05
4.4 Undo data
00:01:47
Lesson 5: Managing Users and Security
Learning objectives
00:00:24
5.1 Users and tablespaces
00:02:59
5.2 Privileges
00:04:16
5.3 Roles and profiles
00:02:57
Lesson 6: Managing Schema Objects
Learning objectives
00:00:32
6.1 Schemas
00:04:05
6.2 Creating tables
00:09:59
6.3 Constraints
00:02:43
6.4 Indexes, views, and stored programs
00:14:38
Lesson 7: Backup and Recovery
Learning objectives
00:00:27
7.1 Oracle database recovery features
00:01:26
7.2 Types of recovery
00:02:35
7.3 Backup policies for configuration
00:05:07
Lesson 8: Administration and Upgrade
Learning objectives
00:00:33
8.1 OEM Advisors
00:02:50
8.2 Configuring and using alerts and metrics
00:01:53
8.3 Automatic Database Diagnostic Monitor (ADDM)
00:01:32
8.4 Other Available Advisors
00:02:32
Summary
Summary
00:01:47