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 Definitive Guide to SQL Get comprehensive coverage of every aspect of SQL from three leading industry experts. Revised with coverage of the latest RDBMS software versions, this one-stop guide explains how to build, populate, and administer high-performance databases and develop robust SQL-based applications. SQL: The Complete Reference, Third Edition shows you how to work with SQL commands and statements, set up relational databases, load and modify database objects, perform powerful queries, tune performance, and implement reliable security policies. Learn how to employ DDL statements and APIs, integrate XML and Java scripts, use SQL objects, build web servers, handle remote access, and perform distributed transactions. Techniques for managing in-memory, stream, and embedded databases that run on today's mobile, handheld, and wireless devices are included in this in-depth volume. Build SQL-based relational databases and applications Create, load, and modify database objects using SQL Construct and execute simple, multitable, and summary queries Implement security measures with authentication, privileges, roles, and views Handle database optimization, backup, recovery, and replication Work with stored procedures, functions, extensions, triggers, and objects Extend functionality using APIs, dynamic SQL, and embedded SQL Explore advanced topics such as DBMS transactions, locking mechanisms, materialized views, and two-phase commit protocol Understand the latest market trends and the future of SQL

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. Install and Configure Grid Control to Manage Your Oracle Landscape Build a robust grid computing infrastructure with guidance from an Oracle expert who developed and taught the Grid Control Deep Dive class to Oracle Consulting. Featuring real-world examples and best practices, Oracle Enterprise Manager 10g Grid Control Implementation Guide explains how to reliably and cost-effectively deploy a dynamic Grid Control environment. Learn how to lay the preinstallation groundwork, configure targets for monitoring, create services, implement security, and fine-tune performance. You'll also get full coverage of backup and recovery strategies and high-availability techniques. Prepare infrastructure hosts for Grid Control rollout Install the Oracle management repository, service, and agents Select the Grid Control installation options that fit your needs Discover and manage host, database, and application server targets Set target metrics and policies according to best practices Optimize performance and availability of your Grid Control framework Secure the Grid Control framework to protect data transmitted between components

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

The Only Authorized Guide to IBM Cognos 8 Business Intelligence

Develop, deploy, and maintain a complete BI solution across your enterprise. IBM Cognos 8 Business Intelligence: The Official Guide shows you how to take full advantage of the robust service-oriented architecture and simplified role-based user interfaces. Learn how to create, share, and analyze data-rich reports that lead to increased productivity and better business decisions. Featuring real-world insight and expert tips, this is a must-have guide for IBM Cognos 8 Business Intelligence users of all levels, from administrators to end users. Measure and monitor performance using dashboards and scorecardsAndnbsp;Andnbsp;Andnbsp;Andnbsp; Assign user roles and privileges Andnbsp;Andnbsp;Andnbsp;Andnbsp;Andnbsp;Andnbsp;Andnbsp;Andnbsp;Andnbsp;Andnbsp;Andnbsp; Provide complete and consistent access to a broad range of data sources via Cognos ConnectionUse Cognos 8 Go! to extend BI to Office applications, mobile devices, and search enginesEnable business users to create reports with Query StudioDevelop new insights by exploring data in multiple dimensions and perspectives with Analysis StudioBuild Dimensional Reports with Report StudioUse Event Studio to identify and deliver mission-critical information Create, modify, organize, and publish a model from Cognos Framework ManagerAndnbsp;Andnbsp;Andnbsp;Andnbsp;Andnbsp;Andnbsp;Andnbsp;Andnbsp; Implement sound security measures Take advantage of the management tools in Cognos Administration to ensure maximum reliability and availability

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 Deploy Highly Responsive Data-Driven Web 2.0 Applications Deliver next-generation user capabilities and client-side services in your Oracle-based Web applications by combining the powerful features of AJAX and PHP. Written by Web 2.0 programming experts, Oracle Database AJAX & PHP Web Application Development shows you how to design faster, lighter, more responsive Web applications while reducing code support and creation time. You'll learn how to develop modular AJAX and PHP code, add dynamically updated content, and implement click-to-edit and drag-and-drop functionality. You'll also get details on incorporating cutting-edge mashup, reporting, and communication features. Build robust Web applications that utilize the latest AJAX, PHP, and modularity techniques Construct AJAX and PHP objects, controllers, iframes, and models Simplify programming with reusable modules, open-source libraries, and templates Optimize scalability, availability, performance, and security Auto-refresh Web pages and execute XML calls using the HttpRequest object Add HTML drill-down tables, DOM drag-and-drop, and click-to-edit features Retrieve data from external sources using Remote Procedure Calls and Pear-based services Solve browser navigation button, bookmarking, and history tracking issues Allow end users to customize Web pages using tracking, JSON, and mashups Facilitate client-side communication with VOIP, IM, targeted reporting, and file sharing

Transform disparate enterprise data into actionable business intelligence

Put timely, mission-critical information in the hands of employees across your organization using Microsoft SQL Server 2005 and the comprehensive information in this unique resource. "Delivering Business Intelligence with Microsoft SQL Server 2005" shows you, step-by-step, how to author, customize, and distribute information that will give your company the competitive edge. It's all right here -- from data mining, warehousing, and scripting techniques to MDX queries, KPI analysis, and the all-new Unified Dimensional Model. Real-world examples, start-to-finish exercises, and downloadable code throughout illustrate all of the integration, analysis, and reporting capabilities of SQL Server 2005.

ESSENTIAL SKILLS FOR DATABASE PROFESSIONALSUnderstand the goals and benefits of business intelligence Manage Analysis Services databases using BI Development Studio Improve performance and decrease latency using proactive caching Create interactive reports using SQL Server 2005 Reporting Services Enable ad hoc reporting using Report Models and Report Builder Integrate with applications using ADOMD.NET and the Report Viewer Control Design and create relational data marts and OLAP cubes Perform powerful data analysis using MDX queries and scripts Perform complex operations with Integration Services Uncover behavior patterns and proclivities using data mining

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. Develop and Deploy Fast, Secure Web ApplicationsEven if you have limited programming experience, you can develop and deploy professional-quality applications using Oracle's new rapid web application development tool. Oracle HTML DB Handbook shows you how to quickly create secure and scalable web applications that can be instantly deployed. Learn how you can consolidate spreadsheets and desktop databases into an Oracle Database and share your applications over the web. You'll also get details on administration and security. Real-world sample projects get you started using Oracle HTML DB right away. Install and configure Oracle HTML DB Work with Oracle database objects using SQL Workshop Create, review, edit, run and delete application elements with the HTML DB Application Builder Work with themes and templates Create, edit, and delete HTML DB pages Work with reports and process forms Implement navigational elements in applications Administer and manage applications and users Add computations, processes, and validations to applications Implement HTML DB security measures

The Essential Resource for All Oracle Database Administrators

Maintain a high-performance Oracle enterprise database with help from this exclusive Oracle Press guide. "Oracle Database 10"g" DBA Handbook" explains how to install Oracle Database 10"g," or upgrade from an earlier version, and take full advantage of all the new and improved management, scalability, availability, and security features. Written by Oracle experts, the book covers Automatic Undo Management, Oracle Real Application Clusters, Oracle Recovery Manager, Oracle Data Guard, and much more. Plan tablespaces--including bigfiles and multiple temporary tablespaces--and physical database layout Manage disk space and CPU usage Use Automatic Undo Management to manage transactions Tune queries using the SQL Access Advisor Monitor and tune your database with the Automated Workload Repository and STATSPACK Implement fine-grained security using authentication, authorization, and auditing techniques Automate the management of the memory areas Enable high availability using Oracle Real Application Clusters Perform backup and recovery with Oracle Recovery Manager Use Oracle Data Guard and the flashback features for data protection and disaster recovery Manage Very Large Databases (VLDB) and distributed databases

About the Authors: Kevin Loney is a senior technical management consultant with TUSC, a Chicago-based consultancy providing Oracle solutions. He has been an Oracle developer and DBA since 1987, and has written for Oracle Magazine and Oracle Press since 1990. In 2002, he was named Oracle Magazine's Editors' Choice as Consultant of the Year. He is a frequent and highly rated speaker at local and international Oracleuser groups. Bob Bryla is an Oracle 8, 8"i," 9 and 10"g" Certified Professional with more than 15 years of experience in database design, database application development, training, and Oracle database administration. He is the primary Internet database designer and an Oracle DBA at Lands' End in Dodgeville, Wisconsin.

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 Release 2 Real Application Clusters with this comprehensive, fully updated guideNow you can maintain a dynamic enterprise computing infrastructure with expert instruction from an Oracle ACE. Oracle Database 12c Release 2 Real Application Clusters Handbook: Concepts, Administration, Tuning, and Troubleshooting has been thoroughly revised and updated to cover the latest tools and features. Find out how to prepare your hardware, deploy Oracle Real Application Clusters, and integrate seamless failover protection. Troubleshooting, performance tuning, and application development are also discussed in this comprehensive Oracle Press guide.* Install and configure Oracle Database 12c Release 2 Real Application Clusters* Configure and manage disk groups using Oracle Automatic Storage Management* Work with services, voting disks, and Oracle Clusterware repository* Diagnose performance problems with Oracle Wait Interface* Look under the hood of Cache Fusion and Global Resource Directory operations* Explore the internal workings of backup and recovery in Oracle Real Application Clusters* Employ workload balancing and Transparent Application Failover* Troubleshoot Oracle Clusterware using advanced diagnostics* Develop custom Oracle Real Application Clusters applications

Master the powerful BI tools available in Microsoft SQL Server 2016Enable informed, timely decision making across any type of organization using the expert tips and best practices contained in this hands-on guide. Delivering Business Intelligence with Microsoft SQL Server 2016, Fourth Edition, fully explains how to effectively develop, customize, and distribute meaningful information. Thoroughly revised for Microsoft SQL Server 2016, the book shows, step-by-step, how to configure and populate databases, analyze the data, and deliver actionable business intelligence. You will discover how to build data marts, create BI Semantic Models, work with the MDX and DAX languages, and share insights using the latest Microsoft client tools. Microsoft BI Cloud, mobile client tools, and forecasting techniques are also covered in this comprehensive resource. * Example scenarios place the BI concepts and tools in real-world contexts * Sample code in the book is available for download though the companion website * Written by a Microsoft Certified Partner and experienced author

A data-driven, fact-based, quantitative text on Oracle performance and scalability

With database concepts and theories clearly explained in Oracle's context, readers quickly learn how to fully leverage Oracle's performance and scalability capabilities at every stage of designing and developing an Oracle-based enterprise application. The book is based on the author's more than ten years of experience working with Oracle, and is filled with dependable, tested, and proven performance optimization techniques.

"Oracle Database Performance and Scalability" is divided into four parts that enable readers to progressively learn and apply new skills:

Part 1, Getting Started with Oracle, describes how to set up a working Oracle environment, offering a quick tour to illustrate major database concepts

Part 2, Oracle Architecture from Performance and Scalability Perspectives, explains all the major database concepts and architectural features that readers need to know to optimize Oracle performance and scalability

Part 3, Optimizing Oracle Performance and Scalability, offers hands-on instructions to optimize and fine-tune performance and scalability for all database applications

Part 4, Case Studies: Oracle Meeting Real-World Performance and Scalability Challenges, sets forth quantitative case studies based on the author's first-hand experience that demonstrate how readers can apply proven techniques to dramatically improve the performance and scalability of actual database products

In addition to case studies, this book offers a detailed secure online banking application as an example, making it possible for readers to fully explore Oracle's performance and scalability features on their own. "Oracle Database Performance and Scalability" is an ideal text for pre-conditioning college students and training software developers.

This text serves as a complete guide to designing databases for optimal performance. A proper data model is the single most important aspect of database performance, and this book is a complete guide to designing databases to utilize database structures, using examples from the popular Oracle database. Not just a theory book, it combines data modeling theory with Oracle data structures. Physical Database Design Using Oracle shows how to model a structure for use by Oracle to achieve the highest performance.

Focusing on tried and true best practice techniques in cross-technology based Oracle embedded programming, this book provides authoritative guidance for improving your code compilation and execution. Geared towards IT professionals developing Oracle-based Web-enabled applications in PL/SQL, Java, C, C++, .NET, Perl, and PHP, it covers application development from concepts to customization, following a pragmatic approach to design, coding, testing, deployment, and customization explaining how to maximize embedded programming practices.

Oracle Embedded Programming and Application Development explains application development frameworks using 3GL and 4GL high-level language code as embedded code segments across .NET, Java, and Open Source technologies, in conjunction with SQL and/or PL/SQL and the Oracle RDBMS through version 11gR2. It also:

• Features pluggable code using parameterized constructs to promote code reuse
• Explains when to use a particular embedded language as a best fit for specific applications
• Highlights design considerations that reduce the probability of errors, enable quick resolution, and boost performance in terms of enabling a Fast-Actionable-Synchronized-Tested (FAST) solution implementation
• Provides best practice techniques that can enhance any application development code-design methodology for a better, easier, faster, cheaper, and pervasive solution that in turn helps achieve a Better Business Benefit (B-B-B)

This practical guide details techniques for constructing architecture and code design methodologies for live application development projects that can be generalized and standardized as application development and code design frameworks. Cover to cover, the text provides an understanding of how the designed, developed, and deployed solutions conform to emerging and next-generation trends. It also discusses the conformance and usage of Web 2.0-based RIA functionality and regulatory compliance practices involving auditing and security.

Praise for:

"Taking an Oracle-centric approach, Lakshman skillfully guides you through the maze of various popular programming languages and environments including .NET, C/C++, Perl, PHP, Java, and even SQL and PL/SQL not only showing you how they interact with Oracle but also which language is the best fit for a given situation."
John Kanagaraj, Executive Editor, IOUG SELECT Journal

Data warehouses are fundamentally different from OLTP (online transaction processing) systems, which are more familiar to developers and database administrators. This book gives you the concepts for understanding, designing, and delivering data warehouses as well as the technical tools for building them with MySQL.7The only book on data warehousing (business reports, queries) aimed at programmers and DBAs wanting to implement MySQL data warehouses, not strictly a database book7Uses real world examples; concise; task-based format, rather than just looking at the technologies involved.

Pro SQL Server 2005, Second Edition is a revised and expanded version of this classic and bestselling book, which provides in-depth coverage of all the key new SQL Server features and enhancements. It focuses on what experienced SQL Server DBAs, developers, and Business Intelligence practitioners need to know to get up to speed with SQL Server 2005 as quickly as possible. Each new feature is carefully presented and precisely illustrated using examples to show you how to use it most effectively. The second edition expands on the original by adding chapters on encryption, full-text search, LINQ, and the ADO.NET 3.0 Entity Data Model, bringing it up to date for .NET 3.5, and making it even more attractive than ever to readers. You'll find incisive, expert guidance on all of the major new functionality of SQL Server 2005 under one cover, including essential topics for all SQL Server professionals, such as Transact-SQL enhancements SQL Server Management Studio CLR integration and programming stored procedures in C# SQL Server Reporting Services enhancements SQL Server Analysis Services enhancements The new XML datatype and XQuery support Security enhancements and Service Broker SQL Server Integration Services for data extraction, transformation, and loading Encryption Full-text search ADO.NET 3.0 Entity Data Model A team of expert authors provides practical, in-depth coverage of the core topics each specializes in--all supported by realistic examples, so you'll be able to design and implement your own SQL Server 2005 solutions quickly and painlessly. This book is a roadmap for exploring and exploiting SQL Server 2005. So fasten your seatbelts, start your computers, and race tomastery of SQL Server 2005 What you'll learn How to use enhanced T-SQL statements and features How to use SQL Server Management Studio to manage databases How to program stored procedures in C# with SQLCLR How to use Reporting Services and Analysis Services enhancements How to use the new XML datatype and XQuery support How to take advantage of enhanced security features How to use Service Broker How to use Integration Services to extract, transform, and load data How to encrypt and decrypt data How to do full-text searches How to simply access data with LINQ How to use the ADO.NET 3.0 Entity Data Model Who is this book for? Pro SQL Server 2005, Second Edition is for every experienced SQL Server 2000 user who wants to quickly learn about the many major new features of SQL Server 2005. It's also for experienced SQL Server 2005 users who need to quickly master new features and exploit them to solve problems in a more efficient and effective way. Each chapter is a self-contained, in-depth introduction to a new feature. The wealth of information contained makes the book an indispensable reference for every database user, programmer, and administrator. About the Apress Pro Series The Apress Pro series books are practical, professional tutorials to keep you on and moving up the professional ladder. You have gotten the job, now you need to hone your skills in these tough competitive times. The Apress Pro series expands your skills and expertise in exactly the areas you need. Master the content of a Pro book, and you will always be able to get the job done in a professional development project. Written by experts in their field, Pro series books from Apress give you the hard-wonsolutions to problems you will face in your professional programming career. Related Titles from Apress Pro T-SQL 2005 Programmer's Guide Pro SQL Server 2005 Reporting Services Foundations of SQL Server 2005 Business Intelligence Expert C# 2005 Business Objects. Second Edition Foundations of LINQ in C#

Randy Nordell Microsoft(R) Office 2013: In Practice
"Topic, Instruction, Practice "

McGraw-Hill's Microsoft(R) Office 2013: In Practice offers a fresh, new approach to teaching today's students Microsoft(R) Office skills by clearly introducing skills in a logical sequence: 1) Topic 2) Instruction and 3) Practice. Nordell's "T.I.P.s" approach builds a foundation for success by helping students practice what they learn, and provides transferable skills that allow students to grasp critical thinking beyond the textbook assignment.

In Practice seamlessly integrates with SIMnet Online, McGraw-Hill's online learning and assessment solution, which has 1:1 content to help students practice and master computing concepts and Microsoft(R) Office skills. In Practice projects in SIMgrader allow students to practice their skills in a live Office application. Students receive immediate feedback upon completion of these auto-graded projects. The integration of In Practice with SIMnet helps to meet the diverse needs of students and accommodate individual learning styles.

Additional textbook resources can be found on the text's Online Learning Center: www.mhhe.com/office2013inpractice. For more information on Nordell; Microsoft(R) Office 2013: In Practice and SIMnet Online for Office 2013, please visit www.simnetkeepitsimple.com or contact your McGraw-Hill representative.

The first two editions of Inside Relational Databases have both been best sellers. These new editions will also cover the relational database model but will use different engines to illustrate the model. In doing so, readers will be able to apply the model using their preferred database engine. Initially three versions are planned starting with Access, SQL Server and my SQL.

The books show just how simple and useful databases can be. No prior knowledge is required i.e. real world examples show how to manage data efficiently.

A significant amount of new material is included in the core of the book and particular emphasis is given to showing how to make a database run faster and more efficiently.

UML (Unified Modeling Language) has become the standard notation for modeling O-O systems and is embraced by major software developers like Microsoft and Oracle. This title covers Object Oriented (O-O) concepts, tools, development life cycle, problem solving, modeling, analysis, and design, while utilizing UML for O-O modeling.

Help your students develop the complete Microsoft (R) Access 2016 skills they need to be successful in college and beyond with the emphasis on critical-thinking, problem-solving, and in-depth coverage found in NEW PERSPECTIVES MICROSOFT OFFICE 365 & ACCESS 2016: COMPREHENSIVE. Updated with all-new case-based modules, this thorough introduction applies the progressive skills students are learning to real-world situations to ensure that concepts remain highly relevant. A new Productivity Apps module visually introduces Microsoft (R) OneNote, Sway, Office Mix and Edge with fun, hands-on activities. Companion Sways provide videos and step-by-step instructions to help students learn to master each app. With an unmatched emphasis on learning outcomes and transference of skills, NEW PERSPECTIVES MICROSOFT (R) OFFICE 365 & ACCESS 2016: COMPREHENSIVE engages students by clearly demonstrating the importance of the extensive Microsoft (R) Access 2016 skills they're learning.

Discover the latest advancements in Microsoft (R) Access 2016 with MICROSOFT (R) OFFICE 365 & ACCESS 2016: INTERMEDIATE -- the new edition in today's generation of acclaimed Shelly Cashman Series (R) books. For more than three decades, the Shelly Cashman Series (R) has effectively introduced computer skills to millions. MICROSOFT (R) OFFICE 365 & ACCESS 2016: INTERMEDIATE continues the Series' strong history of innovation with a proven learning approach enhanced to address the learning styles of students like you. A trademark step-by-step, screen-by-screen approach encourages you to expand your understanding of Microsoft (R) Access 2016 through experimentation, critical thought, and personalization. This new edition delivers effective educational materials specifically designed to engage, improve retention, and prepare you for future success in working with both basic and more advanced Microsoft (R) Access 2016 skills.

Develop the higher-level Microsoft (R) Access 2016 skills you need to be successful in college and beyond with the emphasis on critical-thinking, problem-solving, and in-depth coverage found in NEW PERSPECTIVES MICROSOFT (R) OFFICE 365 & ACCESS 2016: INTERMEDIATE. Updated with all-new case-based modules, this dynamic introduction applies the skills you are learning to real-world situations to ensure that you see the relevance of the concepts you are learning. New Productivity Apps visually introduce Microsoft (R) OneNote, Sway, Office Mix and Edge with fun, hands-on activities. Companion Sways provide videos and step-by-step instructions to help you learn to use each app. NEW PERSPECTIVES MICROSOFT OFFICE 365 & ACCESS 2016: INTERMEDIATE clearly demonstrates the importance of the basic and more advanced skills you're mastering while helping you transfer those skills to other applications and disciplines for further success.

Loved by students like you for its visual and flexible approach to building computer skills, the ILLUSTRATED COURSE GUIDE: MICROSOFT (R) OFFICE 365 & ACCESS 2016: INTERMEDIATE is the ideal resource for learning Microsoft (R) Access 2016, regardless of your experience level. Each two-page spread focuses on a single skill, ensuring information is easy to follow and absorb. The ILLUSTRATED COURSE GUIDE divides important Microsoft (R) Access 2016 concepts and skills into three manageable levels -- Introductory, Intermediate, and Advanced -- making it perfect for mastering the skills you need in any learning environment.

Develop the Microsoft (R) Office and Access 2016 skills you need to be successful in college and beyond with the emphasis on critical-thinking, problem-solving, and in-depth coverage found in NEW PERSPECTIVES MICROSOFT (R) OFFICE 365 & ACCESS 2016: INTRODUCTORY. Updated with all new case-based modules, this dynamic introduction applies the skills you are learning to real-world situations to ensure that concepts remain highly relevant. New Productivity Apps visually introduce Microsoft (R) OneNote, Sway, Office Mix and Edge with fun, hands-on activities. Companion Sways provide videos and step-by-step instructions to help you learn to use each app. NEW PERSPECTIVES MICROSOFT OFFICE 365 & ACCESS 2016: INTRODUCTORY clearly demonstrates the importance of what you're learning while helping you transfer skills to other applications and disciplines for further success.