Cargando…
Teradata Cookbook : Over 85 recipes to implement efficient data warehousing solutions.
Teradata, unlike other relational database management systems, is mainly popular because of its faster analytical processing and storage capabilities. This book unveils all the functionality offered by Teradata's analytical platform with the help of practical recipes. From installation to query...
| Clasificación: | Libro Electrónico |
|---|---|
| Autor principal: | |
| Otros Autores: | |
| Formato: | Electrónico eBook |
| Idioma: | Inglés |
| Publicado: |
Birmingham :
Packt Publishing,
2018.
|
| Temas: | |
| Acceso en línea: | Texto completo |
MARC
| LEADER | 00000cam a2200000Mi 4500 | ||
|---|---|---|---|
| 001 | EBSCO_on1024273637 | ||
| 003 | OCoLC | ||
| 005 | 20231017213018.0 | ||
| 006 | m o d | ||
| 007 | cr |n|---||||| | ||
| 008 | 180224s2018 enk o 000 0 eng d | ||
| 040 | |a EBLCP |b eng |e pn |c EBLCP |d MERUC |d CHVBK |d OCLCO |d IDB |d OCLCQ |d OCLCF |d VT2 |d TEFOD |d OCLCQ |d LVT |d OCLCQ |d N$T |d OCLCO |d K6U |d OCLCQ |d OCLCO | ||
| 020 | |a 9781787282339 |q (electronic bk.) | ||
| 020 | |a 1787282333 |q (electronic bk.) | ||
| 029 | 1 | |a CHNEW |b 000987176 | |
| 029 | 1 | |a CHVBK |b 509400930 | |
| 029 | 1 | |a AU@ |b 000067022856 | |
| 029 | 1 | |a AU@ |b 000067097813 | |
| 035 | |a (OCoLC)1024273637 | ||
| 037 | |a 68ED7D90-D2DD-465C-827E-B77265A1BF82 |b OverDrive, Inc. |n http://www.overdrive.com | ||
| 050 | 4 | |a QA76.9.D37 |b .K436 2018 | |
| 082 | 0 | 4 | |a 658.40380285574 |2 23 |
| 049 | |a UAMI | ||
| 100 | 1 | |a Khandelwal, Abhinav. | |
| 245 | 1 | 0 | |a Teradata Cookbook : |b Over 85 recipes to implement efficient data warehousing solutions. |
| 260 | |a Birmingham : |b Packt Publishing, |c 2018. | ||
| 300 | |a 1 online resource (448 pages) | ||
| 336 | |a text |b txt |2 rdacontent | ||
| 337 | |a computer |b c |2 rdamedia | ||
| 338 | |a online resource |b cr |2 rdacarrier | ||
| 588 | 0 | |a Print version record. | |
| 505 | 0 | |a Cover; Copyright and Credits; Dedication; Packt Upsell; Contributors; Table of Contents; Preface; Chapter 1: Installation; Setting up Teradata 15.10; How to do it ... Â ; Setting up Teradata Studio Express; Getting ready; How to do it ... ; Teradata on Azure; Getting ready; How to do it ... ; How it works ... ; There's more ... ; Defining a connection; How to do it ... ; Connecting to the Teradata system; How to do it ... ; There's more ... ; Using Studio tool options; Setting up Teradata SQLA; Getting ready; How to do it ... ; How it works ... ; There's more ... ; Configuring SQLA; Getting ready; How to do it ... | |
| 505 | 8 | |a How it works ... Building a query builder; How to do it ... ; Query builder in SQLA; Query builder in Express; Importing data; Getting started; How to do it ... ; In Express; Exporting data; How to do it; How it works ... ; There's more ... ; Chapter 2: SQLs; Introduction; Writing queries; Getting ready; How to do it ... ; Using SQLA; Using BTEQ in Windows; How it works ... ; There's more ... ; Querying efficiently; Getting ready; How to do it ... ; How it works ... ; Explain before executing queries; Getting ready; How to do it ... ; How it works ... ; There's more ... ; Decoding explain; How to do it ... | |
| 505 | 8 | |a How it works ... There's more ... ; Resolving skewing data; Getting ready; How to do it ... ; How it works ... ; There's more ... ; See also; Resolving skew in database; Getting ready; How to do it ... ; How it works ... ; There's more ... ; Solving insert performance; Getting ready; How to do it ... ; How it works ... ; There's more ... ; Improving delete performance; Getting ready; How to do it ... ; How it works ... ; There's more ... ; Improving update performance; Getting ready; How to do it ... ; How it works ... ; There's more ... ; See also; Performing MERGE INTO; Getting ready; How to do it ... ; How it works ... | |
| 505 | 8 | |a Chapter 3: Advanced SQL with Backup and RestoreIntroduction; Backup and recovery; Exploring ordered analytic functions; Getting ready; How to do it ... ; How it works ... ; There's more ... ; Using CASE statements; Getting ready; How to do it ... ; How it works ... ; There's more ... ; Working with correlated subqueries; Getting ready; How to do it ... ; How it works ... ; There's more ... ; Experimenting with JSON; Getting ready; How to do it ... ; How it works ... ; There's more ... ; Partitioning tables column wise; Getting ready; How to do it ... ; How it works ... ; There's more ... ; Archiving data dictionary | |
| 505 | 8 | |a Getting readyHow to do it ... ; How it works ... ; There's more ... ; Archiving databases; Getting ready; How to do it ... ; How it works ... ; There's more ... ; Archiving PPI tables; Getting ready; How to do it ... ; How it works ... ; There's more ... ; Restoring a table; Getting ready; How to do it ... ; How it works ... ; There's more ... ; Generating a unique row number; Getting ready; How to do it ... ; How it works ... ; There's more ... ; Chapter 4: All about Indexes; Introduction; Creating a partitioned primary index to improve performance; Getting ready; How to do it ... ; How it works ... ; There's more ... | |
| 500 | |a Creating a join index to improve performance. | ||
| 520 | |a Teradata, unlike other relational database management systems, is mainly popular because of its faster analytical processing and storage capabilities. This book unveils all the functionality offered by Teradata's analytical platform with the help of practical recipes. From installation to querying, indexing to loading utilities for analytical ... | ||
| 590 | |a eBooks on EBSCOhost |b EBSCO eBook Subscription Academic Collection - Worldwide | ||
| 650 | 0 | |a Data warehousing. | |
| 650 | 6 | |a Entrepôts de données (Informatique) | |
| 650 | 7 | |a Data warehousing |2 fast | |
| 700 | 1 | |a BHAMIDIPATI, RAJSEKHAR. | |
| 776 | 0 | 8 | |i Print version: |a Khandelwal, Abhinav. |t Teradata Cookbook : Over 85 recipes to implement efficient data warehousing solutions. |d Birmingham : Packt Publishing, ©2018 |
| 856 | 4 | 0 | |u https://ebsco.uam.elogim.com/login.aspx?direct=true&scope=site&db=nlebk&AN=1712731 |z Texto completo |
| 938 | |a EBL - Ebook Library |b EBLB |n EBL5301597 | ||
| 938 | |a EBSCOhost |b EBSC |n 1712731 | ||
| 994 | |a 92 |b IZTAP | ||