HP Vertica Architecture and SQL
- 2h 39m
- Leslie Nolander, Tom Coffing
- Coffing Data Warehousing
- 2015
One of the most exciting new database inventions is Columnar technology. HP has built one of the best columnar databases in the world. HP Vertica is designed for both on-premises and cloud technology. This book details the architecture of the HP Vertica database and the SQL commands available. The book educates readers on how to create tables and indexes, how the data is distributed, and how the system process the data. Plus, it is followed up with over 500 pages of SQL examples and explanations. This book is a must have for anyone designing, implementing or querying the HP Vertica system. The Authors Tera-Tom Coffing, who has written over 75 successful books on Data Warehousing and Leslie Nolander, Chief Operations Officer (COO) of Coffing Data Warehousing bring a combined 40 years of experience of data warehouse knowledge to create this must have book.
In this Book
-
What is Columnar?
-
Vertica Data Distribution
-
Clever Features of Vertica
-
Nexus
-
The Basics of SQL
-
The WHERE Clause
-
Aggregation
-
Join Functions
-
Date Functions
-
OLAP Functions
-
Temporary Tables
-
Sub-query Functions
-
Strings
-
Interrogating the Data
-
View Functions
-
Set Operators Functions
-
Table Create and Data Types
-
Data Manipulation Language (DML)
-
Statistical Aggregate Functions
