One of the most important challenges faced by Oracle database administrators and Oracle developers is the need to tune SQL statements so that they execute efficiently. Poorly tuned SQL statements are one of the leading causes of substandard database performance and poor response time. SQL statements that perform poorly result in frustration for users, and can even prevent a company from serving its customers in a timely manner.In this book, Mark Gurry shares his in-depth knowledge ...

SAP HANA is the SAP product for in-memory computing. It streamlines transactions, analytics, planning, and data processing on a single in-memory database allowing businesses to operate in real-time. Over the course of the last few years, the authors have led many diverse SAP HANA projects with extraordinary success resulting in 10,000, or in some cases even 100,000, times improvement of system performance.In this book, the authors share their findings from SAP HANA projects to help...

Forms that Work: Designing Web Forms for Usability clearly explains exactly how to design great forms for the web. The book provides proven and practical advice that will help you avoid pitfalls, and produce forms that are aesthetically pleasing, efficient and cost-effective. It features invaluable design methods, tips, and tricks to help ensure accurate data and satisfied customers. It includes dozens of examples - from nitty-gritty details (label alignment, mandatory fields) to visual de...

Offering real-world insight and explanations, this book provides a roadmap for organizations looking to develop a profitable big data strategy and reveals why it's not something they can leave to the I.T. department.Big data--the enormous amount of data that is created as virtually every movement, transaction, and choice we make becomes digitized--is revolutionizing business. Sharing best practices from companies that have implemented a big data strategy including ...

This book has individual recipes and you can read it from cover to cover or dip into any recipe and get solution to a specific issue. Every recipe is based on a script/procedure explained with step-by-step instructions and screenshots. Concepts are illustrated for better understanding of why one solution performs better than another. SQL Server 2012 Performance Tuning Cookbook is aimed at SQL Server Database Developers, DBAs, and Database Architects who are working in any capacity to achie...

The essential getting started guide to Oracle Database 12c. This book covers:* Installation* Database Fundamentals* Database Creation* Tablespaces* User Accounts and Roles* Database Schema (tables, indexes, sequences, synonyms, views...)* RMAN Backups and more!

The Oracle Utilities Pocket Reference is a handy, quick-reference guide to the multitude of Oracle utilities that database administrators (DBAs) use every hour of every day.As the undisputed leader among database products, Oracle is grasped conceptually by most DBAs. However, they understandably may not recall the specific utility to use for a given task, and, more commonly, won't in many cases remember the syntax to use. And that's exactly what the Oracle Utilities Pocket Ref...

Dive into SQLAlchemy, the popular, open-source code library that helps Python programmers work with relational databases such as Oracle, MySQL, PostgresSQL, and SQLite. Using real-world examples, this practical guide shows you how to build a simple database application with SQLAlchemy, and how to connect to multiple databases simultaneously with the same metadata.SQL is a powerful language for querying and manipulating data, but it’s tough to integrate it with your application. SQL...

SQL Server 2008 is how-to guide for experienced DBAs. Tutorial-based, this book will get you over the learning curve of how to configure and administer SQL Server 2008. Whether you're an administrator or developer using SQL Server, you can't avoid wearing a DBA hat at some point. The book is loaded with unique tips and workarounds for the most difficult SQL Server admin issues, including managing and monitoring SQL Server, automating administration, security, performance tuning, s...

SQL Server 2005, Microsoft's next-generation data management and analysis solution, represents a huge leap forward. It comes with a myriad of changes that deliver increased security, scalability, and power--making it the complete data package. Used properly, SQL Server 2005 can help organizations of all sizes meet their data challenges head on.Programming SQL Server 2005 from O'Reilly provides a practical look at this updated version of Microsoft's premier database product...

This book is specially written for students of Computer Engineering (CE) and Information Technology.Also every one with interest in Database Management System can refer this book to get the knowledge about RDBMS.It covers virtually most of core features and some of the advanced features of RDBMS for administrator development including more than hands on examples tested through Oracle 9i. Most of code samples are presented in easy to use through Oracle. Throughout the book m...

The Definitive Guide to MongoDB, Second Edition, is updated for the latest version and includes all of the latest MongoDB features, including the aggregation framework introduced in version 2.2 and hashed indexes in version 2.4. MongoDB is the most popular of the "Big Data" NoSQL database technologies, and it's still growing. David Hows from 10gen, along with experienced MongoDB authors Peter Membrey and Eelco Plugge, provide their expertise and experience in teaching you everything you ne...