SQL Injection Attacks and Defense

SQL injection represents one of the most dangerous and well-known, yet misunderstood, security vulnerabilities on the Internet, largely because there is no central repository of information to turn to for help. This is the only book devoted exclusively to this long-established but recently growing threat. It includes all the currently known information about these attacks and significant insight from its contributing team of SQL injection experts.

• What is SQL injection?-Understand what it is and how it works
• Find, confirm, and automate SQL injection discovery
• Discover tips and tricks for finding SQL injection within the code
• Create exploits using SQL injection
• Design to avoid the dangers of these attacks

SQL Injection Attacks and Defense

Read more...

Oracle Database 10g The Top 20 Features for DBAs

Over the last 27 years, Oracle has made tremendous improvements in its core database product. Now, that product is not only the world's most reliable and performant database, but also part of a complete software infrastructure for enterprise computing. With each new release comes a sometimes dizzying display of new capabilities and features, sometimes leaving developers, IT managers, and even seasoned DBAs wondering
which new features will benefit them most.

With the introduction of Oracle Database 10g, DBAs will have in their hands one of the most profound new releases ever from Oracle. So, DBAs who take the time to understand the proper application of new Oracle technology to their everyday jobs will enjoy many time-saving, and ultimately, money-saving new capabilities.
Oracle Database 10g offers many new tools that help DBAs work more efficiently (and perhaps more enjoyably), freeing them for more strategic, creative endeavors—not to mention their nights and weekends. Oracle Database 10g really is that big of a deal for DBAs.

Over the new 20 weeks, I will help you through the ins and outs of this powerful new release by presenting what I consider to be the top 20 new Oracle Database 10g features for database administration tasks. This list ranges from the rudimentary, such as setting a default tablespace for creating users, to the advanced, such as the new Automatic Storage Management feature.

In this series, I will provide brief, focused analyses of these interesting new tools and techniques. The goal is to outline the functions and benefits of the feature so that you can put it into action in your environment as quickly as possible. I welcome your thoughts, comments, and questions about this series. Enjoy!

Oracle Database 10g The Top 20 Features for DBAs

Read more...

Expert Oracle Database Architecture: Oracle Database 9i, 10g, and 11g Programming Techniques and Solutions

This fully revised second edition covers the developments up to Oracle Database 11g. Each feature is taught in a proof-by-example manner, not only discussing what it is, but also how it works, how to implement software using it, and the common pitfalls associated with it.
Don’t treat Oracle Database as a black-box. Get this book. Get under the hood. Turbo-charge your career.

• Fully revised to cover Oracle Database 11g
• Proof-by-example approach: Let the evidence be your guide
• Dives deeply into Oracle Databases’s most powerful features

What you’ll learn

• Develop an evidence-based approach to problem solving
• Manage transactions in highly concurrent environments
• Speed access to data through table and index design
• Manage files and memory structures for performance and reliability
• Scale up through partitioning and parallel processing
• Load and unload data to interface with external systems
• Think for yourself; don’t take Tom’s word for it!

Who this book is for

This book is aimed at Oracle Database administrators, at PL/SQL and Java developers writing code to be deployed inside the database, and at developers of external applications who use Oracle Database as a data store. It is the go-to book for those wishing to create efficient and scalable applications.

Table of Contents

1. Developing Successful Oracle Applications   
2. Architecture Overview  
3. Files   
4. Memory Structures  
5. Oracle Processes  
6. Locking and Latching  
7. Concurrency and Multi-versioning  
8. Transactions 
9. Redo and Undo  
10. Database Tables   
11. Indexes   
12. Datatypes  
13. Partitioning  
14. Parallel Execution  
15. Data Loading and Unloading 
16. Data Encryption 

Expert Oracle Database Architecture: Oracle Database 9i, 10g, and 11g Programming Techniques and Solutions

Read more...

Physical Database Design Using Oracle

Physical Database Design Using Oracle

This book contains information obtained from authentic and highly regarded sources. Reprinted material is quoted with permission, and sources are indicated. A wide variety of references are listed. Reasonable efforts have been made to publish reliable data and information, but the author and the publisher cannot assume responsibility for the validity of all materials or for the consequences of their use.

Physical Database Design Using Oracle

Read more...

Oracle Database 10g on Windows Architecture for Performance

Oracle Database 10g on Windows Architecture for Performance

Read more...

D70842GC10 BEA WebLogic Portal 9/10: System Administration

What you will learn
This course trains experienced BEA WebLogic Server 9/10 system administrators on the configuration and management of applications built with BEA WebLogic Portal 9/10. Students will learn how to stage and tune portal applications and their relational data, and to propagate these changes to a highly available production environment. Course labs have been validated on BEA WebLogic Portal 10.
 

Learn to:
Initialize a domain and database to support BEA WebLogic Portal applications
Propagate portal data from staging to production environments
Configure and secure portal desktop components

Prerequisites
BEA WebLogic Server domains, servers and clusters
BEA WebLogic Server performance tuning
Security realms and providers
Keystores and certificates
Data sources
Security Assertion Markup Language (SAML)
Familiarity with essential concepts of BEA WebLogic Portal
Ant scripting fundamentals
BEA WebLogic Server 9/10: Advanced System Administration


Course Objectives
Propagate portal data from staging to production environments
Manage and secure portal resources
Delegate portal administrative capabilities
Initialize a domain and database to support BEA WebLogic Portal applications
Manage federated portal resources
Configure and tune a content repository
Index and search content and other information using autonomy


Course Topics

Product installation

Portal production architecture

Portal domains and applications

Product database schema

Shared libraries

Portal deployment plans

BEA WebLogic Portal Administration Console

Portal desktop management

Community management

Federated portal administration

Content repository administration

User profile management

Visitor entitlements

Delegated administration

Portal cache manager

Autonomy search administration

Propagation tool

BEA AquaLogic Analytics

 

D70842GC10 BEA WebLogic Portal 9/10: System Administration

Read more...

D17276GC10 Oracle Database 10gReal Application Clusters Vol 2

D17276GC10 Oracle Database 10gReal Application Clusters Vol 2

Read more...

D17276GC10 Oracle Database 10g Real Application Clusters Vol-1

What you will learn

This course offers students an introduction to the general features and capabilities of Oracle Database 10g Release 1 for Oracle Real Application Clusters (RAC).

Students learn how to configure and administer a database for use with Real Application Clusters. The course also explains how to setup and use Automatic Storage Management (ASM) in a Real Application Clusters environment. Lectures are reinforced with hands-on practices designed to walk the student through the RAC administration.

This course counts towards the Hands-on course requirement for the Oracle Database 10g Administrator Certification. Only instructor-led inclass or instructor-led online formats of this course will meet the Certification Hands-on Requirement. Self Study CD-Rom and Knowledge Center courses are excellent study and reference tools but DO NOT meet the Hands-on Requirement for certification.


Audience
Database Administrators

Course Objectives
Identify Real Application Clusters components
Install, create, administer, and monitor a Real Application Clusters database
Use configuration and management tools for Real Application Clusters databases
Migrate your database storage to Automatic Storage Management
Setup services for workloads management, and applications high availability
Develop a backup and recovery strategy for Real Application Clusters databases
Review high availability best practices

Course Topics

Introduction
Define a cluster
Define Oracle Real Application Clusters
List the advantages of using RAC
Define scalability
High availability and RAC

Architecture and Concepts
List the various components of Cluster Ready Services (CRS) and Real Application Clusters (RAC)
Describe the various types of files used by a RAC database
Describe the various techniques used to share database files across a cluster
Describe the purpose of using services with RAC

RAC Installation and Configuration Part I
Outline Oracle 10g RAC Installation
Preinstallation Tasks
Cluster Setup Tasks
Installing OCFS
Installing Cluster Ready Services

RAC Installation and Configuration Part II
Install Database Software
Launching VIPCA with root.sh
Database Precreation Tasks
Creating the Cluster Database
Database Postinstallation Tasks
Administering Enterprise Manager Jobs in Real Application Clusters
Node Addition and Deletion and the SYSAUX Tablespace
AWR snapshots in RAC

RAC Database Instances Administration
Understand the EM Cluster Database Home Page
Starting and Stopping RAC Instances
RAC Initialization Parameter Files
Adding a Node to a Cluster
Deleting Instances from a RAC Database
Quiescing RAC Databases
Administering Alerts with Enterprise Manager

Administering Storage in RAC Part I
Describe automatic storage management (ASM)
Install the ASM software
Set up initialization parameter files for ASM and database instances
Start up and shut down ASM instances
Add ASM instances to the target list of Database Control
Use Database Control to administer ASM in a RAC environment

Administering Storage in RAC Part II
Manage redo log groups in a RAC environment
Manage undo tablespaces in a RAC environment
Use SRVCTL to manage ASM instances
Migrate database files to ASM
Manage and recover the OCR file and voting disk

Services
Configure and manage services in a RAC environment
Use services with client applications
Use services with the Database Resource Manager
Use services with the Scheduler
Set performance-metric thresholds on services
Configure services aggregation and tracing

High Availability of Connections
Configure client side connect-time load balancing
Configure client side connect-time failover
Configure server side connect-time load balancing
Benefit from Fast Application Notification (FAN)
Configure server-side callouts
Configure the server and client-side ONS
Configure Transparent Application Failover (TAF)

Managing Backup and Recovery in RAC
Configure RAC Recovery Settings with EM
Configure RAC Backup Settings with EM
Initiate Archiving
Configuring RMAN
RAC Backup and Recovery Using EM

RAC Performance Tuning
Determine RAC specific tuning components
Tune instance recovery in RAC
Determine RAC specific wait events, global enqueues, and system statistics
Implement most common RAC tuning tips
Use the Cluster Database Performance pages
Use Automatic Workload Repository and Automatic Database Diagnostic Monitor in RAC

Design for High Availability
Design a Maximum Availability Architecture in your environment
Determine the best RAC and Data Guard topologies for your environment
Configure the Data Guard Broker configuration files in a RAC environment
Patch your RAC system in a rolling fashion

D17276GC10 Oracle Database 10g Real Application Clusters

Read more...

The Language of SQL

Most SQL texts attempt to serve as an encyclopedic reference on SQL syntax an approach that is counterproductive, since this information is readily available in online references published by the major database vendors. For SQL beginners, it is more important for a book to focus on general concepts and offer clear explanations and examples of what the various statements can accomplish. This is that beginner book. A number of features make The LANGUAGE OF SQL unique among introductory SQL books. First, you will not be required to download software or sit with a computer as you read the text.

The intent of this book is to provide examples of SQL usage that can be understood simply by reading them. Second, topics are organized in an intuitive and logical sequence. SQL keywords are introduced one at a time, allowing you to build on your prior understanding as you encounter new words and concepts. Finally, this book covers the syntax of three widely used databases: Microsoft SQL Server, MySQL, and Oracle, with special Database Differences boxes that will show you any differences in the syntax among those three databases, as well as instructions on how to obtain and install free versions of the databases. This is the only book you'll need to gain a working knowledge of SQL and relational databases.


Language of SQL

Read more...

Oracle CRM On Demand Deployment Guide

Description

Master Oracle CRM On Demand

Foster long-term customer relationships and accelerate productivity using the proven strategies and best practices in this Oracle Press guide. Oracle CRM On Demand Deployment Guide shows how to set up, customize, and manage a dynamic software-as-a-service solution across your enterprise. Develop implementation plans, maximize user adoption, build applets and portals, integrate Web 2.0 features, and use analytics dashboards. The latest design, tuning, and data security techniques are also covered in this practical resource.

* Establish business objectives, project requirements, and key success metrics
* Staff an implementation team and develop effective rollout plans
* Configure, deploy, and administer Oracle CRM On Demand
* Manage users and restrict access using roles and privileges
* Customize sales, marketing, and service processes with the object model
* Embed external content and URLs using the web services API
* Distribute real-time BI using dashboards and advanced reporting tools
* Incorporate web tabs, mashups, Google services, and RSS feeds
* Use workflow to automate business process management




Oracle CRM On Demand Deployment Guide

Read more...

How to Become an Exceptional DBA, 2nd Edition

A 2nd edition of Brad McGehee's popular "career guide" for DBAs, designed to help new and prospective DBAs find their feet in the profession, and to advise those more-experienced on how they can excel at their jobs, and so become Exceptional DBAs.



How to Become an Exceptional DBA, 2nd Edition

Read more...

D46306GC10 Oracle Directory Services Administration

http://www.mediafire.com/D46306GC10.Oracle.Directory.Services.Administration.rar

Read more...

D53181GC10 Oracle SOA Suite 10g R3: Administration

Getting Started with Oracle Application Server

Identifying different OracleAS administrator roles
Providing an overview of OracleAS 10g R2 (10.1.2.0.2)
Describing the main components that compose the OracleAS architecture
Explaining the transition from OracleAS 10g R2 to OracleAS 10g R3 (10.1.3.1.0)

Installing Oracle Application Server 10g R3

Identifying the installation requirements for OracleAS 10g Release 3 (10.1.3.1.0)
Describing the installation types of OracleAS 10g Release 3 (10.1.3.1.0)
Installing OracleAS 10g Release 3 (10.1.3.1.0)
Applying OracleAS 10g Release 3 (10.1.3) Patch Set 3 (10.1.3.3.0) to a 10g Release 3 (10.1.3.1.0) Oracle home

Administering and Managing Oracle Application Server
Discussing the Application Server Control architecture
Describing the management infrastructure and tools in OracleAS 10g Release 3 (10.1.3.1.0)
Managing an OracleAS 10g Release 3 (10.1.3.1.0) instance
Discussing the new features of OracleAS 10g Release 3 (10.1.3.1.0)
Starting and stopping an OracleAS instance or a component
Deploying J2EE applications
Performing advanced tasks using admin_client.jar
Performing advanced tasks using Ant

Introducing Service-Oriented Architecture and Oracle SOA Suite 10g
Providing an overview of Service-Oriented Architecture
Identifying Standards that Enable SOA
Describing Oracle BPEL Process Manager Architecture
Describing Oracle Enterprise Service Bus Architecture
Describing Oracle Business Rules
Describing Oracle Web Services Manager
Introducing the Adapter Framework

Administering and Monitoring Oracle BPEL
Accessing Oracle BPEL Control
Compiling and Deploying a BPEL Process
Managing BPEL Processes
Testing BPEL Processes
Viewing Oracle BPEL Process Reports
Identifying BPEL Process Management API
Managing BPEL Dehydration Store
Configuring and Viewing BPEL Process Logs

Administering and Monitoring Oracle ESB
Providing an overview of Creating, Configuring, and Managing Oracle Enterprise Service Bus
Introducing Oracle Enterprise Service Bus Control
Managing Oracle ESB Systems and Service Groups
Creating or Modifying Routing Rules
Defining and Managing Tracking Fields
Using Import and Export Utilities in ESB
Error Handling in ESB

Administering Oracle WSM
Discussing Oracle WSM Component Architecture
Configuring a Gateway
Managing Policy in Oracle WSM
Configuring a Server Agent
Configuring a Client Agent
Using Oracle WSM Client and Server Agents to Enforce Security Policies

Monitoring Oracle WSM
Introducing Oracle WSM Monitoring and Auditing
Monitoring System Performance
Managing the Operational Environment
Viewing the Message Logs
Creating an Alarm Rule
Viewing Alarms by Using the Oracle WSM Control

High Availability Solutions for Oracle SOA Suite
Introducing high availability for Oracle SOA Suite
Implementing high availability for Oracle BPEL Process Manager
Implementing high availability for Oracle ESB
Configuring Oracle WSM in a clustered environment

Backing Up and Restoring Oracle Application Server
Configuring the OracleAS Recovery Manager
Configuring OracleAS for a full backup
Describing a backup strategy for OracleAS
Performing a complete OracleAS backup
Describing a recovery strategy for OracleAS
Restoring an OracleAS environment

Troubleshooting Oracle Application Server
Troubleshooting BPEL
Troubleshooting ESB
Troubleshooting OWSM

http://www.mediafire.com/Oracle.SOA.Suite.10g.R3.Administration.rar

Read more...

1z0-402 & 1z0-007 Item Bank 100% coverage of Exam

OCA 042 exam history, there have been two sets of item bank, which means kinds of questions once changes have taken place. Now the popular item bank is the second item bank, a total of 168 questions, the basic guarantee clearance. However, individual bad luck, saying that problems encountered by all the new hung up. In fact, problems encountered are not new, but the old questions - the first set of questions.  So put these two sets of item bank to do the merger.  Item bank so far back that 296 people who reflect the coverage of 100%. 

http://www.mediafire.com/1Z0-042.item.bank.rar

http://www.mediafire.com/1z0-007.item.bank.rar

Download Password: itembank

Read more...

Oracle Application Server 10g Administration I Study Guide (Exam 1Z0-311)

Description:

• Complete coverage of the exam objectives, hands-on exercises, review questions, and more, this is the first and only book to offer such in-depth coverage of this challenging exam
• Takes into consideration that candidates must not only know how to install and configure Oracle Application Server 10g, but how to use the robust tool set, including Oracle HTTP Server and OracleAS Portal
• The book features an interactive CD-ROM, including the Sybex Test Engine with chapter review questions and bonus exams, a series of flash cards that can be used on a PC or handheld, and an e-version of the book

Download Link:

http://www.mediafire.com/Oracle.Application.Server.10g.Administration.I.Study.Guide.Exam.1Z0-311.rar

Read more...

TestKing (1z0-042 & 1z0-043)

TestKing Oracle 10g Database Administration-I & II

Exam Dumps (1z0-042 & 1z0-043)

Download Links:

http://www.mediafire.com/TestKing.Oracle.10g.1Z0-042.rar

http://www.mediafire.com/TestKing.Oracle.10g.1Z0-043.rar

Email me (shaheer.badar@yahoo.com) to get the download password

Read more...

D58373GC10 Oracle WebLogic Server 10gR3 Monitoring and Performance

Download Link:

http://www.mediafire.com/D58373GC10.Oracle.WebLogic.Server.10g.R3.Monitoring.and.Performance.Tuning.rar

Read more...

Oracle Application Server 10g (1z0-311 & 1z0-312) Exam Dumps 2009

Oracle Application Server 10g

Administration-I & II Exam Dumps 2009

Download Link:

http://www.mediafire.com/Oracle.Application.Server.10g.Admin-I.1z0-311.Exam.Dump.2009.rar

http://www.mediafire.com/Oracle.Application.Server.10g.Admin-II.1z0-312.Exam.Dump.2009.rar

Email me at (shaheer.badar@yahoo.com) to get the password

Read more...

1z0-048 Oracle Database 10gR2 Administrating RAC Exam Dump 2009

Oracle Database 10R2: Administrating RAC

Download Link:

http://www.mediafire.com/Oracle.Database.10gR2.Administrating.RAC.1z0-048.Exam.Dump.2009.rar

Email me at (shaheer.badar@yahoo.com) to get the password

Read more...

Oracle Exam Dumps June-July 2009

Description:

Oracle.1Z0-020.Exam.Q.and.A.06.12.09

Oracle.1Z0-023.Exam.Q.and.A.06.12.09

Oracle.1Z0-023.Exam.Q.and.A.06.29.09

Oracle.1Z0-023.Exam.Q.and.A.07.14.09

Oracle.1Z0-025.Exam.Q.and.A.06.12.09

Oracle.1Z0-030.Exam.Q.and.A.06.15.09

Oracle.1Z0-032.Exam.Q.and.A.06.15.09

Oracle.1Z0-032.Exam.Q.and.A.06.23.09

Oracle.1Z0-040.Exam.Q.and.A.06.23.09

Oracle.1Z0-041.Exam.Q.and.A.06.24.09

Oracle.1Z0-042.Exam.Q.and.A.06.24.09

Oracle.1Z0-043.Exam.Q.and.A.06.24.09

Oracle.1Z0-101.Exam.Q.and.A.06.24.09

Oracle.1Z0-131.Exam.Q.and.A.06.24.09

Oracle.1Z0-132.Exam.Q.and.A.06.24.09

Oracle.1Z0-140.Exam.Q.and.A.06.10.09

Oracle.1Z0-140.Exam.Q.and.A.06.24.09

Oracle.1Z0-200.Exam.Q.and.A.06.24.09

Oracle.1Z0-211.Exam.Q.and.A.06.29.09

Oracle.1Z0-212.Exam.Q.and.A.06.29.09

Oracle.1Z0-213.Exam.Q.and.A.06.29.09

Oracle.1Z0-222.Exam.Q.and.A.06.29.09

Oracle.1Z0-231.Exam.Q.and.A.07.03.09

Oracle.1Z0-233.Exam.Q.and.A.07.03.09

Oracle.1Z0-301.Exam.Q.and.A.07.03.09

Oracle.1Z0-311.Exam.Q.and.A.06.10.09

Download Link:

http://www.mediafire.com/Oracle.Exam.Dumps.June-July.2009.rar

shaheer.badar@yahoo.com mail me to get the download password

Read more...