Add seamless, interactive, user-controlled delivery to your Flash applications. This book builds upon your understanding of basic ActionScript (AS) syntax with the foundational skills that you need to use XML in Flash applications and AS2 or AS3 to migrate your existing applications. Beginning with an introduction to XML, XML parsing methods, and a short introduction to AS2 you learn how to create a universal XML load/onload Class as well as a universal XHTML parser. Then you learn how to use Components using XML as the data source, including the menu, menubar, datagrid and tree component. Finally, a tutorial project-the design and development of a Real Estate Web site that contains an XML search engine-pulls it all together with hands-on experience. All the applications use XML as the data source and are written as class files. Select parts of the Real Estate Web site are redeveloped in AS3 for purposes of illustration. The new XML class is presented and specific code examples demonstrate techniques to apply methods and use properties. Particular attention is paid to the differences between AS2 and AS3 and how to effectively transition from one AS version to the other. The downloadable resources contain code for all of the properties and methods of the AS2, AS3, and XML class examples. Components for the Real Estate Web site project are also provided.

Beginning PivotTables in Excel 2007 explains what PivotTables are, how you can benefit from using them, how to create them and modify them, and how to use their enhanced features. Using a Pivot Table in Microsoft Office Excel 2007 is a quick and exciting way to slice and dice a large amount of data. Carefully explains the benefits of using Pivot Tables for fast data analysis Provides a step-by-step approach to those new to Pivot Tables Offers tips and tricks that cannot be found elsewhere

Dive deep into the internals of query tuning and optimization in SQL Server 2005 with this comprehensive reference. Understanding the internals of SQL Server helps database developers and administrators to better create, access, and effectively process information from enterprise data. Written by experts on SQL Server, this volume from the Inside Microsoft SQL Server series of books focuses on query tuning and optimization. You'll take an in-depth look at the best ways to make queries more efficient and effective, while maximizing existing resources. Includes extensive code samples and table examples to help database developers and administrators understand the intricacies and help promote mastery of query tuning and optimization.

Unless you are working at a very advanced level, this is the only SQL book you will ever need. The authors have taken the mystery out of complex queries and explained principles and techniques with such clarity that a "Mere Mortal" will indeed be empowered to perform the superhuman. Do not walk past this book! --Graham Mandeno, Database Consultant provides a step-by-step, easy-to-read introduction to writing SQL queries. It includes hundreds of examples with detailed explanations. This book provides the tools you need to understand, modify, and create SQL queries SQL Queries for Mere Mortals --Keith W. Hare, Convenor, ISO/IEC JTC1 SC32 WG3--the International SQL Standards Committee I learned SQL primarily from the first edition of this book, and I am pleased to see a second edition of this book so that others can continue to benefit from its organized presentation of the language. Starting from how to design your tables so that SQL can be effective (a common problem for database beginners), and then continuing through the various aspects of SQL construction and capabilities, the reader can become a moderate expert upon completing the book and its samples. Learning how to convert a question in English into a meaningful SQL statement will greatly facilitate your mastery of the language. Numerous examples from real life will help you visualize how to use SQL to answer the questions about the data in your database. Just one of the "watch out for this trap" items will save you more than the cost of the book when you avoid that problem when writing your queries. I highly recommend this book if you want to tap the full potential of your database. --Kenneth D. Snell, Ph.D., Database Designer/Programmer I don't think they do this in public schools any more, and it is a shame, but do you remember in the seventh and eighth grades when you learned to diagram a sentence? Those of you who do may no longer remember how you did it, but all of you do write better sentences because of it. John Viescas and Mike Hernandez must have remembered because they take everyday English queries and literally translate them into SQL. This is an important book for all database designers. It takes the complexity of mathematical Set Theory and of First Order Predicate Logic, as outlined in E. F. Codd's original treatise on relational database design, and makes it easy for anyone to understand. If you want an elementary- through intermediate-level course on SQL, this is the one book that is a requirement, no matter how many others you buy. --Arvin Meyer, MCP, MVP Even in this day of wizards and code generators, successful database developers still require a sound knowledge of Structured Query Language (SQL, the standard language for communicating with most database systems). In this book, John and Mike do a marvelous job of making what's usually a dry and difficult subject come alive, presenting the material with humor in a logical manner, with plenty of relevant examples. I would say that this book should feature prominently in the collection on the bookshelf of all serious developers, except that I'm sure it'll get so much use that it won't spend much time on the shelf! -- Doug Steele, Microsoft Access Developer and author Over the last several decades, SQL has evolved from a language known only to computer specialists to a widely used international standard of the computer industry. The number of new applications deployed each year using SQL now totals in the millions. If you are accessing corporate information from the Internet or from an internal network, you are probably using SQL. This new edition of helps new users learn the foundations of SQL queries, and is an essential reference guide for intermediate and advanced users. SQL Queries for Mere Mortals The accompanying CD contains five sample databases used for the example queries throughout the book in four different formats: Microsoft SQL Server 2000 and later, Microsoft Access 2000 and later, MySQL version 5.0 and later, and SQL scripts that can be used with most other implementations of the language.

This IBM Redbooks publication will illustrate the installation procedures of InfiniBand on the IBM System p5 with Linux and AIX 5L. InfiniBand adapters, switches, and network management software will be described in this publication. The IBM HPC stack will be tested with InfiniBand (Parallel Environment, LoadLeveler, GPFS, ESSL, and Parallel ESSL). Communication protocols such as MPI and LAPI will be tested and observations will be illustrated in this book. This book is the complete guide on how to implement InfiniBand on the IBM System p5. It is targeted at all IT professionals looking to understand what is behind the InfiniBand technologies, how to deploy it, and what is the IBM solution incorporating this technology.

What is IBM Electronic Services? Why do I need it? Where do you get it? When and how do you use it? How will this help you electronic support relationship with IBM? Find the answers to these questions and more details about IBM Electronic Services in this IBM Redbooks publication. The goal of IBM Electronic Services is to simplify your support relationship to make it easier and faster to do business with IBM. Through automation and Internet access, Electronic Services integrates the IBM Support community with your company staff and your IT environment. The two major components are IBM Electronic Service Agent™ (Service Agent) and the IBM Electronic Services Web site. IBM Electronic Services reaches across all IBM systems in all countries or regions where IBM does business. Electronic Services can provide the electronic support relationship for a single machine environment or a multinational complex of many servers. This book is intended for IT management, system operators, and other people who work for and with IBM clients. Prior to reading this book, you need to have a thorough understanding of your computer system and networking environments.

A new edition of this title is available, ISBN-10: 0789738201 ISBN-13: 9780789738202 The all-encompassing book about everything Google. Not only will you learn advanced search techniques, but you also will learn how to master Google’s web and software tools. It’s all inside! Blogger-create your own personal blog Gmail-Google’s web-based email service Google Web Search-the most popular search on the Internet Google AdSense-put profit-making ads on their own website Google AdWords-buy keyword advertising on the Google site Google Product Search-find hot deals without ever leaving your office chair Google Book Search-search the full text of selected books Google Calendar-a web-based scheduling and public calendar service Google Checkout-pay for your Web goodies and collect payments from people who buy from you Google Desktop-search documents and emails on your PC’s hard drive Google Directory-the best sites on the Web, picked by Google’s editors Google Docs & Spreadsheets-create and share web-based word processing and spreadsheet documents Google Earth-a fun way to view 3D maps of any location on Earth YouTube-view and share videos over the Web Google Groups-a collection of user-created message forums Google Image Search-search the web for pictures Google Maps-maps, satellite images, and driving directions for any location GOOGLE MAY BE THE INTERNET'S MOST POPULAR SEARCH SITE, BUT IT’S ALSO MORE THAN JUST SIMPLE WEB SEARCHES. • Use Google to search for news headlines, scholarly articles, and the best prices on the Web • Read and respond to blog postings and create your own blogs with Blogger • View the latest viral videos with YouTube • Create maps and driving directions with Google Maps • Use Google’s free web-based email service Gmail • Create your own custom Google Maps mashups–and put customized Google search on your own website Michael Miller has written more than 75 nonfiction how-to books, including Que’s Absolute Beginner’s Guide to Computer Basics, Tricks of the eBay Masters, and iPodpedia: The Ultimate iPod and iTunes Resource. Category Internet Covers Google User Level Intermediate to Advanced

John Morecroft's book is an ideal text for students interested in system modelling and its application to a range of real world problems. The book covers all that is necessary to develop expertise in system dynamics modelling and through the range of applications makes a persuasive case for the power and scope of the approach. As such it will appeal to practitioners as well as students. Robert Dyson, Professor of Operational Research, Associate Dean, Warwick Business School. Much more than an introduction, John Morecroft's Strategic Modelling and Business Dynamics uses interactive "management flight simulators" to create an engaging and effective learning environment in which readers, whatever their background, can develop their intuition about complex dynamic systems. The numerous examples provide a rich test-bed for the development of systems thinking and modelling skills John Sterman, Jay W. Forrester Professor of Management, MIT Sloan School of Management This book, with its vivid examples and simulators, will help to bring modelling, system dynamics and simulation into the mainstream of management education where they now belong. John A. Quelch, Professor of Marketing, Harvard Business School, Former Dean of London Business School This text fills the gap between texts focusing on the purely descriptive systems approach and the more technical system dynamics ones. Ann van Ackere, Professor of Decision Sciences, HEC Lausanne, Universit? de Lausanne Strategic modelling based on system dynamics is a powerful tool for understanding how firms adapt to a changing environment. The author demonstrates the appeal and power of business modelling to make sense of strategic initiatives and to anticipate their impacts through simulation. The book offers various simulators that allow readers to conduct their own policy experiments. Dr. Erich Zahn, Professor of Strategic Management, Betriebswirtschaftliches Institut, University of Stuttgart A website to accompany the book can be found at www.wiley.com/college/morecroft housing supplementary material for both students and lecturers.

This IBM Redbooks publication describes and documents a number of different aspects of the Software Configuration and Library Manager (SCLM). Part 1 of the book focuses on setting up an SCLM project using commonly used languages such as COBOL and PL/I. Additionally, migration techniques are discussed for those customers considering migrating to SCLM from other vendor Software Configuration Management products. Part 2 describes basic usage of SCLM functions such as Edit, Build, and Promote. Part 3 goes a bit beyond the basics and looks at some of the newer functions that are being added to SCLM, along with writing user exits and setting up SCLM for debugging with IBM Debug Tool. Parts 4, 5, and 6 concentrate on the SCLM Advanced Edition products such as Breeze, Enhanced Access Control, SCLM Developer Toolkit, and SCLM Administrator Toolkit. These sections describe what these products are and how they can be set up and used to aid your application development. Please note that the additional material referenced in the text is not available from IBM.

Whether you are a FileMaker developer who is new to web publishing, a web developer who is new to FileMaker, or a complete beginner looking to put your data online, this book is for you. In Part I, you learn the basics of how web publishing works and how to write your own HTML and PHP. In Part II, you learn how to build a FileMaker database and install and configure the FileMaker Server to host the database. In Part III, you learn how to put it all together to create web pages that talk to your database and allow people to view the data and, if you like, modify it. Throughout the book, publishing a FileMaker Product Catalog to the web is used as an example. Each chapter builds on the previous chapter. When you are done, you will have a working website! Detailed information on how to… Master web publishing Read and write basic HTML Read and write basic PHP Build a FileMaker database Install and configure FileMaker Server Publish your FileMaker data to the web Work with portals and container fields Repurpose your FileMaker layouts on the web Introduction 1

Many customer sites need to access data from both Windows and UNIX clients. For these environments, Data ONTAP has native multiprotocol support. After the user is authenticated on the network, if the user has both appropriate share or export permissions and the necessary file permissions, the user can access all data from UNIX hosts using NFS or from Windows hosts using CIFS. IBM System Storage N series allows users to access data from both types of clients by supporting multiple security models. This IBM Redbooks publication discusses those models in detail. It can help storage administrators in determining what type of data access configuration is appropriate for their environment.

This IBM Redbooks publication provides an overview of the IBM Tivoli Asset Management for IT portfolio. The portfolio is made up of the three primary products, IBM Tivoli Asset Management for IT, IBM Tivoli License Compliance Manager for z/OS, and IBM Tivoli License Compliance Manager. By using these products together, you can implement a comprehensive IT asset management solution. This book provides a functional overview of each of the products in the portfolio and also provides example scenarios of how they can be used to address IT asset management disciplines. The IBM Tivoli Asset Management for IT product is a relatively new acquisition. It has its roots in enterprise asset management and has very rich function. This product will be enhanced and adapted to provide functions specific to IT asset management, such as facilities to handle contract management, full asset life-cycle management, integration with Enterprise Resource Planning (ERP) solutions and much more. This book introduces the portfolio and describes its current capabilities. Our intention for the future is to provide additional materials for a deeper understanding of best practices for using the portfolio to implement a complete IT asset management solution.

In this IBM Redbooks publication, we provide an overview of Informix Dynamic Server (IDS) 11. IDS is designed to help businesses leverage their existing information assets as they move into an on demand business environment. Requirements here call for a flexible data server that can accommodate growth, in applications, data volume, and numbers of users. And it offers the capability to minimize downtime and to provide the high availability required today. A new suite of business availability functionality provides greater flexibility and performance, automated statistical and performance metric gathering, improvements in administration, and reductions in operating costs. The IDS technology enables efficient use of existing hardware and software, including single and multiprocessor architectures. And it helps you keep up with technological growth, including such things as the use of nontraditional data types. Built on the IBM Informix Dynamic Scalable Architecture™ (DSA), IDS provides a next-generation parallel data server architecture that delivers mainframe-caliber scalability; manageability and performance; minimal operating system overhead; and automatic workload distribution. IDS delivers a lower total cost of ownership (TCO) by leveraging its well-regarded general ease of use and systems administration. It enables customers to use information in new and more efficient ways to create business advantage.

JMP Start Statistics: A Guide to Statistics and Data Analysis Using JMP, Fourth Edition, is a complete and orderly introduction to analyzing data using JMP statistical discovery software from SAS. A mix of software manual and statistics text, this book provides hands-on tutorials with just the right amount of conceptual and motivational material to illustrate how to use JMP's intuitive interface for data analysis. Each chapter features concept-specific tutorials, examples, brief reviews of concepts, step-by-step illustrations, and exercises. Written by John Sall, Lee Creighton, and Ann Lehman, this book is a great tool for statistics students or practitioners needing a software-related statistics review.

In this pragmatic, example-driven book, author Neil Constable demonstrates how you can use SAS code to enhance the capabilities of SAS Enterprise Guide. Designed to help you gain extra value from the products you already have, SAS Programming for Enterprise Guide Users contains tips and techniques that show you a variety of features that cannot be accessed directly through the task interfaces. In all cases, techniques are shown with examples that you can try and test, plus additional exercises are included to give you more practice. The end result is more efficient and resilient use of SAS Enterprise Guide in a wider variety of business areas. Included is a discussion of the following subject areas: the Output Delivery System advanced formatting macro variables and macros advanced reporting using PROC REPORT highlighting in reports hyperlinking between reports and graphs data manipulation using SQL data manipulation using the DATA step extended graphics By adding small amounts of code in key areas, SAS Enterprise Guide users can get more out of the product than the tasks reveal. Users should be familiar with the SAS Enterprise Guide user interface and tasks. No programming experience is necessary.

Web analytics is the process of measuring your web site, analyzing the data, and making changes based on the analysis. Many businesses are just starting to learn how they can increase the performance of their web site by using web analytics. For many people, their first exposure to web analytics is Google Analytics, a free tool available to everyone. Although analysis is vital to web analytics, you can't do analysis without good data. Configuring Google Analytics correctly is the key to collecting good data. This Short Cut provides a thorough description of how the Google Analytics system works, information about many different types of implementations, and ways to avoid common pitfalls. It also shares some best practices to get your setup correct the first time.

It's sometimes said that the true job of an Oracle database administrator can be summed up in one, essential skill: to be able to recover your database. There's much wisdom in that statement. Of all the things you are responsible for as a database administrator, nothing is more important than the data itself. Like it or not, the fearsome responsibility of protecting your organization's most critical data falls squarely upon your shoulders: Lose that data and your company could fail. Lose that data and you could be out of a job. Scared? You should be. But there's help. You are not alone. Oracle experts Darl Kuhn, Sam Alapati, and Arup Nanda have come together in this book to show you the power of Recovery Manager, or RMAN, which is Oracle's backup and recovery tool of choice. RMAN Recipes for Oracle Database 11g helps you take advantage of all that RMAN has to offer by providing easy-to-understand solutions to business-critical backup and recovery operations. This handy guide: Demystifies the steps required to protect your business data Provides ready-made and step-by-step solutions to simple and complex backup, restore, and recovery operations Is task-oriented, making it easy for you to find the solution to pressing backup and recovery problems Respects your time by providing example-based solutions, not endless reading material When the pressure's on, you don't have time for long discussions of theory. This book gets right to the point with quick and easy-to-read, step-by-step solutions that can help you backup and recover your data with confidence. What you'll learn Oracle Database experts Darl Kuhn, Sam Alapati, and Arup Nanda show you how to Reliably back up and recover your database using Oracle's Recovery Manager Utilize new Oracle Database 11g features such as the Data Recovery Advisor Let Oracle Database manage your backup files via the Flash Recovery Area Automate backup and recovery tasks by writing scripts Troubleshoot RMAN problems and optimize RMAN performance Interface with a Media Management Layer to manage your backup tape library Recover from the loss of a control file, loss of an online redo log, and other (hopefully!) unusual situations Who this book is for Oracle database administrators responsible for database backup and recovery operations.

Get started with PL/SQL, the built-in language that every Oracle developer and database administrator must know, in Beginning PL/SQL, a fast-paced and example-filled tutorial. Learn from author Don Bales extensive experience to discover the most commonly used aspects of PL/SQL, without wasting time with obscure and obsolete features. Bales takes his 20+ years of experience and a wealth of statistics he's gathered on PL/SQL usage over those years and applies the 80/20 rule: cover what's most needed and used by PL/SQL professionals and avoid what's not necessary! The result is a book that covers all the key features of PL/SQL without wasting your time discussing esoteric and obsolete parts of the language. Learn what really matters, so that you can get to work feeling confident with what you know about PL/SQL. Discover the 20% of PL/SQL that gives you 80% of the bang! Key topics covered include variables and datatypes, executing statements, working with cursors, real-world objects, debugging, testing, and more. Learn how to write production-level, object-oriented PL/SQL. You'll explore relational PL/SQL, but unlike most other books on the subject, this one emphasizes the use of PL/SQLs object-oriented features as well. Work through real examples of using of PL/SQL. You'll learn PL/SQL by applying it to real-world business problems, not by heavy theory.

Google Analytics 2.0 BONUS : Each copy of Google Analytics 2.0 includes a $25 Google AdWords gift card compliments of Google. With this $25 gift card , you can attract new customers to your website on Google's dime.

Service-oriented architecture (SOA) is one of the most important topics on the agenda of any IT person. SOA involves a new vision of how to design, develop, and manage applications. It also has new requirements when building an architecture for the underlying infrastructure. This IBM Redbooks publication is the result of a project managed in the IBM European Design Center, based in Montpellier, France. The scope of the project involved helping a major worldwide customer in the automotive industry to validate and justify an SOA implementation. In particular, the customer wanted to add new business values to work with its partners, by adding new data models. It also wanted to modernize an infrastructure, by adding new Internet interfaces. The customer faced the need to eradicate an obsolete programming language. Furthermore, it wanted to build a smooth migration path, with as few risks and costs as possible. The thought, planning, and architecture of the new system, which included integration of the SOA concepts, was built by the customer with the participation of Atos Origin, a leading international IT services provider. The existing customer IT infrastructure was already built around UNIX systems, IBM System z, non-IBM clusters, SAP solutions, 3270 screens, IMS-DL/I databases, and specific code. SOA was the right solution to connect this existing environment to new components using Java, Web services, and DB2 in particular. This book explores the business needs and the architectural choices that were faced by the customer. It describes the mock-ups and prototypes, provides performance numbers that were used to validate the decisions, and explains how they were implemented. It also suggests a generic and riskless solution to eradicate the obsolete programming language.