In this compact book, Steven Feuerstein, widely recognized as one of the world's leading experts on the Oracle PL/SQL language, distills his many years of programming, teaching, and writing about PL/SQL into a set of best practices-recommendations for developing successful applications.
Whether you're running Access, MySQL, SQL Server, Oracle, or PostgreSQL, this book will help you push the limits of traditional SQL to squeeze data effectively from your database.
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.
A poorly performing database application not only costs users time, but also has an impact on other applications running on the same computer or the same network.
When you need to find the right SQL keyword or MySQL client command-line option right away, turn to this convenient reference, known for the same speed and flexibility as the system it covers so thoroughly.
In this compact book, Steven Feuerstein, widely recognized as one of the world's leading experts on the Oracle PL/SQL language, distills his many years of programming, teaching, and writing about PL/SQL into a set of best practices-recommendations for developing successful applications.
Whether you're running Access, MySQL, SQL Server, Oracle, or PostgreSQL, this book will help you push the limits of traditional SQL to squeeze data effectively from your database.
For all the buzz about trendy IT techniques, data processing is still at the core of our systems, especially now that enterprises all over the world are confronted with exploding volumes of data.
A poorly performing database application not only costs users time, but also has an impact on other applications running on the same computer or the same network.
Understand how to use the new features of Microsoft SQL Server 2008 for data mining by using the tools in Data Mining with Microsoft SQL Server 2008, which will show you how to use the SQL Server Data Mining Toolset with Office 2007 to mine and analyze data.
The Best Fully Integrated Study System Available With hundreds of practice questions and hands-on exercises, MCTS SQL Server 2005 Implementation & Maintenance Study Guide covers what you need to know--and shows you how to prepare--for this challenging exam.
Master the Powerful Virtualization Tools in Oracle VMSet up and maintain a dynamic virtualization platform across your enterprise using the detailed information contained in this Oracle Press guide.
Previous McGraw-Hill SQL Server 2005 titles have sold more than 40,000 copiesHigh availability is an important new focus for SQL Server 2005--IT professionals must be skilled in maximizing system uptime
The Definitive Guide to Microsoft SQL Server 2008 Reporting ServicesCreate and deliver data-rich reports across the enterprise using this complete server-based reporting solution.
Transform disparate enterprise data into actionable business intelligencePut timely, mission-critical information in the hands of employees across your organization using Microsoft SQL Server 2005 and the comprehensive information in this unique resource.
Managing Data in Motion describes techniques that have been developed for significantly reducing the complexity of managing system interfaces and enabling scalable architectures.
Between the high-level concepts of business intelligence and the nitty-gritty instructions for using vendors' tools lies the essential, yet poorly-understood layer of architecture, design and process.
Data Architecture: From Zen to Reality explains the principles underlying data architecture, how data evolves with organizations, and the challenges organizations face in structuring and managing their data.
Time and Relational Theory provides an in-depth description of temporal database systems, which provide special facilities for storing, querying, and updating historical and future data.
Managing Time in Relational Databases: How to Design, Update and Query Temporal Data introduces basic concepts that will enable businesses to develop their own framework for managing temporal data.
Topological UML Modeling: An Improved Approach for Domain Modeling and Software Development presents a specification for Topological UML(R) that combines the formalism of the Topological Functioning Model (TFM) mathematical topology with a specified software analysis and design method.
CMDB Systems: Making Change Work in the Age of Cloud and Agile shows you how an integrated database across all areas of an organization's information system can help make organizations more efficient reduce challenges during change management and reduce total cost of ownership (TCO).
Multi-Domain Master Data Management delivers practical guidance and specific instruction to help guide planners and practitioners through the challenges of a multi-domain master data management (MDM) implementation.
SQL for Smarties was hailed as the first book devoted explicitly to the advanced techniques needed to transform an experienced SQL programmer into an expert.
Time and Relational Theory provides an in-depth description of temporal database systems, which provide special facilities for storing, querying, and updating historical and future data.
Entity Information Life Cycle for Big Data walks you through the ins and outs of managing entity information so you can successfully achieve master data management (MDM) in the era of big data.