by | Released September 2012 | ISBN: 0133259382

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. Show and hide more

1. Introduction
   • Introduction 00:02:25
2. 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
3. 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
4. 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
5. 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
6. 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
7. 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
8. 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
9. 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
10. Summary
    • Summary 00:01:47
Show and hide more