Saturday, December 1, 2007

SQL Queries for Mere Mortals: A Hands-On Guide to Data Manipulation in SQL (2nd Edition)

John L. Viescas, Michael J. Hernandez "SQL Queries for Mere Mortals: A Hands-On Guide to Data Manipulation in SQL (2nd Edition)"

Addison-Wesley Professional (September 24, 2007) ISBN 0321444434 672 Pages PDF 2.3 Mb

Over the last several decades, SQL has evolved from a language known only to computer specialists to a widely used international standard of the computer industry. The number of new applications deployed each year using SQL now totals in the millions. If you are accessing corporate information from the Internet or from an internal network, you are probably using SQL. SQL Queries for Mere Mortals will help new users learn the foundations of SQL queries, and will prove to be an essential reference guide for intermediate and advanced users.


http://rapidshare.com/files/73473066/SQL.Queries.for.Mere.Mortals.2nd.Edition.Sep.2007.rar

http://www.megaupload.com/?d=O3M5NDND

Practical Oracle Security: Your Unauthorized Guide to Relational Database Security

Josh Shaul, Aaron Ingram, "Practical Oracle Security: Your Unauthorized Guide to Relational Database Security"
Syngress (August 15, 2007) ISBN 1597491985 432 Pages PDF 3.4 Mb

This is the only practical, hands-on guide available to database administrators to secure their Oracle databases. This book will help the DBA to assess their current level of risk as well as their existing security posture. It will then provide practical, applicable knowledge to appropriately secure the Oracle database. The books companion Web site contains dozens of working scripts that DBAs can use to secure andautomate their Oracle databases.* The only practical, hands-on guide for securing your Oracle databasepublished by independent experts.* Companion Web site contains dozens of scripts to help you automatesecurity tasks.* Your Oracle database does not exist in a vacuum, so this book showsyou how to securely integrate your database into your enterprise.

http://rapidshare.com/files/73470750/Syngress.Practical.Oracle.Security.Aug.2007.rar
http://www.megaupload.com/?d=AJ94UNNE

Saturday, November 24, 2007

Joe Celko's SQL Programming Style

Joe Celko "Joe Celko's SQL Programming Style" Morgan Kaufmann ISBN 0120887975 2005 Year PDF ~2 Mb 272 Pages


Are you an SQL programmer that, like many, came to SQL after learning and writing procedural or object-oriented code? Or have switched jobs to where a different brand of SQL is being used, or maybe even been told to learn SQL yourself? If even one answer is yes, then you need this book. A "Manual of Style" for the SQL programmer, this book is a collection of heuristics and rules, tips, and tricks that will help you improve SQL programming style and proficiency, and for formatting and writing portable, readable, maintainable SQL code. Based on many years of experience consulting in SQL shops, and gathering questions and resolving his students’ SQL style issues, Joe Celko can help you become an even better SQL programmer.+ Help you write Standard SQL without an accent or a dialect that is used in another programming language or a specific flavor of SQL, code that can be maintained and used by other people. + Enable you to give your group a coding standard for internal use, to enable programmers to use a consistent style. + Give you the mental tools to approach a new problem with SQL as your tool, rather than another programming language—one that someone else might not know!


http://rapidshare.de/files/5583753/SQL_Programming_Style.pdf.html

Beginning PL/SQL: From Novice to Professional

Donald Bales , "Beginning PL/SQL: From Novice to Professional "Apress (August 24, 2007) ISBN: 1590598822 476 pages PDF 5,5 Mb

Get started with PL/SQL, the built-in language that every Oracle developer and database administrator must know, in Beginning PL/SQL, a fast-paced and example-filled tutorial. Learn from author Don Bales' extensive experience to discover the most commonly used aspects of PL/SQL without wasting time with obscure and obsolete features. Author Don Bales takes his 20+ years of experience and a wealth of statistics he's gathered on PL/SQL usage over those years and applies the 80/20 rule -- cover what's most needed and used by PL/SQL professionals and avoid what's not necessary! The result is a book that covers all the key features of PL/SQL without wasting your time discussing esoteric and obsolete parts of the language. Learn what really matters, so that you can get to work feeling confident with what you know about PL/SQL.Discover the 20% of PL/SQL that gives you 80% of the bang--key topics covered include variables and datatypes, executing statements, working with cursors, real-world objects, debugging, testing, and more.Learn how to write production-level, object-oriented PL/SQL--you'll explore relational PL/SQL, but unlike most other books on the subject, Don Bales emphasizes the use of PL/SQL's object-oriented features as well.Work through real examples of using of PL/SQL--you'll learn PL/SQL by applying it to real-world business problems, not by heavy theory.What you'll learnHow important SQL is in PL/SQLHow to use PL/SQL in both a relational and object-relational settingHow to create maintainable, modular, and reusable PL/SQL program unitsThe importance of testing as you go, and of building a permanent test plan for each moduleThe importance of building debugging capabilities into your code and building a permanent debug facility for each moduleThe importance of documenting as you go, and in the process building a permanent documentation set for your reusable modulesHow to apply modular PL/SQL to solve real-world problemsWho is this book for?Anyone who wants to learn how to create stored procedures against an Oracle database using PL/SQL. Programmers developing applications to be deployed against an Oracle database will need PL/SQL to take full advantage of the power Oracle has to offer. Database administrators who wish to implement functionality exposed only via PL/SQL package interfaces will also find this book useful.

http://depositfiles.com/files/2175989

http://rapidshare.com/files/65486766/Beginning_PLSQL_From_Novice_to_Professional_with_SOURCE_CODE-1590598822.rar

Oracle9i PL/SQL A Developers Guide

Oracle9i PL/SQL: A Developer's Guide is intended for both intermediate-level Oracle developers who are designing or coding applications in SQL and PL/SQL and for advanced PL/SQL programmers who need to learn new PL/SQL 9ifeatures. In addition to providing developers with detailed coverage of the PL/SQL 9i language itself, author Bulusu Lakshman covers the techniques of using PL/SQL 9i for server-side applications and provides the methodology for implementing robust applications. Lakshman also mentors developers in implementing effective techniques for real-world and code-centric Oracle applications that, in the long run, will save them time and energy. Oracle9i PL/SQL: A Developer's Guide is a solid source for the development of Oracle9i PL/SQL applications. Developers incorporating these technologies into new applications and those migrating from earlier versions will both find Lakshman's expert treatment of the topic beneficial.

http://rapidshare.de/files/17398029/ebook0023.rar

Pass: danci