In this book, readers will learn the Snowflake architecture with an excellent level of detail. Readers will also learn the clever tricks and tips that make Snowflake unique, including failsafe, time travel, and min-max pruning. In addition, Reader can create all types of Snowflake tables and views and learn how to performance tune Snowflake tables and queries. Readers will also gain significant knowledge of SQL, starting at the most basic level and building to intermediate and advanced lev...

The brilliance behind the Tera-Tom Genius series is that each book gets deeper and deeper into the details of Teradata. The Business Users book begins with brilliant fundamentals before diving into how Teradata works, how data is laid out, how people are set up as users, and how they are tracked. Business Users will completely understand Teradata at the exact level they need to after reading this book.

The Brilliance of Netezza will make all readers instant experts on the architecture of Netezza. With its clever design and “secret sauce” of FPGA Cards and Zone Maps, Netezza is quickly becoming a staple of all major enterprise data warehouses. This is a perfect opportunity to make yourself an invaluable asset to your company by obtaining the kind of knowledge that this book contains.

This is an opportunity for an executive to understand the complex Teradata technology at a common-sense level. It will give executives great insight into the strengths and weaknesses of Teradata. It will give expert advice about how to lead those who are working under them when it comes to their Teradata system. This book will help them understand what they need to know, and what’s most important to make strategic decisions.

If you want to pass the certification test and become a “Teradata Certified Associate,” then this book is for you. Tera-Tom, a Teradata Certified Master who has more than 25 years of Teradata experience, explains the fundamentals of Teradata, relational databases, and every subject you need to pass the test. With hundreds of sample questions and Tom’s easy explanations, you will soon be knowledgeable and certified on Teradata. Having Teradata knowledge and your certification means that the...

This single book teaches the reader everything they need to know about Teradata, the architecture, and how Teradata works. It then gives over 1000 SQL examples that teach them everything. If you went to a desert island and could only take one book, this is the one you want.

You are going to love this book because your confidence and knowledge will soar. V14 Certification: Teradata Basics has been designed to help you pass the test, but it is so much more. It is an incredible reference guide, learning tool, and foundation for passing all the tests and becoming a Teradata Certified Master.

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 explan...

Greenplum is the first open source data warehouse. Purchased and improved by EMC, sold to Dell, makes Greenplum one of the most powerful and widely-used systems in the world. This incredible MPP data warehouse is designed for on-premises systems and the cloud. This book details the architecture of the Greenplum Data Warehouse and the SQL commands available. This book is perfect for anyone who designs, administers or queries Greenplum. The book educates readers on how to create tables and i...

One of the most popular databases worldwide is Microsoft’s SQL Server. Now Microsoft has introduced their MPP data warehouse system, designed for the cloud, called the Microsoft Azure SQL Data Warehouse. The Microsoft Azure Cloud is rapidly making T-SQL one of the standards of SQL among millions of companies. This book details the architecture of the Azure SQL Data Warehouse and the SQL commands available. This book is perfect for anyone who works with the Microsoft Azure SQL Data Warehous...

One of the most exciting database inventions is in-memory technology. Kognitio has been the pioneer of the in-memory database and it is brilliant for both on-premises and cloud technology. This book details the architecture of the Kognitio and the SQL commands available. This book is perfect for anyone who works with a Kognitio system. This book educates readers on how to create tables, how the data is distributed, and how the system process the data. Plus, it is followed up with over 500 ...

One of the most popular databases worldwide is the Microsoft’s SQL Server. The Microsoft Azure Cloud is rapidly making T-SQL one of the standards of SQL among millions of companies. The Microsoft SQL Server 2012 T-SQL book is your key to mastering T-SQL. With easy to use sample tables, and 700 pages of real-world example’s and explanations, this book is your perfect reference guide. Each chapter in this book starts with simple examples and continues to use a building block approach to teac...