Database

Tutorials for Drupal 7, more than 120 commercials. Part of the rollers are laid out in free access to the site of the author - in this hand does not. Also, there is not that part of the video that the site has been updated - it's about 10 spots on theming, and some for creating modules.

Drupal 7 Development - Core Concepts
This series contains over 120 videos and 12 hours of content, covering the most essential aspects of Drupal development, from setting up module scaffolding to working with forms and the database to working with jQuery and javascript. This library is a must-have for all developers.
Working With Files in Drupal 7
This collection walks you through working with files and the File API in Drupal 7, beginning by explaining the basics of working with files and permissions, and ending with a fully functioning image gallery. We explore how to work with private and public files, discuss stream wrappers, and explain the difference between managed and unmanaged files. There are 24 videos in this 2+ hour collection.
Drupal Theming Essentials
How to build or modify a theme in Drupal 7. We discuss various methods to modify Drupal output, how to decide which to use, and work through several practical applications of useful techniques.

A much-needed resource on database development and enterprise integration for the iPhone

An enormous demand exists for getting iPhone applications into the enterprise and this book guides you through all the necessary steps for integrating an iPhone app within an existing enterprise. Experienced iPhone developers will learn how to take advantage of the built-in capabilities of the iPhone to confidently implement a data-driven application for the iPhone.

• Shows you how to integrate iPhone applications into enterprise class systems
• Introduces development of data-driven applications on the iPhone
• Discusses storing data using SQLite, managing data using Core Data, and integrating with Web Services
• In-depth coverage of displaying data on the phone using the UITableView

Professional iPhone Database Application Programming gets you up to speed on developing data-driven applications for the iPhone.

Create a Highly Available Microsoft SQL Server 2008 Environment

Written by the technical director for SQL Server Magazine, this expert guide shows you how to implement clustering and database mirroring in SQL Server 2008. Learn proven techniques for ensuring zero database loss, avoiding system downtime, and providing instant data backups. Filled with detailed instructions, Microsoft SQL Server 2008 High Availability with Clustering & Database Mirroring takes you from planning to management of a robust high availability solution.

• Configure Windows Failover Clustering
• Set up the Microsoft Distributed Transaction Coordinator on a two node failover cluster
• Install SQL Server 2008 on your cluster
• Handle cluster management and backup
• Configure and manage database mirroring for high availability
• Implement Hyper-V virtualization and Live Migration
• Manage a SQL Server virtual machine

Michael Otey is the technical director for SQL Server Magazine and Windows IT Pro and the bestselling author of Microsoft SQL Server 2005 Developer's Guide, Microsoft SQL Server 2008 New Features, and several other books. He is president of TECA, Inc., a software development and consulting company.

Pro Oracle Database 11g RAC on Linux provides full-life-cycle guidance on implementing Oracle Real Application Clusters in a Linux environment. Real Application Clusters, commonly abbreviated as RAC, is Oracle’s industry-leading architecture for scalable and fault-tolerant databases. RAC allows you to scale up and down by simply adding and subtracting inexpensive Linux servers. Redundancy provided by those multiple, inexpensive servers is the basis for the failover and other fault-tolerance features that RAC provides.

Written by authors well-known for their talent with RAC, Pro Oracle Database 11g RAC on Linux gives you a rock-solid and technically flawless foundation on which to build your RAC-management skills. Authors Julian Dyke and Steve Shaw share their hard-won experience in building RAC clusters, showing you how to build for success using the very latest Oracle technologies, such as Automatic Storage Management (ASM) and Oracle Clusterware. You’ll learn to troubleshoot performance and other problems. You’ll even learn how to correctly deploy RAC in a virtual-machine environment based upon Oracle VM, which is the only virtualization solution supported by Oracle Corporation.

RAC is a complex and powerful technology. It demands expertise in its deployment. You can’t just “wing it” in creating a RAC solution. Julian and Steve have earned the right to term themselves expert—in Pro Oracle Database 11g RAC on Linux, they offer a rigorous and technically-correct treatment of RAC that helps you build a solid foundation of expertise and achieve success.

What you’ll learn

• Plan the architecture for a successful RAC installation
• Implement failover and other fault-tolerant features
• Scale RAC clusters up and down as needed to achieve performance targets
• Consolidate RAC clusters using Oracle’s virtualization solution
• Manage RAC proactively so as to sleep well at night
• Troubleshoot and solve performance and availability problems

Who this book is for

Pro Oracle Database 11g RAC on Linux is written for Oracle Database Administrators who want to step up their skills to be equal to the task of managing Real Application Clusters.

Java Database Bible is a comprehensive approach to learning how to develop and implement a professional level Java 2 database program using the Java database connection API (JDBC 3.0).
Includes an introduction to relational databases and designing database applications; covers interacting with a relational database using a Java program; and shows how to create and work with XML data storage using a Java program.

Java Database Development with Oracle is a hands-on book for Java developers who want to learn how use Oracle and integrate it with their Java applications. It assumes an intermediate knowledge of Java and no knowledge of Oracle. This book is segmented into three parts. Part One begins by investigating how and why databases relate to object-oriented programming with Java. Introductory chapters on the Oracle database, SQL and other Oracle features, including its object-relational support, lay the groundwork for the chapters that follow. Part Two presents thorough coverage of the essential Java technologies for database programming, with chapters on SQLJ, JDBC and JDO (Java Data Objects). Part Three takes a higher-level view of application architecture and considers the role of Oracle in enterprise applications, particularly with regard to EJB (Enterprise Java Beans) and the J2EE framework.

Java Database Best Practices rescues you from having to slog through books on each of the various APIs before figuring out which method to use! This guide introduces each of the dominant APIs, explores the methodology and design components that use those APIs, and then offers practices most appropriate for different types and makes of databases, and different types of applications. Java Database Practices also examines database design, from table and database architecture to normalization, and offers a number of best practices for handling these tasks as well. Learn how to move through the various forms of normalization, understand when to denormalize, and even get detailed instructions on optimizing your SQL queries to make the best use of your database structure. Through it all, this book focuses on practical application of these techniques, giving you information that can immediately be applied to your own enterprise projects.

Whether building a relational, object-relational, or object-oriented database, database developers are increasingly relying on an object-oriented design approach as the best way to meet user needs and performance criteria. This book teaches you how to use the Unified Modeling Language-the official standard of the Object Management Group-to develop and implement the best possible design for your database.

Inside, the author leads you step by step through the design process, from requirements analysis to schema generation. You'll learn to express stakeholder needs in UML use cases and actor diagrams, to translate UML entities into database components, and to transform the resulting design into relational, object-relational, and object-oriented schemas for all major DBMS products.

* Teaches you everything you need to know to design, build, and test databases using an OO model.
* Shows you how to use UML, the accepted standard for database design according to OO principles.
* Explains how to transform your design into a conceptual schema for relational, object-relational, and object-oriented DBMSs.
* Offers practical examples of design for Oracle, SQL Server, Sybase, Informix, Object Design, POET, and other database management systems.
* Focuses heavily on re-using design patterns for maximum productivity and teaches you how to certify completed designs for re-use.

(Pearson Education) Text in UML for database design, using a running case study throughout the text to illustrate key concepts and techniques, with appendices containing the actual UML models from the case study. Discusses everything from moving to the business system model to creating tables from classes. Softcover. DLC: Database design.

This volume will take you from novice to master, covering not only how to use SQL but also the Oracle extensions to SQL. The examples feature the sample schemas available with Oracle Database 10g, and free code will be available for download.