Web for Web Developer

Building Oracle XML Applications
O’Reilly Media | ISBN: 1565926919 | 789 pages | October 2, 2000 | PDF

Oracle Corporation, committed to supporting XML in a wide range of products, has XML-enabled its entire Oracle Internet platform–the Oracle8″i database, Oracle interMedia, Oracle Application Server, and a variety of other products.

“Building Oracle XML Applications, by Steve Muench, Oracle’s lead “XML evangelist” and a key Oracle XML developer, gives Java and PL/SQL developers a rich and detailed look at the many tools Oracle has provided to support XML development, such as the Oracle XML Parser, the Oracle XML SQL Utility, and the XSQL Servlet.

The company describes Oracle8″i as “the first XML enabled database.” This book shows how to combine the power of XML and XSLT with the speed, functionality, and reliability of the Oracle database to build flexible applications. The author delivers nearly 800 pages of entertaining text, helpful and time-saving hints, and extensive examples that developers can put to use immediately to build custom XML applications.

Products covered include:
XSQL pages and the XSQL servlet: declarative templates and an extensive framework to assemble any kind of static or dynamic XML information and transform it for delivery using XSLT stylesheets.JDeveloper: a complete integrated development environment for Java XML developers, including editing, syntax checking, debugging, and more. XSLT Processor: a product that enables XML information to be presented and delivered in many different ways, using any web-based format, both inside and outside the database. XML SQL utility: an Oracle utility that works with the results of SQL statements as XML documents and uses XML documents to insert, update, and delete information from database tables, views, andobject views.XML Parser: a product that lets Java, PL/SQL, C, and C++ developers process and construct XML.interMedia: a product whose Text option lets developers search XML documents from SQL and leverage the XML document structure for razor-sharp search precision.Advanced Queuing: an Oracle queuing mechanism that lets both PL/SQL and Java programs enqueue and and dequeue XML messages. PLSXML utilities: Oracle PL/SQL utilities that let developers using any version of Oracle produce XML from SQL statements.
Read More »

Expert Oracle Database Architecture: 9i and 10g Programming Techniques and Solutions by Thomas Kyte
Publisher: Apress; Bk&CD-Rom edition (September 15, 2005) | ISBN-10: 1590595300 | PDF | 4,8 Mb | 768 pages

This is a defining book on the Oracle database for any developer or DBA who works with Oracle-driven database applications. Tom has a simple philosophy: you can treat Oracle as a black box and just stick data into it or you can understand how it works and exploit it as a powerful computing environment. If you choose the latter, then you will find that there are few information management problems that you cannot solve quickly and elegantly.

Expert Oracle Database Architecture is the first of a three-book series that completely explores and defines the Oracle database. It covers all of the most important Oracle architecture features, including:

— Files, memory structures and processes — Locking and latching — Transactions, concurrency and multi-versioning — Tables and Indexes — Datatypes — Partitioning and parallelism
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.

This fully revised edition covers both the 9i and 10g versions. It also comes with a CD containing a searchable PDF of the 8i version of the book.

Tom has fully revised and expanded the architecture-related sections from Expert One-on-One Oracle (a searchable PDF of which is included on the CD accompanying this book), and added substantial new material. He focuses solely on 9i and 10g architecture in this book and refers to the CD for 8i-specific details. The number of changes will surprise you.

In summary, this book provides a one-stop resource containing deep wisdom on the design, development and administration of Oracle applications, written by one of the world’s foremost Oracle experts, Thomas Kyte.
Read More »

MySQL Stored Procedure Programming by Guy Harrison, Steven Feuerstein
Publisher: O’Reilly Media (March 28, 2006) | ISBN-10: 0596100892 | CHM | 4,1 Mb | 609 pages

The implementation of stored procedures in MySQL 5.0 a huge milestone — one that is expected to lead to widespread enterprise adoption of the already extremely popular MySQL database. If you are serious about building the web-based database applications of the future, you need to get up to speed quickly on how stored procedures work — and how to build them the right way. This book, destined to be the bible of stored procedure development, is a resource that no real MySQL programmer can afford to do without.

In the decade since MySQL burst on the scene, it has become the dominant open source database, with capabilities and performance rivaling those of commercial RDBMS offerings like Oracle and SQL Server. Along with Linux and PHP, MySQL is at the heart of millions of applications. And now, with support for stored procedures, functions, and triggers in MySQL 5.0, MySQL offers the programming power needed for true enterprise use.

MySQL’s new procedural language has a straightforward syntax, making it easy to write simple programs. But it’s not so easy to write secure, easily maintained, high-performance, and bug-free programs. Few in the MySQL world have substantial experience yet with stored procedures, but Guy Harrison and Steven Feuerstein have decades of combined expertise.
In MySQL Stored Procedure Programming, they put that hard-won experience to good use. Packed with code examples and covering everything from language basics to application building to advanced tuning and best practices, this highly readable book is the one-stop guide to MySQL development. It consists of four major sections:

— MySQL stored programming fundamentals — tutorial, basic statements, SQL in stored programs, and error handling — Building MySQL stored programs — transaction handling, built-in functions, stored functions, and triggers — MySQL stored programs in applications — using stored programs with PHP, Java, Perl, Python, and .NET (C# and VB.NET) — Optimizing MySQL stored programs — security, basic and advanced SQL tuning, optimizing stored program code, and programming best practices
A companion web site contains many thousands of lines of code, that you can put to use immediately.

Guy Harrison is Chief Architect of Database Solutions at Quest Software and a frequent speaker and writer on MySQL topics. Steven Feuerstein is the author of Oracle PL/SQL Programming, the classic reference for Oracle stored programming for more than ten years. Both have decades of experience as database developers, and between them they have authored a dozen books.
Read More »

MySQL 5.0 Certification Study Guide (MySQL Press) by Paul DuBois, Stefan Hinz, Carsten Pedersen
Publisher: MySQL Press; Bk&CD-Rom edition (August 24, 2005) | ISBN-10: 0672328127 | CHM | 1,6 Mb | 672 pages

This is the official guide to passing the two MySQL certification tests for MySQL 5, the long-awaited major revision of MySQL. It includes a voucher for 25 percent off either exam-a $50 value! The number of MySQL certification exams taken has doubled in the last six months. Certcities.com lists the MySQL certification as one of the top 10 certifications to grow in 2005. MySQL professionals need a way to distinguish themselves from the vast majority of database administrators and developers. With more than 4 million active installations, MySQL is the world’s most popular open-source database. Known for its speed, reliability and case of use, MySQL has become a low-cost alternative to expensive database systems such as Oracle, IBM and Microsoft. MySQL AB has aggressively improved the feature set of MySQL with MySQL 5, making it more suitable for enterprise-level applications and uses. The MySQL certification tests, available at over 3,000 PearsonVUE testing centers, is a key component of this enterprise growth strategy, establishing a base level of skills for database users, administrators and programmers.

The MySQL Core Certification is aimed at the database user who wants proof of his or her abilities in such fundamental areas as SQL, data entry and maintenance, and data extraction. The MySQL Professional Certification test is designed for the advanced user who wants to prove his or her knowledge in such areas as database management, installation, security, disaster prevention and optimization. Both tests are thoroughly covered in the MySQL 5.0 Certification Study Guide. Written by Paul DuBois, the leading author of books on MySQL topics, and reviewed for technical accuracy by MySQL AB, this book is the fastest, most reliable way for MySQL users, developers, and administrators to prepare for either of the MySQL tests.

Read More »

Product Details

* Paperback: 926 pages
* Publisher: McGraw-Hill Osborne Media; 1 edition (September 12, 2005)
* Language: English
* ISBN: 0072257903
* Product Dimensions: 9.4 x 7.4 x 1.9 inches
* Shipping Weight: 3.53 pounds (View shipping rates and policies)
* Average Customer Review:

based on 3 reviews. (Write a review.)
* Amazon.com Sales Rank: #15,305 in Books (See Top Sellers in Books) Books)
*
(Publishers and authors: improve your sales)
Would you like to update product info or give feedback on images ? (We’ll ask you to sign in so we can get back to you)

Editorial Reviews
Book Description
Four for the price of one! Oracle Database 10g OCP Certification All-in-One Exam Guide is the only book that offers thorough exam prep and a great on-the-job reference for both the latest OCA and OCP exams.

Also includes the Boson’s Oracle self-assessment engine to get experience taking the test in the environment it will be given

From the Back Cover

The Most Authoritative OCA/OCP Exam Guide Available

Prepare to pass the OCA and OCP Oracle Database 10g certification exams with help from this Oracle Press guide. With complete coverage of all the material on Exam #1Z0-042 Oracle Database 10g: Administration I and Exam #1Z0-043 Oracle Database 10g: Administration II, this book covers everything you need to know to pass both exams. Inside, you’ll find helpful exam tips, hundreds of practice questions, and real-world exercises. This comprehensive guide serves as both a study tool and an on-the-job reference. Get full details on all exam objectives, including how to:
Read More »

Publisher: IBM Press
Language: English
ISBN: 0130463884
Paperback: 800 pages
Data: July 7, 2003
Format: CHM
Description: * Definitive preparation for Exam 704: DB2 UDB V8.1 Advanced Database Administration for Linux, UNIX, and Windows, which leads to an IBM Certified Advanced Database Administrator certification.
* Database design, performance monitoring and tuning, scaling for terabytes of data, high availability, enterprise-level security, and more.
* The appendices contain sample certification exam questions and answers.

Whether you’re a long-time DB2 UDB professional or an experienced DBA who’s migrated from another database platform, there’s one sure way to demonstrate the highest level of skills in DB2 Universal Database administration: pass the challenging IBM DB2 Universal Database Advanced Database Administration Exam 704.

Now, there’s a definitive guide to advanced DB2 UDB database administration that also delivers all the depth and insight you need to prepare for the tough new IBM exam. Straight from the DB2 experts at IBM, this book offers systematic and authoritative coverage of every exam objective and will serve as a reference after you have passed the test.

For the first time, this book brings together IBM best practices, techniques, tips, guidelines, and rules of thumb for virtually every aspect of advanced DB2 UDB v8 database administration-including all this and more:
* Ability to design, create, and manage table spaces
* Ability to design, create, and manage buffer pools
* When and how to exploit parallelism in DB2 UDB
* Configuring federated database access
* Designing and implementing a backup and recovery strategy
* Ability to implement a standby database
* Monitoring and tuning DB2
* Using and managing tables with multidimensional clustering
* Designing and configuring multiple database partitions
* Implementing authentication and encryption on a large scale
* Leveraging parallelism and symmetric multiprocessing
* Preparing for and executing recovery in an enterprise environment
* Rapid recovery in the event of table space or table level disasters
* Effective monitoring and problem determination
* Maximizing performance and scalability
Read More »

Beginning Relational Data Modeling, Second Edition by Sharon Allen, Evan Terry
Publisher: Apress; 2 edition (March 24, 2005) | ISBN-10: 1590594630 | CHM | 22,9 Mb | 632 pages

Data storage design, and awareness of how data needs to be utilized within an organization, is of prime importance in ensuring that company data systems work efficiently. Beginning Relational Data Modeling will lead you step by step through the process of developing an effective logical data model for your relational database model. No previous data modeling experience is required. If you need to know how to capture the information needs of a business system in a relational database model, but dont know where to start, then this is the book for you.
Read More »

Databases are the nerve center of our economy. Every piece of your personal information is stored there—medical records, bank accounts, employment history, pensions, car registrations, even your children’s grades and what groceries you buy. Database attacks are potentially crippling—and relentless.

In this essential follow-up to The Shellcoder’s Handbook, four of the world’s top security experts teach you to break into and defend the seven most popular database servers. You’ll learn how to identify vulnerabilities, how attacks are carried out, and how to stop the carnage. The bad guys already know all this. You need to know it too.

- Identify and plug the new holes in Oracle and Microsoft SQL Server
- Learn the best defenses for IBM’s DB2, PostgreSQL, Sybase ASE, and MySQL servers
- Discover how buffer overflow exploitation, privilege escalation through SQL, stored procedure or trigger abuse, and SQL injection enable hacker access
- Recognize vulnerabilities peculiar to each database
- Find out what the attackers already know

Read More »

Microsoft.Press.Microsoft.SQL.Server.2005.Applied.Techniques Step.by.Step.Jun.2006.eBook-BBL
Title: Microsoft SQL Server™ 2005: Applied Techniques Step by Step (Pro - Step By Step Developer)
Author: Solid Quality Learning
Publisher: Microsoft Press
Edition: Bk&CD-Rom edition (June 21, 2006)
ISBN: 0735623163
Format: CHM
SQl Server 2005 is Microsofts next-generation data management and analysis solution that delivers increased security, scalability, and availability to enterprise data and analytical applications while making them easier to create, deploy, and manage. This is a skill-building, learn-by-doing tutorial to help developers and database administrators with basic product knowledge begin to master SQL Server 2005.
Read More »

Robert Sheldon’s MySQL programming is rooted in ten years of experience working with SQL, as it is implemented not only in a MySQL environment, but also within SQL Server, Microsoft Access, and Oracle environments. He has programmed with SQL directly through database interfaces and script files and indirectly through PHP, JSP, ASP, and ASP.NET applications that connected to various databases and issued SQL statements.

Robert has also managed the maintenance and development of Web sites and online tools, which has included performing project analysis, developing functional specifications, and managing database and Web development. He has designed and implemented various Microsoft Access, SQL Server, and MySQL databases, as well as developed and implemented a variety of Web-based solutions.

In all these roles, he has had to perform numerous types of ad hoc queries and modifications, build databases, create and modify database objects, create and review embedded statements, and troubleshoot system- and data-related problems.
Read More »