Publisher's Note: Products purchased from Third Party sellers are not guaranteed by the publisher for quality, authenticity, or access to any online entitlements included with the product. Master Oracle E-Business Suite's Oracle Procure-to-Pay Drive better decision making and maximize asset usage with Oracle E-Business Suite's comprehensive end-to-end procurement solution. This Oracle Press guide details, step-by-step, how to streamline and optimize your enterprise acquisition cycle using Oracle Procure-to-Pay. Set up and configure each module, generate contracts and purchase orders (POs), perform automatic invoicing, process payments, and enforce fiscal policies. You will also learn how to use powerful new purchasing and payables features. Manage POs and strengthen policy compliance using Oracle Purchasing Track documents from the buyers work center and demand workbench Centralize requisition creation and approvals Create and use sourcing rules for supplier purchases Use Oracle Payables to process invoices and handle settlements Consolidate and disburse funds using Oracle Payments Understand key setups for Oracle Purchasing, Oracle Payables, and Oracle Payments

SQL Server Profiler is one of the most useful of SQL Server's "built-in" tools, recording data about various SQL Server events. "Mastering SQL Server Profiler" will make it easier for you to learn how to use Profiler, analyze the data it provides, and to take full advantage of its potential for troubleshooting SQL Server problems. All the examples have been optimized to work with both SQL Server 2005 and 2008.

Publisher's Note: Products purchased from Third Party sellers are not guaranteed by the publisher for quality, authenticity, or access to any online entitlements included with the product. Get a Solid Foundation in Oracle Database Technology Master Oracle Database 11g 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 11g 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

Excel 2007 VBA Programming with XML and ASP offers a hands-on approach for those looking to extend and customize Excel functionality. From recording a simple macro and writing VBA code to working with XML documents and using ASP to access and display data, this book takes you on a programming journey that will change the way you work with Excel Learn how to: * Automate spreadsheet tasks with macros. * Write VBA code to program PivotTables, generate charts, build dialog boxes, and customize the Ribbon. * Handle errors and debug programs. * Create hyperlinks and publish HTML files. * Retrieve data from the web directly into Excel. * Develop and manipulate smart tags using XML.

SQL Server 2008 represents a sizable jump forward in scalability, performance, and usability for the DBA, developer, and business intelligence (BI) developer. It is no longer unheard of to have 20-terabyte databases running on a SQL Server. SQL Server administration used to just be the job of a database administrator (DBA), but as SQL Server proliferates throughout smaller companies, many developers have begun to act as administrators as well. Additionally, some of the new features in SQL Server are more developer-centric, and poor configuration of these features can result in poor performance. SQL Server now enables you to manage the policies on hundreds of SQL Servers in your environment as if you were managing a single instance. We've provided a comprehensive, tutorial-based book to get you over the learning curve of how to configure and administer SQL Server 2008. Whether you're an administrator or developer using SQL Server, you can't avoid wearing a DBA hat at some point. Developers often have SQL Server on their own workstations and must provide guidance to the administrator about how they'd like the production configured. Oftentimes, they're responsible for creating the database tables and indexes. Administrators or DBAs support the production servers and often inherit the database from the developer. This book is intended for developers, DBAs, and casual users who hope to administer or may already be administering a SQL Server 2008 system and its business intelligence features, such as Integration Services. This book is a professional book, meaning the authors assume that you know the basics about how to query a SQL Server and have some rudimentary concepts of SQL Server already. For example, this book does not show you how to create a database or walk you through the installation of SQL Server using the wizard. Instead, the author of the installation chapter may provide insight into how to use some of the more advanced concepts of the installation. Although this book does not cover how to query a SQL Server database, it does cover how to tune the queries you've already written. The first ten chapters of the book are about administering the various areas of SQL Server, including the developer and business intelligence features. Chapter 1 briefly covers the architecture of SQL Server and the changing role of the DBA. Chapters 2 and 3 dive into best practices on installing and upgrading to SQL Server 2008. Managing your SQL Server database instance is talked about in Chapter 4. This chapter also describes some of the hidden tools you may not even know you have. Once you know how to manage your SQL Server, you can learn in Chapter 5 how to automate many of the redundant monitoring and maintenance tasks. This chapter also discusses best practices on configuring SQL Server Agent. Chapters 6 and 7 cover how to properly administer and automate many tasks inside of the Microsoft business intelligence products, such as Integration Services and Analysis Services. Developers will find that Chapter 8 is very useful, as it covers how to administer the development features, such as SQL CLR. Chapter 9 explains how to secure your SQL Server from many common threats and how to create logins and users. Chapter 10 covers how to create a SQL Server project and do proper change management in promoting your scripts through the various environments. It also covers the Policy-Based Management framework in SQL Server. Chapters 11 through 15 make up the performance tuning part of the book. Chapter 11 discusses how to choose the right hardware configuration for your SQL Server in order to achieve optimal performance. After the hardware and operating system is configured, Chapter 12 shows you how to optimize your SQL Server instance for the best performance. Chapter 13 describes how to monitor your SQL Server instance for problematic issues such as blocking and locking. Chapters 14 and 15 discuss how to optimize the T-SQL that accesses your tables and then how to index your tables appropriately. Chapters 16 through 20 consist of the high-availability chapters of the book. Chapter 16 covers how to use the various forms of replication, while database mirroring is covered in Chapter 17. Classic issues and best practices with backing up and recovering your database are discussed in Chapter 18. Chapter 19 dives deeply into the role of log shipping in your high-availability strategy, and Chapter 20 presents a step-by-step guide to clustering your SQL Server and Windows 2008 server. This edition of the book covers all the same great information we covered in the last book, and we've added loads of new content for SQL Server 2008, which adds numerous new features to improve the DBA's life. In short, the new version of SQL Server focuses on improving your efficiency, the scale of your server, and the performance of your environment, so you can do more in much less time, and with fewer resources and people. This means you can manage many servers at one time using Policy-Based Management, scale your I/O load using compression, and collect valuable information about your environment using data collectors, to name just a few key new features. To follow the examples in this book, you will need to have SQL Server 2008 installed. If you wish to learn how to administer the business intelligence features, you need to have Analysis Services and the Integration Services components installed. You need a machine that can support the minimum hardware requirements to run SQL Server 2008; and you also need the AdventureWorks2008 and AdventureWorksDW2008 databases installed. Instructions for accessing these databases can be found in the ReadMe file on this book's Web site. Some features in this book (especially in the high-availability part) require the Enterprise or Developer Edition of SQL Server. If you do not have this edition, you will still be able to follow through some of the examples in the chapter with Standard Edition.

The ability to manage information is the key to businesses thriving in an increasingly competitive market. With FileMaker (R) Pro Business Applications, small business owners and workgroup managers can find out how to write custom database applications in order to add value to critical business information. After demonstrating how easily a database can be written using FileMaker Pro, this book presents a set of 11 business database case studies, all of which can be easily adapted by readers for their own data management requirements. The final section of the book offers ideas on deploying database solutions over a network and the web. Learn how to build a database and design layouts; create relationships between tables; automate tasks using scripts and buttons; secure data through the use of accounts and privileges; exchange data with other applications.

Beginners/Intermediate. The quickest and easiest way to learn Microsoft Access 2003. "Microsoft Access 2003 With Examples" is a step-by-step approach to building and maintaining your database. It is full of practical examples and tips. With screen-by-screen illustration you can learn fast. With examples and illustrations you can learn Microsoft Access 2003 and start building your own databases in no time. Master the essentials of designing and building a database. Create effective tables and queries. Create professional looking forms and reports. Import, export data from different sources and databases. Create web pages with your database. Secure your database from unauthorized users. Analyze your data.

Publisher's Note: Products purchased from Third Party sellers are not guaranteed by the publisher for quality, authenticity, or access to any online entitlements included with the product. Your One-Stop Guide to Enterprise Reporting with Crystal Reports 2008 Transform disconnected corporate data into compelling, interactive business intelligence using all of the powerful tools available in Crystal Reports 2008. Through detailed explanations, real-world examples, and expert advice, this comprehensive guide shows you how to create, maintain, and distribute dynamic, visually appealing enterprise database reports. Crystal Reports 2008: The Complete Reference explains how to select and gather pertinent business data, organize it into manageable groups, and assemble it into user-friendly business reports. You will learn how to improve report interactivity with sort controls and the parameter panel; solve complex reporting problems with cross-tabs and subreports; integrate Crystal Xcelsius dashboards; reduce development time; and publish your results to Web and Windows applications. Integrate pictures, multimedia files, graphs, and charts Allow user-controlled report sorting with new sort controls Develop sophisticated formulas and custom functions with the Formula Workshop Embed Flash files, including Xcelsius 2008 interactive dashboards Create complex cross-tab reports with new derived rows and columns Export reports into Word, Excel, Acrobat, and updated XML formats Enhance Web interactivity with the new parameter panel and optional parameter fields Work with SQL databases, OLAP cubes, and proprietary systems Centralize design elements and auto-update reports using the repository Schedule and distribute reports with the latest BusinessObjects Enterprise XI 3.0 Embed reports in Web and Windows applications using Visual Studio 2008

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 skillsNotes--Extra information related to the topic being coveredSelf-Tests--Chapter-ending quizzes to test your knowledgeAnnotated Syntax--Example code with commentary that describes the programming techniques being illustrated

Asynchronous JavaScript and XML (Ajax) is a web technique used to transfer data between a browser and server asynchronously without posting the web page to the server. "Asynchronously" implies that the processing of the web page continues while the Ajax request is sent to the server and a response is received from the server. The web page, or section(s) of the web page, is refreshed with the Ajax response without reposting the web page. Ajax has the following advantages over non-Ajax web applications.

- Reduced response time and reduced server load, as the complete web page is not reposted.

- Reduced bandwidth of web applications as only data is transferred and the HTML format is applied in the browser.

- Separation of data, format and style.

The book covers web search and RSS Feed with Ajax as well as form validation with Ajax frameworks for Java, JSP, JSF, and PHP. It discusses using Ajax in Oracle JDeveloper and is IDE based. JDeveloper has the following advantages over Eclipse IDE.

- JDeveloper 11g provides an integrated JavaScript Editor for Ajax/Web development.

- It also provides a PHP extension.

- JDeveloper has a built-in support for JSF and for JDBC.

Publisher's Note: Products purchased from Third Party sellers are not guaranteed by the publisher for quality, authenticity, or access to any online entitlements included with the product. Build and manage a scalable storage infrastructure with Oracle Automatic Storage Management Streamline data management and provisioning using Oracle Automatic Storage Management (Oracle ASM) and the detailed information contained in this exclusive Oracle Press resource. Written by a team of database experts, Oracle Automatic Storage Management: Under-the-Hood & Practical Deployment Guide explains how to build and maintain a dynamic, highly available Oracle database storage environment. Inside, you'll learn how to configure storage for Oracle ASM, build disk groups, use data striping and mirroring, and optimize performance. You'll also learn how to ensure consistency across server and storage platforms, maximize data redundancy, and administer Oracle ASM from the command line. Manage Oracle ASM Instances and configure Oracle RDBMS instances to leverage Oracle ASM Define, discover, and manage disk storage under Oracle ASM Create external, normal-redundancy, and high-redundancy disk groups Add and remove Oracle ASM storage without affecting RDMS instance availability Learn how Oracle ASM provides even I/O distribution Work with Oracle ASM directories, files, templates, and aliases Improve storage performance and integrity using the ASMLIB API Simplify system administration with the Oracle ASM command line interface Understand key internal Oracle ASM structures and algorithms

This is a practical guide to working with the Oracle 10g v10.2 database from Visual Studio .NET 2005, using Oracle Data Provider for .NET and Oracle Developer Tools. ODP.NET optimizes Oracle database access from a .NET environment, allowing developers to leverage advanced Oracle database functionality, including Real Application Clusters, XML DB, and advanced security, using VB.NET, C#, or any .NET language. With many hands-on examples the book provides the in-depth information to use ODP.NET and Oracle Developer Tools from Visual Studio 2005. After introducing ODP.NET, it covers using SQL, PL/SQL, LOBs, and XML DB through ODP.NET; developing Web Applications, Web Services, and Mobile Applications; and finally Oracle Developer Tools for VS.NET. All the code examples use Visual Basic.NET 2005. This book is for professional .NET developers with a minimum knowledge of Oracle SQL and PL/SQL who need to work with and take full advantage of the Oracle Database 10g using Visual Studio 2005.

Do you have tons and tons of data on your computer but you're not quite sure how to make heads or tails of them-or even organize them? Are you using Access as spreadsheet rather than what it was really meant for? If you have trouble finding meaning in your data, then Access 2007 Forms & Reports for Dummies let you discover the wonders of this highly useful program. This no-nonsense guide gets right down to business by showing you the easy way to use this powerful tool. It gets you started with selective, targeted queries; forms that improve efficiency; and reports that communicate-while sparing you of any fancy language. This hands-on guide features clear, concise instructions that show you how to: * Orient yourself with forms and reports * Create and modify queries * Build and edit forms * Design and update reports * Troubleshoot queries, forms, and reports * Make your forms useful * Add multiple tables to forms * Add finishing touches to reports Thanks to the included references, Web sites, and informative tips, putting your data to good use has never been easier. You'll even add some pizzazz to your reports with handy suggestions on ways to wow your viewers. With Access 2007 Forms & Reports for Dummies, you will be creating effective queries, forms, and reports in no time!

Publisher's Note: Products purchased from Third Party sellers are not guaranteed by the publisher for quality, authenticity, or access to any online entitlements included with the product. SQL Server 2005 is Microsoft's next-generation data management and analysis software designed to deliver increased scalability, availability, and security to enterprise data and analytical applications while making them easier to create, deploy, and manage. Filled with practical solutions and real-world examples, this resource includes full details on: Enterprise data management capabilities, including security and clustering Powerful developer tools -- T-SQL, .NET CLR, XML, ADO.NET 2.0 Business Intelligence features, such as Integration Services, data warehousing, and reports

Designed to exploit Oracle 10g's SQL, this book takes a comprehensive look at Oracle 10g's analytical functions, MODEL statements, and regular expressions. In addition, the book covers collection objects and object-oriented structures and introduces new Oracle 10g topics such as XML and statistical functions. The authors' logical and developmental approach to query building includes a review of older Oracle tools to help in the transition to newer material. This text will teach the reader how to format result sets with SQL*Plus reporting tools; use aggregate functions for partitioning, ordering, and reporting; perform calculations with the MODEL statement; search within strings using regular expressions; work with collection objects; handle XML within SQL.

Targeting the data warehouse professional, this book provides tips on how to glean hidden trends and correlations from terabytes of Oracle data using proven tools such as SAS and ODM. Instructions for performing complex predictive analysis are also included.

Gain the Competitive Edge with the Ultimate Resource on BusinessObjects XI Release 2.

. Publish actionable business reports across your enterprise using BusinessObjects XI and the detailed information contained in this one-stop resource. "BusinessObjects XI: The Complete Reference" explains, step-by-step, how to design and build powerful universes, integrate security, execute efficient queries, and distribute the results..

. You'll learn how to create an implementation strategy that fits your business goals, define and manage users, and integrate your reports into Web and Windows applications. All of the new and updated features of BusinessObjects XI Release 2 are covered in full detail, including the new architecture, Designer, security through the Central Management Console, InfoView, Web Intelligence, Desktop Intelligence, report scheduling, and auditing usage..

. Develop a visionary BusinessObjects XI deployment strategy. Migrate existing deployments to BusinessObjects XI Release 2. Use Designer to create robust universes aligned with the business goals that empower users to answer their own questions. Design and implement security policies that fit your company's needs. Monitor system usage and develop deployment practices for mission-critical BI. Translate complex business questions into simple, efficient Web Intelligence queries. Design reports that facilitate insight with richly formatted tables, charts, alerters, and report formulas. Reach more users with the power of interactive reports to dynamically sort, filter, rank, and drill through to detail at a simple mouse-click

The essential reference for PL/SQL has been revised and expanded, featuring all new examples throughout based on the new Oracle Database 10g sample schema plus a CD with all the book’s code as well as development environments. Written by a senior member of the technical staff on the Diagnostics and Defect Resolution (DDR) team in Oracle’s Server Technologies Division.

This unique book focuses on removing the guesswork from creating dynamic web pages with Oracle content. Packed with working code examples, this book shows working examples of connecting to Oracle and delivering data into an HTML page. This indispensable reference shows working examples of complex Oracle queries in PHP, updating Oracle from PHP, and passing parameters to a PHP program.

"This book should satisfy those who want a different perspective than the official Oracle documentation. It will cover all important aspects of a data warehouse while giving the necessary examples to make the reading a lively experience."
- Tim Donar, Author and Systems Architect
for Enterprise Data Warehouses
Tuning a data warehouse database focuses on large
transactions, mostly requiring what is known as throughput. Throughput is the passing of large amounts of information through a server, network
and Internet environment, backwards and forwards, constantly! The ultimate objective of a data warehouse is the production of meaningful and useful reporting, from historical and archived data. The trick is to make the reports print within an acceptable time frame.
A data model contains tables and relationships between tables. Tuning a data model involves Normalization and Denormalization. Different approaches are required depending on the application, such as OLTP or a Data Warehouse. Inappropriate database design can make SQL code impossible to tune. Poor data modeling can have a most profound effect on database performance since all SQL code is constructed from the data model.
* Takes users beyond basics to critical issues in running most efficient data warehouse applications
* Illustrates how to keep data going in and out in the most productive way possible
* Focus is placed on Data Warehouse performance tuning

Your Oracle career starts here! Ideal for those new to Oracle technology, this officially authorized entry-level book shows new DBAs various methods for backup and recovery--including Recovery Manager (RMAN). Includes hands-on exercises and end-of-chapter reviews to reinforce just-learned concepts.

Publisher's Note: Products purchased from Third Party sellers are not guaranteed by the publisher for quality, authenticity, or access to any online entitlements included with the product. Troubleshoot, tune, and optimize your Oracle database efficiently and successfully every time This book explains how to take full advantage of the revolutionary Oracle Wait Interface to quickly pinpoint--and solve--core problems and bottlenecks, and increase productivity exponentially.

Oracle security expert David Knox explains how to design and develop an integrated, secure Oracle environment.
“In my experience in the security world, including 32 years at the Central Intelligence Agency, I’ve not found anyone with more experience in the theory and practice of protecting your data than David Knox.” --Dave Carey, former Executive Director of the CIA

Includes information that every Oracle administrator and programmer must know to maximize uptime and recover data without compromising mission critical systems.

This book is the ultimate field guide for every SQL Server DBA’s laptop bag. Don’t go onsite without it! Covers the most commonly used SQL Server database versions. Handy, easy-to-find information includes security, database creation and management, restoration and recovery, automating SQL Server administration, monitoring performance, tuning, and much more.