Teradata Cookbook

Over 100 recipes to help you implementing efficient data warehousing solutions with Teradata

About This Book
  • Take your understanding of Teradata to the next level and build efficient data warehousing applications for your organization
  • Covers recipes on data handling, warehousing, advanced querying and the administration tasks in Teradata
  • Contains practical solutions to tackle the common as well as the not-so-common problems you might encounter in your day to day activities
Who This Book Is For

This book is for DBAs and Teradata users who are looking for a practical, one-stop resource to solve all their problems while handling their Teradata solution. If you are looking to learn the basic as well as the advanced tasks involved in Teradata querying or admininstration, this book will also help you. Some knowledge of the relational database concepts will be helpful to get the best out of this book.

What You Will Learn
  • Understand Teradata's competitive advantage over other RDBMSs.
  • Use SQL to process data stored in Teradata tables.
  • Leverage Teradata’s available application utilities and parallelism to play with large datasets
  • Apply various performance turning techniques to optimize the queries.
  • Acquire deeper knowledge and understanding of the Teradata Architecture.
  • Easy steps to load, archive, restore data and implement Teradata protection features
  • Gain confidence in running a wide variety of Data analytics and develop applications for the Teradata environment
In Detail

Teradata is an enterprise software company that develops and sells a relational database management system (RDBMS) with the same name. It is considered to be a leading data warehousing solutions and provides data management solutions for analytics. This book will be your guide to get all the practical information you need for the creation and implementation of your data warehousing solution using Teradata.

The book begins with recipes on quickly setting up a development environment for you to work with different types of data structuring and manipulation functions. You will tackle all problems related to efficient querying, stored procedures searching and navigation techniques. Additionally, you’ll master the various administration tasks such as user and security management, workload management, high availability, performance tuning and monitoring.

This book is designed to take you through the best practices of performing the 'real' daily tasks of a Teradata DBA, and will help you tackle any problem you might encounter in the process.

1126739533
Teradata Cookbook

Over 100 recipes to help you implementing efficient data warehousing solutions with Teradata

About This Book
  • Take your understanding of Teradata to the next level and build efficient data warehousing applications for your organization
  • Covers recipes on data handling, warehousing, advanced querying and the administration tasks in Teradata
  • Contains practical solutions to tackle the common as well as the not-so-common problems you might encounter in your day to day activities
Who This Book Is For

This book is for DBAs and Teradata users who are looking for a practical, one-stop resource to solve all their problems while handling their Teradata solution. If you are looking to learn the basic as well as the advanced tasks involved in Teradata querying or admininstration, this book will also help you. Some knowledge of the relational database concepts will be helpful to get the best out of this book.

What You Will Learn
  • Understand Teradata's competitive advantage over other RDBMSs.
  • Use SQL to process data stored in Teradata tables.
  • Leverage Teradata’s available application utilities and parallelism to play with large datasets
  • Apply various performance turning techniques to optimize the queries.
  • Acquire deeper knowledge and understanding of the Teradata Architecture.
  • Easy steps to load, archive, restore data and implement Teradata protection features
  • Gain confidence in running a wide variety of Data analytics and develop applications for the Teradata environment
In Detail

Teradata is an enterprise software company that develops and sells a relational database management system (RDBMS) with the same name. It is considered to be a leading data warehousing solutions and provides data management solutions for analytics. This book will be your guide to get all the practical information you need for the creation and implementation of your data warehousing solution using Teradata.

The book begins with recipes on quickly setting up a development environment for you to work with different types of data structuring and manipulation functions. You will tackle all problems related to efficient querying, stored procedures searching and navigation techniques. Additionally, you’ll master the various administration tasks such as user and security management, workload management, high availability, performance tuning and monitoring.

This book is designed to take you through the best practices of performing the 'real' daily tasks of a Teradata DBA, and will help you tackle any problem you might encounter in the process.

48.99 In Stock
Teradata Cookbook

Teradata Cookbook

Teradata Cookbook

Teradata Cookbook

Paperback

$48.99 
  • SHIP THIS ITEM
    In stock. Ships in 1-2 days.
  • PICK UP IN STORE

    Your local store may have stock of this item.

Related collections and offers


Overview

Over 100 recipes to help you implementing efficient data warehousing solutions with Teradata

About This Book
  • Take your understanding of Teradata to the next level and build efficient data warehousing applications for your organization
  • Covers recipes on data handling, warehousing, advanced querying and the administration tasks in Teradata
  • Contains practical solutions to tackle the common as well as the not-so-common problems you might encounter in your day to day activities
Who This Book Is For

This book is for DBAs and Teradata users who are looking for a practical, one-stop resource to solve all their problems while handling their Teradata solution. If you are looking to learn the basic as well as the advanced tasks involved in Teradata querying or admininstration, this book will also help you. Some knowledge of the relational database concepts will be helpful to get the best out of this book.

What You Will Learn
  • Understand Teradata's competitive advantage over other RDBMSs.
  • Use SQL to process data stored in Teradata tables.
  • Leverage Teradata’s available application utilities and parallelism to play with large datasets
  • Apply various performance turning techniques to optimize the queries.
  • Acquire deeper knowledge and understanding of the Teradata Architecture.
  • Easy steps to load, archive, restore data and implement Teradata protection features
  • Gain confidence in running a wide variety of Data analytics and develop applications for the Teradata environment
In Detail

Teradata is an enterprise software company that develops and sells a relational database management system (RDBMS) with the same name. It is considered to be a leading data warehousing solutions and provides data management solutions for analytics. This book will be your guide to get all the practical information you need for the creation and implementation of your data warehousing solution using Teradata.

The book begins with recipes on quickly setting up a development environment for you to work with different types of data structuring and manipulation functions. You will tackle all problems related to efficient querying, stored procedures searching and navigation techniques. Additionally, you’ll master the various administration tasks such as user and security management, workload management, high availability, performance tuning and monitoring.

This book is designed to take you through the best practices of performing the 'real' daily tasks of a Teradata DBA, and will help you tackle any problem you might encounter in the process.


Product Details

ISBN-13: 9781787280786
Publisher: Packt Publishing
Publication date: 02/21/2018
Pages: 454
Product dimensions: 7.50(w) x 9.25(h) x 0.92(d)

About the Author

Abhinav Khandelwal has 11 years of industry experience in BI, analytics, and data warehousing. He gained a BE from GIT Sitapura, Jaipur. He is pursuing his MBA at Welingkar, Mumbai and is currently based in Melbourne. He acts as a senior consultant on BI DWH projects. He has also been in the news for his award-winning projects. For more information, you can refer to his blogs called as anonymously rave and three of kind. Contact him on Twitter at @abhi_khandu.Rajsekhar Bhamidipati has 13 years' industry experience in Teradata and DWH and gained his BTech from BPUT Rourkela. He is working in Pune with Teradata Corp as a Senior Teradata Specialist on Teradata DWH projects. He has been associated with Teradata for more than 8 years and has successfully led multiple projects in various roles, with notable success in service delivery. He leverages Teradata and related technologies in the areas of database administration, workload, performance and cloud.

Table of Contents

Table of Contents
  1. Installation
  2. SQLs
  3. Advanced SQL with Backup and Restore
  4. All about Indexes
  5. Mixing Strategies – Joining of Tables
  6. Building Loading Utility – Replication and Loading
  7. Monitoring the better way
  8. Collect Statistics the Better Way
  9. Application and OPS DBA insight
  10. DBA
  11. Performance Tuning
  12. Troubleshooting
From the B&N Reads Blog

Customer Reviews