Video accessible from your Account page after purchase.
Register your product to gain access to bonus material or receive a coupon.
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.
Skill Level
Introduction
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
Summary