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. Ramp Up Your PL/SQL Programming SkillsMaster PL/SQL through the hands-on exercises, extensive examples, and real-world projects inside this Oracle Press guide. Filled with best practices, Oracle Database 11g PL/SQL Programming Workbook covers all the latest features and enhancements of the language. Mastery checks at the end of each chapter reinforce the material covered, and sample code from the book is available for download. Even experienced Oracle professionals will benefit from this practical resource. Understand the Oracle development architecture and the mechanics of connections Work with data types, structures, blocks, cursors, and PL/SQL semantics Write, deploy, and use functions, procedures, and packages Manage transactions and more Use dynamic SQL statements in real-world applications Support online transaction processing and data warehousing applications with external tables Find syntax samples and best practices to solve problems Write, deploy, and use object types For a complete list of Oracle Press titles, visit www.OraclePressBooks.com

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 Data Guard 11g Provide superior data protection, availability, and disaster recovery using the tested techniques in this Oracle Press guide. Cowritten by a team of Oracle experts, Oracle Data Guard 11g Handbook provides a sound architectural foundation along with best practices for configuration, monitoring, maintenance, and troubleshooting. You will get full details on implementing deployment architectures to address requirements that extend beyond disaster recovery. This invaluable resource also includes a complete set of monitoring scripts available for download. Develop a disaster recovery plan for your Oracle database to meet your organization's requirements Configure and deploy Oracle Data Guard for your environment Tune and troubleshoot your physical and logical standby databases Implement the Oracle Data Guard Broker management framework Integrate with Oracle Grid Control Monitor your Oracle Data Guard environment Enable read-only services and disaster recovery with Oracle Active Data Guard Configure seamless database and application failover Minimize planned downtime using Oracle Data Guard switchover Handle backup and recovery with Oracle Recovery Manager

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 General Ledger Maintain a centralized, highly automated processing platform across a fully integrated set of Oracle E-Business Suite applications using Oracle General Ledger. This Oracle Press guide explains how to utilize Oracle General Ledger to distribute timely and accurate financial information enterprise-wide. Learn efficient techniques for creating transactions and budgets, defining custom rules and flows, reconciling balances, and easing regulatory compliance. You will also discover how to consolidate financial data, process foreign currencies, and implement the brand-new Oracle Subledger Accounting. Plan, test, and carry out a new implementation or upgrade Work with ledgers, calendars, journals, budgets, and business flows Convert and load data from external systems and spreadsheets Perform company-wide consolidations Render reports using the Financial Statement Generator Handle foreign transactions, translations, and revaluations Centralize accounting rules using Oracle Subledger Accounting Understand implications of setup and implementation decisions

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. Design and Deliver PeopleSoft Enterprise Resource Planning Solutions Develop data-driven Oracle PeopleSoft applications and business intelligence reports with help from the expert advice in this Oracle Press guide. PeopleSoft Developer's Guide for PeopleTools & PeopleCode shows you how to build and enhance PeopleSoft modules that maximize return on investment. Set up PeopleSoft Pure Internet Architecture, create PeopleCode projects, integrate HTML and Web features, and create reports with Oracle XML Publisher. You will also learn how to use COBOL, SQR, PeopleSoft Application Engine, and Middleware integration. Install and configure PeopleSoft Pure Internet Architecture Work with PeopleCode components, objects, and classes Build pages and modules using the PeopleTools application designer Add HTML and Web elements in PeopleCode Implement code on the middle tier tools and work with process manager Execute powerful batch processes with application engine Generate detailed reports using Oracle XML Publisher and SQR Debug, secure, and optimize your PeopleSoft applications

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. Maximize the Business Intelligence Tools in Microsoft SQL Server 2008 Manage, analyze, and distribute enterprise data with help from this expert resource. Delivering Business Intelligence with Microsoft SQL Server 2008 covers the entire BI lifecycle and explains how to build robust data integration, reporting, and analysis solutions. Real-world examples illustrate all of the powerful BI capabilities of SQL Server 2008. This is your one-stop guide for transforming disparate data into actionable insight for users throughout your organization. Understand the goals and benefits of business intelligence Design and create relational data marts and OLAP cubes Manage Analysis Services databases using BI Development Studio Cleanse data and populate data marts with SQL Server Integration Services Take advantage of the flexibility of the Unified Dimensional Model Manipulate and analyze data using MDX scripts and queries Use data mining to identify data patterns, correlations, and clustering Develop and distribute interactive reports with SQL Server 2008 Reporting Services Integrate business intelligence into enterprise applications using ADOMD.NET and the Report Viewer Control

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 Oracle CRM On Demand Reporting Plan, build, and distribute data-rich business intelligence reports with ease. Oracle CRM On Demand Reporting details the entire report-building process and explains how to use the powerful features available in Answers On Demand to create and share comprehensive, integrated reports. The book includes proven strategies for report design and development, real-world examples, formatting tips, advanced reporting techniques, and sample formulas. Convert disparate corporate data into actionable business intelligence with help from this detailed guide. Maximize the features of Answers On Demand Strategically plan your reports Format, sort, filter, and modify report data Use column formulas with numeric, date and time, and text data Apply logic and transform data with column formulas Format report title and table views Add charts, graphs, pivot tables, filter prompts, and interactivity to reports Configure advanced views and create custom dashboards Manage reports and control access

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 Started on Microsoft SQL Server 2008 in No Time Learn to use all of the powerful features available in SQL Server 2008 quickly and easily. Microsoft SQL Server 2008: A Beginner's Guide explains the fundamentals of each topic alongside examples and tutorials that walk you through real-world database tasks. Install SQL Server 2008, construct high-performance databases, use powerful Transact-SQL statements, create stored procedures and triggers, and execute simple and complex database queries. Performance tuning, Database Engine security, Business Intelligence, and XML are also covered. Set up, configure, and maintain SQL Server 2008 Build and manage database objects using Transact-SQL statements Create stored procedures and user-defined functions Optimize database performance, availability, and reliability Implement solid security using authentication, encryption, and authorization Automate tasks using SQL Server Agent Create reliable data backups and perform flawless system restores Use all-new SQL Server 2008 Business Intelligence, development, and administration tools Learn in detail the SQL Server XML technology (SQLXML)

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 Hands-On Guide to SAP ERP Sales & Distribution Written by senior SAP consultant Glynn Williams, Implementing SAP ERP Sales & Distribution is packed with tested, time-saving tips and advice. Learn how to use SAP ERP Central Component 5.0 and 6.0 to create sales documents and contracts, control material and customer master data, schedule deliveries, and automate billing. You'll also find out how to deliver robust financial and transactional reports, track customer and credit information, and interoperate with other SAP modules. Configure and manage the SAP ERP SD module Track sales, shipping, and payment status using master records Create multi-level sales documents and item proposals Develop contracts and rebate agreements Deliver materials and services requirements to the supply chain Plan deliveries, routes, and packaging using Logistics Execution Perform resource-related, collective, and self billing Generate pricing reports, incompletion logs, and hierarchies Handle credit limits, payment guarantees, and customer blocks Integrate user exits, third-party add-ons, and data sharing Configure pricing procedures and complex pricing condition types

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. Maximize the Capabilities of Oracle Collaboration Suite Facilitate enterprisewide communication, data sharing, and team work using Oracle Collaboration Suite 10g and the in-depth information contained in this Oracle Press guide. Oracle Collaboration Suite Handbook explains how to install, implement, manage, and optimize the suite in an enterprise environment. You'll discover how you can use this powerful tool to securely, reliably, and cost-effectively enable real-time collaboration, streamline business processes, simplify data distribution, and consolidate corporate information. Tailor a system-specific Oracle Collaboration Suite environment Install the Infrastructure Tier, Datastore Tier, and Applications Tier Perform successful migrations to Oracle Collaboration Suite 10g Create, manage, monitor, and delete user accounts with provisioning Control processes, components, and subcomponents from the command line and the Enterprise Manager Browser interface Perform reliable full and partial database backups and restores Monitor, analyze, and act on system log files Administer applications, application components, and program functionality Manipulate unstructured data using intelligent containers and Oracle Content Services

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. The Essential Resource for Oracle DBAs--Fully Updated and ExpandedManage a flexible, highly available Oracle database with help from the expert information contained in this exclusive Oracle Press guide. Fully revised to cover every new feature and utility, Oracle Database 11g DBA Handbook shows how to perform a new installation, upgrade from previous versions, configure hardware and software for maximum efficiency, and employ bulletproof security. You will learn to automate the backup and recovery process, provide transparent failover capability, audit and tune performance, and distribute your enterprise databases with Oracle Net. Plan and deploy permanent, temporary, and bigfile tablespaces Optimize disk allocation, CPU usage, I/O throughput, and SQL queries Develop powerful database management applications Guard against human errors using Oracle Flashback and Oracle Automatic Undo Management Diagnose and tune system performance using Oracle Automatic Workload Repository and SQL Tuning Sets Implement robust security using authentication, authorization, fine-grained auditing, and fine-grained access control Maintain high availability using Oracle Real Application Clusters and Oracle Active Data Guard Respond more efficiently to failure scenarios by leveraging the Oracle Automatic Diagnostic Repository and the Oracle Repair Advisor Back up and restore tables, tablespaces, and databases with Oracle Recovery Manager and Oracle Data Pump Export and Import Work with networked databases, data warehouses, and VLDBs Put the latest Oracle Database 11g tools to work--Oracle Total Recall, Oracle Flashback Data Archive, and more

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. FOREWORD by Tom Kyte Your Must-Have Guide to Everything New in Oracle Database 11g Realize the full potential of Oracle Database 11g with help from the experts. Written by Robert G. Freeman, and with insightful commentary throughout from Arup Nanda, this Oracle Press guide offers full details on the architectural changes, database administration upgrades, availability and recovery revisions, security enhancements, and programming innovations. Every new and updated feature is covered and presented with screenshots, code samples, tables, and charts. Find out how to take full advantage of all the new and improved capabilities of Oracle Database 11g, including: New Oracle Automatic Storage Management features, such as Fast Disk Resync, Compatibility Attributes, Preferred Mirror Read, and Rolling Upgrade components Improved Automated Memory Management capabilities New database design features, such as virtual columns, tablespace encryption, and true table-level data compression New Database Advisors for data recovery and repair, partitioning, and streams performance New tuning features, such as Automatic SQL Tuning and SQL Performance Analyzer Enhancements to Oracle RMAN, including active database duplication and UNDO backup optimization Improved auditing and security capabilities Advanced BI, data warehousing, and partitioning features New SQL and PL/SQL enhancements

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. The easiest way to set up a PostgreSQL database server on Windows Get up-and-running on PostgreSQL quickly using this hands-on guide. Filled with real-world examples, PostgreSQL 8 for Windows offers you practical, step-by-step details on installing, configuring, and using PostgreSQL 8--the full-featured, open-source database management system--on Windows platforms. You'll learn to administer, secure, and tune your database and use SQL. You'll also discover how to interface Microsoft Access, Microsoft .NET, Visual C++, and Java with the PostgreSQL database. Install and configure PostgreSQL 8 on Windows Customize your system using the configuration files Work with the utilities Administer your database from the pgAdmin III graphical interface Use the psql command line program to manually execute SQL commands Take advantage of built-in functions or create your own stored procedures and triggers Implement tested security measures Maintain optimal database performance Access a PostgreSQL database from a Microsoft Access application and migrate Access databases to PostgreSQL Create .NET, Visual C++, and Java applications that interface with your PostgreSQL server

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. Maintain a High-Performance Oracle Database 10g Environment Monitor, analyze, and optimize Oracle Database 10g using the tested methods and insider advice contained in this definitive volume. Written by Oracle Certified Master Richard Niemiec, Oracle Database 10g Performance Tuning Tips & Techniques is packed with detailed case studies, best practices, and code samples illustrating Oracle's new tuning features. Find out how to select optimal indexing options, effectively manage drives and disk arrays, troubleshoot queries, and reliably predict future performance. You'll also get detailed coverage of PL/SQL performance enhancements, initialization file tweaks, and the latest database surveying and reporting utilities.

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. Learn cutting-edge technology from Oracle expertsWritten by Oracle insiders, this comprehensive guide covers everything you need to know about Real Application Clusters -- low-cost hardware platforms that can rival and exceed the quality of service, availability, and scalability of the most expensive mainframe systems. Concepts covered are applicable to all previous versions of Oracle Tuning and troubleshooting tips, providing insight on the most advanced diagnostics available Detailed coverage of advanced RAC concepts Working code for all examples available online

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. The Most Complete Guide to Maximizing Oracle Recovery Manager Deploy a rock-solid data backup and disaster recovery strategy with the in-depth guidance of this authoritative volume. From the exclusive publishers of Oracle Press books, Oracle Database 10g RMAN Backup & Recovery shows you, step by step, how to set up RMAN-ready databases, create reliable backup tapes and discs, and perform accurate Oracle system restores. Find out how to use RMAN from the command line and from Enterprise Manager, generate meaningful lists and reports, and automate administrative tasks using third-party media management tools. Plus, you'll learn to perform incremental backups, Flashback recoveries, and database cloning. Set up, configure, and maintain Oracle Database 10g RMAN Use RMAN recovery catalogs, target database packages, and control files Centralize backup tape management using Oracle Secure Backup Perform online, offline, and incremental system backups Monitor and tune performance with Enterprise Manager Grid Control and Database Control Accomplish complete and partial RMAN database restores Improve functionality using VERITAS NetBackup, EMC NetWorker Module, and Tivoli Storage Manager Overcome human errors using Flashback Versions Query and Transaction Query Create clone and standby databases from tape and disc backups Work with Real Application Cluster (RAC) databases and sync-and-split hardware technologies

Generate detailed reports that will give your company the competitive edge. .

Put essential information in the hands of end-users across your organization using Oracle Business Intelligence Discoverer 10"g" and the comprehensive information contained in this Oracle Press guide. Youll learn, step-by-step, how to query databases and warehouses, format the results, and distribute dynamic, Web-enabled reports. All features are covered in full detail, including OracleBI Discoverer Desktop, Workbook Wizard, Plus, Viewer, Discoverer Administrator, Portlet Provider, OLAP, and Enterprise Manager. Real-world case studies and tutorials illustrate all of the analysis, security, and reporting capabilities of Oracle Discoverer 10"g,." . Set up, configure, and manage Oracle Business Intelligence Discoverer 10"g," Perform ad hoc and fixed queries using the Workbook Wizard. Integrate sorts, calculations, percentages, and parameters using Discoverer Plus. Create reports with graphs, tables, titles, headers, footers, and margins. Use Discoverer Viewer to review, format, export, email, and print reports. Refine queries using interactive pivoting, drilling, and Hyper Drilling. Control OLAP workbooks using the Discoverer Catalog and Oracle Enterprise Manager. Establish access and sharing rights, and scheduling privileges with Discoverer Administrator. Set up and use Portal using Discoverer Portlet Provider and Portlets. Implement query shortcuts, cascading parameters and advanced analytic calculations using templates. .

CREATE ROBUST DATA MANAGEMENT AND BUSINESS INTELLIGENCE APPLICATIONS.

. Build powerful, enterprise-wide database programs using Microsoft SQL Server 2005 and the comprehensive information contained in this definitive volume. "Microsoft SQL Server 2005 Developer's Guide" explains how to develop server-side and client-side database applications and analyze business intelligence data. All of the brand-new features are covered in-depth -- including .NET CLR Integration, Reporting Services, Integration Services, Notification Services, and Service Broker. Real-world examples and practical tips detail how to use SQL Server 2005 as a cross-tier database platform with Visual Studio 2005, create custom management scripts with SQLCMD, and improve performance with SQL Profiler..

. ESSENTIAL SKILLS FOR DATABASE PROFESSIONALS. Use SQL Server Management Studio and Business Intelligence Development Studio. Write stored procedures and use T-SQL Data Definition Language (DDL) and Data Manipulation Language (DML). Create custom database objects with .NET CLR. Build enterprise database applications using ADO, ADO.NET, and ADOMD.NET. Develop and deploy SQL Server Integration Services packages. Design enterprise reports using Reporting Services and Report Builder. Integrate cross-platform data using XML and Web services. Extend SQL Server manageability using SQL Management Objects (SMO)

Provides beginning DBAs and developers with a solid foundation in the database administration and programming basics needed to embark on an Oracle career. The focus is on Oracle Database 10g, but you’ll get the fundamentals applicable to all Oracle database releases.

YOUR ON-THE-JOB QUICK REFERENCE.

. Carry essential Oracle Database administration information and troubleshooting techniques along with you so you can handle a wide variety of tasks on the spot. This handy resource offers fast access to administrative commands, error resolutions, best practices, and more. Written by an Oracle expert and published by Oracle Press, this convenient reference gives you quick solutions in an easy-to-find format. Don't leave your desk without it! Get details on: .
. Database creation and management. Rollback/undo segments, control files, and redo logs. Oracle tablespaces and tables. Indexes, views, and materialized views. Clusters. Sequences and synonyms. Users, profiles, roles, and grants. Types, dimensions, and other Oracle objects. Clauses and outlines. PL/SQL. DML commands

Written by members of the Oracle XML group, this is a must-have reference for all IT managers, DBAs, and developers who want to learn the best practices for using XML with Oracle’s XML-enabled products. Includes real-world case studies based on the authors’ experience managing Oracle’s XML Discussion Forum--a community of 20,000+ XML component users.

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. Attain real solutions for current availability challenges. Based on a "DBA-centric" approach to High Availability, Oracle Database 10g High Availability concentrates on explaining Oracle Database 10g technologies and practices to database administrators, covering general availability, real application clusters (RAC), disaster planning and recovery, and distributed database solutions. Hardware and application needs are also taken into account. While Oracle Database 10g is the main focus, many of the options discussed are available in earlier database releases. Organized to provide conceptual understanding of High Availability, included are "HA Workshops," step-by-step instructions to get you through certain implementations, plus real-world inspired case studies.

Here is an invaluable overview of all the cutting-edge features of Oracle’s latest database release, Oracle Database 10g. Includes expert commentary throughout from world-renowned Oracle guru Jonathan Lewis. This is an ideal resource for decision-makers and IT staff preparing for upgrades or migration.

Get comprehensive coverage of all the powerful new features of MySQL, one of the fastest--and free--relational databases in use today. Written in conjunction with the MySQL development team, this expert resource covers transactional integrity, disaster recovery, scalability, support for mobile users, Web-based and client/server programming, and much more.

Most modern-day organizations have a need to record data relevant to their everyday activities and many choose to organise and store some of this information in an electronic database. Database Systems provides an essential introduction to modern database technology and the development of database systems. This new edition has been fully updated to include new developments in the field, and features new chapters on: e-business, database development process, requirements for databases, and distributed processing. In addition, a wealth of new examples and exercises have been added to each chapter to make the book more practically useful to students, and full lecturer support will be available online.

Get results from the best-selling database management system with help from this expertly written guide. Learn to build databases for all your information management needs, from a simple address list to a complex inventory management system. Highly regarded database author Virginia Andersen shows you in step-by-step detail how to set up Access for storing, retrieving, and interpreting your data. Enter and edit data. Design tables for storing information. Retrieve specific information and present it in customized forms, reports, and dynamic data access pages. Let this friendly, solutions-oriented resource help you understand and employ all the data organizing tools available in Access 2003.. . Master this powerful information management tool . Create more efficient relational databases . Retrieve, exchange, and process all types of information . Customize data entry for efficient data transfer and editing . Integrate Access with other applications . Sort and filter data--plus create custom forms, reports, and charts . Use queries to extract only the information you want . Administer multiple-user databases securely. .