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
- 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
- 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
- Introduction
-
Lesson 1: Oracle Database Architecture
- Learning objectives 00:01:07
- 1.1 Understand the concept of a relational database 00:17:22
- 1.2 Understand relational database basics--Part 1 00:19:07
- 1.3 Understand relational database basics--Part 2 00:16:18
- 1.4 Understand database modeling basics 00:04:53
- 1.5 Build a database model: Define a person table 00:18:01
- 1.6 Build a database model: Primary, surrogate and natural keys 00:12:25
- 1.7 Build a database model: Create a normalized model 00:30:27
- 1.8 Understand Oracle Database fundamental concepts--Part 1 00:13:57
- 1.9 Understand Oracle Database fundamental concepts--Part 2 00:17:34
-
Lesson 2: Installing and Deinstalling Oracle Database Software
- Learning objectives 00:00:35
- 2.1 Prepare to install Oracle Database 00:16:44
- 2.2 Download Oracle Database 00:11:30
- 2.3 Install Oracle Database software 00:14:38
- 2.4 Deinstall Oracle Database software 00:05:34
-
Lesson 3: Creating the Oracle Database
- Learning objectives 00:00:28
- 3.1 Prepare to create the Oracle Database 00:51:32
- 3.2 Create the Oracle Database with DBUA--Test database 00:20:05
- 3.3 Create the Oracle Database with DBUA--Production database: Part 1 00:18:35
- 3.4 Create the Oracle Database with DBUA--Production database: Part 2 00:15:12
- 3.5 Remove the Oracle Database 00:04:53
-
Lesson 4: Tools for Connecting to the Oracle Database
- Learning objectives 00:00:46
- 4.1 Oracle Administration Accounts 00:04:46
- 4.2 Connect to the Oracle Database 00:07:59
- 4.3 Use SQL*Plus 00:13:20
- 4.4 Use SQL Developer 00:09:56
-
Lesson 5: Administration of Oracle Users
- Learning objectives 00:00:45
- 5.1 Create Oracle users 00:11:56
- 5.2 Drop Oracle users 00:00:59
- 5.3 Alter and administer users 00:08:55
- 5.4 Understand the Oracle data dictionary 00:06:08
- 5.5 Utilize user related data dictionary views 00:17:29
-
Lesson 6: Basic SQL for the DBA
- Learning objectives 00:00:57
- 6.1 Understand ACID and the Oracle Database 00:03:48
- 6.2 Understand the Oracle read consistency model 00:05:10
- 6.3 Understand Oracle read consistency 00:07:47
- 6.4 View basic select statements 00:06:28
-
Lesson 7: Administer Control Files and Redo Logs
- Learning objectives 00:00:45
- 7.1 Understand database control files 00:04:50
- 7.2 Administer a control file 00:05:27
- 7.3 Explore control file data dictionary views 00:06:38
- 7.4 Understand database redo logs 00:18:08
- 7.5 Explore redo log performance considerations 00:09:50
- 7.6 Administer the redo log 00:07:42
-
Summary
- Oracle DBA Fundamentals: Summary 00:02:02
Product information
- Title: Oracle DBA Fundamentals
- Author(s):
- Release date: December 2016
- Publisher(s): Pearson
- ISBN: 013466521X
You might also like
video
Python Fundamentals
51+ hours of video instruction. Overview The professional programmer’s Deitel® video guide to Python development with …
video
Oracle SQL Performance Tuning for Developers LiveLessons (Video Training)
The focus of Oracle SQL Performance Tuning for Developers LiveLessons Description In this video training, Dan …
video
Learning Oracle 11g - Real Application Clusters
In this Oracle 11g RAC training course, expert trainer Steve Hamilton explains Oracle's Real Application Clusters …
video
Oracle PL/SQL Programming: Fundamentals to Advanced
Overview Oracle PL/SQL Programming: Fundamentals to Advanced LiveLessons begins with a fundamentals module that covers the …