Book Description

Expert PL/SQL Practices is a book of collected wisdom on PL/SQL programming from some of the best and the brightest in the field. Each chapter is a deep-dive into a specific problem, technology, or feature set that you’ll face as a PL/SQL programmer. Each author has chosen their topic out of the strong belief that what they share can make a positive difference in the quality and scalability of code that you write.

The path to mastery begins with syntax and the mechanics of writing statements to make things happen. If you’ve reached that point with PL/SQL, then let the authors of Expert PL/SQL Practices show you how to combine syntax and mechanics with features and techniques to really make the language sing. You’ll learn to do more with less effort, to write code that scales and performs well, and to eliminate and avoid defects.

These authors are passionate about PL/SQL and the power it places at your disposal. They want you to succeed, to know all that PL/SQL can offer. Let Expert PL/SQL Practices open your eyes to the full power of Oracle’s world-class language for the database engine.

• Goes beyond the manual to cover good techniques and best practices
• Delivers knowledge usually gained only by hard experience
• Covers the functionality that distinguishes PL/SQL as a powerful and scalable programming language for deploying logic inside the database engine

Download Now »

Book Description

Apache Cassandra is a fault-tolerant, distributed data store which offers linear scalability allowing it to be a storage platform for large high volume websites.

This book provides detailed recipes that describe how to use the features of Cassandra and improve its performance. Recipes cover topics ranging from setting up Cassandra for the first time to complex multiple data center installations. The recipe format presents the information in a concise actionable form.

The book describes in detail how features of Cassandra can be tuned and what the possible effects of tuning can be. Recipes include how to access data stored in Cassandra and use third party tools to help you out. The book also describes how to monitor and do capacity planning to ensure it is performing at a high level. Towards the end, it takes you through the use of libraries and third party applications with Cassandra and Cassandra integration with Hadoop.

What you will learn from this book :

• Interact with Cassandra using the command line interface
• Write programs that access data in Cassandra
• Configure and tune Cassandra components to enhance performance
• Model data to optimize storage and access
• Use tunable consistency to optimize data access Download Now »

Book Description

Get hands-on experience with SPARQL, the RDF query language that’s become a key component of the semantic web. With this concise book, you will learn how to use the latest version of this W3C standard to retrieve and manipulate the increasing amount of public and private data available via SPARQL endpoints. Several open source and commercial tools already support SPARQL, and this introduction gets you started right away.

Begin with how to write and run simple SPARQL 1.1 queries, then dive into the language’s powerful features and capabilities for manipulating the data you retrieve. Learn what you need to know to add to, update, and delete data in RDF datasets, and give web applications access to this data.

• Understand SPARQL’s connection with RDF, the semantic web, and related specifications
• Query and combine data from local and remote sources
• Copy, convert, and create new RDF data
• Learn how datatype metadata, standardized functions, and extension functions contribute to your queries
• Incorporate SPARQL queries into web-based applications

Table of Contents
Chapter 1 Jumping Right In: Some Data and Some Queries
Chapter 2 The Semantic Web, RDF, and Linked Data (and SPARQL)
Chapter 3 SPARQL Queries: A Deeper Dive
Chapter 4 Copying, Creating, and Converting Data (and Finding Bad Data) Download Now »

Book Description

Microsoft SQL Server Master Data Services (MDS) enables organizations to manage and maintain business data used to make critical business decisions. MDS is a Master Data Management (MDM) application, which standardizes and streamlines the critical data entities of an organization, essentially centralizing your master data.

A focused, practical tutorial, this book will show you how to manage and maintain your organization’s master data and improve data quality with Microsoft SQL Server 2008 R2 Master Data Services. Using credible techniques and an end-to-end approach, this book will take you through the steps required to implement Master Data Management, enabling business users to standardize and streamline their business data.

This book will enable you to manage and maintain your organization’s master data with Microsoft SQL Server 2008 R2 Master Data Services, covering each feature in a step-by-step manner. The book starts with an overview of Master Data Management. You will then move on to an overview of Microsoft SQL Server 2008 R2 Master Data Services (MDS). The book then dives deep into topics such as installing, configuring, and maintaining Master Data Services, creating and using Models, Version Management, Business Rules, and importing Data into Master Data Services amongst others.

A comprehensive guide to Microsoft SQL Server 2008 R2 Master Data Services, which uses an end-to-end approach showing you how to implement Master Data Management on the Microsoft platform. Download Now »

Book Description

You’re beyond the basics, so dive right in and customize, automate, and extend Access—using Visual Basic® for Applications (VBA). This supremely organized reference is packed with hundreds of time-saving solutions, troubleshooting tips, and workarounds. It’s all muscle and no fluff. Discover how the experts use VBA to exploit the power of Access—and challenge yourself to new levels of mastery!

• Enhance your application with VBA built-in functions and SQL code
• Use the Access Object Model to work with data in forms and reports
• Manipulate data using SQL, queries, and recordsets with Data Access Objects (DAO)
• Create classes for handling form and control events
• Connect your Access database to different sources of data
• Effectively plan how to upsize an existing Access database to Microsoft SQL Server®
• Dynamically update Microsoft Excel® spreadsheets from the database
• Migrate your Access database directly to the cloud using SQL Azure™

About the Author
Andrew Couch is a Microsoft Access MVP. He has been programming with VBA since it was introduced into the Access product, and uses VBA on a daily basis in commercial applications. As a director and founding member of the UK Access User Group, he has been involved with developers and software companies using VBA. Download Now »

Book Description

Along with MySQL’s popularity has come a flood of questions about solving specific problems, and that’s where this Cookbook is essential. Designed as a handy resource when you need quick solutions or techniques, the book offers dozens of short, focused pieces of code and hundreds of worked-out examples for programmers of all levels who don’t have the time (or expertise) to solve MySQL problems from scratch.

The new edition covers MySQL 5.0 and its powerful new features, as well as the older but still widespread MySQL 4.1. One major emphasis of this book is how to use SQL to formulate queries for particular kinds of questions, using the mysql client program included in MySQL distributions. The other major emphasis is how to write programs that interact with the MySQL server through an API. You’ll find plenty of examples using several language APIs in multiple scenarios and situations, including the use of Ruby to retrieve and format data. There are also many new examples for using Perl, PHP, Python, and Java as well.

Other recipes in the book teach you to:

• Access data from multiple tables at the same time
• Use SQL to select, sort, and summarize rows
• Find matches or mismatches between rows in two tables
• Determine intervals between dates or times, including age calculations
• Store images into MySQL and retrieve them for display in web pages
• Get LOAD DATA to read your data files properly or find which values in the file are invalid Download Now »