Oracle DBA made simple-Rampant Press

Oracle database administration techniques
By Mike Ault
Copyright © 2003 by Rampant TechPress. All rights reserved.
Published by Rampant TechPress, Kittrell, North Carolina, USA
Series Editor: Don Burleson
Production Editor: Teri Wade
Cover Design: Bryan Hoff
Oracle, Oracle7, Oracle8, Oracle8i, and Oracle9i are trademarks of Oracle
Corporation. Oracle In-Focus is a registered Trademark of Rampant TechPress.

Many of the designations used by computer vendors to distinguish their products
are claimed as Trademarks. All names known to Rampant TechPress to be
trademark names appear in this text as initial caps.

The information provided by the authors of this work is believed to be accurate
and reliable, but because of the possibility of human error by our authors and
staff, Rampant TechPress cannot guarantee the accuracy or completeness of
any information included in this work and is not responsible for any errors,
omissions, or inaccurate results obtained from the use of information or scripts in
this work.

Download eBooks :
http://rapidshare.com/files/124593625/Rampant_TechPress_Oracle_DBA_Made_Simple_By_Neo.ImediaR.rar

Read More..

Delphi 2009 Handbook

Author(s): Marco Cantu
Publisher: Piacenza
Date : 2008
Pages : 401
Format : pdf
Language : English

The book covers all the new featrues of Delphi 2009 for Win32, from Unicode support to generics, from anonymous methods to other language enhancements, from new IDE features to the Ribbon control, from Vista-enabled controls to DataSnap 2009. This is a brand new book, there is no overlapping material with the Delphi 2007 Handbook!

The Delphi 2009 Handbook has 400 pages covering exclusively new Delphi 2009 features. There is no introduction material or anything like that. The book is for developers who use Delphi 2007. If not, consider also grabbing the Delphi 2007 Handbook.

Download Ebooks :
http://flyfile.us/xoaew5lzxret/Delphi2009Handbook.rar.html
or
http://hotfile.com/dl/7224037/ca877e1/Delphi2009Handbook.rar.html

Read More..

MySQL Cookbook

Publisher: O'Reilly Media | ISBN: 0596001452 | edition 2002 | CHM | 1022 pages | 1,4 mb

Good programming--which is to say, programming that yields both efficient code and a profitable life for the programmer--depends on not reinventing the wheel.

If someone else has solved the problem you're facing (and someone almost always has), you'd be foolish to waste your energy figuring out your own solution.

MySQL Cookbook presents solutions to scores of problems related to the MySQL database server.

Readers stand a good chance of finding a ready-made solution to problems such as querying databases, validating and formatting data, importing and exporting values, and using advanced features like session tracking and transactions.

Paul DuBois has done a great job assembling efficient solutions to common database programming problems, and teaches his readers a lot about MySQL and its attendant APIs in the process.

Downloads :
http://depositfiles.com/files/iefo9pjaq

Read More..

Head First SQL Your Brain on SQL - A Learner's Guide

Description:

# Paperback: 607 pages
# Publisher: O'Reilly Media, Inc.
# Language: English
# ISBN-10: 0596526849
# ISBN-13: 978-0596526849

Head First SQL: Your Brain on SQL -- A Learner's Guide (Head First)

Bill Sawyer, ATG Curriculum Manager, Oracle
"There are books you buy and books you keep on your desk... Head First SQL is at the top of my stack."

Andrew Cumming, Author of SQL Hacks, Zoo Keeper at sqlzoo.net
"This is not SQL made easy; this is SQL made challenging, SQL made interesting, SQL made fun."

Download :
http://rapidshare.com/files/115249808/Head_First_SQL_Your_Brain_on_SQL_--_A_Learner_s_Guide.rar

Read More..

Oracle Procure to Pay Guide

Oracle Procure-to-Pay Guide
Melanie Cameron | ISBN: 0071622276 | PDF | 305 pages | April 2009 | 4.86 MB


Drive better decision making and maximize asset usage with Oracle E-Business Suite’s comprehensive end-to-end procurement solution.

his Oracle Press guide details, step-by-step, how to streamline and optimize your enterprise acquisition cycle using Oracle Procure-to-Pay. Set up and configure each module, generate contracts and purchase orders (POs), perform automatic invoicing, process payments, and enforce fiscal policies. You will also learn how to use powerful new purchasing and payables features.

* Manage POs and strengthen policy compliance using Oracle Purchasing
* Track documents from the buyers work center and demand workbench
* Centralize requisition creation and approvals
* Create and use sourcing rules for supplier purchases
* Use Oracle Payables to process invoices and handle settlements
* Consolidate and disburse funds using Oracle Payments
* Understand key setups for Oracle Purchasing, Oracle Payables, and Oracle Payments

Download

Read More..

Professional Visual Basic 2008 (Programmer to Programmer)

The 2008 version of Visual Basic is tremendously enhanced and introduces dramatic new concepts, techniques, and features to this popular object-oriented language. Written by an elite author team, this comprehensive resource provides a clear and concise approach to using VB 2008 in the ever-expanding .NET world. This book focuses on using the latest and most powerful tools from the Microsoft arsenal within your Visual Basic solutions. Youll examine everything from the .NET Framework to the best practices for deploying .NET applications to database access and integrating with other technologies.

Download :
http://rapidshare.com/files/135742786/0470191368.rar

Read More..

Cryptography for Internet & Database Applications

SBN: 0471210293, Author: Nick Galbreath, Publisher: Wiley, Pages: 320, Publication Date: 2002-07-15

Cryptography is the gold standard for security. It is used to protect the transmission and storage of data between two parties by encrypting it into an unreadable format.

Cryptography has enabled the first wave of secure transmissions, which has helped fuel the growth of transactions like shopping, banking, and finance over the world’s biggest public network, the Internet. Many Internet applications such as e-mail, databases, and browsers store a tremendous amount of personal and financialinformation, but frequently the data is left unprotected.

Traditional network security is frequently less effective at preventing hackers from accessing this data. For instance, once-private databases are now completely exposed on the Internet. Itturns out that getting to the database that holds millions of credit card numbers-the transmission-is secure through the use of cryptography, but the database itself isn’t, fueling the rise of credit card information theft.

A paradigm shift isnow under way for cryptography. The only way to make data secure in any application that runs over the Internet is to use secret (also known as private) key cryptography. The current security methods focus on securing Internet applications usingpublic keys techniques that are no longer effective.

In this groundbreaking book, noted security expert Nick Galbreath provides specific implementation guidelines and code examples to secure database and Web-based applications to prevent theft ofsensitive information from hackers and internal misuse.


http://rapidshare.com/files/240240432/Cryptography_for_Internet_sam05_ND.rar

Read More..

HOWTO Secure and Audit Oracle 10g and 11g

Product Description

This guide demonstrates how to secure sensitive data and comply with internal and external audit regulations using Oracle 10g and 11g. It provides the hands-on guidance required to understand the complex options provided by Oracle and the know-how to choose the best option for a particular case. The book presents specific sequences of actions that should be taken to enable, configure, or administer security-related features. It includes best practices in securing Oracle and on Oracle security options and products. By providing specific instructions and examples this book bridges the gap between the individuals who install and configure a security feature and those who secure and audit it.

Read More..

Microsoft SQL Server Black Book. .

Coriolis Group Books | ISBN: 1576101495 | 1997 | PDF | 464 pages | 3.33 MB

Teaches, with step-by-step guides, the most important SQL Server tasks. Troubleshoots common database and client-server problems. Improves performance with sophisticated SQL Server tuning techniques. Develops powerful database features that can easily be integrated into your current database system. Uses ready-to-run database examples and SQL code.

Download :
http://2838750227354.usercash.com

Read More..

' Oracle Database 11g The Complete Reference, 2008 '

Get full details on the powerful features of Oracle Database 11g from this thoroughly updated Oracle Press guide. Oracle Database 11g: The Complete Reference explains how to use all the new features and tools, execute powerful SQL queries, construct PL/SQL and SQL*Plus statements, and work with large objects and object-relational databases.

Learn how to implement the latest security measures, tune database performance, and deploy grid computing techniques. An invaluable cross-referenced appendix containing Oracle commands, keywords, features, and functions is also included.

* Install Oracle Database 11g or upgrade from an earlier version
* Create database tables, sequences, indexes, views, and user accounts
* Construct SQL statements, procedures, queries, and subqueries
*Optimize security using virtual private databases and transparent data
encryption
*Import and export data using SQL*Loader and Oracle Data Pump
* Use SQL replay, change management, and result caching
*Avoid human errors using flashback and automatic undo management
*Build and tune PL/SQL triggers, functions, and packages
*Develop database applications using Java, JDBC, and XML
*Optimize availability and scalability with Oracle Real Application Clusters

Download :
http://4550864100921.usercash.com

Read More..

SQL: The Complete Reference

McGraw-Hill || ISBN 0-07-211845-8 || Author: James R. Groff and Paul N. Weinberg || English || PDF || 689 Pages || Size: 4.35 MB

Preface

SQL: The Complete Reference provides a comprehensive, in-depth treatment of the SQL language for both technical and non-technical users, programmers, data processing professionals, and managers who want to understand the impact of SQL in the computer market.

This book offers a conceptual framework for understanding and using SQL, describes the history of SQL and SQL standards, and explains the role of SQL in the computer industry today. It will show you, step-by-step, how to use SQL features, with many illustrations and realistic examples to clarify SQL concepts. The book alsocompares SQL products from leading DBMS vendors ? describing their advantages, benefits, and trade-offs ? to help you select the right product for your application. The accompanying CD contains actual trial versions of five leading SQL databases, so you can try them for yourself and gain actual experience in using major database products from Oracle, Microsoft, Sybase, Informix, an IBM.

In some of the chapters in this book, the subject atter is explored at two different levels— a fundamental description of the topic, and an advanced discussion intended for computer professionals who need to understand some of the "internals" behind SQL. The more advanced information is covered in sections marked with an asterisk (*). You do not need to read these sections to obtain an understanding of what SQL is and what it does.

Download

Read More..

SQL All-in-One Desk Reference For Dummies

Allen G. Taylor, "SQL All-in-One Desk Reference For Dummies"
For Dummies | ISBN-10: 0470119284 | July 2, 2007 | 684 pages | PDF | 7.6MB

Master queries for any SQL database! Your one-stop guide to building and maintaining relational databases with SQL If you're looking for a good general reference on SQL, look no further. This all-in-one guide delivers the goods on all major SQL topics, from basic concepts to the latest XML data-handling functions. Whether you're a database developer or DBA, you'll find fast answers to your SQL questions and savvy tips on building databases that are robust, secure, and efficient.

- Tackle a database development project
- Formulate SQL queries
- Build database applications
- Secure your database
- Handle XML data
- Tune and optimize a database

Download

Read More..

Database Design: Know It All

This book brings all of the elements of database design together in a single volume, saving the reader the time and expense of making multiple purchases.

It consolidates both introductory and advanced topics, thereby covering the gamut of database design methodology ? from ER and UML techniques, to conceptual data modeling and table transformation, to storing XML and querying moving objects databases.

The proposed book expertly combines the finest database design material from the Morgan Kaufmann portfolio. Individual chapters are derived from a select group of MK books authored by the best and brightest in the field. These chapters are combined into one comprehensive volume in a way that allows it to be used as a reference work for those interested in new and developing aspects of database design.

Download

Read More..

SQL and Relational Theory: How to Write Accurate SQL Code

Understanding SQL’s underlying theory is the best way to guarantee that your SQL code is correct and your database schema is robust and maintainable. On the other hand, if you’re not well versed in the theory, you can fall into several traps. In SQL and Relational Theory, author C.J. Date demonstrates how you can apply relational theory directly to your use of SQL. With numerous examples and clear explanations of the reasoning behind them, you’ll learn how to deal with common SQL dilemmas, such as:

* Should database access granted be through views instead of base tables?
* Nulls in your database are causing you to get wrong answers. Why? What can you do about it?

* Could you write an SQL query to find employees who have never been in the same department for more than six months at a time?

* SQL supports “quantified comparisons,” but they’re better avoided. Why? How do you avoid them?
* Constraints are crucially important, but most SQL products don’t support them properly. What can you do to resolve this situation?

Database theory and practice have evolved since Edgar Codd originally defined the relational model back in 1969. Independent of any SQL products, SQL and Relational Theory draws on decades of research to present the most up-to-date treatment of the material available anywhere. Anyone with a modest to advanced background in SQL will benefit from the many insights in this book.

About the Author

C.J. Date has a stature that is unique within the database industry. C.J. is a prolific writer, and is well-known for his best-selling textbook: An Introduction to Database Systems (Addison Wesley). C.J. is an exceptionally clear-thinking writer who can lay out principles and theory in a way easily understood by his audience.

Download

Read More..

Murach's Beginning Visual Basic .NET

Book Description

With this book, you can learn the skills of a professional programmer in just 692 pages. Because of its self-paced approach in the first 7 chapters, you can do that whether you're new to Visual Basic.NET or you're upgranding from Visual Basic 6.

From that point on, you're ready for rapid progress as you learn how to develop sophisticated GUIs, how to use the .NET classes for a wide variety of purposes, how to work with XML, how to develop database appplications with ADO.NET, and how to develop web applications with ASP.NET.

To insure success, this book includes 18 complete business applications so you can see how the forms, controls, and code of Visual Basic applications work together. Applications like these should be a standard part of all programming books. BUT NO OTHER VB BOOK DOES THIS

Download
Password: netkahero

Read More..

Visual Basic 2008 Recipes

Visual Basic 2008 Recipes - A problem Solution approach Sometimes you just need to solve a problem and get on with your work. To that end, VisualBasic 2008 Recipes is a compendium of practical solutions for busy VB .NET programmers.

Create time for the more interesting aspects of your VB .NET project by solving common problems with the practical solutions and dozens of code examples in this book. Important new .NET 3.5 technologies, such as Windows Presentation Framework (WPF) and LanguageIntegrated Query (LINQ), are covered, and each chapter addresses a specific problem domain, including database access, multimedia, XML manipulation, networking, and security. The code is free to download so you can use the recipes immediately.

* Take advantage of quality, ready made solutions to common Visual Basic programming problems.

* Avoid the tedium of having to reinvent the wheel. Focus instead on the more interesting problems specific to your application.

* Learn from and be inspired by what the authors have done. Use their work as stepping

stones to solve even more complex problems.

What you will learn


* Store data to and retrieve data from your relational database using LINQ.

* Manipulate XML data using LINQ.

* Make your programs dynamically configurable through the judicious application of reflection.

* Take advantage of multiple CPU cores by writing multithreaded applications.

* Integrate multimedia into your Visual Basic projects.

* and a lot more....

Who is this book for?

Visual Basic 2008 Recipes is written for Visual Basic developers who have at least some experience in developing Visual Basic solutions. The book contains recipes appealing to intermediate through advanced developers.

704 pages

Download

Read More..

VTC Training - MySQL

Virtual Training Company's MySQL tutorial is just what you need to begin designing and developing database management systems. Joshua Mostafa will help you go from a beginner's understanding of databases and SQL to gaining mastery knowledge in only 8 hours of training. He starts the tutorial by covering the basics of databases and SQL. Once you are comfortable with the basics, move on to the more complex aspects of SQL, such as variables and security. You can start right away by simply clicking one of the movie topics below.

Title: MySQL
Author: Joshua Mostafa
SKU: 33364
ISBN: 1930519745
Release Date: 2002-07-25
Duration: 8 hrs / 71 lessons
Compatibility: Win XP, 2000, 98, NT, Mac OS X, OS 9

To view the Free Tutorials listed below, you must have QuickTime installed. Monitor resolution needs to be set to at least 1024x768 to view the entire movie.

Download :
http://3488567886408.usercash.com

Read More..