V14 Certification: Teradata SQL

Tom Coffing, Leona Coffing

• Publisher: Coffing Publishing
• Year: 2015
• eBook ISBN: 9781940540252
• Topic: Computer Science
• Subtopic: Data Warehousing
• Index: Computer Science

You are going to love this book because your confidence and knowledge will soar. V14 Certification: Teradata SQL has been designed to help you pass the test, but it is so much more. It is an incredible reference guide, learning tool, and the only book you will need for learning, writing Teradata SQL and passing the certification test.

Chapter 1 – The Basics of SQL

“As I would not be a slave, so I would not be a master.”

– Abraham Lincoln

Passing Your Teradata Certification Tests

Exam No	Exam Name
TE0-141	Teradata 14 Basics
TE0-142	Teradata 14 SQL
TE0-143	Teradata 14 Physical Design and Implementation
TE0-144	Teradata 14 Database Administration
TE0-145	Teradata 14 Solutions Development
TE0-146	Teradata 14 Enterprise Architecture
TE0-147	Teradata 14 Comprehensive Mastery Exam

V14 Certification Title	Exams Required For Certification
Teradata 14 Certified Professional	TE0-141
Teradata 14 Certified Technical Specialist	TE0-141, TE0-142 , TE0-143
Teradata 14 Certified Database Administrator	TE0-141, TE0-142, TE0-143, TE0-144
Teradata 14 Certified Solutions Developer	TE0-141, TE0-142, TE0-143, TE0-145
Teradata 14 Certified Enterprise Architect	TE0-141, TE0-142, TE0-143, TE0-145, TE0-146
Teradata 14 Certified Master	Pass all seven exams

All exams must be taken and passed in the order listed. Teradata V12 Masters can take one test to achieve a V14 Masters Upgrade and that is TE0-147. Go to www.prometric.com/Teradata to register for an exam.

Introduction

The Student_Table above will be used
in our early SQL Examples

This is a pictorial of the Student_Table which we will use to present some basic examples of SQL and get some hands-on experience with querying this table. This book attempts to show you the table, show you the query, and show you the result set.

SELECT * (All Columns) in a Table

Mostly every SQL statement will consist of a SELECT and a FROM. You SELECT the columns you want to see on your report and an Asterisk (*) means you want to see all columns in the table on the returning answer set!

SELECT Specific Columns in a Table

SELECT First_Name

,Last_Name

,Class_Code

,Grade_Pt

FROM Student_Table ;

This is a great way to show the columns you are selecting from the Table_Name.

Commas in the Front or Back?

Why is the example on the left better even though they are functionally equivalent? Errors are easier to spot and comments won’t cause errors.

Place your Commas in front for better Debugging Capabilities

"A life filled with love may have some thorns,
but a life empty of love will have no roses."

Anonymous

Having commas in front to separate column names makes it easier to debug. Remember our quote above. "A query filled with commas at the end just might fill you with thorns, but a query filled with commas in the front will allow you to always come up smelling like roses."

Sort the Data with the ORDER BY Keyword

Rows typically come back to the report in rand...

Table of contents

• Cover
• The Tera-Tom Video Series
• The Tera-Tom Genius Series
• Tera-Tom- Author of over 50 Books
• The Best Query Tool Works on all Systems
• Trademarks and Copyrights
• About Tom Coffing
• About Leona Coffing
• Contents
• Chapter 1 – The Basics of SQL
• Chapter 2 – The Where Clause
• Chapter 3 – Distinct, Group By and TOP
• Chapter 4 - Aggregation
• Chapter 5 – Join Functions
• Chapter 6 – Date Functions
• Chapter 7 – Format Functions
• Chapter 8 - OLAP Functions
• Chapter 9 – The Quantile Function
• Chapter 10 - Temporary Tables
• Chapter 11 - Sub-query Functions
• Chapter 12 – Substring and Positioning Functions
• Chapter 13 – Interrogating the Data
• Chapter 14 – View Functions
• Chapter 15 – Macro Functions
• Chapter 16 – Set Operators Functions
• Chapter 17 - Table Create and Data Types
• Chapter 18 - Data Manipulation Language (DML)
• Chapter 19 – Stored Procedure Functions
• Chapter 20 – Trigger Functions
• Chapter 21 – The SAMPLE Function
• Chapter 22 – Statistical Aggregate Function
• Chapter 23 – HELP and SHOW
• Chapter 24 – Teradata (BTET) vs. ANSI Mode
• Chapter 25 – BTEQ – Batch Teradata Query
• Chapter 26 – Locking
• Chapter 27 – Lessons with Tera-Tom Video Guide