Your cart is empty
Discover the latest advantages that Microsoft (R) Access (R) has to offer with this new book in the next generation of the Shelly Cashman Series (R). For three decades, the Shelly Cashman Series (R) has effectively introduced essential computer skills to millions of students like you. ENHANCED MICROSOFT ACCESS 2013: COMPREHENSIVE continues the history of innovation with new features that accommodate your learning style. Specially refined learning tools help improve your retention and prepare you for future success while new labs integrate cloud and web technologies with MS Access. This book's trademark step-by-step, screen-by-screen approach now guides you in expanding your understanding of Microsoft Access 2013 through experimentation, critical thought, and personalization. Trust ENHANCED MICROSOFT ACCESS 2013: COMPREHENSIVE to help you succeed with today's most effective educational approach.
A concise reference to the enormous store of information Oracle8 or Oracle7 DBAs need every day, Oracle Database Administration covers DBA tasks like installation, tuning, backups, networking, auditing, and query optimization. It's also a set of quick references on initialization parameters, SQL statements, data dictionary tables, system privileges, roles, and syntax for SQL*Plus, Export, Import, and SQL*Loader.
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
SQL Server Integration Services Design Patterns is newly-revised for SQL Server 2014, and is a book of recipes for SQL Server Integration Services (SSIS). Design patterns in the book help to solve common problems encountered when developing data integration solutions. The patterns and solution examples in the book increase your efficiency as an SSIS developer, because you do not have to design and code from scratch with each new problem you face. The book's team of expert authors take you through numerous design patterns that you'll soon be using every day, providing the thought process and technical details needed to support their solutions. SQL Server Integration Services Design Patterns goes beyond the surface of the immediate problems to be solved, delving into why particular problems should be solved in certain ways. You'll learn more about SSIS as a result, and you'll learn by practical example. Where appropriate, the book provides examples of alternative patterns and discusses when and where they should be used. Highlights of the book include sections on ETL Instrumentation, SSIS Frameworks, Business Intelligence Markup Language, and Dependency Services. Takes you through solutions to common data integration challenges Provides examples involving Business Intelligence Markup Language Teaches SSIS using practical examples
If you want a reference to show you practical solutions, or just want to satisfy your need for more knowledge of this fantastic NoSQL database, then this book is ideal for you. To get the most out of this book, you should know the basics of MongoDB.
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.
Oracle RMAN for Absolute Beginners is a gentle introduction to the use of Oracle's Recovery Manager software to make backups of an Oracle database, and to restore all or part of a database in the event that data loss occurs. It is often said that a database administrator's #1 job responsibility is to be able to recover from data loss. If you're new to the Oracle platform, or you're new to database administration in general, you can hardly go wrong by making it your first priority to learn to backup and recover the database that has been entrusted into your hands. This book is short and sweet at just 200 pages. Focus lies on the mainstream use cases. Recovery Manager, or RMAN as it is called, is a powerful and complex tool that can be intimidating at first. Author Darl Kuhn understands the need to focus on the core use cases, building your confidence in the tool, and in your ability to recover from lost database files, and even to recover your entire database should that become necessary. Oracle RMAN for Absolute Beginners shows how to backup your database. That's the first job. You'll learn to backup the entire database, and to create incremental backups that in turn can speed restore and recovery operations. Then you'll learn to recover from lost data files, lost redo log files, lost control files, and even to restore the entire database from scratch. You'll even learn how to clone a database for development and test purposes by backing the database up on one system and restoring it onto another. Author Darl Kuhn has a decade and a half of experience in writing about, and teaching Oracle Database backup and recovery. If you are newly responsible for an Oracle Database, you can hardly do better than to pick up a copy of Oracle RMAN for Absolute Beginners.
Develop RESTful web services using the Flask micro-framework and integrate them using MySQL. Use Flask to develop, deploy, and manage REST APIs with easy-to-read and understand Python code. Solve your problem from a choice of libraries. Learn to use MySQL as the web services database for your Flask API using SQLAlchemy ORM. Building REST APIs with Flask provides a primer on Flask, RESTful services, and working with pip to set up your virtual environment. The key differences between NoSQL and SQL are covered, and you are taught how to connect MySQL and Flask using SQLAlchemy. Author Kunal Relan presents best practices for creating REST APIs and guides you in structuring your app and testing REST endpoints. He teaches you how to set up authentication and render HTML using views. You learn how to write unit tests for your REST APIs, and understand mocks, assertions, and integration testing. You will know how to document your REST APIs, deploy your Flask application on all of the major cloud platforms, and debug and monitor your Flask application. What You'll Learn Use MySQL to create Flask REST APIs Test REST endpoints Create CRUD endpoints with Flask and MySQL Deploy Flask on all of the major cloud platforms Monitor your Flask application Who This Book Is For Python developers interested in REST API development using Flask and web developers with basic programming knowledge who want to learn how Python and REST APIs work together. Readers should be familiar with Python (command line, or at least pip) and MySQL.
Expert Oracle Exadata, 2nd Edition opens up the internals of Oracle's Exadata platform so that you can fully benefit from the most performant and scalable database hardware appliance capable of running Oracle Database. This edition is fully-updated to cover Exadata 5-2 and Oracle Database 12c. If you're new to Exadata, you'll soon learn that it embodies a change in how you think about and manage relational databases. A key part of that change lies in the concept of offloading SQL processing to the storage layer. In addition there is Oracle's engineering effort in creating a powerful platform for both consolidation and transaction processing. The resulting value proposition in the form of Exadata has truly been a game-changer. Expert Oracle Exadata, 2nd Edition provides a look at the internals and how the combination of hardware and software that comprise Exadata actually work. Authors include Martin Bach, Andy Colvin, and Frits Hoogland, with contributions from Karl Arao, and built on the foundation laid by Kerry Osborne, Randy Johnson, and Tanel Poder in the first edition. They share their real-world experience gained through a great many Exadata implementations, possibly more than any other group of experts today. Always their goal is toward helping you advance your career through success with Exadata in your own environment. This book is intended for readers who want to understand what makes the platform tick and for whom-"how" it does what it is does is as important as what it does. By being exposed to the features that are unique to Exadata, you will gain an understanding of the mechanics that will allow you to fully benefit from the advantages that the platform provides. This book changes how you think about managing SQL performance and processing. It provides a roadmap to successful Exadata implementation. And it removes the "black box" mystique. You'll learn how Exadata actually works and be better able to manage your Exadata engineered systems in support of your business. This book: Changes the way you think about managing SQL performance and processing Provides a roadmap to successful Exadata implementation Removes the "black box" mystique, showing how Exadata actually works
All production environments need automated, auditable, and reproducible processes. This book discusses how to automate all aspects of WebLogic, an essential prerequisite for all production environments. The WebLogic Server platform is recognized as one of the leading J2EE application servers and is the foundation of the Fusion Middleware platform. It is well suited for a variety of different application architectures including modern grid and cloud infrastructures. A large number of WebLogic installations from a single server to thousands of servers exist all over the world. Complex environments may consist of hundreds of domains and thousands of managed-servers. It is impossible for an administrator group to maintain all those servers with manual tasks or the web console. This book is written based on 15+ years of experience with many real architecture and consultancy assignments, and includes tips based on lessons learned from real project experience. Its main focus is to teach readers who are already familiar with WebLogic how to use the powerful automation APIs to operate WebLogic in small to very complex environments. This book includes many practical examples that can be easily adapted to the reader's needs. This book does not use the WebLogic GUI nor talk about J2EE programming; it focuses on automation only. A comprehensive code download of powerful WLST and JMX scripts is also provided.
Protecting Oracle Database 12c helps you solve the problem of maximizing the safety, resilience, and security of an Oracle database whilst preserving performance, availability, and integration. The book demonstrates through coded examples how to enable the consolidation features of Oracle Database 12c without increasing risk of either internal corruption or external vulnerability. In addition, new protections not publicly available are included in a task-based recipe format so that demonstrable risk improvements can be achieved, measured, and communicated to higher management. Most importantly, the challenge of privileged access control within a consolidation environment will be addressed, thus enabling a safe move to greater efficiency. * Demonstrates the securing of software and identity vulnerabilities. * Guides in implementing access controls over privileged accounts. * Helps you integrate with identity access management systems. * Provides a safe path to consolidation using the new, pluggable database feature set.
In this text, John Garmany leverages his ability to explain complex issues in plain English into a one-of-a-kind book for SQL and SQL*Plus beginners. This book is intended for anyone who needs to extract Oracle data and format reports. John reveals even more secrets for quickly and easily producing stunning reports from Oracle. Unknown to most Oracle professionals, special SQL extraction techniques and SQL*Plus commands can be used to quickly create complex reports, without buying expensive third-party reporting tools. Best of all, John Garmany's exciting second edition shares more working samples in his online code depot than before. Your time savings from a single script is worth the price of this great book. Easy Oracle SQL is your introduction to using SQL and SQL*Plus with an Oracle database. Whether you are just learning SQL or just need a handy reference, this book will provide you with proven methods to building queries and reports using SQL. Each concept is explained in detail with multiple examples and exercises at the end of each section. Also included is a section detailing how to effectively use SQL*Plus to not only create and run queries but also to create quality reports and scripts. This book will have you up and using SQL quickly and efficiently.
"Eric and Russell were early adopters of Cassandra at SimpleReach. In Practical Cassandra, you benefit from their experience in the trenches administering Cassandra, developing against it, and building one of the first CQL drivers. If you are deploying Cassandra soon, or you inherited a Cassandra cluster to tend, spend some time with the deployment, performance tuning, and maintenance chapters... If you are new to Cassandra, I highly recommend the chapters on data modeling and CQL." -From the Foreword by Jonathon Ellis, Apache Cassandra Chair Build and Deploy Massively Scalable, Super-fast Data Management Applications with Apache Cassandra Practical Cassandra is the first hands-on developer's guide to building Cassandra systems and applications that deliver breakthrough speed, scalability, reliability, and performance. Fully up to date, it reflects the latest versions of Cassandra-including Cassandra Query Language (CQL), which dramatically lowers the learning curve for Cassandra developers. Pioneering Cassandra developers and Datastax MVPs Russell Bradberry and Eric Lubow walk you through every step of building a real production application that can store enormous amounts of structured, semi-structured, and unstructured data. Drawing on their exceptional expertise, Bradberry and Lubow share practical insights into issues ranging from querying to deployment, management, maintenance, monitoring, and troubleshooting. The authors cover key issues, from architecture to migration, and guide you through crucial decisions about configuration and data modeling. They provide tested sample code, detailed explanations of how Cassandra works "under the covers," and new case studies from three cutting-edge users: Ooyala, Hailo, and eBay. Coverage includes Understanding Cassandra's approach, architecture, key concepts, and primary use cases- and why it's so blazingly fast Getting Cassandra up and running on single nodes and large clusters Applying the new design patterns, philosophies, and features that make Cassandra such a powerful data store Leveraging CQL to simplify your transition from SQL-based RDBMSes Deploying and provisioning through the cloud or on bare-metal hardware Choosing the right configuration options for each type of workload Tweaking Cassandra to get maximum performance from your hardware, OS, and JVM Mastering Cassandra's essential tools for maintenance and monitoring Efficiently solving the most common problems with Cassandra deployment, operation, and application development
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.
SQL Server 2012 Prep and Reference for Exam 70-461 is the first in a series covering Microsoft's premium database product SQL Server. It, and all subsequent books on the subject, uses Microsoft's published list of certification test contents to identity the important elements of SQL Server according to Microsoft. 18 chapters divide the topic list for the T-SQL development certification test 70-461. The chapters are grouped into sections. The sections are those provided by Microsoft in grouping the test topics. Using this Jake's Book as a resource, you can quickly organize your strengths and weaknesses to prepare for the test. Using Jake's book, you can practice scores of examples to test them for use in your work. Unlike all singly-focused certification resources, this book prepares you for the exam AND provides you a quick reference to use in your work.
Loved by instructors for the visual and flexible way to build computer skills, the Illustrated Course Guides are ideal for teaching Microsoft Access 2013 to students across experience levels. Each two-page spread focuses on a single skill, making information easy to follow and absorb. The Illustrated Course Guides split Microsoft Access 2013 concepts and skills into three manageable levels - Basic, Intermediate, and Advanced - perfect for workshops or accelerated courses.
A straightforward, full-color guide to showcasing data so your audience can see what you mean, not just read about it
Big data is big news Every company, industry, not-for-profit, and government agency wants and needs to analyze and leverage datasets that can quickly become ponderously large. Data visualization software enables different industries to present information in ways that are memorable and relevant to their mission. This full-color guide introduces you to a variety of ways to handle and synthesize data in much more interesting ways than mere columns and rows of numbers.
Learn meaningful ways to show trending and relationships, how to convey complex data in a clear, concise diagram, ways to create eye-catching visualizations, and much more Effective data analysis involves learning how to synthesize data, especially big data, into a story and present that story in a way that resonates with the audienceThis full-color guide shows you how to analyze large amounts of data, communicate complex data in a meaningful way, and quickly slice data into various viewsExplains how to automate redundant reporting and analyses, create eye-catching visualizations, and use statistical graphics and thematic cartographyEnables you to present vast amounts of data in ways that won't overwhelm your audience
Part technical manual and part analytical guidebook, "Data Visualization For Dummies" is the perfect tool for transforming dull tables and charts into high-impact visuals your audience will notice...and remember.
Oracle Exadata Survival Guide is a hands-on guide for busy Oracle database administrators who are migrating their skill sets to Oracle's Exadata database appliance. The book covers the concepts behind Exadata, and the available configurations for features such as smart scans, storage indexes, Smart Flash Cache, hybrid columnar compression, and more. You'll learn about performance metrics and execution plans, and how to optimize SQL running in Oracle's powerful, new environment. The authors also cover migration from other servers. Oracle Exadata is fast becoming the standard for large installations such as those running data warehouse, business intelligence, and large-scale OLTP systems. Exadata is like no other platform, and is new ground even for experienced Oracle database administrators. The Oracle Exadata Survival Guide helps you navigate the ins and outs of this new platform, de-mystifying this amazing appliance and its exceptional performance. The book takes a highly practical approach, not diving too deeply into the details, but giving you just the right depth of information to quickly transfer your skills to Oracle's important new platform.* Helps transfer your skills to the platform of the future * Covers the important ground without going too deep * Takes a practical and hands-on approach to everyday tasks What you'll learn * Learn the components and basic architecture of an Exadata machine * Reduce data transfer overhead by processing queries in the storage layer * Examine and take action on Exadata-specific performance metrics * Deploy Hybrid Columnar Compression to reduce storage and I/O needs * Create worry-free migrations from existing databases into Exadata * Understand and address issues specific to ERP migrations Who this book is for Oracle Exadata Survival Guide is for the busy enterprise Oracle DBA who has suddenly been thrust into the Exadata arena. Readers should have a sound grasp of traditional Oracle database administration, and be prepared to learn new aspects that are specific to the Exadata appliance.
You may like...
Knight's Microsoft SQL Server 2012…
Brian Knight, Devin Knight, … Paperback
Database Systems: Pearson New…
Hector Garcia-Molina, Jeffrey Ullman, … Paperback R1,722 Discovery Miles 17 220
Oracle Database 10g RMAN Backup…
Matthew Hart, Robert Freeman Paperback
Robin Nixon Paperback
Portable DBA Oracle
Robert Freeman Paperback
Access 2016 Bible
Michael Alexander, Richard Kusleika Paperback
Laravel: Up & Running - A Framework for…
Matt Stauffer Paperback
New Perspectives on Microsoft (R) Access…
Joseph Adamski, Kathy Finnegan Paperback
Professional Microsoft SQL Server 2016…
Paul Turley Paperback
Oracle Business Intelligence 11g…
Mark Rittman Paperback