by Steve Ries | Released May 2014 | ISBN: 9781771372411

In this Oracle 12c training course, expert author Steve Ries will teach you how to everything you need to know about the newest version of the Oracle database system. This course is designed for the absolute beginner, meaning no prior knowledge of Oracle is needed. You will start by learning about the Oracle database technology, including learning the database architecture of Oracle and how to install the software on your computer. This video tutorial will cover topics such as how to create an Oracle database, basic SQL and PL/SQL, storage structures, database objects, security, backup and recovery, and Oracle administration tasks. Finally, you will learn about data migration and Oracle networking. Once you have completed this computer based training course, you will have a fundamental understanding of how an Oracle database functions, and how database concepts apply to the latest version of Oracle. Show and hide more Publisher resources View/Submit Errata

1. Introduction
   • What You Should Expect From This Course 00:04:04
   • About The Author 00:03:48
   • What is Oracle? 00:04:01
2. The Oracle Technology Family
   • Hardware 00:02:49
   • Operating Systems 00:04:30
   • Virtualization 00:05:19
   • Middleware And Java 00:04:41
3. Oracle Database Technology
   • What Is A Database? 00:06:16
   • Oracle RDBMS 00:05:14
   • Oracle Database Server Editions 00:05:38
   • Oracle Database Server Versioning 00:07:41
   • Oracle Database Options 00:07:17
   • Software 00:08:59
   • Documentation 00:06:30
   • SQL Developer 00:08:40
4. Database Architecture
   • The Oracle RDBMS - Instance And Database 00:03:50
   • The Instance - Background Memory Processes 00:12:09
   • The Instance - System Global Area 00:07:18
   • The Instance - Program Global Area 00:05:58
   • The Database - Core Datafiles 00:10:10
   • The Redo Architecture 00:05:51
   • Real Application Clusters 00:05:56
   • Container Databases 00:04:35
   • Pluggable Databases 00:05:43
5. Installing The Oracle Software
   • Planning An Installation 00:06:04
   • The Oracle Universal Installer 00:05:41
   • Installing The Software - Part 1 00:06:26
   • Installing The Software - Part 2 00:03:48
6. Creating An Oracle Database
   • Planning Database Creation 00:04:58
   • Running NETCA And DBCA 00:04:43
   • Stepping Through Database Creation - Part 1 00:06:43
   • Stepping Through Database Creation - Part 2 00:07:06
   • Stepping Through Database Creation - Part 3 00:06:21
   • Setting Up The SQL Developer 00:04:39
7. Structured Query Language (SQL)
   • What Is SQL? 00:06:56
   • Select 00:07:03
   • Insert 00:06:07
   • Update 00:04:26
   • Deletes 00:05:55
   • Joins 00:08:58
   • Single Row Functions 00:09:02
   • Data Aggregation 00:07:04
   • Optimizer And Execution Plans 00:09:40
   • Transactions And Concurrency 00:04:51
8. PL And SQL
   • What Is PL And SQL? 00:05:53
   • Anonymous Blocks 00:06:28
   • Procedures 00:05:26
   • Functions 00:05:39
   • Packages 00:06:15
   • Object Types 00:06:39
9. Oracle Storage Structures
   • Blocks 00:08:19
   • Extents 00:07:30
   • Segments 00:06:56
   • Datafiles 00:07:46
   • Smallfile Tablespaces 00:06:38
   • Bigfile Tablespaces 00:07:43
   • Automatic Storage Management - ASM 00:10:01
10. Database Objects
    • Tables 00:07:50
    • Partitions 00:09:21
    • Temporary Tables 00:04:18
    • B-tree Indexes 00:07:46
    • Bitmap Indexes 00:05:50
    • Index Organized Tables 00:04:03
    • Function Based Indexes 00:05:08
    • Views 00:04:49
    • Primary And Unique Keys 00:06:53
    • Foreign Keys 00:06:40
    • Check Constraints 00:06:13
    • Synonyms 00:05:39
    • Sequences 00:08:31
11. Database Security
    • Principles Of Database Security 00:08:09
    • Oracle Schema Based Approach 00:04:46
    • Creating And Dropping Users 00:06:53
    • System Privileges 00:06:44
    • Object Privileges 00:05:53
    • Roles 00:10:15
    • Profiles 00:07:07
    • Auditing 00:10:15
12. Database Administrative Tasks
    • Instance Startup 00:06:17
    • Instance Shutdown 00:07:15
    • Parameter File 00:06:47
    • Modifying Parameters 00:08:18
    • The Data Dictionary 00:12:15
    • Password File 00:06:03
    • ADRCI 00:05:17
    • Alert Log And Trace Files 00:07:02
    • Memory Management 00:06:28
    • Monitoring Sessions 00:08:29
    • Monitoring Space Usage 00:05:17
13. Database Backup And Recovery
    • Backup And Recovery Concepts 00:09:48
    • RMAN Backups 00:04:25
    • RMAN Incremental Backups 00:06:57
    • RMAN Complete Recovery 00:04:51
    • RMAN Incomplete Recovery 00:07:28
    • RMAN Backup Maintenance 00:05:19
14. Data Migration
    • SQL Loader 00:08:11
    • External Tables 00:04:39
    • Data Pump Export 00:07:22
    • Data Pump Import 00:04:40
15. Oracle Networking
    • Understanding Oracle Connections 00:04:37
    • Networking Configuration Files 00:04:52
    • Listener Control 00:04:12
16. Conclusion
    • Wrap-Up And Review 00:03:12
Show and hide more