Free Trial

Safari Books Online is a digital library providing on-demand subscription access to thousands of learning resources.

Help

Databases


1221. 

Microsoft® SQL Server® 2008 T-SQL Fundamentals

Microsoft® SQL Server® 2008 T-SQL Fundamentals

By: 

Publisher: Microsoft Press

Publication Date: 22-OCT-2008

Insert Date: 20-JAN-2009

Slots: 1.0

Table of Contents • Start Reading

This essential reference is designed for database developers and administrators who need to write queries and develop code using Transact-SQL (T-SQL), the Microsoft implementation of the standard SQL language. Guided by SQL Server guru Itzik Ben-Gan, you'll walk through the steps for writing queries, including retrieving and modifying data, with an overview of programmable objects supported by SQL Server 2008. Rather than focusing just on the syntactical elements of T-SQL, however, this book explains the logic behind the language - helping you develop a true, core understanding of...

1222. 

Oracle Database 11g New Features

Oracle Database 11g New Features

By: 

Publisher: Oracle Press

Publication Date: 05-NOV-2007

Insert Date: 14-JAN-2009

Slots: 1.0

Table of Contents • Start Reading

Realize the full potential of Oracle Database 11g with help from the experts. Written by Robert G. Freeman, and with insightful commentary throughout from Arup Nanda, this Oracle Press guide offers full details on the architectural changes, database administration upgrades, availability and recovery revisions, security enhancements, and programming innovations. Every new and updated feature is covered and presented with screenshots, code samples, tables, and charts. Find out how to take full advantage of all the new and improved capabilities of Oracle Database 11g, including: New...

1223. 

Oracle Database 11g PL/SQL Programming: Develop Robust, Database-Driven PL/SQL Applications

Oracle Database 11g PL/SQL Programming: Develop Robust, Database-Driven PL/SQL Applications

By: 

Publisher: Oracle Press

Publication Date: 21-MAR-2008

Insert Date: 14-JAN-2009

Slots: 1.0

Table of Contents • Start Reading

Deliver dynamic, client/server PL/SQL applications with expert guidance from an Oracle programming professional. With full coverage of the latest features and tools, Oracle Database 11g PL/SQL Programming lays out each topic alongside detailed explanations, cut-and-paste syntax examples, and real-world case studies. Access and modify database information, construct powerful PL/SQL statements, execute effective queries, and deploy bulletproof security. You'll also learn how to implement C, C++, and Java procedures, Web-enable your database, cut development time, and optimize...

1224. 

Oracle Database 11g DBA Handbook: Administer a Scalable, Secure Oracle Enterprise Database

Oracle Database 11g DBA Handbook: Administer a Scalable, Secure Oracle Enterprise Database

By: 

Publisher: Oracle Press

Publication Date: 06-DEC-2007

Insert Date: 13-JAN-2009

Slots: 1.0

Table of Contents • Start Reading

The Essential Resource for Oracle DBAs--Fully Updated and Expanded Manage a flexible, highly available Oracle database with help from the expert information contained in this exclusive Oracle Press guide. Fully revised to cover every new feature and utility, Oracle Database 11g DBA Handbook shows how to perform a new installation, upgrade from previous versions, configure hardware and software for maximum efficiency, and employ bulletproof security. You will learn to automate the backup and recovery process, provide transparent failover capability, audit and tune performance, and...

1225. 

Head First PHP & MySQL

Head First PHP & MySQL

By: ;

Publisher: O'Reilly Media, Inc.

Publication Date: 22-DEC-2008

Insert Date: 12-JAN-2009

Slots: 1.0

Table of Contents • Start Reading

If you're ready to create web pages more complex than those you can build with HTML and CSS, Head First PHP & MySQL is the ultimate learning guide to building dynamic, database-driven websites using PHP and MySQL. Packed with real-world examples, this book teaches you all the essentials of server-side programming, from the fundamentals of PHP and MySQL coding to advanced topics such as form validation, session IDs, cookies, database queries and joins, file I/O operations, content management, and more. Head First PHP & MySQL offers the same visually rich format that's turned every title in...

1226. 

Just Enough Web Programming with XHTML™, PHP®, and MySQL®

Just Enough Web Programming with XHTML™, PHP®, and MySQL®

By: Guy W. Lecky-Thompson

Publisher: Course Technology PTR

Publication Date: 10-APR-2008

Insert Date: 08-JAN-2009

Slots: 1.0

Table of Contents • Start Reading

Just Enough Web Programming with XHTML, PHP, and MySQL provides a layperson's guide to web programming for the casual web designer, student, or serious professional. The book explains how to build powerful interactive sites, whether you're designing a bulletin board, game, or web store. As part of the Just Enough series, the book provides "just enough" information to get you started quickly, without overloading you with unnecessary details. After a brief introduction, the book concisely explains the XML, XHTML, and CSS concepts you need to understand to start creating web sites. From there,...

1227. 

Crystal Reports® XI for Developers

Crystal Reports® XI for Developers

By: David McAmis

Publisher: Course Technology PTR

Publication Date: 21-NOV-2005

Insert Date: 08-JAN-2009

Slots: 1.0

Table of Contents • Start Reading

Crystal Reports XI is a powerful software tool for turning raw data into corporate decision-making information. End-users and developers alike use Crystal Reports to extract and format information, and with over 9 million licenses shipped, Crystal Reports is one of the most popular packages for corporate reporting. This book provides a solid introduction for any report or application developer just getting started. Using this practical guide, they will learn to create presentation-quality reports from a variety of data sources and how to add the advanced features developers need, such as...

1228. 

SQL Server 2005 For Developers

SQL Server 2005 For Developers

By: Robert Ericsson; Jason Cline

Publisher: Course Technology PTR

Publication Date: 30-JUN-2006

Insert Date: 07-JAN-2009

Slots: 1.0

Table of Contents • Start Reading

Capturing and analyzing data about customers, products, and the market is essential to staying competitive. Microsoft SQL Server is a leading database tool, and with its ease of use and low total ownership cost, you can customize it to meet your ever-changing business needs. SQL Server 2005 has many enhanced tools that fall into three main categories: data management, developer tools, and business intelligence. SQL Server 2005 for Developers teaches you how to leverage these new tools by covering the topics relevant to developers. Samples throughout the book illustrate the features of SQL...

1229. 

Creating Content Management Systems in Java

Creating Content Management Systems in Java

By: Arron Ferguson

Publisher: Course Technology PTR

Publication Date: 04-AUG-2006

Insert Date: 07-JAN-2009

Slots: 1.0

Table of Contents • Start Reading

In today's fast-paced, information-packed world, it's critical for businesses to organize and manipulate the data gathered from customers, sales, and product responses, etc. into usable information. Content Management Systems (CMS) can do this for your business easily and efficiently. There are several commercial systems available, but customizing one for your specific needs is usually necessary based on your data. Creating Content Management Systems in Java teaches you how to develop an open source CMS from scratch using XML as the storage mechanism, XSLT as the presentation layer, and Java...

1230. 

Oracle Utilities Pocket Reference

Oracle Utilities Pocket Reference

By: 

Publisher: O'Reilly Media, Inc.

Publication Date: 11-NOV-2004

Insert Date: 19-DEC-2008

Slots: 1.0

Table of Contents • Start Reading

The Oracle Utilities Pocket Reference is a handy, quick-reference guide to the multitude of Oracle utilities that database administrators (DBAs) use every hour of every day. As the undisputed leader among database products, Oracle is grasped conceptually by most DBAs. However, they understandably may not recall the specific utility to use for a given task, and, more commonly, won't in many cases remember the syntax to use. And that's exactly what the Oracle Utilities Pocket Reference supplies--the syntax and options for whatever utility a DBA needs to perform a given task. Some of the...

1231. 

CouchDB: The Definitive Guide

CouchDB: The Definitive Guide

By: ; ;

Publisher: O'Reilly Media, Inc.

Publication Date: 26-JAN-2010

Insert Date: 11-DEC-2008

Slots: 1.0

Table of Contents • Start Reading

This book introduces you to Apache CouchDB, a document-oriented database that offers a different way to model your data. CouchDB is a schema-free database, designed to work with applications that handle document-based information such as contacts, invoices, and receipts. In CouchDB: The Definitive Guide , three of the core developers gently explain how to work with CouchDB, using clear and practical scenarios. Each chapter showcases key features, such as simple document CRUD (create, read, updated, delete), advanced MapReduce, and deployment tuning for...

1232. 

DB2 9 for Linux, UNIX, and Windows Advanced Database Administration Certification Study Guide

DB2 9 for Linux, UNIX, and Windows Advanced Database Administration Certification Study Guide

By: Roger E. Sanders; Dwaine R Snow

Publisher: MC Press

Publication Date: 03-NOV-2008

Insert Date: 06-DEC-2008

Slots: 1.0

Table of Contents • Start Reading

Database administrators versed in DB2 wanting to learn more about advanced database administration activities and students wishing to gain knowledge to help them pass the DB2 9 UDB Advanced DBA certification exam will find this exhaustive reference invaluable. Written by two individuals who were part of the team that developed the certification exam, this comprehensive study guide prepares the student for challenging questions on database design; data partitioning and clustering; high availability diagnostics; performance and scalability; security and encryption; connectivity and networking;...

1233. 

SQL in a Nutshell, 3rd Edition

SQL in a Nutshell, 3rd Edition

By: 

Publisher: O'Reilly Media, Inc.

Publication Date: 25-NOV-2008

Insert Date: 20-NOV-2008

Slots: 1.0

Table of Contents • Start Reading

For programmers, analysts, and database administrators, SQL in a Nutshell is the essential reference for the SQL language used in today's most popular database products. This new edition clearly documents every SQL command according to the latest ANSI standard, and details how those commands are implemented in Microsoft SQL Server 2008, Oracle 11g, and the MySQL 5.1 and PostgreSQL 8.3 open source database products. You'll also get a concise overview of the Relational Database Management System (RDBMS) model, and a clear-cut explanation of foundational RDBMS concepts -- all packed into a...

1234. 

IBM Enterprise Content Management and System Storage Solutions: Working Together

IBM Enterprise Content Management and System Storage Solutions: Working Together

By: Mary Lovelace; Nicholas Buchanan; Gavin Cameron; Flavio de Rezende; John Tarella

Publisher: IBM Redbooks

Publication Date: 30-SEP-2008

Insert Date: 19-NOV-2008

Slots: 1.0

Table of Contents • Start Reading

An Enterprise Content Management (ECM) system is designed to contain unstructured information such as files, images, and drawings. Its purpose is the delivery of the right content to the right person at the right time, and in the right context. In enterprise content management, the term content is used to refer to unstructured information; structured information such as database content is referred to as data. Although data is also present in ECM systems, it is used in a supportive role to help locate and manage the content. All relevant information is stored either as data, content, or...

1235. 

Microsoft® SQL Server 2008 Management and Administration

Microsoft® SQL Server 2008 Management and Administration

By: Ross Mistry; Hilary Cotter

Publisher: Sams

Publication Date: 23-DEC-2008

Insert Date: 15-NOV-2008

Slots: 1.0

Table of Contents • Start Reading

If you need to deploy, manage, or secure Microsoft SQL Server 2008, this is the complete, fast-paced, task-based reference you’ve been searching for. Authored by a world-class expert on SQL Server in the enterprise, this book goes far beyond the basics, taking on the complex tasks that DBAs need to make the most of Microsoft’s flagship database platform. SQL Server MVP, Ross Mistry presents proven techniques for SQL Server 2008 installation, upgrades, backup/restore, data transfer, indexing, high availability, security, and much more. He draws on extensive testing in high-profile production...

1236. 

The Data Access Handbook: Achieving Optimal Database Application Performance and Scalability

The Data Access Handbook: Achieving Optimal Database Application Performance and Scalability

By: John Goodson; Robert A. Steward

Publisher: Prentice Hall

Publication Date: 16-MAR-2009

Insert Date: 12-NOV-2008

Slots: 1.0

Table of Contents • Start Reading

The Data Access Handbook Achieving Optimal Database Application Performance and Scalability John Goodson • Robert A. Steward Drive breakthrough database application performance by optimizing middleware and connectivity Performance and scalability are more critical than ever in today’s enterprise database applications, and traditional database tuning isn’t nearly enough to solve the performance problems you are likely to see in those applications. Nowadays, 75-95% of the time it takes to process a data request is typically spent in the database middleware. Today’s worst performance and...

1237. 

SQL: Visual QuickStart Guide, Third Edition

SQL: Visual QuickStart Guide, Third Edition

By: Chris Fehily

Publisher: Peachpit Press

Publication Date: 04-JUN-2008

Insert Date: 11-NOV-2008

Slots: 1.0

Table of Contents • Start Reading

SQL is a standard interactive and programming language for querying and modifying data and managing databases. This task-based tutorial and reference guide takes the mystery out learning and applying SQL. After going over the relational database model and SQL syntax in the first few chapters, veteran author Chris Fehily immediately launches into the tasks that will get readers comfortable with SQL. In addition to covering all the SQL basics, this thoroughly updated reference contains a wealth of in-depth SQL knowledge and serves as an excellent reference for more experienced users....

1238. 

DB2 Deployment Guide

DB2 Deployment Guide

By: Whei-Jen Chen; Jian TJ Tang; Carsten Block; John Chun

Publisher: IBM Redbooks

Publication Date: 24-OCT-2008

Insert Date: 07-NOV-2008

Slots: 1.0

Table of Contents • Start Reading

DB2® provides various installation methods as well as features and tools to deploy a large number of clients and servers. Database administrators, application developers, and application architects have a number of available options when deploying DB2 9.5 for Linux® , UNIX® , and Windows® (DB2 for LUW). Focusing on the DB2 V9.5 deployment methodology, this IBM® Redbooks® publication provides general guidance and serves as a reference resource for DB2 based solution deployment. These techniques and considerations are also applicable to other recent versions of DB2 for LUW. Deployment...

1239. 

Microsoft® SQL Server™ 2008 Integration Services Unleashed

Microsoft® SQL Server™ 2008 Integration Services Unleashed

By: Kirk Haselden

Publisher: Sams

Publication Date: 29-JAN-2009

Insert Date: 29-OCT-2008

Slots: 1.0

Table of Contents • Start Reading

Microsoft SQL Server Integration Services is Microsoft’s powerful platform for building enterprise-level data integration and data transformation solutions. It’s a powerful product, but it’s also complex and can be confusing if you don’t have a clear map for the journey. Microsoft SQL Server 2008 Integration Services Unleashed will be the only book you’ll need to harness the power that Integration Services provides. Through clear, concise explanations and samples, you’ll grasp a clear understanding of working in the Integration Services environment, including how to set up stock components,...

1240. 

Beginning PHP and MySQL: From Novice to Professional, Third Edition

Beginning PHP and MySQL: From Novice to Professional, Third Edition

By: W. Jason Gilmore

Publisher: Apress

Publication Date: 28-MAR-2008

Insert Date: 22-OCT-2008

Slots: 1.0

Table of Contents • Start Reading

Beginning PHP and MySQL: From Novice to Professional, Third Edition offers a comprehensive introduction to two of the most prominent open-source technologies on the planet: the PHP scripting language and the MySQL database server. Updated to introduce the features found in MySQL's most significant release to date, readers will learn how to take advantage of the features of both technologies to build powerful, manageable, and stable web applications. Essentially three books in one, readers will not only profit from extensive introductions to the core features of each technology, but also...