IT Books | Training CBTs | Exam Dumps | PowerPoint Presentations: July 2009

Oracle Performance Tuning for 10gR2

Thursday, July 30, 2009

Description:

Fully updated for version 10gR2 and provides all necessary transition material from version 9i. Includes all three aspects of Oracle database tuning: data model tuning, SQL & PL/SQL code tuning, physical plus configuration tuning. Contains experienced guidance and real-world examples using large datasets Emphasizes development as opposed to operating system perspective

Download Link:

http://www.mediafire.com/oracle-performance-tuning-for-10gr2.rar

Oracle 10g RAC Grid, Services & Clustering

Description:

Oracle RAC and grid technology is transforming the economics of high-end database computing and is a technology that all Oracle professionals should become familiar with. Murali is one of the worlds foremost independent experts on Oracle RAC technology and his book contains everything you need to become proficient in both the theory and practice of Real Application Clusters. If you are planning a RAC implementation, looking to optimize an existing RAC implementation or simply want to become more familiar with this important technology, you should read this book.

Download Link:

http://www.mediafire.com/download.php?24z3my2zwzz

Oracle 10g/11g Data and Database Management Utilities (with Source Code) 2009

Wednesday, July 29, 2009

Description:

Master twelve must-use utilities to optimize the efficiency, management, and performance of your daily database tasks

• Optimize time-consuming tasks efficiently using the Oracle database utilities

• Perform data loads on the fly and replace the functionality of the old export and import utilities using Data Pump or SQL*Loader

• Boost database defenses with Oracle Wallet Manager and Security

• A handbook with lots of practical content with real-life scenarios

In Detail Does your database look complicated? Are you finding it difficult to interact with it? Database interaction is a part of the daily routine for all database professionals. Using Oracle Utilities the user can benefit from improved maintenance windows, optimized backups, faster data transfers, and more reliable security and in general can do more with the same time and resources.

You don't have to reinvent the wheel, just learn how to properly use the Oracle Utilities to achieve your goals. This is what this book is about; it covers topics oriented towards data management, session management, batch processing, massive deployment, troubleshooting, and how to make the most out of the frequently used DBA tools to improve your daily work.

Data management is one of the most frequently required tasks; doing a backup is a must-do task for any company. Data management includes several tasks such as data transfers, data uploading and downloading, reorganizing data, and data cloning, among many others. If people learn to use a tool and things appear to go well, few will question if their approach is optimal. Often it is only when maintenance windows start shrinking, due to the amount of data and business availability, that problems with any particular approach get identified. If people get used to the old export/import utilities to perform data management and if it works, they probably will consider the problem solved and will continue to use an obsolete tool. This book explores further possibilities and new tools. It makes the user question if his/her current environment is optimized and teaches how to adopt more optimized data management techniques focusing to the tools and the requirements most frequently seen in modern production environments.

What you will learn from this book?

• Improve performance and manageability using the advanced features of direct export/import utilities among different databases

• Optimize your maintenance windows related to data management tasks such as importing data from one database to another using Data Pump and SQL*Loader

• Perform more than just the ETL processes by taking advantage of the external tables feature

• Use Oracle Scheduler to specify maintenance windows, assign priorities, configure job classes and many more features, and take decisions based on the task outcome

• Get acquainted with all the possibilities the Oracle Universal Installer tool offers to make the installation task more efficient

• Execute effective database creations: not just default creations, but comprehensive database creations

• Configure and manage an ASM environment using DBCA

• Improve performance and reduce the impact of recovery manager database backups in production environments

• Increase the security in an Oracle environment, protect the backups, and manage certificates using Oracle Wallet Manager

• Perform installations in batch environments and manage your software updates related to Critical Patch Updates (CPU) or individual patches using OPatch

Approach

This book is written using a practical approach that guides you through different practical scenarios. It provides a brief introduction to the topics; this way you can quickly get to know the main features, start being productive with the tool, and grow with it at a fast pace. You won't have to spend too much time getting to the basics of the tool and can immediately progress towards the advanced tips.

Using this practical approach you don't have to spend valuable time trying to decipher arid reference manuals; you can easily set up the practical scenarios, and try to follow up the presentations. The images used in the book come from real scenarios, and the output is always explained so you can easily interpret what is being displayed on the screen after issuing the commands.

Who this book is written for?

This book is aimed at all Oracle professionals who interact with the database through the data and database utilities and are willing to optimize their interaction with it.

Entry-level users will get acquainted with the best practices to get their job done in a timely and efficient manner. Advanced users will find useful tips and How-Tos that will help them focus on getting the most out of the database utilities and fine-tune batch processing.

Download Link:

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

Oracle DBA 10G Administration-I & II PPTs

Very Informative Oracle DBA 10G Administration-I & II

PowerPoint Presentations

Preview:-

Dwonlaod Links:-

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

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

Useful Oracle PL/SQL PPT

Tuesday, July 28, 2009

Very Informative Oracle PL/SQL Powerpoint Presentation

Downlaod Link:

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

Migrating from RedHat to SUSE Linux Enterprise Server 10

Monday, July 27, 2009

Migrating from RedHat to SUSE Linux Enterprise Server 10

(Official Book)

Are you an Administrator who is looking to expand their skills to be able to successfully carry out a migration from Red Hat Enterprise Linux 4 to SUSE Linux Enterprise Server 10?

Description:

Migrating from Red Hat to SUSE Linux Enterprise Server 10 (Course 3068) focuses on the main differences between Red Hat Enterprise Linux 4 and SUSE Linux Enterprise Server 10. It enables an experienced Linux administrator familiar with Red Hat Enterprise Linux 4 to perform administrative tasks on the SUSE Linux Enterprise Server 10 platform.
This course also covers topics that are not part of the Novell CLP 10 certification, but are of importance in migration scenarios, like iSCSI, OCFS, or specific differences in mail or web server configuration.

Download Link:

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

Upgrading to Certified Linux Engineer 10 Course 3076

(Official Book)

Description:

This course is designed to cover information on the differences between SUSE Linux Enterprise Server version 9 and version 10. Students will learn all about the new features and changes made in version 10 compared to their existing knowledge as a Novell Certified Linux Engineer 9.

Downlaod Link:

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

Novell Cluster Services™ for Linux® and NetWare®

Description:

Need to configure or manage Novell Cluster Services on NetWare, Linux or a mixed environment? Pick up a copy of the official reference guide, Novell Cluster Services for Linux and NetWare. This book blends in-depth information with practical, real world examples to cover cluster services configuration strategies, backup requirements, cluster services management, and upgrading tactics. You'll gain invaluable insight from authors Rob Bastiaansen and Sander van Vugt, two Novell Certified Instructors with day-to-day experience consulting on the topics covered in this book. Master intalling and managing Novell Cluster Services with the tutorial not available from anyone else, Novell Cluster Services for Linux and NetWare.

Download Link:

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

Linux Kernel Development Second Edition

Description:

The Linux kernel is one of the most interesting yet least understood open-source projects. It is also a basis for developing new kernel code. That is why Sams is excited to bring you the latest Linux kernel development information from a Novell insider in the second edition of Linux Kernel Development. This authoritative, practical guide will help you better understand the Linux kernel through updated coverage of all the major subsystems, new features associated with Linux 2.6 kernel and insider information on not-yet-released developments. You'll be able to take an in-depth look at Linux kernel from both a theoretical and an applied perspective as you cover a wide range of topics, including algorithms, system call interface, paging strategies and kernel synchronization. Get the top information right from the source in Linux Kernel Development.

Download Link:

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

Oracle 10g Developer Project for Medical Complex (Forms Only)

Saturday, July 25, 2009

Oracle 10g Project (Budjet Entry System)

Pictures of my Project

This Project was built using:

1) Forms [32 Bit] Version 10.1.2.0.2 (Production)

2) Oracle 10g Database

Forms

10)

11)

12)

Reports

(uploaded only two reports)

Excel to Oracle

Friday, July 24, 2009

Description:

Excel-to-Oracle is a program to migrate MS Excel data to Oracle database. Each worksheet becomes a table, each row becomes a record and each cell becomes a field.

Features

All versions of MS Excel are supported

Command line support

Convert individual worksheets

Convert Comma Separated Values (CSV) files into Oracle tables

Easy-to-use wizard-style interface

Full install/uninstall support

Requirements

At least 32 MB RAM

Oracle client and networking components

Necessary privileges to write into the destination databas

Download Link:

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

Oracle9i: SQL CBTs

Thursday, July 23, 2009

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