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 Database 12c PL/SQL Application DevelopmentDevelop, debug, and administer robust database programs. Filled with detailed examples and expert strategies from an Oracle ACE, Oracle Database 12c PL/SQL Programming explains how to retrieve and process data, write PL/SQL statements, execute effective queries, incorporate PHP and Java, and work with dynamic SQL. Code testing, security, and object-oriented programming techniques are fully covered in this comprehensive Oracle Press guide. Explore new SQL and PL/SQL features in Oracle Database 12c Build control structures, cursors, and loop statements Work with collections, varrays, tables, and associative array collections Locate and repair errors and employ exception handlers Execute black box, white box, and integration tests Configure and manage stored packages and libraries Handle security with authentication and encryption Use LOBs to store text and multimedia content Write and implement PL/SQL and Java triggers Extend functionality using dynamic SQL statements Understand object types, nested tables, and unnesting queries

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. Essential Microsoft SQL Server 2012 Skills Made EasyGet up and running on Microsoft SQL Server 2012 in no time with help from this thoroughly revised, practical resource. Filled with real-world examples and hands-on exercises, Microsoft SQL Server 2012: A Beginner's Guide, Fifth Edition starts by explaining fundamental relational database system concepts. Then, you'll learn how to write Transact-SQL statements, execute simple and complex database queries, handle system administration and security, and use the powerful analysis, business intelligence, and reporting tools. XML, spatial data, and full-text search are also covered in this step-by-step tutorial. Install, configure, and customize SQL Server 2012 Create and modify database objects with Transact SQL statements Write stored procedures and user-defined functions Handle backup and recovery Automate administrative tasks Tune your database system for optimal performance, availability, and reliability Implement security measures using authentication, encryption, and authorization Work with SQL Server Analysis Services, SQL Server Reporting Services, and other business intelligence tools Store, display, and query XML documents Manage spatial data Query documents using MS Full-Text Search (FTS)

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.Implement Oracle Business Intelligence ApplicationsProvide actionable business intelligence across the enterprise to enable informed decision-making and streamlined business processes. Oracle Business Intelligence Applications: Deliver Value Through RapidImplementations shows how to justify, configure, customize, and extend this complete package of BI solutions. You'll get a technical walkthrough of Oracle Business Intelligence Applications architecture--from thedashboard to the data source--followed by best practices for maximizing the powerful features of each application. You will also find out about stakeholders critical to project approval and success. Optimize performance using Oracle Exalytics In-Memory Machine Deliver timely financial information to managers with Oracle Financial Analytics Enable a streamlined, demand-driven supply chain viaOracle Supply Chain and Order Management Analytics Provide end-to-end visibility into manufacturing operations with Oracle Manufacturing Analytics Optimize supply-side performance through Oracle Procurement and Spend Analytics Use Oracle Human Resources Analytics to provide key workforce information to managers and HR professionals Track the costs and labor required to maintain and operate assets with Oracle Enterprise Asset Management Analytics Maintain visibility into project performance via Oracle Project Analytics Provide actionable insight into sales opportunities using Oracle Sales Analytics Enable superior customer service with Oracle Service Analytics

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 only Oracle Press guide to MySQL Workbench explains how to design and model MySQL databases.MySQL Workbench Data Modeling and Development helps developers learn how to effectively use this powerful product for database modeling, reverse engineering, and interaction with the database without writing SQL statements. MySQL Workbench is a graphical user interface that can be used to create and maintain MySQL databases without coding. The book covers the interface and explains how to accomplish each step by illustrating best practices visually. Clear examples, instructions, and explanations reveal, in a single volume, the art of database modeling. This Oracle Press guide shows you how to get the tool to do what you want. Annotated screen shots demonstrate all interactions with the tool, and text explains the how, what, and why of each step. Complete coverage Installation and Configuration; Creating and Managing Connections; Data Modeling Concepts; Creating an ERD; Defining the Physical Schemata; Creating and Managing Tables; Creating and Managing Relationships; Creating and Managing Views; Creating and Managing Routines; Creating and Managing Routine Groups; Creating and Managing User & Groups; Creating and Managing SQL Scripts; Generating SQL Scripts; Forward Engineering a Data Model; Synchronize a Model with a Database; Reverse Engineering a Database; Managing Differences in the Data Catalog; Creating and Managing Model Notes; Editing Table Data; Editing Generated Scripts; Creating New Instances; Managing Import and Export; Managing Security; Managing Server Instances

EXAM PREP GUIDE Ace your preparation for the skills measured by Exam 70-462--and on the job--with this official Microsoft study guide. Work at your own pace through a series of lessons and reviews that fully cover each exam objective. Then, reinforce and apply what you've learned through real-world case scenarios and practice exercises.

Maximize your performance on the exam by mastering the skills and experience measured by these objectives: Install and configure SQL ServerMaintain instances and databasesOptimize and troubleshoot SQL ServerManage dataImplement securityImplement high availability

PRACTICE TESTS A Note Regarding Practice Tests

Assess your skills with practice tests. You can work through hundreds of questions using multiple testing modes to meet your specific learning needs. You get detailed explanations for right and wrong answers--including a customized learning path that describes how and where to focus your studies. For customers who purchase an ebook version of this title, instructions for downloading the CD files can be found in the ebook.

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. 400+ ready-to-use, powerful SQL queriesLearn powerful techniques for surfacing and delivering actionable business intelligence using SQL. Practical SQL Queries for Microsoft SQL Server 2008 R2 contains more than 400 downloadable SQL queries you can use to extract meaningful insights from large amounts of data. The application, syntax, and results of each query are described in detail. The book emphasizes SQL for use in SSMS, but the queries also apply to SSRS, WinForms, WebForms, and many other applications. Enter, maintain, and retrieve database data Search records using the Where clause Sort SQL query results with the Order By clause Create tables and perform joins on tables Perform set operations using Union, Intersect, and Except Group data and produce totals with the Group By clause Manipulate and transform data using built-in functions Create reusable views and user-defined functions Use stored procedures to change SQL dynamically based on conditional factors Create, maintain, and secure database objects with DDL and DCL Deliver SQL query results to end 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. Written by the most knowledgeable Oracle JDeveloper author team in the world This Oracle Press guide shows how to build Web applications using the Fusion Middleware development tool, Oracle JDeveloper. The book discusses the latest technologies and explains how to develop code using multiple techniques. Oracle JDeveloper 11g Handbook: A Guide to Fusion Web Development covers the Oracle Application Development Framework and JavaServer Faces. Hands-on practice examples walk you through the creation of a complete sample application that employs highly-interactive user interface components and declarative development methods. You will learn the techniques required to implement Fusion-oriented software solutions in JDeveloper.

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 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. 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. 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. 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. 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. 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. 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. 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 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

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.

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.

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. .

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.

Official Microsoft study guide for the database development skills tested on the job—and on MCP Exam 70-229

Learn how to deliver powerful database solutions—and prepare for MCP Exam 70-229—with this official Microsoft study guide. Exam 70-229 is an elective for MCSE/MCSA certification and a core exam on the MCDBA track. Build your expertise designing and implementing data-driven business applications using SQL Server 2000 by working at your own pace through the book’s lessons and hands-on exercises. The second edition of this popular TRAINING KIT now features a testing tool to measure what you know and where to focus your studies—before taking the actual exam. Topics include developing a logical data model; creating databases; using Transact-SQL and Data Transformation Services (DTS) to manipulate data; extracting data in XML format; programming business logic using stored procedures, transactions, triggers, user-defined functions, and views; optimizing database performance by using SQL Profiler and the Index Tuning Wizard; and implementing security. You also get a CD-ROM loaded with practice exercises and an easy-search electronic version of the study guide.