Oracle DBA Fundamentals

Oracle DBA Fundamentals

by Robert G. Freeman
Released December 2016
Publisher(s): Pearson
ISBN: 013466521X

Read it now on the O’Reilly learning platform with a 10-day free trial.

O’Reilly members get unlimited access to live online training experiences, plus books, videos, and digital content from O’Reilly and nearly 200 trusted publishing partners.

Start your free trial

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
  2. Lesson 1: Oracle Database Architecture
    1. Learning objectives
    2. 1.1 Understand the concept of a relational database
    3. 1.2 Understand relational database basics--Part 1
    4. 1.3 Understand relational database basics--Part 2
    5. 1.4 Understand database modeling basics
    6. 1.5 Build a database model: Define a person table
    7. 1.6 Build a database model: Primary, surrogate and natural keys
    8. 1.7 Build a database model: Create a normalized model
    9. 1.8 Understand Oracle Database fundamental concepts--Part 1
    10. 1.9 Understand Oracle Database fundamental concepts--Part 2
  3. Lesson 2: Installing and Deinstalling Oracle Database Software
    1. Learning objectives
    2. 2.1 Prepare to install Oracle Database
    3. 2.2 Download Oracle Database
    4. 2.3 Install Oracle Database software
    5. 2.4 Deinstall Oracle Database software
  4. Lesson 3: Creating the Oracle Database
    1. Learning objectives
    2. 3.1 Prepare to create the Oracle Database
    3. 3.2 Create the Oracle Database with DBUA--Test database
    4. 3.3 Create the Oracle Database with DBUA--Production database: Part 1
    5. 3.4 Create the Oracle Database with DBUA--Production database: Part 2
    6. 3.5 Remove the Oracle Database
  5. Lesson 4: Tools for Connecting to the Oracle Database
    1. Learning objectives
    2. 4.1 Oracle Administration Accounts
    3. 4.2 Connect to the Oracle Database
    4. 4.3 Use SQL*Plus
    5. 4.4 Use SQL Developer
  6. Lesson 5: Administration of Oracle Users
    1. Learning objectives
    2. 5.1 Create Oracle users
    3. 5.2 Drop Oracle users
    4. 5.3 Alter and administer users
    5. 5.4 Understand the Oracle data dictionary
    6. 5.5 Utilize user related data dictionary views
  7. Lesson 6: Basic SQL for the DBA
    1. Learning objectives
    2. 6.1 Understand ACID and the Oracle Database
    3. 6.2 Understand the Oracle read consistency model
    4. 6.3 Understand Oracle read consistency
    5. 6.4 View basic select statements
  8. Lesson 7: Administer Control Files and Redo Logs
    1. Learning objectives
    2. 7.1 Understand database control files
    3. 7.2 Administer a control file
    4. 7.3 Explore control file data dictionary views
    5. 7.4 Understand database redo logs
    6. 7.5 Explore redo log performance considerations
    7. 7.6 Administer the redo log
  9. Summary
    1. Oracle DBA Fundamentals: Summary

Product information

  • Title: Oracle DBA Fundamentals
  • Author(s): Robert G. Freeman
  • Release date: December 2016
  • Publisher(s): Pearson
  • ISBN: 013466521X