The Classic SQL Tutorial: Fully Updated for Today’s Standards and Today’s Top Databases For twenty years, van der Lans’ Introduction to SQL has been the definitive SQL tutorial for database professionals everywhere, regardless of experience or platform. Now van der Lans has systematically updated this classic guide to reflect the latest SQL standards and the newest versions of today’s leading RDBMSs: Oracle, Microsoft SQL Server, DB2, and MySQL. 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

This IBM Redbooks publication introduces the IBM Problem Determination and Deployment Tools for z/OS and OS/390. The tools covered are: -> IBM Application Performance Analyzer for z/OS Version 1 Release 1 This comprehensive suite of powerful yet easy-to-use tools helps developers to efficiently build, test, and service applications while minimizing errors and increasing cost-effectiveness. The tools allow users to quickly identify and resolve problems that occur in batch, IMS, DB2, CICS, and UNIX System Services applications. For each tool, this book provides step-by-step instructions for installation and customization, a detailed discussion of the features and capabilities, and guidance for using the tool in your environment.

This comprehensive book guides readers through Microsoft's brand-new SQL 2005 administrator exam: Designing a Database Server Infrastructure by Using Microsoft SQL Server 2005 (Exam 70443) Addresses the database tasks that the MCITP exam focuses on such as design, development, deployment, optimization, maintenance, and support Reviews key topics, including defining high availability solutions, automating administrative tasks, defining security solutions, monitoring and troubleshooting the database server, and much more The CD-ROM features leading-edge exam prep software with test engine plus hundreds of practice questions and electronic flashcards Note: CD-ROM/DVD and other supplementary materials are not included as part of eBook file.

In-depth coverage of Microsoft’s powerful new data integration tool Learn to maximize the features of SQL Server 2005 Integration Services from this essential guide. Hands-On Microsoft SQL Server 2005 Integration Services makes learning SSIS easy through the use of extensive real-world exercises structured around every component within the tool. You will learn to collect corporate data from various sources and transform that data for analysis, mining, and reporting.

IBM TotalStorage Productivity Center is a suite of infrastructure management software that can centralize, automate, and simplify the management of complex and heterogeneous storage environments. It can help reduce the effort of managing complex storage infrastructures, improve storage capacity utilization, and improve administration efficiency. IBM TotalStorage Productivity Center allows you to respond to on demand storage needs and brings together, in a single point, the management of storage devices, fabric, and data. TotalStorage Productivity Center V3.1 is a rewrite of previous versions. This IBM Redbooks publication shows you how to access the functions as compared to the previous releases. This book is intended for administrators and users who are installing and using IBM TotalStorage Productivity Center. It provides an overview of the product components and functions. It describes the hardware and software environment required and provides a step- by-step installation procedure. Customization and usage hints and tips are also provided.

First Published in 2006. Routledge is an imprint of Taylor & Francis, an informa company.

"The expertise, thought, and effort that go into each book are obvious, and I sincerely appreciate your efforts. Keep up the wonderful work!" --Tracey Moore (Memphis, TN) Welcome to the only guidebook series that takes a visual approach to professional-level computer topics. Open the book and you will discover step-by-step screen shots that demonstrate over 140 key techniques using PHP amd MySQL, including: Configuring Apache to process PHP code Working with character strings Creating, sorting, and comparing arrays Defining and using functions Finding and replacing substrings Querying databases and retrieving data Stopping and starting the MySQL server Adding dynamic check boxes Sending new Web pages to a browser Extra / Apply It High-resolution screen shots demonstrate each task Succinct explanations walk you through step-by-step Two-page lessons break big topics into bite-sized modules "Apply It" and "Extra" sidebars highlight useful tips

SQL Server 2005 is Microsoft’s next-generation data management and analysis solution that delivers enhanced scalability, availability, and security features to enterprise data and analytical applications while making them easier to create, deploy, and manage. Now you can teach yourself how to design, build, test, deploy, and maintain SQL Server databases—one step at a time. With STEP BY STEP, you work at your own pace through hands-on, learn-by-doing exercises. Instead of merely focusing on describing new features, this book shows new database programmers and administrators how to use specific features within typical business scenarios. Each chapter puts you to work, providing a highly practical learning experience that demonstrates how to build database solutions to solve common business problems.

Identity and user lifecycle management projects are being deployed more and more frequently - and demand is growing. By demonstrating how IBM Tivoli Identity Manager can be made resilient and adapted to special functional requirements, this IBM Redbooks publication creates or enhances confidence in the IBM Tivoli Identity Manager-based solution for senior management, architects, and security administrators. Advanced design topics can start with infrastructure availability for all involved components, Web application, and database server clustering as well as LDAP multi-master setups, continuing with compliance challenges addressing enhanced auditing and reporting, and designing and creating your own self-care/self-registration application environment that embraces external users and business partners offering fine-tuned workflow options and lifecycle management capabilities. The powerful features and extensions of IBM Tivoli Identity Manager are opening doors into a world of advanced design and customization for every identity management challenge you might encounter. Please note that the additional material referenced in the text is not available from IBM.

Avoid misunderstandings that can affect the design, programming, and use of database systems. Whether you're using Oracle, DB2, SQL Server, MySQL, or PostgreSQL, The Relational Database Dictionary will prevent confusion about the precise meaning of database-related terms (e.g., attribute, 3NF, one-to-many correspondence, predicate, repeating group, join dependency), helping to ensure the success of your database projects. Carefully reviewed for clarity, accuracy, and completeness, this authoritative and comprehensive quick-reference contains more than 600 terms, many with examples, covering issues and concepts arising from the relational model of data. This one-of-a-kind dictionary provides a single, compact source where DBAs, database designers, DBMS implementers, application developers, and database professors and students can find the accurate definitions they need on a daily basis, information that isn't readily available anywhere else. If you're working with or learning about relational databases, you need this pocket-sized quick-reference.

Beginning Hibernate is ideal if you're experienced in Java with databases (the traditional, or connected, approach), but are new to open source lightweight Hibernate—the most popular de facto object-relational mapping and database-oriented application development framework. This book packs in information about the release of the Hibernate 3.2.x persistence layer and provides a clear introduction to the current standard for object-relational persistence in Java. Experienced author Dave Minter and contributor Jeff Linwood provide more in-depth examples than any other books for Hibernate beginners. The authors also present material in a lively, example-based mannernot in a dry, theoretical, hard-to-read fashion. And since the book keeps its focus on Hibernate without wasting time on nonessential third-party tools, you'll be able to immediately start building transaction-based engines and applications.

Until recently, building interactive web-based mapping applications has been a cumbersome affair. This changed when Google released its powerful Maps API. Beginning Google Maps Applications with PHP and Ajax was written to help you take advantage of this technology in your own endeavorswhether you're an enthusiast playing for fun or a professional building for profit. This book covers version 2 of the API, including Google's new Geocoding service. Authors Jeffrey Sambells, Cameron Turner, and Michael Purvis get rolling with examples that require hardly any code at all, but you'll quickly become acquainted with many facets of the Maps API. They demonstrate powerful methods for simultaneously plotting large data sets, creating your own map overlays, and harvesting and geocoding sets of addresses. You'll see how to set up alternative tile sets and where to access imagery to use for them. The authors even show you how to build your own geocoder from scratch, for those high-volume batch jobs. As well as providing hands-on examples of real mapping projects, this book supplies a complete reference for the Maps API, along with the relevant aspects of JavaScript, CSS, PHP, and SQL. Visit the authors' website for additional tips and advice.

See how SQL interfaces with today's environments Start building and using relational databases with SQL's newest features The database may be the twenty-first century filing cabinet, but building one is a little more complex than sliding drawers into a metal box. With this book to guide you through all the newest features of SQL, you'll soon be whipping up relational databases, using SQL with XML to power data-driven Web sites, and more! Discover how to * Use SQL in a client/server system * Build a multitable relational database * Construct nested and recursive queries * Set up database security * Use SQL within applications * Map SQL to XML

IBM, the leader in collaboration, has created IBM Workplace Collaboration Services, a completely integrated collaborative environment based on open standards. Workplace Collaboration Services provides a wide range of integrated ready-to-use communication and collaboration capabilities as services for the IBM Workplace environment. This includes such capabilities as e-mail, calendaring and scheduling, presence awareness, instant messaging, e-learning, team spaces, Web conferencing, and document and Web content management. The integrated design of the IBM System i5 platform provides a low-cost, low-maintenance computing system for Workplace solutions. The System i5 platform, which employs the latest implementation of Power Architecture, advances IBM eServer iSeries integration, simplicity, and low total cost of ownership to record-setting levels. You magnify the benefits of IBM Workplace Collaboration Services by hosting it on the System i5 platform. This IBM Redbooks publication is written for administrators who want to install, configure, and administer IBM Workplace Collaboration Services on the System i5 platform. It introduces you to Workplace Collaboration Services. It shows you how to deploy and customize it on the System i5 platform as well as how to configure the IBM Workplace Managed Client. In addition, this book provides many performance tips to help you optimize your Workplace Collaboration Services environment. Please note that the additional material referenced in the text is not available from IBM.

The calculation dialog in FileMaker serves as a fundamental element in nearly all development activities. The calculation dialog allows developers easy access to the data fields in their solutions and to a complete function list. This Short Cut presents a complete description of each calculation function, lists examples, and in many cases offers additional comments on usage. This Short Cut is Chapter 6 from the book FileMaker 8 Functions and Scripts Desk Reference by Scott Love, Steve Lane, and Bob Bowers (0-7897-3511-3). As such, it contains references pointing you to additional information not found in this Short Cut, but in a companion book, Special Edition Using FileMaker 8. Apart from this reference, the Short Cut is fully self-contained and is an excellent sampling of calculation functions.

This Short Cut presents a sampling of custom functions that we’ve found useful, or that serve as good examples of functions in our day-to-day practice. The functions are broken into groups according to their purpose, much as FileMaker’s calculation functions are. Please note that these functions are meant as examples—although the examples were not tested exhaustively, nor is this collection meant to be comprehensive. We hope you’ll find some of them helpful directly, or that reading and analyzing others might provide a springboard for your own ideas. Table of Contents Date Calculations Text and Data Conversions Email Tools List Handlers Developer Tools System Constants Toolkit for Complex Data Structures Data API Within FileMaker Data Tree Using XML as a Data Structure Path-Based Selections The Functions

Hibernate has clearly arrived. Are you ready to benefit from its simple way of working with relational databases as Java objects? This PDF updates the introductory material from the award-winning Hibernate: A Developer's Notebook to teach you how to jump right in and get productive with the current release of Hibernate. You'll be walked through the ins and outs of setting up Hibernate and some related tools that make it easier to use--and that may give you new ideas about how to store information in your Java programs. In short, this PDF gives you exactly the information you need to start using Hibernate today.

This IBM Redbook focuses on the technology, serviceability, and features that are used by the IBM eServer p5 and IBM System p5 servers, which allow you to make your server one of the most reliable and available parts of your IT infrastructure.

Everyone knows that Google lets you search billions of web pages. But few people realize that Google also gives you hundreds of cool ways to organize and play with information. Since we released the last edition of this bestselling book, Google has added many new features and services to its expanding universe: Google Earth, Google Talk, Google Maps, Google Blog Search, Video Search, Music Search, Google Base, Google Reader, and Google Desktop among them. We've found ways to get these new services to do even more. The expanded third edition of Google Hacks is a brand-new and infinitely more useful book for this powerful search engine. You'll not only find dozens of hacks for the new Google services, but plenty of updated tips, tricks and scripts for hacking the old ones. Now you can make a Google Earth movie, visualize your web site traffic with Google Analytics, post pictures to your blog with Picasa, or access Gmail in your favorite email client. Industrial strength and real-world tested, this new collection enables you to mine a ton of information within Google's reach. And have a lot of fun while doing it: Search Google over IM with a Google Talk bot Build a customized Google Map and add it to your own web site Cover your searching tracks and take back your browsing privacy Turn any Google query into an RSS feed that you can monitor in Google Reader or the newsreader of your choice Keep tabs on blogs in new, useful ways Turn Gmail into an external hard drive for Windows, Mac, or Linux Beef up your web pages with search, ads, news feeds, and more Program Google with the Google API and language of your choice For those of you concerned about Google as an emerging Big Brother, this new edition also offers advice and concrete tips for protecting your privacy. Get into the world of Google and bend it to your will!

The MCTS 70-431 Exam Cram is a must-have resource in your MCTS 70-431 exam preparation. The Exam Cram focuses on exactly what you need to know to get certified. This includes features like: Complete coverage of all 70-431 exam objectives Exam alerts, practice questions, notes, tips, sidebars, cautions, test-taking strategies, and time-saving tips Access to MeasureUp practice questions and innovative testing software The popular Cram Sheet tear card, giving you the key facts you should review before you enter the testing center Insight from author Thomas Moore, a Microsoft Certified Trainer (MCT) and SQL Server expert who has helped hundreds of students earn their SQL Server certifications

This IBM Redbooks publication introduces the features and capabilities of SnapMirror, and describes how SnapMirror technology can be used in an IBM System Storage N Series environment to achieve enterprise data protection.

The fastest way to get up and running on Oracle Database XE Take full advantage of all the powerful features available in Oracle Database 10 Express Edition with help from this easy-to-follow Oracle Press guide.Hands-On Oracle Database 10 Express Edition for Windows shows you, step by step, how to set up, administer, tune, troubleshoot, and secure a robust database system. You will also learn to use PL/SQL and Oracle Application Express to build custom database applications. Get started today with the Oracle database that’s free to develop, deploy, and distribute. The ebook version does not provide access to the companion files.

Consuming the Sent Data with XML and JSON (Digital Short Cut) Joshua Eichorn ISBN 0132337932 There are two main ways that AJAX programmers can process the data received from an XMLHttpRequest object or one of the alternative fallback methods. One is known as the document-centric approach and involves parsing a Document Object Model (DOM) document. The other involves remote scripting using a subset of JavaScript called JavaScript Object Notation (JSON), which is the literal syntax for JavaScript objects. This Short Cut is a detailed examination of both techniques.

SAP Query Reporting is everything an SAP user needs to know to create your own reports in SAP using Query tools, no programming required! Designed as a hands-on learning aid, you will be able to follow along and perform each new skill learned on your own SAP system. The book's tutorial style, step-by-step instruction will teach you everything you need to know to use the SAP Query tools, including its configuration, advanced usage, and integration to Microsoft. Additionally the book gives best business practice recommendations for the technology and internal business use of the tools. Learn to: Understand query security, table reads, and table joins Perform basic and advanced calculations Incorporate pictures and graphics into reports Configure shortcuts and tran codes, schedule jobs and email PDFs Utilize SAP Reporting with Microsoft Office applications

All medium to large companies have to deal with data being stored in a number of databases, spreadsheets and proprietary applications. Bringing all this data together into one system can be useful to analyzing the business; but can also be quite difficult to do. Integration Services is the next big bet in Microsoft's business intelligence lineup, providing you with true enterprise extract transform and load features (ETL). Microsoft SQL Server 2005 Integration Services concentrates on providing you with real world solutions to real world problems, giving you a head start on various projects. If you are only evaluating Integration Services, you'll be able to focus on the early chapters with the option of drilling down into details in the later chapters where some of the more complex concepts will be discussed in detail. The interesting sidebars peppered throughout the book provide insight into the processes, people and decisions that yielded the final IS product.