Expert Oracle Application Express, 2nd Edition is newly updated for APEX 5.0 and brings deep insight from some of the best APEX practitioners in the field today. You'll learn about important features in APEX 5.0, and how those can be applied to make your development work easier and with greater impact on your business. Oracle Application Express (APEX) is an entirely web-based development framework that is built into every edition of Oracle Database. The framework rests upon Oracle's powerful PL/SQL language, enabling power users and developers to rapidly develop applications that easily scale to hundreds, even thousands of concurrent users. APEX has seen meteoric growth and is becoming the tool of choice for ad-hoc application development in the enterprise. The many authors of Expert Oracle Application Express, 2nd Edition build their careers around APEX. They know what it takes to make the product sing-developing secure applications that can be deployed globally to users inside and outside a large enterprise. The authors come together in this book to share some of their deepest and most powerful insights into solving the difficult problems surrounding globalization, configuration and lifecycle management, and more. New in this edition for APEX 5.0 is coverage of Oracle REST Data Services, map integration, jQuery with APEX, and the new Page Designer. You'll learn about debugging and performance, deep secrets to customizing your application u ser interface, how to secure applications from intrusion, and about deploying globally in multiple languages. Expert Oracle Application Express, 2nd Edition is truly a book that will move you and your skillset a big step towards the apex of Application Express development. Contains all-new content on Oracle REST Data Services, jQuery in APEX, and map integration Addresses globalization and other concerns of enterprise-level development Shows how to customize APEX for your own application needs

For all the buzz about trendy IT techniques, data processing is still at the core of our systems, especially now that enterprises all over the world are confronted with exploding volumes of data. Database performance has become a major headache, and most IT departments believe that developers should provide simple SQL code to solve immediate problems and let DBAs tune any "bad SQL" later.

In "The Art of SQL," author and SQL expert Stephane Faroult argues that this "safe approach" only leads to disaster. His insightful book, named after Art of War by Sun Tzu, contends that writing quick inefficient code is sweeping the dirt under the rug. SQL code may run for 5 to 10 years, surviving several major releases of the database management system and on several generations of hardware. The code must be fast and sound from the start, and that requires a firm understanding of SQL and relational theory.

"The Art of SQL" offers best practices that teach experienced SQL users to focus on strategy rather than specifics. Faroult's approach takes a page from Sun Tzu's classic treatise by viewing database design as a military campaign. You need knowledge, skills, and talent. Talent can't be taught, but every strategist from Sun Tzu to modern-day generals believed that it can be nurtured through the experience of others. They passed on their experience acquired in the field through basic principles that served as guiding stars amid the sound and fury of battle. This is what Faroult does with SQL.

Like a successful battle plan, good architectural choices are based on contingencies. What if the volume of this or that table increases unexpectedly? What if, following a merger, the numberof users doubles? What if you want to keep several years of data online? Faroult's way of looking at SQL performance may be unconventional and unique, but he's deadly serious about writing good SQL and using SQL well. "The Art of SQL" is not a cookbook, listing problems and giving recipes. The aim is to get you-and your manager-to raise good questions.

Advanced data management has always been at the core of efficient database and information systems. Recent trends like big data and cloud computing have aggravated the need for sophisticated and flexible data storage and processing solutions. This book provides a comprehensive coverage of the principles of data management developed in the last decades with a focus on data structures and query languages. It treats a wealth of different data models and surveys the foundations of structuring, processing, storing and querying data according these models. Starting off with the topic of database design, it further discusses weaknesses of the relational data model, and then proceeds to convey the basics of graph data, tree-structured XML data, key-value pairs and nested, semi-structured JSON data, columnar and record-oriented data as well as object-oriented data. The final chapters round the book off with an analysis of fragmentation, replication and consistency strategies for data management in distributed databases as well as recommendations for handling polyglot persistence in multi-model databases and multi-database architectures. While primarily geared towards students of Master-level courses in Computer Science and related areas, this book may also be of benefit to practitioners looking for a reference book on data modeling and query processing. It provides both theoretical depth and a concise treatment of open source technologies currently on the market.

Prominent FileMaker developers Susan Prosser and Stuart Gripman know how to work magic with FileMaker Pro, and they share their knowledge in this bestselling book. You'll learn how to build a database and organize all of your information quickly and efficiently.

Need a quick and easy to understand introduction to MongoDB and NoSQL databases? MongoDB Basics, from The Definitive Guide to MongoDB, 2E, shows you how a document-oriented database system differs from a relational database, and how to install and get started using it. You'll also learn MongoDB design basics, including geospatial indexing, how to navigate, view, and query your database, and how to use GridFS with a bit of Python.

Beginning SQL Server for Developers is the perfect book for developers new to SQL Server and planning to create and deploy applications against Microsoft's market-leading database system for the Windows platform. Now in its fourth edition, the book is enhanced to cover the very latest developments in SQL Server, including the in-memory features that are introduced in SQL Server 2014. Within the book, there are plenty of examples of tasks that developers routinely perform. You'll learn to create tables and indexes, and be introduced to best practices for securing your valuable data. You'll learn design tradeoffs and find out how to make sound decisions resulting in scalable databases and maintainable code. SQL Server 2014 introduces in-memory tables and stored procedures. It's now possible to accelerate applications by creating tables (and their indexes) that reside entirely in memory, and never on disk. These new, in-memory structures differ from caching mechanisms of the past, and make possible the extraordinarily swift execution of certain types of queries such as are used in business intelligence applications. Beginning SQL Server for Developers helps you realize the promises of this new feature set while avoiding pitfalls that can occur when mixing in-memory tables and code with traditional, disk-based tables and code. Beginning SQL Server for Developers takes you through the entire database development process, from installing the software to creating a database to writing the code to connect to that database and move data in and out. By the end of the book, you'll be able to design and create solid and reliable database solutions using SQL Server. Takes you through the entire database application development lifecycle Includes brand new coverage of the in-memory features Introduces the freely-available Express Edition

Get a head start with eXist, the open source NoSQL database and application development platform built entirely around XML technologies. With this hands-on guide, you'll learn eXist from the ground up, from using this feature-rich database to work with millions of documents to building complex web applications that take advantage of eXist's many extensions. If you're familiar with XML - as a student, professor, publisher, or developer - you'll find that eXist is ideal for all kinds of documents. This book shows you how to store, query, and search documents with XQuery and other XML technologies, and how to construct applications on top of the database with tools such as eXide and eXist's built-in development environment. Manage both data-oriented and text-oriented markup documents securely Build a sample application that analyzes and searches Shakespeare's plays Go inside the architecture and learn how eXist processes documents Learn how to work with eXist's internal development environment Choose among various indexes, including a full-text index based on Apache Lucene Dive into eXist's APIs for integrating or interacting with the database Extend eXist by building your own Triggers, Scheduled Tasks, and XQuery extension modules

In "Advanced Transact-SQL for SQL Server 2000," authors Itzik Ben-Gan and Thomas Moreau explore the powerful capabilities of Transact-SQL (T-SQL). Ben-Gan and Moreau offer solutions to common problems encountered using all versions of SQL Server, with a focus on the latest version, SQL Server 2000.

Expert tips and real code examples teach advanced database programmers to write more efficient and better-performing code that takes full advantage of T-SQL. The authors offer practical solutions to the everyday problems programmers face and include in-depth information on advanced T-SQL topics such as joins, subqueries, stored procedures, triggers, user-defined functions (UDFs), indexed views, cascading actions, federated views, hierarchical structures, cursors, and more.

Performance problems are rarely problems per se. They are more often crises during which you're pressured for results by a manager standing outside your cubicle while your phone rings with queries from the help desk. You won't have the time for a leisurely perusal of the manuals, nor to lean back and read a book on theory. What you need in that situation is a book of solutions, and solutions are precisely what Oracle Database 12c Performance Tuning Recipes delivers. Oracle Database 12c Performance Tuning Recipes is a ready reference for database administrators in need of immediate help with performance issues relating to Oracle Database. The book takes an example-based approach, wherein each chapter covers a specific problem domain. Within each chapter are recipes, showing by example how to perform common tasks in that chapter's domain. Solutions in the recipes are backed by clear explanations of background and theory from the author team. Whatever the task, if it's performance-related, you'll probably find a recipe and a solution in this book.* Provides proven solutions to real-life Oracle performance problems * Offers relevant background and theory to support each solution * Gets straight to the point for when you're under pressure for results What you'll learn * Optimize the use of memory and storage * Monitor performance and troubleshoot problems * Identify and improve poorly-performing SQL statements * Adjust the most important optimizer parameters to your advantage * Create indexes that get used and make a positive impact upon performance * Automate and stabilize using key features such as SQL Tuning Advisor and SQL Plan Baselines Who this book is for Oracle Database 12c Performance Tuning Recipes is aimed squarely at Oracle Database administrators. The book especially appeals to those administrators desiring to have at their side a ready-to-go set of solutions to common database performance problems.

Expert Consolidation in Oracle Database 12c is your key to reducing data management costs and increasing data center efficiency. Consolidation and cloud computing are converging trends sweeping the industry. The same technologies enabling cloud computing enable consolidation as well, leading to savings on all fronts from the amount of power used for servers to the amount of floor space consumed to the number of administrators needed to manage an installation. Yet the consolidation process can be a long and winding road. Success requires planning, and consideration to the impacts on supporting infrastructure.Expert Consolidation in Oracle Database 12c guides you through planning and implementing a consolidated Oracle Database installation using the many new features built into the latest release of Oracle's database management system. You'll learn to identify candidates for consolidation and to recognize instances that are best left stand-alone. The book guides in working with clustered systems and ASM storage in the consolidated environment. Focus is given to Oracle Enterprise Manager 12c Cloud Control as a monitoring and management dashboard. Always the goal is to drive towards a cost-effective environment that is efficient both in technology and people. Focuses on the new consolidation features in Oracle Database 12c Helps you evaluate and correctly decide when to consolidate Leads to cost savings and improved data center efficiency

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 powerful features of the latest release of today's most popular desktop database program How to Do Everything with Microsoft Office Access 2007 shows you how to create and customize an efficient, multi-user database, retrieve, interpret, and share your data, secure your information, and much more. Designed to help you get things done quickly and easily, this user-friendly guide is your all-access pass to Access 2007. Navigate the new user interface with ease Design a well-organized database using pre-designed templates Enter and edit data and ensure data validity Sort, filter, and print records Extract specific information using queries Master form and report design basics Add charts and graphs to forms and reports easily Optimize database performance and speed Exchange database objects and text files between Access databases

Pro Oracle SQL, Second Edition unlocks the power of SQL in the Oracle database--one of the most potent SQL implementations on the market today. To master it requires a multi-pronged approach: learn the language features, learn how and why the language features work, learn the supporting features that Oracle provides to help use the language effectively, and learn to think and work in sets. Karen Morton has updated the content for Oracle version 12c and helps you master powerful aspects of Oracle SQL from the inside-out. You'll learn analytic functions, the MODEL clause, and advanced grouping syntax--features that will help in creating good queries for reporting and business intelligence applications. Pro Oracle SQL, Second Edition also helps you minimize parsing overhead, read execution plans, test for correct results, understand performance management, and exert control over SQL execution in your database. You'll learn when to create indexes, how to verify that they make a difference, how to use SQL Baselines and Profiles to optimize and stabilize SQL execution plans, and much more.You'll also understand how SQL is optimized for working in sets, and that the key to getting accurate results lies in making sure that queries ask clear and precise questions. Pro Oracle SQL, Second Edition helps you work at a truly professional level in the Oracle dialect of SQL. You'll master the language, the tools to work effectively with the language, and the right way to think about a problem in SQL. * Endorsed by the OakTable Network, a group of Oracle technologists well-known for their rigorous and scientific approach to Oracle Database performance * Comprehensive--goes beyond the language with a focus on what you need to know to write successful queries and data manipulation statements. * Performance focused--teaches you how to measure the performance of your SQL statements and not just the syntax.What you'll learn * Master powerful SQL features implemented in the Oracle Database * Understand how the Oracle Optimizer develops execution plans * Read and interpret SQL execution plans * Quickly diagnose and fix badly performing SQL * Control execution plans through hints, profiles, and plan baselines * Optimize queries within packaged applications without touching the code * Recognize when not to waste time on SQL that is performing optimally Who this book is for Pro Oracle SQL, Second Edition is aimed at developers and database administrators who submit SQL for execution by an Oracle database. Readers should already know the basic four SQL statements, and be ready to learn deeply about Oracle's specific implementation of the language, including Oracle-specific features and syntax. Readers should also want to learn about Oracle Database features such as analytic queries, the MODEL clause, and the WITH clause (subquery factoring) that are designed to help developers and database administrators exert control over their SQL environment and its execution.

Oracle RMAN Pocket Reference is ideal for DBAs who require a concise reference to common RMAN tasks. The first portion of the book presents commands for such tasks as taking a full database backup, recovering from loss of data file, and cloning a database. The second portion offers a very concise RMAN syntax reference. This book will save DBAs time when performing tasks that are infrequent, yet extremely vital.

RMAN Recipes for Oracle Database 12c is an example-driven approach to the Oracle database administrator's #1 job responsibility: * Be able to recover the database. Of all the things you are responsible for as database administrator, nothing is more important than the data itself. Like it or not, the fearsome responsibility of protecting your organization's most critical data falls squarely upon your shoulders: * Lose that data and your company could fail. * Lose that data and you could be out of a job. Oracle's flagship database product fortunately implements a wide-ranging feature set to aid you in the all-important task of safeguarding against data loss. Recovery Manager, or RMAN, is at the heart of that feature set, and is the tool most-often used to initiate database backup and recovery operations. In this book, well-known authors and database experts Darl Kuhn, Sam Alapati, and Arup Nanda have created a set of examples encompassing the gamut of backup and recovery tasks that you might need to perform. Sometimes, especially when the heat is on, a good example is what you need to get started towards a solution. RMAN Recipes for Oracle Database 12c delivers.It'll be the book you reach for when that dreaded call comes in at 3:00am some dreary morning. It'll be the book that lets you sleep at night knowing that no matter what transpires, that you've done your job well and can recover from any outage. RMAN Recipes for Oracle Database 12c gets right to the point with quick and easy-to-read, step-by-step solutions that can help you backup and recover your data with confidence.

Enterprise Manager 12c (EM12c), Oracle's newest and fully-integrated enterprise management product, now provides a complete cloud lifecycle management solution and enterprise environment management interface. Expert Oracle Enterprise Manager 12c opens up the secrets of this incredible management tool, saving you time while enhancing your visibility as someone management can rely upon to deliver reliable database service in today's increasingly chaotic and change-driven IT environment. Expert Oracle Enterprise Manager 12c covers all the topics you demand and need to function effectively, from basic monitoring and configuration to advanced metric extensions and plugins. Real-life scenarios and demonstrations place you in the comfort zone of using the EM12c console, and the experienced author team provides deep understanding of the inner workings of this new Enterprise Manager. Database administrators and system administrators are expected to offer increasing levels of service for 24X7 systems and newer cloud environments. Em12c offers robust, end-to-end intelligent management of the complete environment. It includes direct, real-time integration with Oracle's online knowledgebase.Expert Oracle Enterprise Manager 12c helps you master this important tool and manage any challenge that comes your way. * Provides example solutions to everyday problems through EM12c features. * Explains the changes in EM12c, included trusted extensions. * Focuses on advanced aspects of the EM12c interface. What you'll learn * Installation and agent employment * Patching and provisioning * Advanced techniques for managing and monitoring * Use of EM12c in cloud environments, with RAC, and for Exadata * Creation of EM12c plugins and metric extensions * High-availability and disaster-recovery options with EM12c * Incident Manager and EM12c job management Who this book is for Expert Oracle Enterprise Manager 12c is for database administrators who are ready to upgrade, or who have already upgraded to Enterprise Manager 12c. The book also appeals to system administrators who may have responsibility for helping support Oracle Database environments -- including RAC and Exadata -- at the enterprise level.

Business intelligence projects do not need to cost multi-millions of dollars or take months or even years to complete Using rapid application development (RAD) techniques along with Microsoft SQL Server 2012, this book guides database administrators, SQL programmers, and report specialists in creating practical, cost-effective business intelligence solutions for their companies and departments. Pro SQL Server 2012 BI Solutions provides practical examples of cost-effective business intelligence projects. Readers will be guided through several complete projects that build a foundation for real-world solutions. Even with limited experience using Microsoft's SQL Server, Integration Server, Analysis Server, and Reporting Server, you can leverage your existing knowledge of SQL programming and database design to provide users with the business intelligence reports they need.* Provides recipes for multiple business intelligence scenarios * Progresses from simple to advanced projects using several examples * Shows Microsoft SQL Server technology used to complete real-world business intelligence projects What you'll learn * How to plan and implement cost-effective business intelligence projects * How to create practical data warehouse databases * How to extract, transform, and load data with Integration Services * How to develop OLAP cubes and dimensions on Analysis Server * How to create Reporting Server reports using both SQL and MDX * How to apply performance-tuning techniques to get the most from your solutions Who this book is for Pro SQL Server 2012 BI Solutions is aimed at database administrators, SQL programmers, and report developers who create business intelligence solutions for midsized businesses and departments.Table of Contents * Business Intelligence Solutions * A Big Picture Overview * Planning Solutions * Designing a Data Warehouse * Creating a Data Warehouse * ETL Processing with SQL * Beginning the ETL Process with SSIS * Concluding the ETL Process with SSIS * Beginning the SSAS Project * Configuring Dimensions with SSAS * Creating and Configuring SSAS Cubes * Additional Cube and Dimension Configurations * Creating Reports with SQL Queries * Reporting with MDX Queries * Reporting with Microsoft Excel * Creating Reports with SSRS * Configuring Reports with SSRS * Testing and Tuning BI Solutions * Approve, Release, and Prepare

Learn how to write, tune, and port SQL queries and other statements for a Big Data environment, using Impala - the massively parallel processing SQL query engine for Apache Hadoop. The best practices in this practical guide help you design database schemas that not only interoperate with other Hadoop components, and are convenient for administers to manage and monitor, but also accommodate future expansion in data size and evolution of software capabilities. Ideal for database developers and business analysts, Getting Started with Impala includes advice from Cloudera's development team, as well as insights from its consulting engagements with customers. Learn how Impala integrates with a wide range of Hadoop components Attain high performance and scalability for huge data sets on production clusters Explore common developer tasks, such as porting code to Impala and optimizing performance Use tutorials for working with billion-row tables, date- and time-based values, and other techniques Learn how to transition from rigid schemas to a flexible model that evolves as needs change

Is Responsive Web Design (RWD) slowing your site down? It doesn't have to. With this concise book, you'll learn practical techniques for improving performance with RWD, including a default set of guidelines you can use as an easy starting point. Web performance researcher and evangelist Guy Podjarny walks you through several existing solutions for dealing with RWD performance problems, and offers advice for choosing optimizations that will be most useful for your needs. RWD performance problems stem from excessive downloads of resources, including images, JavaScript and CSS, and HTML--downloads designed to let your web application adapt to different screen sizes. Podjarny presents a series of increasingly larger-scope solutions to each issue, including client-side techniques and RESS (Responsive + Server Side Components). Address performance issues by starting with Podjarny's default guidelines Use a JavaScript image loader and an image transcoding service to create Responsive Images Reduce JavaScript and CSS downloads with asynchronous scripts, conditional loading, and multi-viewport CSS Prioritize resources to avoid excess content in RWD and defer the load of any content that's not critical Explore server-side Adaptive Delivery and RESS solutions as an alternative to "pure" RWD Guy Podjarny, or Guypo for short, is the Chief Technology Officer (CTO) of Akamai's Web Experience business unit.

Beginning SQL Server 2012 for Developers is the perfect book for developers new to SQL Server and planning to create and deploy applications against Microsoft's market-leading database system for the Windows platform. Now in its third edition, the book is enhanced to cover the very latest developments in SQL Server 2012. Also new in the book is coverage of the no-cost Express Edition. Whether you have no knowledge of databases, or have knowledge of desktop databases such as Microsoft Access, or even come from another brand such as Oracle Database, Beginning SQL Server 2012 for Developers provides the insights to get up and running with SQL Server 2012. Within the book, there are plenty of examples of tasks that developers routinely perform. You'll learn to create tables and indexes, and best practices for securing your valuable data. You'll learn design tradeoffs and find out how to make sound decisions resulting in scalable databases and maintainable code. Beginning SQL Server 2012 for Developers takes you through the entire database development process, from installing the software to creating a database to writing the code to connect to that database and move data in and out. By the end of the book, you'll be able to design and create solid and reliable database solutions using SQL Server 2012. * Takes you through the entire database application development lifecycle * Includes brand new coverage of SQL Server 2012 features * Introduces the freely-available Express Edition What you'll learn * How to install SQL Server 2012 * How to build a database application from start to finish * How to create tables and indices to manage your data * How to write stored code to execute directly in the database server * How to back up, recover, and otherwise maintain your database * How to connect to your database from client languages such as C# and VB .NET Who this book is for Beginning SQL Server 2012 for Developers is ideal for developers starting out with SQL Server 2012. There is no prerequisite background in developing database applications.Developers from other platforms and those brand new to database programming alike will find in Beginning SQL Server 2012 for Developers an excellent introduction to using and programming Microsoft's database platform. Table of Contents * Overview and Installation * SQL Server Management Studio * Database Design and Creation * Security and Compliance * Defining Tables * Creating Indexes and Database Diagramming * Database Backups and Recovery * Database Maintenance * Inserting and Deleting Data * Selecting and Updating Data * Building a View * Stored Procedures, Functions, and Security * Essentials for Effective Coding * Advanced T-SQL * Triggers * Connecting from Client Code

Server bottlenecks and failures are a fact of life in any database deployment, but they don't have to bring everything to a halt. This practical book explains replication, cluster, and monitoring features that can help protect your MySQL system from outages, whether it's running on hardware, virtual machines, or in the cloud.

Written by engineers who designed many of the tools covered, this book reveals undocumented or hard-to-find aspects of MySQL reliability and high availability--knowledge that's essential for any organization using this database system. This second edition describes extensive changes to MySQL tools. Versions up to 5.5 are covered, along with several 5.6 features.Learn replication fundamentals, including use of the binary log and MySQL Replicant LibraryHandle failing components through redundancyScale out to manage read-load increases, and use data sharding to handle large databases and write-load increasesStore and replicate data on individual nodes with MySQL ClusterMonitor database activity and performance, and major operating system parametersKeep track of masters and slaves, and deal with failures and restarts, corruption, and other incidentsExamine tools including MySQL Enterprise Monitor, MySQL Utilities, and GTIDs

Oracle Core: Essential Internals for DBAs and Developers by Jonathan Lewis provides just the essential information about Oracle Database internals that every database administrator needs for troubleshooting - no more, no less. Oracle Database seems complex on the surface. However, its extensive feature set is really built upon upon a core infrastructure resulting from sound architectural decisions made very early on that have stood the test of time. This core infrastructure manages transactions and the ability to commit and roll back changes, protects the integrity of the database, enables backup and recovery, and allows for scalability to thousands of users all accessing the same data. Most performance, backup, and recovery problems that database administrators face on a daily basis can easily be identified through understanding the essential core of Oracle Database architecture that Lewis describes in this book.* Provides proven content from a world-renowned performance and troubleshooting expert * Emphasizes the significance of internals knowledge to rapid identification of database performance problems * Covers the core essentials and does not waste your time with esoterica What you'll learn * Oracle's core architectural foundations * How much overhead is reasonable * How to recognize when you're doing too much work * How to predict bottlenecks and why they will happen * How to minimise contention and locking * Why concurrency can slow things down significantly Who this book is for Oracle Core: Essential Internals for DBAs and Developers is aimed at database administrators ready to move beyond the beginning stage of doing work by rote towards the mastery stage, in which knowledge of what needs to be done comes not from a set of recipe-style instructions, but rather from the intimate knowledge and understanding of the system to be managed. Experienced database administrators will also find the book useful in solidifying their knowledge and filling in any missing pieces of the Oracle Database puzzle.Table of Contents * Introduction * Redo and Undo * Transactions and Consistency * Latches and Locks * Caches and Copies * Writing and Recovery * RAC and Ruin * Dumping and Debugging * Working and Waiting

Written by Oracle insiders, this indispensable guide distills an enormous amount of information about the Oracle Database into one compact volume. Ideal for novice and experienced DBAs, developers, managers, and users, "Oracle Essentials" walks you through technologies and features in Oracle's product line, including its architecture, data structures, networking, concurrency, and tuning.

Complete with illustrations and helpful hints, this fifth edition provides a valuable one-stop overview of Oracle Database 12"c," including an introduction to Oracle and cloud computing. "Oracle Essentials" provides the conceptual background you need to understand how Oracle truly works.

Topics include: A complete overview of Oracle databases and data stores, and Fusion Middleware products and featuresCore concepts and structures in Oracle's architecture, including pluggable databasesOracle objects and the various datatypes Oracle supportsSystem and database management, including Oracle Enterprise Manager 12"c"Security options, basic auditing capabilities, and options for meeting compliance needsPerformance characteristics of disk, memory, and CPU tuningBasic principles of multiuser concurrencyOracle's online transaction processing (OLTP)Data warehouses, Big Data, and Oracle's business intelligence toolsBackup and recovery, and high availability and failover solutions

Pro Access 2010 Development is a fundamental resource for developing business applications that take advantage of the features of Access 2010 and the many sources of data available to your business. In this book, you'll learn how to build database applications, create Web-based databases, develop macros and Visual Basic for Applications (VBA)tools for Access applications, integrate Access with SharePoint and other business systems, and much more. What you'll learn How to build business applications that integrate local data, web-generated data, and data available from SQL Server and other sources How to develop VBA routines and macros to enhance the automation of your database How to deploy databases to your users and "web-ify" your application for access from anywhere How to secure access to your data and maintain its integrity How to integrate Access with SharePoint and other business applications Who this book is for

This book is for intermediate to advanced Access developers who want to get up to speed with the new features available in Access 2010. Experienced Access users who want to begin developing code-based applications and project solutions in Access will also find this book useful. Table of Contents Introduction Definingand Relating Tables Using Data Macros DesigningQueries Creating PivotTables Standard Forms Creatinga CheckOut Form Creating aCustomer Admin Form EnhancingProductAdministration Enhancing the User Experience Branding with Themes and Styles Reports Upsizing Distributing the Application Publishing to the Web Integrating Outlook Using External Data Miscellaneous Features Security

Foundations of SQL Server 2008 R2 Business Intelligence introduces the entire exciting gamut of business intelligence tools included with SQL Server 2008. Microsoft has designed SQL Server 2008 to be more than just a database. It's a complete business intelligence (BI) platform. The database is at its core, and surrounding the core are tools for data mining, modeling, reporting, analyzing, charting, and integration with other enterprise-level software packages. SQL Server 2008 puts an incredible amount of BI functionality at your disposal. But how do you take advantage of it? That's what this book is all about. Authors Guy Fouche and Lynn Langit show how to implement end-to-end BI solutions using SQL Server Analysis Services (SSAS), SQL Server Integration Services (SSIS), SQL Server Reporting Services (SSRS), and other tools in the Microsoftbusiness intelligencetoolkit. You'll learn about all-features such as PowerPivot and Report Builder 3.0. Also provided are clear examples of predictive analysis made possible through powerful data mining features in SQL Server. If you're an analyst or developer working with SQL Server 2008 who is charged with delivering results that drive business success, you can't afford to be without this book; you can't afford to ignore the powerfulbusiness intelligencesuite that Microsoft has placed at your disposal. Provides the big picture of Microsoft's BI tool suite Covers PowerPivot and other game-changing technologies introduced alongside SQL Server 2008 Release 2 Gives a practical analysis of features based on real-world practices What you'll learn Apply dimensional- and fact-based modeling to create OLAP schemas Optimize data extraction and transformation with SQL Server Integration Services Develop OLAP and data-mining solutions using SQL Server Analysis Services Create compelling reports using the new Report Builder 3.0 in SQL Server Reporting Services Deliver self-service business-intelligence via Microsoft PowerPivot Manage and maintain control over your business intelligence environment Who this book is for

Foundations of SQL Server 2008 R2 Business Intelligence is for business intelligence analysts and developers wanting to employ the full stack of business intelligence tools that are part of SQL Server. The book also appeals to database administrators managing databases in support of business intelligence efforts. Table of Contents What Is Business Intelligence? OLAP Modeling Concepts Introducing OLAP Modeling with SSAS Intermediate OLAP Modeling with SSAS Advanced OLAP Modeling with SSAS Cube Storage and Aggregation Introducing SSIS Intermediate SSIS Advanced SSIS Reporting Tools Data Mining with Excel Introducing PowerPivot Introduction to MDX Introduction to Data Mining

Oracle PL/SQL Recipes is your go to book for PL/SQL programming solutions. It takes a task-oriented approach to PL/SQL programming that lets you quickly look up a specific task and see the pattern for a solution. Then it's as simple as modifying the pattern for your specific application and implementing it. And you're done and home for dinner.
Oracle PL/SQL Recipes is another in Apress' ongoing series of recipe books aimed at Oracle practitioners. The recipe format is ideal for the busy professional who just needs to get the job done. Covers the most common PL/SQL programming problems Presents solutions in ready-to-use format Stays short and to-the-point What you'll learn Move business logic into the database Implement robust exception-handling Optimize and debug, taking advantage of Oracle SQL Developer Integrate PL/SQL with web-based applications Interface with Java code and dynamic languages in the database, and running externally Run the UTPLSQL unit-testing framework Who this book is for

Oracle PL/SQL Recipes is database administrators and developers wanting to take advantage of Oracle Database's built-in support for procedural logic. Database administrators can use PL/SQL to automate administrative tasks, audit access to sensitive data, and more. Developers will be able to optimize processing, push business logic into the database layer, and interface with Java and web applications. Table of Contents PL/SQL Fundamentals Essential SQL Looping and Logic Functions, Packages, and Procedures Triggers Type Conversion Numbers, Strings, and Dates Dynamic SQL Exceptions PL/SQL Collections and Records Automating Routine Tasks Oracle SQL Developer Analyzing and Improving Performance Using PL/SQL on the Web Java in the Database Accessing PL/SQL from JDBC, HTTP, Groovy, and Jython Unit Testing With utPLSQL