This book includes over 1000 examples of all aspects of SQL starting at the most basic level and going to the most advanced level with real examples that work and explain exactly what is going on. The building block approach that continues to take things a step deeper at a time makes this a perfect SQL guide for everyone.

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.

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

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.

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

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.

Amazon Redshift: A Columnar Database SQL and Architecture illuminates the brilliance behind Amazon’s Redshift technology. It is over 600 pages long, and it shows users how to set it up, tune it, load and go. This book also contains all of the SQL you need to query it with ease. After reading this book, you will know why more and more companies are using Redshift as part of their overall data warehouse strategy.

Oracle is one of the most popular database in the world. This incredible database is designed for on-premises systems and the cloud. Learning Oracle SQL is a great opportunity for you to access cutting edge technology. Tera-Tom Coffing and Leona Coffing have written a brilliant book that teaches readers the basics to advanced queries of Oracle SQL. This book is perfect for anyone who needs to write Oracle SQL. The book educates readers with over 600 pages of SQL examples and explanations, ...

One of the most popular databases in the world is IBM’s DB2. This book has over 600 pages of SQL examples and explanations. This book is a must have for anyone who develops or writes SQL for an IBM DB2 system. Readers will also understand how to create tables, views and indexes. 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 ...

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