Learning Oracle 12c – A Beginners Oracle Training Video

Course Curriculum

Chapter 1: Introduction

Lecture 1: 0101 What You Should Expect From This Course

Lecture 2: 0103 What is Oracle?

Chapter 2: The Oracle Technology Family

Lecture 1: 0201 Hardware

Lecture 2: 0202 Operating Systems

Lecture 3: 0203 Virtualization

Lecture 4: 0204 Middleware And Java

Chapter 3: Oracle Database Technology

Lecture 1: 0301 What Is A Database?

Lecture 2: 0302 Oracle RDBMS

Lecture 3: 0303 Oracle Database Server Editions

Lecture 4: 0304 Oracle Database Server Versioning

Lecture 5: 0305 Oracle Database Options

Lecture 6: 0306 Software

Lecture 7: 0307 Documentation

Lecture 8: 0308 SQL Developer

Chapter 4: Database Architecture

Lecture 1: 0401 The Oracle RDBMS – Instance And Database

Lecture 2: 0402 The Instance – Background Memory Processes

Lecture 3: 0403 The Instance – System Global Area

Lecture 4: 0404 The Instance – Program Global Area

Lecture 5: 0405 The Database – Core Datafiles

Lecture 6: 0406 The Redo Architecture

Lecture 7: 0407 Real Application Clusters

Lecture 8: 0408 Container Databases

Lecture 9: 0409 Pluggable Databases

Chapter 5: Installing The Oracle Software

Lecture 1: 0501 Planning An Installation

Lecture 2: 0502 The Oracle Universal Installer

Lecture 3: 0503 Installing The Software – Part 1

Lecture 4: 0504 Installing The Software – Part 2

Chapter 6: Creating An Oracle Database

Lecture 1: 0601 Planning Database Creation

Lecture 2: 0602 Running NETCA And DBCA

Lecture 3: 0603 Stepping Through Database Creation – Part 1

Lecture 4: 0604 Stepping Through Database Creation – Part 2

Lecture 5: 0605 Stepping Through Database Creation – Part 3

Lecture 6: 0606 Setting Up The SQL Developer

Chapter 7: Structured Query Language (SQL)

Lecture 1: 0701 What Is SQL?

Lecture 2: 0702 Select

Lecture 3: 0703 Insert

Lecture 4: 0704 Update

Lecture 5: 0705 Deletes

Lecture 6: 0706 Joins

Lecture 7: 0707 Single Row Functions

Lecture 8: 0708 Data Aggregation

Lecture 9: 0709 Optimizer And Execution Plans

Lecture 10: 0710 Transactions And Concurrency

Chapter 8: PL And SQL

Lecture 1: 0801 What Is PL And SQL?

Lecture 2: 0802 Anonymous Blocks

Lecture 3: 0803 Procedures

Lecture 4: 0804 Functions

Lecture 5: 0805 Packages

Lecture 6: 0806 Object Types

Chapter 9: Oracle Storage Structures

Lecture 1: 0901 Blocks

Lecture 2: 0902 Extents

Lecture 3: 0903 Segments

Lecture 4: 0904 Datafiles

Lecture 5: 0905 Smallfile Tablespaces

Lecture 6: 0906 Bigfile Tablespaces

Lecture 7: 0907 Automatic Storage Management – ASM

Chapter 10: Database Objects

Lecture 1: 1001 Tables

Lecture 2: 1002 Partitions

Lecture 3: 1003 Temporary Tables

Lecture 4: 1004 B-tree Indexes

Lecture 5: 1005 Bitmap Indexes

Lecture 6: 1006 Index Organized Tables

Lecture 7: 1007 Function Based Indexes

Lecture 8: 1008 Views

Lecture 9: 1009 Primary And Unique Keys

Lecture 10: 1010 Foreign Keys

Lecture 11: 1011 Check Constraints

Lecture 12: 1012 Synonyms

Lecture 13: 1013 Sequences

Chapter 11: Database Security

Lecture 1: 1101 Principles Of Database Security

Lecture 2: 1102 Oracle Schema Based Approach

Lecture 3: 1103 Creating And Dropping Users

Lecture 4: 1104 System Privileges

Lecture 5: 1105 Object Privileges

Lecture 6: 1106 Roles

Lecture 7: 1107 Profiles

Lecture 8: 1108 Auditing

Chapter 12: Database Administrative Tasks

Lecture 1: 1201 Instance Startup

Lecture 2: 1202 Instance Shutdown

Lecture 3: 1203 Parameter File

Lecture 4: 1204 Modifying Parameters

Lecture 5: 1205 The Data Dictionary

Lecture 6: 1206 Password File

Lecture 7: 1207 ADRCI

Lecture 8: 1208 Alert Log And Trace Files

Lecture 9: 1209 Memory Management

Lecture 10: 1210 Monitoring Sessions

Lecture 11: 1211 Monitoring Space Usage