CRYSTAL REPORTS® 2008 OFFICIAL GUIDE Whether you’re a DBA, data warehousing or business intelligence professional, Every significant enhancement introduced in Crystal Reports 2008 is covered, including its new visualization options and more robust Web services capabilities. The book concludes by showing how to use Crystal Reports’ powerful .NET and Java SDKs to customize and extend enterprise reporting in virtually unlimited ways. • Learn hands-on, through step-by-step examples and exercises–and discover tips and tricks proven in real-world enterprise environments • Master new Crystal Reports 2008 features, including interactive report viewing, Xcelsius dashboarding, Flex, and Flash integration, Report Designer improvements, report bursting, and more • Publish professional-quality reports against virtually any data source, including relational and OLAP databases, Universes, SAP, PeopleSoft, JavaBeans, .NET/COM objects, XML, and more • Discover advanced visualization techniques using Xcelsius, charts, and maps • Learn methods for distributing reports and integrating content into other applications • Learn about the latest reporting addition to the Business Objects family–Xcelsius and begin creating dynamic and interactive dashboards NEIL FITZGERALD has spent several years working at Business Objects and with one of Business Objects’ largest providers of custom BI and enterprise reporting solutions. BOB COATES currently works as a Sales Consultant for Business Objects, an SAP company, where he has been employed for more than eleven years. RYAN GOODMAN is the founder of Centigon Solutions, Inc., and remains one of the top Xcelsius experts and evangelists in the world. MICHAEL VOLOSHKO is a senior presales consultant for the financial services team at Business Objects. ON THE WEB Find all this and more at informit.com/sams: • Java and .NET sample reports and code samples for all examples in the book • Bonus chapters, tips, tricks, and links to great reporting resources CATEGORY: Database COVERS: Crystal Reports 2008, Crystal Reports Server 2008, Crystal Reports Viewer, crystalreports.com, Xcelsius 2008 USER LEVEL: Beginning–Intermediate informit.com/sams

Get a Solid Foundation in Oracle Database Technology Master Oracle Database 11 g fundamentals quickly and easily. Using self-paced tutorials, this book covers core database essentials, the role of the administrator, high availability, and large database features. Oracle Database 11g: A Beginner's Guide walks you, step by step, through database setup, administration, programming, backup, and recovery. In-depth introductions to SQL and PL/SQL are included. Designed for easy learning, this exclusive Oracle Press guide offers: Core Concepts--Oracle Database 11 g topics presented in logically organized chapters Critical Skills--Lists of specific skills covered in each chapter Projects--Practical exercises that show how to apply the critical skills learned in each chapter Progress Checks--Quick self-assessment sections to check your progress Notes--Extra information related to the topic being covered Mastery Checks--Chapter-ending quizzes to test your knowledge

If you’re a database administrator, you know Microsoft SQL Server 2008 is revolutionizing database development. Get up to speed on SQL Server 2008, impress your boss, and improve your company’s data management — read Microsoft SQL Server 2008 For Dummies! SQL Server 2008 lets you build powerful databases and create database queries that give your organization the information it needs to excel. Microsoft SQL Server 2008 For Dummies helps you build the skills you need to set up, administer, and troubleshoot SQL Server 2008. You’ll be able to: Develop and maintain a SQL Server system Design databases with integrity and efficiency Turn data into information with SQL Server Reporting Services Organize query results, summarizing data with aggregate functions and formatting output Import large quantities of data with SSIS Keep your server running smoothly Protect data from prying eyes Develop and implement a disaster recovery plan Improve performance with database snapshots Automate SQL Server 2008 administration Microsoft SQL Server 2008 For Dummies is a great first step toward becoming a SQL Server 2008 pro!

If you’re in charge of database administration, developing database software, or looking for database solutions for your company, Microsoft SQL Server 2008 All-In-One Desk Reference For Dummies can help you get a handle on this extremely popular relational database management system. Here you’ll find what’s new in the latest version; how to choose and install the right variation for your needs; how to monitor, maintain, and protect your data; and what it takes to keep your database healthy. You’ll discover how to: Build and maintain tables Design a database and communicate with it Retrieve, analyze, and report data Build solid, robust database applications Use the SQL Server Optimizer and Query Designer Navigate SQL Server with Visual Studio Develop useful reports with the Report Builder and Report Designer Create Business Intelligence solutions with Business Intelligence Development Studio Configure your server and perform major administrative tasks To help you quickly find what you need, Microsoft SQL Server 2008 All-In-One Desk Reference For Dummies is divided into nine minibooks: Essential Concepts Designing and Using Databases Interacting With Your Data Database Programming Reporting Services Analysis Services Performance Tips and Tricks Database Administration Appendixes Microsoft SQL Server 2008 All-In-One Desk Reference For Dummies gets you started, helps you solve problems, and will even answer your questions down the road!

Application Express, or APEX, is one of the most innovative products to come out of Oracle in years. APEX is an application development framework for developing database–backed applications. It's easy enough to get started in that power users can quit storing data in random spreadsheets and instead centralize their data in the powerful Oracle database, all without developer help. Developers aren't left out, however. Those who choose to do so can go deep and leverage the full power and flexibility of Oracle's database engine. Getting started with APEX is easy; learning how to take full advantage of APEX is the problem. It was the problem, that is, until this book came along. In Pro Oracle Application Express, authors John Scott and Scott Spendolini open the "hood" of APEX and expose the full power behind its easy–to–use GUI. They show you what you need to know to produce powerful, professionally polished applications—such as user-authentication models, approaches to layout and navigation, how to integrate Ajax, how to deal with localization issues such as time zones and translations, how to customize the look and feel of an APEX web site, and much, much more. The authors are well–qualified to write on APEX. John Scott runs ShellPrompt, a hosting service that handles many large-scale APEX applications, some of which he is paid to develop. John is a hard–core APEX developer. His co-author, Scott Spendolini, is one of the original creators of APEX. Both John and Scott now base their full-time careers on developing APEX applications. Pro Oracle Application Express is your opportunity to learn APEX from the very best.

Get the practical, pocket-sized guide for IT professionals who need to administer, maintain, and optimize SQL Server 2008. Written by award-winning author William Stanek, this portable reference delivers essential details for using SQL Server 2008 to help protect and manage your company s data whether automating tasks, creating indexes and views, performing backups and recovery, replicating transactions, tuning performance, managing server activity, importing and exporting data, or performing other key tasks. Featuring quick-reference tables, lists, and step-by-step instructions, this handy, one-stop guide provides fast, accurate answers on the spot whether you re at your desk or in the field! Key Book Benefits Provides fast facts and immediate reference for administering SQL Server 2008 Delivers must-know details for taking advantage of the improved scalability, security features, and management tools in SQL Server 2008 Features concise tables, easy-to-scan lists, and step-by-step instructions for fast answers, wherever you need them

SQL for the Real World Don’t just learn “generic” SQL. Learn SQL to get results with the world’s top database platforms–Oracle for the enterprise and Microsoft Access for the desktop. Based on John Patrick’s hands-on SQL course at the University of California, Berkeley Extension, this book shows exactly how to retrieve the data you want, when you need it, in any application–from ad hoc reports to the data warehouse. Thoroughly updated for the newest versions of Oracle, Access, and the SQL standard, this book contains more exercises, techniques, and solutions than ever before. You’ll learn exactly how to write SQL queries that are easy to understand, verify, modify, and extend–even if you’ve never worked with databases before. teaches you how to SQL Fundamentals,Third Edition, Build simple statements to retrieve, store, or modify data Craft complex queries that draw information from multiple tables Sort and summarize your data just the way you want it Create and edit your own tables Protect the integrity of your data Create more efficient, high-performance queries Work with unions, subqueries, self joins, cross joins, inner joins, and outer joins Use the Oracle Data Dictionary About the Web Site The accompanying Web site, https://www.box.com/shared/ylbckg2fn0 , contains all the SQL code and tables from the book, including the full databases for several versions of Access and code for building the corresponding Oracle databases. It also provides solutions to many of the book’s problems and an open area for discussions with the author and other readers.

Choice is usually a good thing for consumers but it can be difficult to navigate the landscape of Open Source ESBs. I believe this book is extremely valuable for readers looking to choose an ESB and looking to get a stronger grasp on how to implement an ESB using open source projects. I found the case studies in section III particularly useful since they pull together many of the concepts learned throughout the book. This book guides the reader through a logical journey of discovery and demonstration to deliver a solid understanding of the core ESB concepts and how they can be used in the real world. Armed with this book and the wealth of open source projects available I think the reader will be ready to take on any ESB project. Open Source made ESBs a lot more fun, go and enjoy yourself! —From the Foreword by Ross Mason, Creator of the Mule Project Open-Source ESBs in Action describes how to use ESBs in real-world situations. You will learn how the various features of an ESB such as transformation, routing, security, connectivity, and more can be implemented on the example of two open-source ESB implementations: Mule and ServiceMix. The authors first introduce ServiceMix and Mule, and then present general principles and patterns of ESB use, as well as a structured approach to solving common integration problems, through examples using them. About the Technology The need for enterprise integration is widespread for the simple reason that businesses require independent applications to exchange information with each other. A CRM application must know about the order history of a customer, but that history is stored in the sales application. A technology that companies increasingly use to integrate enterprise applications is the Enterprise Service Bus (ESB). About the Book Working in integration projects is exciting, with new technologies and paradigms arriving every day. In this area, open source is playing a more and more dominant role with projects such as Mule and ServiceMix. Open-Source ESBs in Action will help you to learn open-source integration technologies quickly and will provide you with knowledge that you can use to effectively work with Mule and ServiceMix. What's Inside Numerous code examples Detailed explanation on how to use Mule and ServiceMix Practical, real-world examples and case studies Integration with a full open source tool stack About the Reader About the Authors Tijs Rademakers is a software architect with more than six years of experience in designing and developing Java and EE applications. He works for Atos Origin, a large European system integrator, where he is responsible for SOA and BPM services and knowledge development. Tijs has designed and implemented large process- and application-integration solutions, primarily focused on open standards. He has extensive product knowledge of open source as well as closed source SOA and enterprise integration tools, including Mule, ServiceMix, jBPM, and WebSphere Process Server. Tijs is a regular speaker at Java conferences, where he talks about open source integration topics like Mule and ServiceMix. Tijs lives in the Netherlands near Eindhoven with his girlfriend and his new daughter, Liv. Jos Dirksen has been working with Java and J2EE applications for more than six years as a software architect. The last couple of years, his focus topics have been open source, security, and quality. He has worked with various open source and commercial integration solutions, mostly in the government and the healthcare areas. Jos has a lot of project experience working with Mule, Apache Synapse, and Apache Axis2 and has also completed projects based on the integration tooling from IBM. Jos regularly gives presentation on open source, Mule, and other related topics. He lives in Eindhoven, the Netherlands, with his wife. Quotes A great book for any ESB practitioner. - Rick Wagner, Acxiom Corporation A must-have ESB resource! - Craig Borysowich, Imagination Edge, Inc. The most comprehensive content that I've seen on open source ESBs. - Rodney Biresch, Chariot Solutions The Bible for integration architects. - Davide Piazza, Omnys s.r.l. ...ample code samples and excellent descriptions. - Jeff Davis, HireRight, Inc. This book will take you to a new level. - Christian Siegers, Stater International Mortgage Services

Essential Skills--Made Easy! Written to the SQL:2006 ANSI/ISO standard, this easy-to-follow guide will get you started programming in SQL right away. You will learn how to retrieve, insert, update, and delete database data, and perform management and administrative functions. SQL: A Beginner's Guide, Third Edition covers new features, including SQL/XML, and is loaded with updated SQL examples along with notes on using them with the latest RDBMS software versions such as MySQL 5.0, SQL Server 2008, and Oracle Database 11g. Designed for Easy Learning: Key Skills & Concepts--Lists of specific skills covered in the chapter Ask the Experts--Q&A sections filled with bonus information and helpful tips Try This--Hands-on exercises that show how to apply your skills Notes--Extra information related to the topic being covered Self-Tests--Chapter-ending quizzes to test your knowledge Annotated Syntax--Example code with commentary that describes the programming techniques being illustrated

The Definitive Guide to Using, Programming, and Administering MySQL 5.0 and 5.1 MySQL is an open source relational database management system that has experienced a phenomenal growth in popularity and use. Known for its speed and ease of use, MySQL has proven itself to be particularly well-suited for developing database-backed websites and applications. In MySQL, Paul DuBois provides a comprehensive guide to using and administering MySQL effectively and productively. He describes everything from the basics of getting information into a database and formulating queries, to using MySQL with PHP or Perl to generate dynamic web pages, to writing your own programs that access MySQL databases, to administering MySQL servers. The fourth edition of this bestselling book has been meticulously revised and updated to thoroughly cover the latest features and capabilities of MySQL 5.0, as well as to add new coverage of features introduced with MySQL 5.1. “One of the best technical books I have read on any subject.” –Gregory Haley, C Vu, The Association of C & C++ Users “A top-notch user’s guide and reference manual, and in my opinion, the only book you’ll need for the daily operation and maintenance of MySQL databases.” –Eugene Kim, Web Techniques Introduction 1 Part I: General MySQL Use Chapter 1: Getting Started with MySQL 13 Chapter 2: Using SQL to Manage Data 101 Chapter 3: Data Types 201 Chapter 4: Stored Programs 289 Chapter 5: Query Optimization 303 Part II: Using MySQL Programming Interfaces Chapter 6: Introduction to MySQL Programming 341 Chapter 7: Writing MySQL Programs Using C 359 Chapter 8: Writing MySQL Programs Using Perl DBI 435 Chapter 9: Writing MySQL Programs Using PHP 527 Part III: MySQL Administration Chapter 10: Introduction to MySQL Administration 579 Chapter 11: The MySQL Data Directory 585 Chapter 12: General MySQL Administration 609 Chapter 13: Access Control and Security 699 Chapter 14: Database Maintenance, Backups, and Replication 737 Part IV: Appendixes Appendix A: Obtaining and Installing Software 777 Appendix B: Data Type Reference 797 Appendix C: Operator and Function Reference 813 Appendix D: System, Status, and User Variable Reference 889 Appendix E: SQL Syntax Reference 937 Appendix F: MySQL Program Reference 1037 Note: Appendixes G, H, and I are located online and are accessible either by registering this book at informit.com/register or by visiting www.kitebird.com/mysql-book. Appendix G: C API Reference 1121 Appendix H: Perl DBI API Reference 1177 Appendix I: PHP API Reference 1207 Index 1225

Praise for The Truth About Identity Theft “This book will open your eyes, scare you smart, and make you think twice. Identity theft can happen to you and this book is a must read. Jim Stickley tells you why and how you need to protect yourself.” Matt Lauer, Anchor, TODAY Show "Nowadays, identity theft is an all-too-common occurrence that puts more than just your finances in jeopardy. Fortunately, Jim Stickley's easy-to-understand advice can teach you how to spot and stay ahead of security threats. In short, this book is a must read." Wes Millar, Senior Vice President of CUNA Strategic Services "In an age when identity theft will affect everyone sooner or later, this book is simply a must-read. Jim Stickley teaches you to spot the danger signs and offers smart solutions for everything from banking security and online shopping scams to medical identity theft. Whether it's you, your parents', or your kids' identities, everyone has something to protect. This book tells you what you need to know." Jim Bell, Executive Producer, TODAY Show "Jim Stickley shares his amazing experiences as a professional hacker in the most entertaining manner. He’s a great storyteller and captures your attention with his experiences, which will make you want to upscale your efforts protect your firm’s data and your own ID. Jim’s stories are fascinating. Most of us can’t imagine how simple it is for him to succeed as a conman in situations we think are safe. The trade secrets of hackers he shares with us are mind boggling! You won’t let your guard down after learning what Jim has actually done to get companies and individuals' private information. He’s the updated version of 'To Catch a Thief'[el]but he’s a good guy!" Nancy E. Sheppard, President & CEO of Western Independent Bankers (A Trade Association of 350 Banks) "If you’re not worried about identity theft, you should be[el]and Stickley tells you exactly why. His engaging writing style, coupled with real-life stories about identity theft and concrete actions to help you prevent identity theft are exactly what’s needed to make people take notice of this growing crime. I’ll recommend this book again and again!" Jerri L. Ledford, About.com Guide to Identity Theft Everything you must know to protect yourself and your business from identity thieves! • The truth about real-world identity theft attacks • The truth about how easy it is for thieves to make off with your identity • The truth about stopping identity thieves in their tracks Jim Stickley has stolen credit cards, hacked Social Security numbers, robbed banks, and created fake ATMs. He has broken into armed government facilities and has stolen from teenagers. He is an identity thief, but he is no criminal. Fortunately for all victims involved, Jim was hired to perform these attacks by corporations testing their security, news agencies investigating security concerns, and other media outlets interested in knowing just how easy it is to commit identity theft. His job is to find security flaws before the real criminals find them. This book has been designed to give you the insight that most people only experience after becoming victims of identity theft. Each Truth walks you through a different type of attack, explaining the complete process in a very simple and straight-forward way. Like a magician actually revealing what happens behind the curtain, Jim takes you through the attacks to reveal how people at home, work, and on the road become victims. Prepare yourself. What you read here might be disturbing, but you will never be truly safe from identity thieves until you learn to think like one.

IBM's DB2 Express Edition is one of the most capable of the free database platforms available in today's marketplace. In Beginning DB2, author Grant Allen gets you started using DB2 Express Edition for web sites, desktop applications, and more. The author covers the basics of DB2 for developers and database administrators, shows you how to manage data in both XML and relational form, and includes numerous code examples so that you are never in doubt as to how things work. In this book, you'll find: A friendly introduction to DB2 Express Edition, an industrial-strength, relational database from IBM Dozens of examples so that you are never in doubt as to how things work Coverage of important language interfaces, such as from PHP, Ruby, C#, Python, and more The book is aimed at developers who want a robust database to back their applications.

Learn effective and scalable database design techniques in a SQL Server environment. Pro SQL Server 2008 Relational Database Design and Implementation covers everything from design logic that business users will understand, all the way to the physical implementation of the design in a SQL Server database. Grounded in best practices and a solid understanding of the underlying theory, authors Louis Davidson, Kevin Kline, Scott Klein, and Kurt Windisch show how to 'get it right' in SQL Server database design and lay a solid groundwork for the future use of valuable business data. Solid foundation in best practices and relational theory Maximize SQL Server features to enhance security, performance, scalability Thorough treatment from conceptual design to an effective, physical implementation What you'll learn Develop conceptual models of client data using interviews and client documentation Normalize data models to enhance scalability and the long term use of valuable data Translate conceptual models into high-performing SQL Server databases Secure and protect the integrity of data as part of meeting regulatory requirements Take full advantage of new SQL Server features such as the spatial datatype, XML support, transparent data encryption, and more Create effective indexing to speed query performance Who this book is for Pro SQL Server 2008 Relational Database Design and Implementation is designed for programmers of all types who want to use SQL Server 2008 to store data. Rookie database programmers will find a complete course on the fundamentals of database design that includes conceptual designs and physical implementation. Seasoned veterans will find many tips and tricks for implementing database systems that will be well worth the time invested in reading this book.

Take full advantage of everything SQL Server 2008 Reporting Services has to offer and deliver customizable, web–enabled reports across your business at a reasonable cost. Learn best–practices from professionals who use SQL Server Reporting Services daily to deliver solutions to paying clients and gain the competitive edge on using Microsoft's enterprise–level reporting platform. Provides best–practices for using Reporting Services Written by practicing professionals with paying clients Your key to delivering business intelligence across the enterprise

Third Edition: Thoroughly Updated and Expanded, with Extensive New Coverage! In just 24 sessions of one hour or less, you’ll master the entire SAP project lifecycle, from planning through implementation and system administration through day-to-day operations. Using this book’s straightforward, step-by-step approach, you’ll gain a strong real-world foundation in both the technology and business essentials of today’s SAP products and applications— from the ground up. Step-by-step instructions walk you through the most common questions, issues, and tasks you’ll encounter with SAP. Case study-based exercises help you build and test your knowledge. By the Way notes present interesting pieces of information. Did You Know? tips offer advice or teach an easier way. Watch Out! cautions warn about potential problems. Learn how to… Understand SAP’s newest products for enterprises and small-to-midsize businesses, and choose the right solutions for your company Discover how SAP integrates with Web services and service-oriented architecture Develop an efficient roadmap for deploying SAP in your environment Plan your SAP implementation from business, functional, technical, and project management perspectives Leverage NetWeaver 7.0 features to streamline development and integration, and reduce cost Walk through a step-by-step SAP technical installation Master basic SAP system administration and operations Perform essential tasks such as logon, session management, and printing Build SAP queries and reports Prepare for SAP upgrades and enhancements Develop your own personal career as an SAP professional Register your book at informit.com/title/9780137142842 for convenient access to updates and corrections as they become available.

A study of cryptologic documents dealing with the issue of American pre-knowledge of the Pearl Harbor attack.

Chris Date, one of the founders of the relational model, has updated and expanded his relational database dictionary to include more than 900 terms.

IBM Information Server is a revolutionary new software platform that helps organizations derive more value from the complex heterogeneous information spread across their systems. It enables organizations to integrate disparate data and deliver trusted information wherever and whenever needed, in line and in context, to specific people, applications, and processes. IBM InfoSphere™ DataStage® is a critical component of the IBM Information Server, and the parallel framework of IBM InfoSphere DataStage is also the foundation for IBM InfoSphere QualityStage and IBM InfoSphere Information Analyzer components. This IBM® Redbooks® publication develops usage scenarios that describe the implementation of IBM InfoSphere DataStage flow and job design with special emphasis on the new features such as the distributed transaction stage (DTS) in Version 8.0.1, slowly changing dimensions stage ( Version 8.0.1), complex flat file stage (Version 8.0.1), and access to mainframe data.

Running your own Boarding Kennels is the only guide of its kind which looks at every aspect of running a boarding kennels or cattery, from selecting premises to feeding boaders.

The Definitive Guide to Microsoft SQL Server 2008 Reporting Services Create and deliver data-rich reports across the enterprise using this complete server-based reporting solution. Written by a member of the original Reporting Services development team, Microsoft SQL Server 2008 Reporting Services covers the entire report-building and distribution process, including data extraction, integration with desktop and Web applications, and end-user access. The book explains how to maximize all of the powerful features, including the new Tablix data format, as well as enhanced performance, scalability, and visualization capabilities. Install, configure, and customize SQL Server 2008 Reporting Services Create SELECT queries to extract data Generate reports from the Report Wizard and from scratch Add charts, images, and gauges Build reusable report templates Use the new Tablix data format to create reports with any structure Export reports to Word, Excel, PDF, HTML, XML, and other formats Enable end-user access to reports via the Report Server and its Report Manager web interface