by | Released March 2012 | ISBN: 9781926873954

In this Oracle 11g video based training course, through the expert tutelage of Lewis Cunningham, you will learn the basics of operating an Oracle Database server and environment. You will also discover the basics of how to manage and develop for an Oracle Database, and administer one.This tutorial is designed for the beginner. This training will teach you the basics of what it means to administer an Oracle Database. Throughout the training, you will be able to better understand the path you can continue on from here, whether that is to become a DBA, developer or administrator of Oracle Databases. You will learn about processes and architectural concepts of a database. This video training also covers topics such as storage, data modelling, basic SQL, database tasks, and how all of these apply specifically to Oracle Databases.By the completion of this video tutorial, you will have a fundamental understanding of how an Oracle Database server and environment function, as well as how database concepts apply specifically to an Oracle Database. Working files are included to assist you as you work through this computer software training course. Show and hide more Publisher resources Download Example Code

1. Introduction
   • What Is Oracle 00:02:42
   • What You Should Expect From This Course 00:02:01
   • Download And Install Oracle 00:04:51
2. The Technology - OS, Middleware, And Hardware
   • Operating Systems 00:04:56
   • Middleware 00:03:37
   • Hardware 00:08:31
3. The Technology - Database
   • What Is A Database? 00:03:10
   • What Are The Types Of Database? 00:02:29
   • MySQL 00:01:39
   • TimesTen 00:01:51
   • BerkleyDB 00:01:04
   • NoSQL 00:01:25
   • Oracle Database Server 00:01:17
   • Oracle Database Server Editions 00:07:17
   • Documentation And Software 00:03:24
4. Database Architecture
   • Operating Systems Supported 00:01:20
   • Database Server 00:01:29
   • The Database 00:01:11
   • Database Instance 00:01:25
   • Background Memory Processes 00:04:31
   • User Memory Processes 00:01:24
   • System Global Area 00:02:25
   • Program Global Area 00:01:44
   • Networking 00:01:13
   • Oracle Net Listener 00:02:22
   • Real Application Clusters 00:04:22
5. Storage
   • Blocks 00:02:27
   • Extents 00:01:34
   • Segments 00:01:49
   • Tablespaces 00:02:31
   • Data Files 00:01:17
   • Control Files 00:01:23
   • Redo Log Files 00:02:50
   • Parameter File 00:01:07
   • Password File 00:01:00
   • Fast Recovery Area 00:01:06
   • Alert Logs 00:02:05
   • Trace Files 00:01:54
   • ASM, Grid And Cloud 00:03:33
6. Database Structures
   • The Data Dictionary 00:06:28
   • Schemas And Users 00:03:07
   • Tables 00:07:14
   • Partitions 00:07:23
   • Temp Tables 00:03:27
   • B-tree Indexes 00:08:08
   • Index Organized Tables (IOT) 00:03:07
   • Bitmap Indexes 00:04:14
   • Function Based Indexes 00:05:17
   • Views 00:03:39
   • Primary And Unique Keys 00:05:05
   • Foreign Keys 00:04:40
   • Check Constraints 00:03:24
   • Synonyms 00:02:22
   • Table Clusters 00:01:26
   • Sequences 00:03:08
   • Object Statistics 00:01:40
   • Performance Views 00:03:40
7. Oracle IDEs
   • Oracle SQL Plus 00:03:24
   • SQL Developer - Chapter 7 00:06:50
   • Oracle Universal Installer (OUI) 00:02:06
   • Oracle Enterprise Manager (OEM) 00:03:46
   • Oracle Database Configuration Assistant (ODCA) 00:06:30
8. Structured Query Language (SQL)
   • What Is SQL 00:05:53
   • Select 00:05:17
   • Insert 00:05:27
   • Update 00:03:47
   • Joins 00:05:04
   • Deletes 00:02:17
   • Merge 00:03:35
   • Aggregates 00:02:22
   • SQL Analytics 00:05:46
   • Optimizer And Explain Plan 00:05:40
   • Transactions And Concurrency 00:06:19
9. PL/SQL
   • What Is PL/SQL 00:08:00
   • Anonymous Blocks 00:01:18
   • Procedures 00:04:46
   • Functions 00:05:40
   • Packages 00:07:35
   • Object Types 00:08:48
   • Dynamic SQL 00:07:08
   • Application Express (ApEx) 00:06:54
10. XML
    • What Is XML 00:01:43
    • What Is XMLDB 00:01:17
    • XMLType 00:02:44
    • SQL/XML 00:05:25
    • XQuery 00:02:46
    • XML Repository 00:03:14
    • XML Storage Models 00:01:59
11. Analysis Tasks With Oracle Data Modeler
    • Data Modelling 00:02:52
    • The Conceptual Model 00:03:04
    • The Logical Model 00:05:08
    • The Physical Model 00:04:03
    • Deploying A Data Model 00:03:01
    • Reverse Engineering 00:02:40
12. Database Tasks
    • Backup And Recovery 00:03:22
    • Startup And Shutdown An Instance 00:05:21
    • The Listener 00:04:49
    • Create And Remove Users 00:10:04
    • Monitor Sessions 00:05:07
    • Monitor Resources 00:03:10
    • Monitoring Space Usage 00:01:45
    • Adding Space 00:04:29
    • Freeing Space 00:03:31
    • Replication And Streams 00:04:38
    • Database Scheduling 00:05:35
13. Data Import/Export
    • SQL Loader 00:04:01
    • External Tables 00:04:17
    • Data Pump 00:03:58
    • SQL Plus 00:02:28
    • SQL Developer - Chapter 13 00:06:26
    • ETL Tools 00:02:24
14. Database Security
    • Database Security 00:03:16
    • Data Control Language (DCL) 00:03:55
    • System And Object Privileges 00:03:35
    • Roles 00:05:55
    • DBA And Developer Access 00:02:48
    • Virtual Private Database (VPD) 00:05:54
    • Fine Grained Auditing (FGA) 00:04:30
    • Transparent Data Encryption (TDE) 00:05:34
    • SQL Injection 00:06:29
15. Very Large Databases (VLDB)
    • VLDB 00:08:36
    • OLAP 00:02:38
    • Data Mining 00:04:31
16. About The Author
    • About The Author 00:02:56
Show and hide more