Download Safari Books Online apps: Apple iOS | Android

Entire Site

Safari Books Online

    Free Trial

    Safari Books Online is a digital library providing on-demand subscription access to thousands of learning resources.

    Learning Oracle Database 11g

    Subscriber Reviews • Browse Similar Topics

    Overview

    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.

    Subscriber Reviews

    Average Rating: 4.269230769230769 out of 5 rating Based on 26 Ratings

    "DBA" - by Anonymous on 06-FEB-2013
    Reviewer Rating: 1 star rating2 star rating3 star rating4 star rating5 star rating
    good presentation, very informative
    Report as Inappropriate

    "Very nice refresher for me" - by Sulabh Shukla on 24-DEC-2012
    Reviewer Rating: 1 star rating2 star rating3 star rating4 star rating5 star rating
    A lot of info ... Never goes into too much details but enough to whet your appetite.
    Report as Inappropriate

    "Oracle 11g" - by Shamal Jayakody on 20-APR-2012
    Reviewer Rating: 1 star rating2 star rating3 star rating4 star rating5 star rating
    This is a good training video on Oracle 11g.
    Report as Inappropriate

    Table of Contents

    Chapter/Selection

    Time

    01. Introduction

    What Is Oracle

    Preview

    00:02:42

    What You Should Expect From This Course

    Play Video

    00:02:01

    Download And Install Oracle

    Preview

    00:04:51

    02. The Technology - OS, Middleware, And Hardware

    Operating Systems

    Preview

    00:04:56

    Middleware

    Preview

    00:03:37

    Hardware

    Preview

    00:08:30

    03. The Technology - Database

    What Is A Database?

    Preview

    00:03:10

    What Are The Types Of Database?

    Preview

    00:02:29

    MySQL

    Preview

    00:01:39

    TimesTen

    Preview

    00:01:50

    BerkleyDB

    Preview

    00:01:04

    NoSQL

    Preview

    00:01:25

    Oracle Database Server

    Preview

    00:01:16

    Oracle Database Server Editions

    Preview

    00:07:17

    Documentation And Software

    Preview

    00:03:24

    04. Database Architecture

    Operating Systems Supported

    Preview

    00:01:19

    Database Server

    Preview

    00:01:29

    The Database

    Preview

    00:01:10

    Database Instance

    Preview

    00:01:24

    Background Memory Processes

    Preview

    00:04:30

    User Memory Processes

    Preview

    00:01:24

    System Global Area

    Preview

    00:02:25

    Program Global Area

    Preview

    00:01:43

    Networking

    Preview

    00:01:13

    Oracle Net Listener

    Preview

    00:02:21

    Real Application Clusters

    Preview

    00:04:22

    05. Storage

    Blocks

    Preview

    00:02:26

    Extents

    Preview

    00:01:33

    Segments

    Preview

    00:01:48

    Tablespaces

    Preview

    00:02:31

    Data Files

    Preview

    00:01:17

    Control Files

    Preview

    00:01:23

    Redo Log Files

    Preview

    00:02:50

    Parameter File

    Preview

    00:01:06

    Password File

    Preview

    00:01:00

    Fast Recovery Area

    Preview

    00:01:05

    Alert Logs

    Preview

    00:02:04

    Trace Files

    Preview

    00:01:53

    ASM, Grid And Cloud

    Preview

    00:03:32

    06. Database Structures

    The Data Dictionary

    Play Video

    00:06:27

    Schemas And Users

    Preview

    00:03:06

    Tables

    Preview

    00:07:14

    Partitions

    Preview

    00:07:22

    Temp Tables

    Preview

    00:03:27

    B-tree Indexes

    Preview

    00:08:07

    Index Organized Tables (IOT)

    Preview

    00:03:06

    Bitmap Indexes

    Preview

    00:04:13

    Function Based Indexes

    Preview

    00:05:17

    Views

    Preview

    00:03:38

    Primary And Unique Keys

    Play Video

    00:05:04

    Foreign Keys

    Preview

    00:04:40

    Check Constraints

    Preview

    00:03:24

    Synonyms

    Preview

    00:02:21

    Table Clusters

    Preview

    00:01:25

    Sequences

    Preview

    00:03:08

    Object Statistics

    Preview

    00:01:40

    Performance Views

    Preview

    00:03:39

    07. Oracle IDEs

    Oracle SQL Plus

    Preview

    00:03:23

    SQL Developer

    Play Video

    00:06:49

    Oracle Universal Installer (OUI)

    Preview

    00:02:05

    Oracle Enterprise Manager (OEM)

    Preview

    00:03:45

    Oracle Database Configuration Assistant (ODCA)

    Preview

    00:06:29

    08. Structured Query Language (SQL)

    What Is SQL

    Preview

    00:05:52

    Select

    Play Video

    00:05:16

    Insert

    Preview

    00:05:27

    Update

    Preview

    00:03:46

    Joins

    Preview

    00:05:04

    Deletes

    Preview

    00:02:16

    Merge

    Preview

    00:03:34

    Aggregates

    Preview

    00:02:21

    SQL Analytics

    Preview

    00:05:45

    Optimizer And Explain Plan

    Preview

    00:05:39

    Transactions And Concurrency

    Preview

    00:06:19

    09. PL/SQL

    What Is PL/SQL

    Preview

    00:07:59

    Anonymous Blocks

    Preview

    00:01:17

    Procedures

    Preview

    00:04:46

    Functions

    Preview

    00:05:40

    Packages

    Preview

    00:07:35

    Object Types

    Play Video

    00:08:48

    Dynamic SQL

    Play Video

    00:07:07

    Application Express (ApEx)

    Preview

    00:06:53

    10. XML

    What Is XML

    Preview

    00:01:43

    What Is XMLDB

    Preview

    00:01:17

    XMLType

    Preview

    00:02:44

    SQL/XML

    Preview

    00:05:25

    XQuery

    Preview

    00:02:45

    XML Repository

    Preview

    00:03:14

    XML Storage Models

    Preview

    00:01:59

    11.Analysis Tasks With Oracle Data Modeler

    Data Modelling

    Preview

    00:02:51

    The Conceptual Model

    Preview

    00:03:03

    The Logical Model

    Play Video

    00:05:08

    The Physical Model

    Preview

    00:04:03

    Deploying A Data Model

    Preview

    00:03:00

    Reverse Engineering

    Preview

    00:02:39

    12. Database Tasks

    Backup And Recovery

    Preview

    00:03:22

    Startup And Shutdown An Instance

    Preview

    00:05:20

    The Listener

    Preview

    00:04:48

    Create And Remove Users

    Play Video

    00:10:03

    Monitor Sessions

    Preview

    00:05:06

    Monitor Resources

    Preview

    00:03:10

    Monitoring Space Usage

    Preview

    00:01:44

    Adding Space

    Preview

    00:04:28

    Freeing Space

    Preview

    00:03:31

    Replication And Streams

    Preview

    00:04:37

    Database Scheduling

    Play Video

    00:05:35

    13.Data Import/Export

    SQL Loader

    Preview

    00:04:01

    External Tables

    Preview

    00:04:17

    Data Pump

    Preview

    00:03:58

    SQL Plus

    Preview

    00:02:28

    SQL Developer

    Play Video

    00:06:26

    ETL Tools

    Preview

    00:02:23

    14. Database Security

    Database Security

    Preview

    00:03:16

    Data Control Language (DCL)

    Preview

    00:03:54

    System And Object Privileges

    Preview

    00:03:35

    Roles

    Preview

    00:05:54

    DBA And Developer Access

    Preview

    00:02:48

    Virtual Private Database (VPD)

    Preview

    00:05:53

    Fine Grained Auditing (FGA)

    Preview

    00:04:30

    Transparent Data Encryption (TDE)

    Play Video

    00:05:34

    SQL Injection

    Preview

    00:06:28

    15. Very Large Databases (VLDB)

    VLDB

    Preview

    00:08:35

    OLAP

    Preview

    00:02:38

    Data Mining

    Preview

    00:04:31

    16. About The Author

    About The Author

    Preview

    00:02:55

    Extras

    The publisher has provided additional content related to this title.


    Description
    Content

    These files have been provided by the publisher.

    • Working_Files.zip