Actian Matrix Formely ParAccel Architecture and SQL 1st Edition by Tom Coffing, Ed Bernier 1940540313 9781940540313

Actian Matrix Formely ParAccel Architecture and SQL 1st Edition by Tom Coffing, Ed Bernier – Ebook PDF Instant Download/Delivery: 1940540313, 9781940540313

Full download Actian Matrix Formely ParAccel Architecture and SQL 1st Edition after payment

Product details:

ISBN 10: 1940540313

ISBN 13: 9781940540313

Author: Tom Coffing; Ed Bernier

One of the most exciting new technologies is Columnar and one of the premier pioneers of this technology is Actian’s Matrix database. This book details the architecture of the Matrix system and shows all SQL commands with real-world examples that work. This book educates readers on how to create tables and indexes, how the data is distributed, how columnar works, and how the system processes 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 a Matrix system. The Authors, Tera-Tom Coffing and Ed Bernier, bring experience and expertise together. Tom Coffing has written over 70 books on all technologies and is considered one of the best technical authors in the world. Ed Bernier is a past employee of Actian and Netezza, and has inside knowledge because of his system engineering background on a wide variety of systems.

Actian Matrix Formely ParAccel Architecture and SQL 1st Table of contents:

Chapter 1 – What is Columnar?

Chapter 2 – Best Practices for Table Design

Chapter 3 – Systems Tables

Chapter 4 – Compression

Chapter 5 – Temporary Tables

Chapter 6 – Explain

Chapter 7 – Basic SQL Functions

Chapter 8 – The WHERE Clause

Chapter 9 – Distinct Vs Group By AND TOP

Chapter 10 – Aggregation

Chapter 11 – Join Functions

Chapter 12 – Date Functions

Chapter 13 – OLAP Functions

Chapter 14 – Temporary Tables

Chapter 15 – Sub-query Functions

Chapter 16 – Substrings and Positioning Functions

Chapter 17 – Interrogating the Data

Chapter 18 – View Functions

Chapter 19 – Set Operators Functions

Chapter 20 – Statistical Aggregate Functions

Chapter 21 – Nexus

People also search for Actian Matrix Formely ParAccel Architecture and SQL 1st: 

encyclopedia of small business

entrepreneurship and small business management 2nd edition

encyclopedia of business in today’s world

easy business encyclopedia

Tags:

Tom Coffing,Ed Bernier,Matrix,Formely