Explore Products

Best Sellers

New Releases

Books

Videos

Audiobooks

Learning Hub

Conferences

Free Learning

You're reading from Teradata Cookbook Over 85 recipes to implement efficient data warehousing solutions

Product type Paperback

Published in Feb 2018

Publisher Packt

ISBN-13 9781787280786

Length 454 pages

Edition 1st Edition

Languages

SQL

Tools

Teradata

Concepts

Database Administration

Authors (3):

Abhinav Khandelwal

Viswanath Kasi

Rajsekhar Bhamidipati

View More author details

Table of Contents (14) Chapters

Preface

1. Installation

2. SQLs FREE CHAPTER

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 Insight

11. Performance Tuning

12. Troubleshooting

13. Other Books You May Enjoy

Leave a review - let other readers know what you think

Advanced SQL with Backup and Restore

The following are the recipes we will be covering in this chapter:

Exploring ordered analytic functions
Using CASE statements
Working with correlated subqueries
Experimenting with JSON
Partitioning tables column wise
Archiving DD
Archiving databases
Archiving PPI tables
Restoring a table
Generating a unique row number

The rest of the chapter is locked

A free Packt account unlocks extra newsletters, articles, discounted offers, and much more. Start advancing your knowledge today.

Unlock this book and the full library FREE for 7 days

Get unlimited access to 7000+ expert-authored eBooks and videos courses covering every tech area you can think of

Start free trial

Renews at $19.99/month. Cancel anytime

Authors (3)

Kasi

See other products by Kasi

Khandelwal

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.

See other products by Khandelwal

Bhamidipati

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.

See other products by Bhamidipati