Database Ebooks

It hasn't taken Web developers long to discover that when it comes to creating dynamic, database-driven Web sites, MySQL and PHP provide a winning open source combination. Add this book to the mix, and there's no limit to the powerful, interactive Web sites that developers can create. With step-by-step instructions, complete scripts, and expert tips to guide readers, veteran author and database designer Larry Ullman gets right down to business: After grounding readers with separate discussions of first the scripting language (PHP) and then the database program (MySQL), he goes on to cover security, sessions and cookies, and using additional Web tools, with several sections devoted to creating sample applications. This guide is indispensable for intermediate- to advanced level Web designers who want to replace their static sites with something dynamic. In this edition, the bulk of the new material covers the latest versions of both technologies: PHP 6 (due out in 2008) and MySQL 5 (available now). The book's publication date is likely to beat the official release of PHP 6, making it one of the first books available on the subject.

This comprehensive book guides readers through Microsoft's brand- new SQL 2005 certification: Microsoft Certified IT Professional Developer for SQL Server 2005 (Exam 70441) Topics covered include writing SQL queries, designing and implementing programming objects, database optimization, designing databases at both the conceptual and logical levels, and implementing databases at the physical level Aimed at candidates for this exam, namely professional database developers who are responsible for designing and implementing database solutions using SQL Server 2005 The CD-ROM features leading-edge exam prep software with test engine plus hundreds of practice questions and electronic flashcards..

The Essential Resource for All Oracle Database Administrators

Maintain a high-performance Oracle enterprise database with help from this exclusive Oracle Press guide. Oracle Database 10g DBA Handbook explains how to install Oracle Database 10g, or upgrade from an earlier version, and take full advantage of all the new and improved management, scalability, availability, and security features. Written by Oracle experts, the book covers Automatic Undo Management, Oracle Real Application Clusters, Oracle Recovery Manager, Oracle Data Guard, and much more.

* Plan tablespaces--including bigfiles and multiple temporary tablespaces--and physical database layout
* Manage disk space and CPU usage
* Use Automatic Undo Management to manage transactions
* Tune queries using the SQL Access Advisor
* Monitor and tune your database with the Automated Workload Repository and STATSPACK
* Implement fine-grained security using authentication, authorization, and auditing techniques
* Automate the management of the memory areas
* Enable high availability using Oracle Real Application Clusters
* Perform backup and recovery with Oracle Recovery Manager
* Use Oracle Data Guard and the flashback features for data protection and disaster recovery
* Manage Very Large Databases (VLDB) and distributed databases

Learn to access Oracle databases through SQL statements and construct PL/SQL programs with guidance from Oracle expert, Jason Price. Published by Oracle Press, Oracle Database 11g SQL explains how to retrieve and modify database information, use SQL Plus and SQL Developer, work with database objects, write PL/SQL programs, and much more. Inside, you'll find in-depth coverage of the very latest SQL features and tools, performance optimization techniques, advanced queries, Java support, and XML. This book contains everything you need to master SQL.

*Explore SQL Plus and SQL Developer
*Use SQL SELECT, INSERT, UPDATE, and DELETE statements
*Write PL/SQL programs
*Create tables, sequences, indexes, views, and triggers
*Write advanced queries containing complex analytical functions
*Create database objects and collections to handle abstract data
*Use large objects to handle multimedia files containing music and movies
*Write Java programs to access an Oracle Database using JDBC
*Tune your SQL statements to make them execute faster
*Explore the XML capabilities of the Oracle Database
*Master the very latest Oracle Database 11g features, such as PIVOT and UNPIVOT, flashback archives, and much more.,

Oracle In-Focus is a registered Trademark of Rampant TechPress. Many of the designations used by computer vendors to distinguish their products are claimed as Trademarks. All names known to Rampant TechPress to be trademark names appear in this text as initial caps. The information provided by the authors of this work is believed to be accurate and reliable, but because of the possibility of human error by our authors and staff, Rampant TechPress cannot guarantee the accuracy or completeness of any information included in this work and is not responsible for any errors, omissions, or inaccurate results obtained from the use of information or scripts in this work.

Using case study examples and hands-on exercises, van der Lans illuminates every key SQL concept, technique, and statement. Drawing on decades of experience as an SQL standards team member and enterprise consultant, he reveals exactly why SQL works as it does–and how to get the most out of it. You’ll gain powerful insight into everything from basic queries to stored procedures, transactions to data security. Whether you’re a programmer or DBA, a student or veteran, this book will take you from “apprentice” to true SQL master.
• Writing queries and updating data: all you need to know about SELECT
• Working with joins, functions, and subqueries
• Creating database objects: tables, indexes, views, and more
• Specifying keys and other integrity constraints
• Using indexes to improve efficiency
• Enforcing security via passwords and privileges
• Building stored procedures and triggers
• Developing with embedded SQL and ODBC
• Working with transactions, including rollbacks, savepoints, isolation levels, and more
• Optimizing performance by reformulating SQL statements
• Using object-relational features: subtables, references, sets, and user-defined data types
• Reference section: SQL statement definitions and SQL function lists

Get complete coverage of all three Microsoft Certified IT Professional database developer exams for SQL Server 2005 in this comprehensive volume. Written by a SQL Server expert and MCITP, this definitive exam guide features learning objectives at the beginning of each chapter, exam tips, practice questions, and in-depth explanations. Detailed and authoritative, the book serves as both a complete certification study guide and an essential on-the-job reference. Get full details on all exam topics including how to: Install and configure SQL Server 2005 Manage database design Use Transact-SQL and XML Work with functions, triggers, and CLR integration Optimize, monitor, and secure databases Create stored procedures Handle disaster recovery Work with Service Broker, Web Services, and MARS Use SQL Server Reporting Services and Notification Services Manage locks, deadlocks, and cursors Transfer data using Replication and SQL Server Integration Services

Model SQL Server Databases That Work Better, Do More, and Evolve More Smoothly

Effective data modeling is essential to ensuring that your databases will perform well, scale well, and evolve to meet changing requirements. However, if you’re modeling databases to run on Microsoft SQL Server 2008 or 2005, theoretical or platform-agnostic data modeling knowledge isn’t enough: models that don’t reflect SQL Server’s unique real-world strengths and weaknesses often lead to disastrous performance.

A Developer’s Guide to Data Modeling for SQL Server is a practical, SQL Server-specific guide to data modeling for every developer, architect, and administrator. This book offers you invaluable start-to-finish guidance for designing new databases, redesigning existing SQL Server data models, and migrating databases from other platforms.

You’ll begin with a concise, practical overview of the core data modeling techniques. Next, you’ll walk through requirements gathering and discover how to convert requirements into effective SQL Server logical models. Finally, you’ll systematically transform those logical models into physical models that make the most of SQL Server’s extended functionality. All of this book’s many examples are available for download from a companion Web site.

This book enables you to

* Understand your data model’s physical elements, from storage to referential integrity
* Provide programmability via stored procedures, user-defined functions, triggers, and .NET CLR integration
* Normalize data models, one step at a time
* Gather and interpret requirements more effectively
* Learn an effective methodology for creating logical models
* Overcome modeling problems related to entities, attribute, data types, storage overhead, performance, and relationships
* Create physical models—from establishing naming guidelines through implementing business rules and constraints
* Use SQL Server’s unique indexing capabilities, and overcome their limitations
* Create abstraction layers that enhance security, extensibility, and flexibility

Written with clarity and a down-to-earth approach, Sams Teach Yourself SQL Server 2005 Express in 24 Hours covers the basics of Microsoft's latest version of SQL Server. Expert author Alison Balter takes you from basic concepts to an intermediate level in 24 one-hour lessons. You will learn all of the basic tasks necessary for the administration of SQL Server 2005. You will also learn how to write and fully utilize:

* SQL Server stored procedures
* Functions
* Triggers using T-SQL, VB.NET, and C#

You will also learn how to output SQL Server data to reports and the Internet. Sams Teach Yourself SQL Server 2005 Express in 24 Hours is a well-organized, authoritative introduction that will quickly have you up and running with SQL Server 2005.

* Describes Oracle's Internet Computing Platform for developing applications.
* Outlines Key Oracle Java technologies like Enterprise Java Beans, Business Components, Java Server Pages, and Servlets for developing and deploying applications using Oracle 8i.
* Describes the creation of dynamic Web Content with Java.
* Describes database interaction with Java using Java stored procedures, JDBC, and SQLJ.