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 …
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
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
Introduction
Oracle DBA Fundamentals: 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 2
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.5 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 Create Oracle users
5.2 Drop Oracle users
5.3 Alter and administer 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 Understand ACID and the Oracle Database
6.2 Understand the Oracle read consistency model
6.3 Understand Oracle read consistency
6.4 View basic select statements
Lesson 7: Administer Control Files and Redo Logs
Learning objectives
7.1 Understand database control files
7.2 Administer a control file
7.3 Explore control file data dictionary views
7.4 Understand database redo logs
7.5 Explore redo log performance considerations
7.6 Administer the redo log
Summary
Oracle DBA Fundamentals: Summary