Book Overview & Buying
Table Of Contents

Teradata Cookbook

By : Khandelwal, Kasi, Bhamidipati

3.8 (4)

Buy this Book

Teradata Cookbook

3.8 (4)

By: Khandelwal, Kasi, Bhamidipati

Buy this Book

Overview of this book

Teradata is an enterprise software company that develops and sells its eponymous relational database management system (RDBMS), which is considered to be a leading data warehousing solutions and provides data management solutions for analytics. This book will help you 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 so you can work with different types of data structuring and manipulation function. You will tackle all problems related to efficient querying, stored procedure searching, and navigation techniques. Additionally, you’ll master various 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 the real daily tasks of a Teradata DBA, and will help you tackle any problem you might encounter in the process.

Preface

Who this book is for

What this book covers

To get the most out of this book

Get in touch

Free Chapter

Installation

Setting up Teradata 15.10

Setting up Teradata Studio Express

Teradata on Azure

Defining a connection

Connecting to the Teradata system

Setting up Teradata SQLA

Configuring SQLA

Building a query builder

Importing data

Exporting data

SQLs

Introduction

Writing queries

Querying efficiently

Explain before executing queries

Decoding explain

Resolving skewing data

Resolving skew in database

Solving insert performance

Improving delete performance

Improving update performance

Performing MERGE INTO

Advanced SQL with Backup and Restore

Introduction

Exploring ordered analytic functions

Using CASE statements

Working with correlated subqueries

Experimenting with JSON

Partitioning tables column wise

Archiving data dictionary

Archiving databases

Archiving PPI tables

Restoring a table

Generating a unique row number

All about Indexes

Introduction

Creating a partitioned primary index to improve performance

Creating a join index to improve performance

Creating a secondary index to improve performance

Creating a hash index to improve performance

Mixing Strategies – Joining of Tables

Introduction

Identifying skewness in joins

Identify the right columns for joins

Eliminating product joins

Improving left join

Improving Teradata joins

Building Loading Utility – Replication and Loading

Introduction

Loading data from flat to Teradata

Resolving FastLoad error 2652

Using MultiLoad to delete

Resolving MLOAD error 2571

Resolving failure 7547

Upserting data using MLOAD

Loading data from a one Teradata Database to another

Monitoring the better way

Introduction

Configuring the viewpoint portlet

Identifying killer queries in viewpoint

Setting up viewpoint alerts

Changing and managing filters

Changing and managing throttle

Defining a ruleset

Creating a TASM exception

Collect Statistics the Better Way

Introduction

How to collect statistics

Identifying stats for a table

Identifying multi-column stats

How to collect expression stats

How to copy statistics

Using help and show to resolve query issues

Application and OPS DBA Insight

Introduction

Creating, copying, and dropping tables

Working with views

Defining workloads based on application

Securing passwords using Teradata Wallet

Shrinking your data size

Using query band

DBA Insight

Introduction

Creating a Teradata database

Creating a Teradata database user

Creating profiles and assigning them to users

Creating a Secure Zone

Creating user accounts

Investigating phantom and leftover spool issues

Unlocking archive HUT locks

Performance Tuning

Introduction

Resolving a slow or hung system

Monitoring slow queries

Aborting a session from the supervisor window

Resolving AWT saturation

Identifying suspect queries

Managing DBC space

Optimizing queries

Troubleshooting

Introduction

Restarting the TD system

Insufficient memory to parse this request

Recovering AMP down

Performing scandisk on the system

Unlocking the DBC

Managing the FSG cache

Other Books You May Enjoy

Leave a review - let other readers know what you think

SQLs

In this chapter, we will learn techniques that will help in writing statements/SQL queries efficiently. Increasing the efficiency of DDL/DML/DCL statements/SQL queries will reduce the CPU/IO and runtime of a query.

The following topics will be covered: