on-demand course

Oracle DBA Fundamentals

with Robert G. Freeman

December 2016

Beginner

7h 57m

English

Pearson

Closed Captioning available in English, Japanese, Korean, Chinese (Simplified), Chinese (Traditional)

Watch now

Unlock full access

Includes

Earns Badge

Course outline

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

Content preview from Oracle DBA Fundamentals

1.9 Understand Oracle Database fundamental concepts--Part 2

Become an O’Reilly member and get unlimited access to this title plus top books and audiobooks from O’Reilly and nearly 200 top publishers, thousands of courses curated by job role, 150+ live events each month,
and much more.

Start your free trial

Oracle Databases

O'Reilly Media, Inc.

Learning Oracle PL/SQL

Darryl Hurley

Oracle PL/SQL Programming: Fundamentals to Advanced

Dan Hotka

Oracle PL/SQL Programming Fundamentals LiveLessons

Dan Hotka

Publisher Resources

ISBN: 9780134665214

Oracle DBA Fundamentals

with Robert G. Freeman

Introduction

Lesson 1: Oracle Database Architecture

Lesson 2: Installing and Deinstalling Oracle Database Software

Lesson 3: Creating the Oracle Database

Lesson 4: Tools for Connecting to the Oracle Database

Lesson 5: Administration of Oracle Users

Lesson 6: Basic SQL for the DBA

Lesson 7: Administer Control Files and Redo Logs

Summary

Content preview from Oracle DBA Fundamentals

1.9 Understand Oracle Database fundamental concepts--Part 2

Become an O’Reilly member and get unlimited access to this title plus top books and audiobooks from O’Reilly and nearly 200 top publishers, thousands of courses curated by job role, 150+ live events each month,
and much more.