SQL eBooks
PostgreSQL, 2nd Edition
The 2nd edition of the best-selling PostgreSQL has been updated to completely cover new features and capabilities of the 8.0 version of PostgreSQL. You will be lead through the internals of the powerful PostgreSQL open source database chapter, offering an easy-to-read, code-based approach that makes it easy to understand how each feature is implemented, how to best use each feature, and how to get more performance from database applications. This definitive guide to building, programming and administering the powerful PostgreSQL open-source database system will help you harness one of the most widely used open source, enterprise-level database systems. ...
The 2nd edition of the best-selling PostgreSQL has been updated to completely cover new features and capabilities of the 8.0 version of PostgreSQL. You will be lead through the internals of the powerful PostgreSQL open source database chapter, offering an easy-to-read, code-based approach that makes it easy to understand how each feature is implemented, how to best use each feature, and how to get more performance from database applications. This definitive guide to building, programming and administering the powerful PostgreSQL open-source database system will help you harness one of the most widely used open source, enterprise-level database systems. ...
PHP5 and MySQL Bible
This comprehensive tutorial and reference covers all the basics of PHP 5, a popular open source Web scripting language, and MySQL 4.012, the most popular open source database engine. Explores why users need PHP and MySQL how to get started, how to add PHP to HTML, and how to connect HTML Web pages to MySQL. Offers an extensive tutorial for developing applications with PHP and MySQL. Includes coverage of how to install, administer, and design MySQL databases independently of PHP; exception and error handling; debugging techniques; PostgreSQL database system; and PEAR database functions. The authors provide unique case studies of how and where to use PHP drawn from their own extensive Web experience. ...
This comprehensive tutorial and reference covers all the basics of PHP 5, a popular open source Web scripting language, and MySQL 4.012, the most popular open source database engine. Explores why users need PHP and MySQL how to get started, how to add PHP to HTML, and how to connect HTML Web pages to MySQL. Offers an extensive tutorial for developing applications with PHP and MySQL. Includes coverage of how to install, administer, and design MySQL databases independently of PHP; exception and error handling; debugging techniques; PostgreSQL database system; and PEAR database functions. The authors provide unique case studies of how and where to use PHP drawn from their own extensive Web experience. ...
Professional SQL Server Reporting Services
SQL Server Reporting Services is the customizable reporting solution for report designers and programmers. This hands-on guide will get you up to speed quickly. You can create powerful reports without programming knowledge and extend reporting solutions using VB, C#, and ASP.NET. Packed with detailed examples of building reports, designing report solutions, and developing deployment strategies for interacting with various platforms, this book prepares you to take full advantage of a revolutionary new tool. ...
SQL Server Reporting Services is the customizable reporting solution for report designers and programmers. This hands-on guide will get you up to speed quickly. You can create powerful reports without programming knowledge and extend reporting solutions using VB, C#, and ASP.NET. Packed with detailed examples of building reports, designing report solutions, and developing deployment strategies for interacting with various platforms, this book prepares you to take full advantage of a revolutionary new tool. ...
MySQL Enterprise Solutions
With more than three million users, MySQL is the most popular open-source database server in the world, providing an extremely fast, reliable, and inexpensive alternative to commercial database management systems. Gives corporate users a complete guide to building enterprise-level database applications with MySQL. Covers the pros and cons of adopting MySQL and installing, testing, and configuring the MySQL server. Companion Web site includes all code examples as well as links to useful online resources. ...
With more than three million users, MySQL is the most popular open-source database server in the world, providing an extremely fast, reliable, and inexpensive alternative to commercial database management systems. Gives corporate users a complete guide to building enterprise-level database applications with MySQL. Covers the pros and cons of adopting MySQL and installing, testing, and configuring the MySQL server. Companion Web site includes all code examples as well as links to useful online resources. ...
Oracle SQL Tuning Pocket Reference
One of the most important challenges faced by Oracle database administrators and Oracle developers is the need to tune SQL statements so that they execute efficiently. In this book, Mark Gurry shares his in-depth knowledge of Oracle's SQL statement optimizers. Mark provides solutions to many common problems that occur with both the rule-based and cost-based optimizers. Mark provides a number of handy SQL tuning tips, discusses the use of the DBMS_STATS package to manage database statistics, and shows you how to use outlines to specify execution plans for SQL statements in third-party applications that you can't otherwise modify. ...
One of the most important challenges faced by Oracle database administrators and Oracle developers is the need to tune SQL statements so that they execute efficiently. In this book, Mark Gurry shares his in-depth knowledge of Oracle's SQL statement optimizers. Mark provides solutions to many common problems that occur with both the rule-based and cost-based optimizers. Mark provides a number of handy SQL tuning tips, discusses the use of the DBMS_STATS package to manage database statistics, and shows you how to use outlines to specify execution plans for SQL statements in third-party applications that you can't otherwise modify. ...
Learning Oracle PL/SQL
PL/SQL Oracle's programming language for stored procedures, delivers a world of possibilities for your database programs. PL/SQL supplements the standard relational database language, SQL with a wide range of procedural features, including loops, IF-THEN statements, advanced data structures, and rich transactional control - all closely integrated with the Oracle database server. Knowing where to start with Oracle's procedural language is not always obvious to a newcomer, especially considering the language's feature set and the sheer size of the official documentation (not to mention Oracle's ever-increasing number of pre-built PL/SQL programs). But Learning Oracle PL/SQL offers the signposts and guidance you need to come up to speed on the language, delivered in a manageable number of pages while covering all the essentials. ...
PL/SQL Oracle's programming language for stored procedures, delivers a world of possibilities for your database programs. PL/SQL supplements the standard relational database language, SQL with a wide range of procedural features, including loops, IF-THEN statements, advanced data structures, and rich transactional control - all closely integrated with the Oracle database server. Knowing where to start with Oracle's procedural language is not always obvious to a newcomer, especially considering the language's feature set and the sheer size of the official documentation (not to mention Oracle's ever-increasing number of pre-built PL/SQL programs). But Learning Oracle PL/SQL offers the signposts and guidance you need to come up to speed on the language, delivered in a manageable number of pages while covering all the essentials. ...
PostgreSQL: Introduction and Concepts
The most advanced, feature-rich SQL database server available, the open-source PostgreSQL system has rapidly become a key Internet technology. PostgreSQL: Introduction and Concepts, written by a founding member of the PostgreSQL Global Development Team, provides a much-needed tutorial and real-world guide to understanding and working with this complex yet essential system. ...
The most advanced, feature-rich SQL database server available, the open-source PostgreSQL system has rapidly become a key Internet technology. PostgreSQL: Introduction and Concepts, written by a founding member of the PostgreSQL Global Development Team, provides a much-needed tutorial and real-world guide to understanding and working with this complex yet essential system. ...
Professional Oracle 8i Application Programming with Java, PL/SQL and XML
This book is for professional Oracle database programmers who need a comprehensive roadmap of the new programming possibilities with Oracle 8i. On the other hand, if you are already developing with Java and XML this book will show you how to exploit PL/SQL and the enterprise features of Oracle 8i in optimally distributing your n-tier applications. Knowledge of the essentials of PL/SQL programming is required, and familiarity with Java would be useful. What does this book cover? The Oracle 8i platform and architecture, covering Net8 and the Oracle JVM; PL/SQL development using the Web Toolkit, PSP and Designer 6i; Java application development, including a Java primer; Oracle 8i and Java Stored Procedures, EJB, BC4J, JDBC, SQLJ; XML development with an XML primer; Oracle XDK, XSQL XSLT, Transviewer JavaBeans; Case studies using Designer 6i, interMedia, Portal-to-Go, ASP and SOAP. ...
This book is for professional Oracle database programmers who need a comprehensive roadmap of the new programming possibilities with Oracle 8i. On the other hand, if you are already developing with Java and XML this book will show you how to exploit PL/SQL and the enterprise features of Oracle 8i in optimally distributing your n-tier applications. Knowledge of the essentials of PL/SQL programming is required, and familiarity with Java would be useful. What does this book cover? The Oracle 8i platform and architecture, covering Net8 and the Oracle JVM; PL/SQL development using the Web Toolkit, PSP and Designer 6i; Java application development, including a Java primer; Oracle 8i and Java Stored Procedures, EJB, BC4J, JDBC, SQLJ; XML development with an XML primer; Oracle XDK, XSQL XSLT, Transviewer JavaBeans; Case studies using Designer 6i, interMedia, Portal-to-Go, ASP and SOAP. ...