Product Description
An authoritative guide to designing effective solutions for data cleansing, ETL, and file management with SQL Server 2008 Integration Services

SQL Server Integration Services (SSIS) is the leading tool in the data warehouse industry, used for performing extraction, transformation, and load operations.

After an overview of SSIS architecture, the authors walk you a series of real-world problems and show various techniques for handling them.

* Shows you how to design SSIS solutions for data cleansing, ETL and file management
* Demonstrates how to integrate data from a variety of data sources,
* Shows how to monitor SSIS performance,
* Demonstrates how to avoid common pitfalls involved with SSIS deployment
* Explains how to ensure performance of the deployed solution and effectively handle unexpected system failures and outages
* The companion Web site provides sample code and database scripts that readers can directly implement
Continue Reading »

Product Description
As one of the most popular programming languages in the world, Visual Basic continues to expand on the functionality and flexibility of its framework. This book explains how to use Visual Basic 2005 to write efficient database applications that can be used throughout an enterprise.

With this teaching tool, you’ll learn how to use queries, views, and stored procedures to efficiently access and manipulate data from your applications. You’ll get a firm grasp on using ADO.NET as well as OleDb, SQL, and Oracle to access specific databases. Plus, hands-on examples and try-it-out exercises help you put your reading into practice so that with each chapter, you’ll gradually build the pieces of a single application.

What you will learn from this book
* How ADO.NET continues to evolve as a building block for accessing and manipulating data in relational databases
* Ways to encrypt and decrypt data, hash passwords, and further secure access to your data
* Techniques for accessing your Web Service from both Windows(r) and Web applications
* Best practices for using business logic and data access components to produce report data or update data in your back-end databases
Continue Reading »

Product Description
SQL works with databases to insert and extract data and is an international standard for manipulating data in databases. This hands-on resource covers everything from a review of SQL basics and database design to creating your own databases and using the SQL language in a variety of database applications.

Packed with essential code, theories, concepts, and techniques, as well as a cache of useful examples, this comprehensive text will have you quickly designing your own databases and writing SQL code sufficient for many real-world situations. Practice exercises in each chapter help speed up your comprehension. By the end of the book, you’ll be prepared to handle any surprise that SQL might throw your way.

What you will learn from this book
* How to get the answers you want from a database
* Procedures for using and manipulating data with SQL’s built-in functions
* Ways to retrieve data from numerous and diverse tables
* How to create various levels of security in a database so you can edit data or change the database’s structure
* Theories and practical applications of normalization
* Advanced database design
Continue Reading »

Product Description
Beginning MySQL

As the most popular open source database system in the world, MySQL boasts ease of implementation, minimal overhead, consistent reliability, and low total cost of ownership. This hands-on resource offers you a complete look at MySQL and explains how to implement MySQL and access MySQL with various programming languages.

Using a task-oriented approach along with numerous helpful examples, this book takes you through the steps necessary to install MySQL 4.1 on Linux and Windows platforms, create and manage MySQL databases, query and manipulate data, and administer the MySQL database management system. By the end of the book you’ll have a solid foundation for understanding MySQL as a robust, flexible, and easy-to-implement application that has many diverse uses.

What you will learn from this book
* Where to find MySQL components on your system and what tools are available to access and manipulate data
* How to set up logging, manage security, optimize performance, and back up and restore your system
* Ways to insert, update, copy, import, export, and delete data
* How to access a MySQL database from within a specific programming language
* Effective methods for establishing a connection to a database and issuing SQL statements
Continue Reading »

Product Description
SQL functions are special commands for manipulating data. The international SQL standard defines many functions implemented by all major RDBMS vendors. This comprehensive SQL functions reference enables you to quickly master SQL function data manipulation in any database.

First, the book presents the basics you need to use standard SQL functions with any database. Then the expert authors take you into the core reference material for built-in and user-defined SQL functions in each major RDBMS product. Packed with examples, you’ll immediately learn to apply standard functions and extend your power with functions you define.

You’ll learn all of this from a core author team from Perpetual Technologies, Inc. These experts have extensive experience with Oracle®, SQL Server, Sybase, DB2®, and MySQL®, database design and management for some of the world’s largest corporations and government agencies.

What you will learn from this book
* How to cross-reference different SQL implementations and integrate data from different vendor products
* Ways to create custom functions using vendors’ procedural extensions
* Numerous SQL implementations, such as ANSI SQL, Oracle®, Microsoft® SQL Server®, Sybase, MySQL®, IBM®DB2®, and PostgreSQL Continue Reading »