Home > Store

Oracle DBA Fundamentals Complete Video Course, Part 1

Online Video

Register your product to gain access to bonus material or receive a coupon.


  • Copyright 2017
  • Edition: 1st
  • Online Video
  • ISBN-10: 0-13-466522-8
  • ISBN-13: 978-0-13-466522-1

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.


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.

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

New Player Enables Streaming and Download Access

Now you can stream and download videos for unlimited 24/7 online/offline access and ownership.
  • Streaming–Watch instantly as the video streams online in real time; after purchase, simply click Watch Now to get started.
  • Download–Download video files for offline viewing anytime, anywhere; after purchase, simply click the Download icon within the player and follow the prompts.
Plus, enjoy new player features that track your progress and help you navigate between modules.

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

Sample Content

Table of Contents


Lesson 1: Oracle Database Architecture
Learning objectives
1.1 Understand the concept of a relational database
1.2 Understand relational database basics—Part 1
1.3 Understand relational database basics—Part 2
1.4 Understand database modeling basics
1.5 Build a database model: Define a person table
1.6 Build a database model: Primary, surrogate and natural keys
1.7 Build a database model: Create a normalized model
1.8 Understand Oracle Database fundamental concepts—Part 1
1.9 Understand Oracle Database fundamental concepts—Part 1

Lesson 2: Installing and Deinstalling Oracle Database Software
Learning objectives
2.1 Prepare to install Oracle Database
2.2 Download Oracle Database
2.3 Install Oracle Database software
2.4 Deinstall Oracle Database software

Lesson 3: Creating the Oracle Database
Learning objectives
3.1 Prepare to create the Oracle Database
3.2 Create the Oracle Database with DBUA—Test database
3.3 Create the Oracle Database with DBUA—Production database: Part 1
3.4 Create the Oracle Database with DBUA—Production database: Part 2
3.3 Remove the Oracle Database

Lesson 4: Tools for Connecting to the Oracle Database
Learning objectives
4.1 Oracle Administration Accounts
4.2 Connect to the Oracle Database
4.3 Use SQL*Plus
4.4 Use SQL Developer

Lesson 5: Administration of Oracle Users
Learning objectives
5.1 Creating Oracle Users
5.2 Dropping Oracle Users
5.3 Altering and administrating users
5.4 Understand the Oracle data dictionary
5.5 Utilize user related data dictionary views

Lesson 6: Basic SQL for the DBA
Learning objectives
6.1 ACID and the Oracle Database
6.2 The Oracle read consistency model
6.3 Introducing Our Example Schema
6.4 Basic select statements
6.5 Basic insert statements
6.6 Basic update statements
6.7 Basic delete statements
6.8 The Merge statement

Lesson 7: Administer Control Files, Online Redo Logs
Learning objectives
7.1 About Control Files
7.2 Creating control files
7.3 Dropping control files
7.4 Altering control files
7.5 Control file data dictionary views
7.6 About online redo logs
7.7 Creating online redo log groups
7.8 Creating online redo log group members
7.9 Dropping online redo log members
7.10 Dropping online redo log groups
7.11 Altering online redo logs members
7.12 Altering online redo log groups
7.13 Redo log file data dictionary views



Submit Errata

More Information

Unlimited one-month access with your purchase
Free Safari Membership