Oracle Administration Video Tutorial

Oracle Administration Video Tutorial - 22 lessons

Very good Video guide for Beginners.

Download all 22 lessons as a single file.

Oracle Administration Video Tutorial

Read more...

ORACLE 10g Database Administration - The Complete Video Course

Description:

Your Complete Introduction to The Oracle Database Administration

3 1/2 hours of video instruction PLUS the Oracle DBA Interactive Workbook e-Book, by the Columbia University instructors, Melanie Caffrey & Douglas Scherer.

Master the basics of Oracle database administration—now!

Managing the database and its physical layout, ensuring security and data integrity, providing for backups, PLUS the History of Oracle Networking.

Watch and listen as your instructors use 31/2 hours of video instruction to cover the key topics, and then add step-by-step digital videos, real-world labs, exercises, projects, and insight from the trenches to explore what it means to be an Oracle DBA.

Key Topics :

Covers all key aspects of day-to-day Oracle database administration, including:

Creating new databases

Managing physical database layouts

Administering users, privileges, and resource groups

Tuning Oracle and SQL code for maximum performance

Security, auditing, and data integrity

Backup, recovery, and much more!

Downlaod Links:-

http://www.mediafire.com/Oracle.Database.10g.www.oracleonsles.blogspot.com.part01.rar

http://www.mediafire.com/Oracle.Database.10g.www.oracleonsles.blogspot.com.part02.rar

http://www.mediafire.com/Oracle.Database.10g.www.oracleonsles.blogspot.com.part03.rar

http://www.mediafire.com/Oracle.Database.10g.www.oracleonsles.blogspot.com.part04.rar

http://www.mediafire.com/Oracle.Database.10g.www.oracleonsles.blogspot.com.part05.rar

http://www.mediafire.com/Oracle.Database.10g.www.oracleonsles.blogspot.com.part06.rar

http://www.mediafire.com/Oracle.Database.10g.www.oracleonsles.blogspot.com.part07.rar

http://www.mediafire.com/Oracle.Database.10g.www.oracleonsles.blogspot.com.part08.rar

http://www.mediafire.com/Oracle.Database.10g.www.oracleonsles.blogspot.com.part09.rar

http://www.mediafire.com/Oracle.Database.10g.www.oracleonsles.blogspot.com.part10.rar

http://www.mediafire.com/Oracle.Database.10g.www.oracleonsles.blogspot.com.part11.rar

http://www.mediafire.com/Oracle.Database.10g.www.oracleonsles.blogspot.com.part12.rar

http://www.mediafire.com/Oracle.Database.10g.www.oracleonsles.blogspot.com.part13.rar

http://www.mediafire.com/Oracle.Database.10g.www.oracleonsles.blogspot.com.part14.rar

http://www.mediafire.com/Oracle.Database.10g.www.oracleonsles.blogspot.com.part15.rar

http://www.mediafire.com/Oracle.Database.10g.www.oracleonsles.blogspot.com.part16.rar

Read more...

Oracle Forms Developer The Complete Training Coure

Author:

Benjamin Rosenzweig

ISBN:
0130321249

Description:

This video course contains four-and-a-half hours of QuickTime video instruction as well as the Oracle Forms Interactive Workbook e-Book that integrates the tutorials with hands-on practical exercises, self-review questions, and real-world labs. The 13 video lectures cover topics including Oracle Forms development environment, form builder, reusable objects and code, triggers and built-ins, LOVs and alerts, canvases and windows, multiple form applications, and integration with Oracle reports.

Downlaod Links:

http://www.mediafire.com/Oracle.Forms.Developer.part01.rar

http://www.mediafire.com/Oracle.Forms.Developer.part02.rar

http://www.mediafire.com/Oracle.Forms.Developer.part03.rar

http://www.mediafire.com/Oracle.Forms.Developer.part04.rar

http://www.mediafire.com/Oracle.Forms.Developer.part05.rar

http://www.mediafire.com/Oracle.Forms.Developer.part06.rar

http://www.mediafire.com/Oracle.Forms.Developer.part07.rar

http://www.mediafire.com/Oracle.Forms.Developer.part08.rar

http://www.mediafire.com/Oracle.Forms.Developer.part09.rar

http://www.mediafire.com/Oracle.Forms.Developer.part010.rar

http://www.mediafire.com/Oracle.Forms.Developer.part011.rar

Oracle Form Developer Part08 and 11 are now fixed

Read more...

Oracle9i: SQL CBTs

Introduction to Oracle9i: SQL

Author - Gavin JT Powell / Certified Oracle Instructor
Total Time - 12 Hours

The Introduction to Oracle SQL and PL/SQL tutorial will cover the relational Database Model, the Oracle Architecture and the Physical database. The tutorial is aimed at programmers, and individuals who have had prior SQL and relational database experience.

Gavin Powell, your instructor, will begin teaching you many Oracle tools such as the SQL Plus, SQL Plus Worksheet, and Oracle Enterprise Manager. This tutorial will explain how to maintain the Logical Database, and the difference between the Logical Database and the Physical database. You will be guided, in great detail, in the following areas: retrieving, changing, adding, and deleting data from the Database. From there, you will learn about Logical Database objects, Security, Select Statements, and much more. Introduction to Oracle SQL and PL/SQL will cover areas for the Oracle Certification course (1Z0-007).

Welcome
Welcome
Useful Web Sites
What is Oracle Software?
The History of Databases
The History of Oracle
About this Course

The Relational Database Model
The Relational Database Model
The Concerts Schema
Normalization pt. 1
Normalization pt. 2
Denormalization pt. 1
Denormalization pt. 2

Oracle SQL and PL/SQL Tools
What are the Oracle SQL and PL/SQL Tools?
SQL Plus
Formatting Output
SQL Plus Worksheet
iSQL Plus
Oracle Enterprise Manager
Oracle Enterprise Manager pt. 2

The Architecture of Oracle
The Oracle Database and Oracle Instance pt. 1
The Oracle Database and Oracle Instance pt. 2
Control Files, Logging, Archiving and Recoverability

Creating Database Objects
Oracle Simple Datatypes pt. 1
Oracle Simple Datatypes pt. 2
Oracle Complex and Object Datatypes
Types of Tables
Methods of Table Creation
Create Table Syntax
Example Table Creations pt. 1
Example Table Creations pt. 2
Altering and Dropping Tables pt. 1
Altering and Dropping Tables pt. 2
What are Constraints?
Creating, Changing and Dropping Constraints
Types of Indexes pt. 1
Types of Indexes pt. 2
Creating, Altering and Dropping Indexes
Sequence Counters
Synonyms
Views pt. 1
Views pt. 2
Metadata Views and Error Messages

Users and Security
Schemas, Users, Privileges and Roles pt. 1
Schemas, Users, Privileges and Roles pt. 2
Schemas, Users, Privileges and Roles pt. 3
Types of Users
Creating Users pt. 1
Creating Users pt. 2
Altering and Dropping Users
Security
System Privileges
Object Privileges
Granting and Revoking Privileges pt. 1
Granting and Revoking Privileges pt. 2
Grouping Privileges Using Roles pt. 1
Grouping Privileges Using Roles pt. 2
Setting Roles

Retrieving Data from the Database
The SELECT Statement pt. 1
The SELECT Statement pt. 2
The SELECT Statement pt. 3
Types of SELECT Statement pt. 1
Types of SELECT Statement pt. 2
The DUAL Table pt. 1
The DUAL Table pt. 2
What is a NULL?
Pseudo-Columns pt. 1
Pseudo-Columns pt. 2
More About SQL Plus Formatting pt. 1
More About SQL Plus Formatting pt. 2
More About SQL Plus Formatting pt. 3

Oracle Built In Functions
Types of Functions pt. 1
Types of Functions pt. 2
String Functions pt. 1
String Functions pt. 2
String Functions pt. 3
Number Functions
Date Functions pt. 1
Date Functions pt. 2
Other Functions pt. 1
Other Functions pt. 2
Datatype Conversion Functions pt. 1
Datatype Conversion Functions pt. 2
Custom Functions Using PL/SQL

Filtering SELECT Statements
The WHERE Clause
Conditional Comparisons
Using the WHERE Clause
Using Logical Operators pt. 1
Using Logical Operators pt. 2
Using Conditional Comparisons pt. 1
Using Conditional Comparisons pt. 2

Sorting SELECT Statements
The ORDER BY Clause
Sorting Methods

Joining Multiple Tables
What is a Join?
Two Join Syntax Formats
Types of Joins pt. 1
Types of Joins pt. 2
Types of Joins pt. 3
Cross Join or Cartesian Product
Natural or Inner Join pt. 1
Natural or Inner Join pt. 2
Natural or Inner Join pt. 3
Outer Join pt. 1
Outer Join pt. 2
Self Join
Equi-Joins, Anti-Joins and Range-Joins
Mutable and Complex Joins

Summarizing with GROUP BY
What does GROUP BY do?
The GROUP BY Clause
Types of Grouping Functions pt. 1
Types of Grouping Functions pt. 2
Special Behavior pt. 1
Special Behavior pt. 2
Summary Functions
Statistical Functions
Other Functions
Filtering GROUP BY with the HAVING Clause
Extending the GROUP BY Clause pt. 1
Extending the GROUP BY Clause pt. 2

Subqueries and Other Advanced Queries
What is a Subquery?
Types of Subqueries
Comparison Conditions Revisited pt. 1
Comparison Conditions Revisited pt. 2
Comparison Conditions Revisited pt. 3
Regular vs. Correlated Subqueries
Nested Subqueries and Replacing Joins
Where can Subqueries be Used?
Hierarchical Queries
Set Operators and Composite Queries

Oracle Data Manipulation Language (DML)
What is DML?
Adding Data with INSERT
Multiple Table INSERT pt. 1
Multiple Table INSERT pt. 2
Changing Data with UPDATE pt. 1
Changing Data with UPDATE pt. 2
Remove Data with DELETE or TRUNCATE pt. 1
Remove Data with DELETE or TRUNCATE pt. 2
Merging Tables with MERGE pt. 1
Merging Tables with MERGE pt. 2
Transactional Control
Locking and Visibility of Data Changes
COMMIT vs ROLLBACK

PL/SQL (Programming Language SQL)
What is PL/SQL?
Modular Structure
Anonymous Procedures
Named Procedures
Functions
Packages
Triggers pt. 1
Triggers pt. 2
Variables and Types in PL/SQL pt. 1
Variables and Types in PL/SQL pt. 2
Objects and Object Datatypes
More About Objects pt. 1
More About Objects pt. 2
Programming Control Structures
Simple Database Access in PL/SQL
Cursors and Implicit Cursors pt. 1
Cursors and Implicit Cursors pt. 2
Explicit Cursors pt. 1
Explicit Cursors pt. 2
Dynamic SQL
Provided (DBMS_) Packages

Download Links:

http://www.mediafire.com/download.php?tjezztgmnyy

http://www.mediafire.com/download.php?ayymmyow1zw

http://www.mediafire.com/download.php?4izkmixy5yd

http://www.mediafire.com/download.php?imdddwdmj2m

Read more...

Oracle Applications 11i General Ledger: Complete Course

Welcome to NETg's course Oracle Applications 11i General Ledger: Complete Course. This course will introduce you to the features of Oracle General Ledger (OGL) and the procedure for logging on to Oracle Applications and other advance modules of GL. This course will also cover the concepts and procedures for defining a chart of accounts, an accounting calendar, and a set of books.

Advance Course Contains NetG Video Tutorials for:
Oracle 11i General Ledger (GL)
Oracle 11i GL Advance Features
Oracle 11i GL Currencies
Oracle 11i GL Reporting and Analysis
Oracle 11i GL Transactions


Uploaded onto fast Mediafire server ( you can download multiple files). Total size around 263 Mb





http://www.mediafire.com/download.php?3jkjmejyz5y

http://www.mediafire.com/download.php?yydomnuddmn

http://www.mediafire.com/download.php?zy0y2nnjmzh

http://www.mediafire.com/download.php?nuyizmyyovy

http://www.mediafire.com/download.php?teooucz2yzd

http://www.mediafire.com/download.php?nj30nmylnyh

Read more...

Oracle DBA CBT by Inndsoft Interactive Training

ssss

First 3 parts 30MB and Last part 10.43 MB Enjoy

Download Links:

http://www.mediafire.com/download.php?jygtqummzmd
http://www.mediafire.com/download.php?nzynmmlyyzl
http://www.mediafire.com/download.php?mnymncymhic
http://www.mediafire.com/download.php?mlioae4zx0h
 

Read more...