Teradata is the world's leading provider of business analytics solutions, data and analytics solutions, and hybrid cloud products and services. Its eponymous relational database management system (RDBMS), which is considered to be a leading data warehousing solution. It provides data management solutions for analytics. This book will help you get all the practical information you need to create and implement your data warehousing solution using Teradata.
The book begins with recipes on quickly setting up a development environment so that you can work with different types of data structuring and manipulation functions. You will tackle all the problems related to efficient querying, stored procedure searching, and navigation techniques. Additionally, you'll master administrative 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 real daily tasks no matter what role are you performing when dealing with Teradata. It will help you solve your problem and implement the best solution.
This book is for database administrators and Teradata users who are looking for a practical, one-stop resource to solve all their problems while handling their Teradata solutions. If you are looking to learn the basics as well as advanced tasks involved in Teradata querying or administration, this book will be handy. Some knowledge of relational database concepts will be helpful to get the best out of this book.
Chapter 1, Installation, is about setting up the Teradata database and client utility to access the database.
Chapter 2, SQLs, teaches the basic SQL used to manage and process your data in a database.
Chapter 3, Advanced SQL with Backup and Restore, shows new and advanced SQL and explains how to back up your database.
Chapter 4, All about Indexes, resolves and improves our query performance using indexes.
Chapter 5, Mixing Strategies – Joining of Tables, shows how to improve join performance and explains how they work.
Chapter 6, Building Loading Utility – Replication and Loading, resolves utility issues and makes it work efficiently.
Chapter 7, Monitoring the better way, examines the best practices to catch and resolve performance issues on the database.
Chapter 8, Collect Statistics the Better Way, resolves query performance by collecting and managing statistics.
Chapter 9, Applications and OPS DBA Insight, identifies and resolves daily issues faced by application admins.
Chapter 10, DBA Insight, identifies and resolves daily issues faced by system admins.
Chapter 11, Performance Tuning, helps us identify, resolve, and improve query performance issues faced by database users.
Chapter 12, Troubleshooting, shows how to troubleshoot system-wide issues using database utilities.
- Readers of this book should have working knowledge of the Teradata database and SQL writing.
- In order to install and connect to Teradata, readers have to download the software mentioned by creating a free account on the Teradata developer website.
You can download the example code files for this book from your account at www.packtpub.com. If you purchased this book elsewhere, you can visit www.packtpub.com/support and register to have the files emailed directly to you.
You can download the code files by following these steps:
- Log in or register at www.packtpub.com.
- Select the
SUPPORTtab. - Click on
Code Downloads & Errata. - Enter the name of the book in the
Searchbox and follow the onscreen instructions.
Once the file is downloaded, please make sure that you unzip or extract the folder using the latest version of:
- WinRAR/7-Zip for Windows
- Zipeg/iZip/UnRarX for Mac
- 7-Zip/PeaZip for Linux
The code bundle for the book is also hosted on GitHub at https://github.com/PacktPublishing/Teradata-Cookbook. We also have other code bundles from our rich catalog of books and videos available at https://github.com/PacktPublishing/. Check them out!
We also provide a PDF file that has color images of the screenshots/diagrams used in this book. You can download it here: http://www.packtpub.com/sites/default/files/downloads/TeradataCookbook_ColorImages.pdf.
There are a number of text conventions used throughout this book.
CodeInText: Indicates code words in text, database table names, folder names, filenames, file extensions, pathnames, dummy URLs, user input, and Twitter handles. Here is an example: "It went to the default CASE statement."
A block of code is set as follows:
/*Correlated query*/ SELECT Column1, Column2 FROM Table1 Tb1 WHERE Column1 IN (
When we wish to draw your attention to a particular part of a code block, the relevant lines or items are set in bold:
/*Aggregate CASE*/ SELECT SUM( CASE WHEN department='IT' THEN) AS SAL_IT SUM (
Any command-line input or output is written as follows:
tpareset -f testing the restart commandBold: Indicates a new term, an important word, or words that you see onscreen. For example, words in menus or dialog boxes appear in the text like this. Here is an example: "JavaScript Object Notation (JSON) is a lightweight programming independent data interchange format."
Feedback from our readers is always welcome.
General feedback: Email [email protected] and mention the book title in the subject of your message. If you have questions about any aspect of this book, please email us at [email protected].
Errata: Although we have taken every care to ensure the accuracy of our content, mistakes do happen. If you have found a mistake in this book, we would be grateful if you would report this to us. Please visit www.packtpub.com/submit-errata, selecting your book, clicking on the Errata Submission Form link, and entering the details.
Piracy: If you come across any illegal copies of our works in any form on the Internet, we would be grateful if you would provide us with the location address or website name. Please contact us at [email protected] with a link to the material.
If you are interested in becoming an author: If there is a topic that you have expertise in and you are interested in either writing or contributing to a book, please visit authors.packtpub.com.
Please leave a review. Once you have read and used this book, why not leave a review on the site that you purchased it from? Potential readers can then see and use your unbiased opinion to make purchase decisions, we at Packt can understand what you think about our products, and our authors can see your feedback on their book. Thank you!
For more information about Packt, please visit packtpub.com.