O'Reilly logo

Stay ahead with the world's most comprehensive technology and business learning platform.

With Safari, you learn the way you learn best. Get unlimited access to videos, live online training, learning paths, books, tutorials, and more.

Start Free Trial

No credit card required

Oracle DBA Fundamentals

Video Description

Oracle DBA Fundamentals Complete Video Course presents the architecture, roles, and process of being an Oracle Database Administrator. The video training covers all of the core skills required to administer an Oracle database.

DBAs will be able to follow a basic core curriculum structure, or look for specific topical areas that they need more information on.

Description

Part 1 covers an introduction to the Oracle Database and the role of the DBA. Topics include Oracle Database architecture, installing the Oracle Database, creating the Oracle Database, connecting to the database, and administrating users. In addition, the video covers Basic SQL for a DBA and administer code files.

About the Instructor

Robert G. Freeman is an Oracle DBA with more than 25 years of experience working with Oracle database-related software. He currently works for Businessolver, Inc. in Des Moines, IA. Robert worked for Oracle Corporation for five years and has worked for, contracted at, or consulted with such organizations as CSX Railroad, United Airlines, the FBI, The Federal Reserve, The Chicago Board of Trade Clearing Corporation, the Congress of the United States, and many other commercial and Federal organizations. He is the author and co-author of numerous books, including Oracle Database 12c New Features and Oracle Database 12c RMAN Backup and Recovery, among others.

Skill Level

  • Beginner
You Will Learn How To
  • Understand the Oracle Database architecture
  • Install and deinstall the Oracle Database
  • Create the Oracle Database
  • Connect to the Database
  • Administer users
  • Use basic SQL for DBAs
  • Administer code flies
Who Should Take This Course
  • Individuals training to become a DBA
  • Existing DBAs seeking to improve their skills

About LiveLessons Video Training

The LiveLessons Video Training series publishes hundreds of hands-on, expert-led video tutorials covering a wide selection of technology topics designed to teach you the skills you need to succeed. This professional and personal technology video series features world-leading author instructors published by your trusted technology brands: Addison-Wesley, Cisco Press, IBM Press, Pearson IT Certification, Prentice Hall, Sams, and Que. Topics include: IT Certification, Programming, Web Development, Mobile Development, Home and Office Technologies, Business and Management, and more. View all LiveLessons on InformIT at: http://www.informit.com/livelessons

Table of Contents

  1. Introduction
    1. Oracle DBA Fundamentals: Introduction 00:03:32
  2. Lesson 1: Oracle Database Architecture
    1. Learning objectives 00:01:07
    2. 1.1 Understand the concept of a relational database 00:17:22
    3. 1.2 Understand relational database basics--Part 1 00:19:07
    4. 1.3 Understand relational database basics--Part 2 00:16:18
    5. 1.4 Understand database modeling basics 00:04:53
    6. 1.5 Build a database model: Define a person table 00:18:01
    7. 1.6 Build a database model: Primary, surrogate and natural keys 00:12:25
    8. 1.7 Build a database model: Create a normalized model 00:30:27
    9. 1.8 Understand Oracle Database fundamental concepts--Part 1 00:13:57
    10. 1.9 Understand Oracle Database fundamental concepts--Part 2 00:17:34
  3. Lesson 2: Installing and Deinstalling Oracle Database Software
    1. Learning objectives 00:00:35
    2. 2.1 Prepare to install Oracle Database 00:16:44
    3. 2.2 Download Oracle Database 00:11:30
    4. 2.3 Install Oracle Database software 00:14:38
    5. 2.4 Deinstall Oracle Database software 00:05:34
  4. Lesson 3: Creating the Oracle Database
    1. Learning objectives 00:00:28
    2. 3.1 Prepare to create the Oracle Database 00:51:32
    3. 3.2 Create the Oracle Database with DBUA--Test database 00:20:05
    4. 3.3 Create the Oracle Database with DBUA--Production database: Part 1 00:18:35
    5. 3.4 Create the Oracle Database with DBUA--Production database: Part 2 00:15:12
    6. 3.5 Remove the Oracle Database 00:04:53
  5. Lesson 4: Tools for Connecting to the Oracle Database
    1. Learning objectives 00:00:46
    2. 4.1 Oracle Administration Accounts 00:04:46
    3. 4.2 Connect to the Oracle Database 00:07:59
    4. 4.3 Use SQL*Plus 00:13:20
    5. 4.4 Use SQL Developer 00:09:56
  6. Lesson 5: Administration of Oracle Users
    1. Learning objectives 00:00:45
    2. 5.1 Create Oracle users 00:11:56
    3. 5.2 Drop Oracle users 00:00:59
    4. 5.3 Alter and administer users 00:08:55
    5. 5.4 Understand the Oracle data dictionary 00:06:08
    6. 5.5 Utilize user related data dictionary views 00:17:29
  7. Lesson 6: Basic SQL for the DBA
    1. Learning objectives 00:00:57
    2. 6.1 Understand ACID and the Oracle Database 00:03:48
    3. 6.2 Understand the Oracle read consistency model 00:05:10
    4. 6.3 Understand Oracle read consistency 00:07:47
    5. 6.4 View basic select statements 00:06:28
  8. Lesson 7: Administer Control Files and Redo Logs
    1. Learning objectives 00:00:45
    2. 7.1 Understand database control files 00:04:50
    3. 7.2 Administer a control file 00:05:27
    4. 7.3 Explore control file data dictionary views 00:06:38
    5. 7.4 Understand database redo logs 00:18:08
    6. 7.5 Explore redo log performance considerations 00:09:50
    7. 7.6 Administer the redo log 00:07:42
  9. Summary
    1. Oracle DBA Fundamentals: Summary 00:02:02