Users Online

· Guests Online: 37

· Members Online: 0

· Total Members: 188
· Newest Member: meenachowdary055

Forum Threads

Newest Threads
No Threads created
Hottest Threads
No Threads created

Latest Articles

DEMO - Oracle 11 g Course

DEMO - Oracle 11 g Course
Database Courses
Categories Most Recent Top Rated Popular Courses
 
Uploader Date Added Views Rating
Superadmin 14.03.16 696 No Rating
Description
Oracle 11g Course Description

In this Oracle 11g video based training course, through the expert 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.

Lesson Description
Section 1 Introduction
Lesson 01 What Is Oracle
Lesson 02 What You Should Expect From This Course
Lesson 03 Download And Install Oracle
Section 2 The Technology - OS, Middleware, And Hardware
Lesson 04 Operating Systems
Lesson 05 Middleware
Lesson 06 Hardware
Section 3 The Technology - Database
Lesson 07 What Is A Database?
Lesson 08 What Are The Types Of Database?
Lesson 09 MySQL
Lesson 10 TimesTen
Lesson 11 BerkleyDB
Lesson 12 NoSQL
Lesson 13 Oracle Database Server
Lesson 14 Oracle Database Server Editions
Lesson 15 Documentation And Software
Section 4 Database Architecture
Lesson 16 Operating Systems Supported
Lesson 17 Database Server
Lesson 18 The Database
Lesson 19 Database Instance
Lesson 20 Background Memory Processes
Lesson 21 User Memory Processes
Lesson 22 System Global Area
Lesson 23 Program Global Area
Lesson 24 Networking
Lesson 25 Oracle Net Listener
Lesson 26 Real Application Clusters
Section 5 Storage
Lesson 27 Blocks
Lesson 28 Extents
Lesson 29 Segments
Lesson 30 Tablespaces
Lesson 31 Data Files
Lesson 32 Control Files
Lesson 33 Redo Log Files
Lesson 34 Parameter File
Lesson 35 Password File
Lesson 36 Fast Recovery Area
Lesson 37 Alert Logs
Lesson 38 Trace Files
Lesson 39 ASM, Grid And Cloud
Lesson 40 The Data Dictionary
Lesson 41 Schemas And Users
Lesson 42 Tables
Lesson 43 Partitions
Lesson 44 Temp Tables
Lesson 45 B-tree Indexes
Lesson 46 Index Organized Tables (IOT)
Lesson 47 Bitmap Indexes
Lesson 48 Function Based Indexes
Lesson 49 Views
Lesson 50 Primary And Unique Keys
Lesson 51 Foreign Keys
Lesson 52 Check Constraints
Lesson 53 Synonyms
Lesson 54 Table Clusters
Lesson 55 Sequences
Lesson 56 Object Statistics
Lesson 57 Performance Views
Section 6 Oracle IDEs
Lesson 58 Oracle SQL Plus
Lesson 59 SQL Developer
Lesson 60 Oracle Universal Installer (OUI)
Lesson 61 Oracle Enterprise Manager (OEM)
Lesson 62 Oracle DB Config Assistant (ODCA)
Section 7 Structured Query Language (SQL)
Lesson 63 What Is SQL
Lesson 64 Select
Lesson 65 Insert
Lesson 66 Update
Lesson 67 Joins
Lesson 68 Deletes
Lesson 69 Merge
Lesson 70 Aggregates
Lesson 71 SQL Analytics
Lesson 72 Optimizer And Explain Plan
Lesson 73 Transactions And Concurrency
Lesson 85 SQL/XML
Section 8 PL/SQL
Lesson 74 What Is PL/SQL
Lesson 75 Anonymous Blocks
Lesson 76 Procedures
Lesson 77 Functions
Lesson 78 Packages
Lesson 79 Object Types
Lesson 80 Dynamic SQL
Lesson 81 Application Express (ApEx)
Section 9 XML
Lesson 82 What Is XML
Lesson 83 What Is XMLDB
Lesson 84 XMLType
Lesson 86 XQuery
Lesson 87 XML Repository
Lesson 88 XML Storage Models
Section 10 Analysis Tasks With Oracle Data Modeler
Lesson 89 Data Modelling
Lesson 90 The Conceptual Model
Lesson 91 The Logical Model
Lesson 92 The Physical Model
Lesson 93 Deploying A Data Model
Lesson 94 Reverse Engineering
Section 11 Database Tasks
Lesson 95 Backup And Recovery
Lesson 96 Startup & Shutdown An Instance
Lesson 97 The Listener
Lesson 98 Create And Remove Users
Lesson 99 Monitor Sessions
Lesson 100 Monitor Resources
Lesson 101 Monitoring Space Usage
Lesson 102 Adding Space
Lesson 103 Freeing Space
Lesson 104 Replication And Streams
Lesson 105 Database Scheduling
Section 12 Data Import/Export
Lesson 106 SQL Loader
Lesson 107 External Tables
Lesson 108 Data Pump
Lesson 109 SQL Plus
Lesson 110 SQL Developer
Lesson 111 ETL Tools
Section 13 Database Security
Lesson 112 Database Security
Lesson 113 Data Control Language (DCL)
Lesson 114 System And Object Privileges
Lesson 115 Roles
Lesson 116 DBA And Developer Access
Lesson 117 Virtual Private Database (VPD)
Lesson 118 Fine Grained Auditing (FGA)
Lesson 119 Transparent Data Encrypt (TDE)
Lesson 120 SQL Injection
Section 14 Very Large Databases (VLDCool
Lesson 121 VLDB
Lesson 122 OLAP
Lesson 123 Data Mining

Ratings

Rating is available to Members only.

Please login or register to vote.

No Ratings have been Posted.

Comments

No Comments have been Posted.

Post Comment

Please Login to Post a Comment.
Render time: 0.92 seconds
10,844,156 unique visits