The union of XML and relational databases creates a powerful tool with the ability to transfer information between two completely unrelated databases. With this book, veteran author Gavin Powell shows you how this confluence of two technologies can simplify your database work and provide a more standardized way to exchange data between multiple databases and web sites.

You’ll get an in-depth look at specific XML datatypes that are considered the most critical alliances between XML and a relational database. Plus, an introduction to the basics of SQL and numerous XML standards prove to be essential so that you can grasp database structure and comprehend how XML is used with the Oracle® and SQL Server relational databases. Throughout the book, valuable exercises and a surfeit of step-by-step examples will help you get an overall understanding of the topics at hand.

What you will learn from this book


* The platform independence capability that comes from using XML— including independence from database vendors
* The basics of XML, XSL, the XML DOM, and SQL
* XML datatypes and features in Oracle Database and SQL Server
* How to move data anywhere using XML (B2B)
* Ways to read XML documents using XQuery and navigate documents using XPath®
* XML, the object data model, native XML databases, and industry applications of XML


Download

Pro T-SQL 2005 Programmer’s Guide provides comprehensive and detailed coverage of all the major features and facilities of T-SQL for SQL Server 2005. It is designed for all users of T-SQL, database administrators, systems administrators, application developers, and end-users, who want to learn how to exploit the power of T-SQL. Whatever you need to do with T-SQL, you’ll find it described clearly here.

Stored procedures, triggers, and user-defined functions are only part of the story. Dynamic SQL, the new XML data type, and SQLCLR programming are also covered, as well as accessing SQL Server with ADO.NET. Exception handling and performance are fully covered, too. This book is truly a complete programmer’s guide to T-SQL and SQL Server 2005.

Download

Ajax has the power to revolutionize the way web-based applications are designed. This book provides you with a thorough working knowledge of what Ajax has to offer and how to take full advantage of it in your application development.

Following an exploration of how Ajax works with .NET, you’ll get acquainted with DHTML, the role of JavaScript and the Document Object Model, and the XMLHttpRequest Object, which is the foundation of Ajax. Then you will examine the Ajax-type features built into ASP.NET and explore the Ajax.NET Professional Library in detail. Finally, you will explore client scripting as well as building and using controls with Microsoft’s Atlas. With an entire chapter devoted to debugging, you will have all you need to use this cutting-edge technology.

Download

*Aimed at both working programmers who are applying for a job where puzzles are an integral part of the interview, as well as techies who just love a good puzzle, this book offers a cache of exciting puzzles

* Features a new series of puzzles, never before published, called elimination puzzles that have a pedagogical aim of helping the reader solve an entire class of Sudoku-like puzzles

* Provides the tools to solve the puzzles by hand and computer

* The first part of each chapter presents a puzzle; the second part shows readers how to solve several classes of puzzles algorithmically; the third part asks the reader to solve a mystery involving codes, puzzles, and geography

* Comes with a unique bonus: if readers actually solve the mystery, they have a chance to win a prize, which will be promoted on wrox.com!

Download