Buy on Amazon now!
Buy on Appl iBooks now!
Buy on Kobo books now!

Teradata Certification SQL (V14)

The Teradata Certification SQL Guide is designed for those who are interested becoming Teradata Certified Technical Specialists or higher. Through simplified examples and explanations, this guide prepares the reader to take the Teradata SQL Exam.

  • Identify the correct use of SQL comparison operators
  • HELP, SHOW, and EXPLAIN commands and their expected outputs
  • Explain how data type conversions work
  • Identify uses involving GROUP BY, HAVING, and DISTINCT
  • Proper usage of Joins, Scalar and Non-Scalar Subqueries and Correlated Subqueries
  • Correct usage of date intervals, and extractions
  • Describe the functionality of Ordered Analytic Functions (OLAP)
  • DML, DDL, and DCL SQL statements
  • Considerations for CREATE tables including PPI, MLPPI,  Indexing, and Temporal
  • Describe the types and uses of Stored Procedure parameters and variables

The Teradata 14 Certification Study Guides are the only Teradata authorized study publications. Cerulium Corporation partners with Teradata and the Teradata Certified Professional Program to author the Teradata 14 Certification Study Guides.

Teradata Certified Technical Specialist

“A successful candidate has core knowledge and skills about Teradata Structured Query Language (SQL) using both ANSI standard conventions and Teradata extensions to the language as well as the core knowledge and skills necessary to design and implement a Teradata Database from a logical data model. The candidate understands the Teradata implementation of data distribution, space usage, data access and data manipulation processes. The candidate can implement a Teradata Database using a set of requirements.”*

Teradata Certification Exam TEO-142 is required for:

  • Teradata Certified Technical Specialist
  • Teradata Certified Database Administrator
  • Teradata Certified Solutions Developer
  • Teradata Certified Enterprise Architect
  • Teradata Certified Master

 

Chapter 1: The Teradata Certified Professional Program

  • The Teradata Certified Professional Program
  • Pursue Teradata Certification with Confidence™
  • Your Teradata 14 Certification Upgrade Roadmap
  • Certification… Knowledge Building to Mastery
  • Path to Teradata 14 Mastery
  • Exam Registration
  • Where to Find More Information

Chapter 2: SELECT Command     

  • Teradata Certification SQL Objectives
  • Structured Query Language
  • ORDER BY
  • DISTINCT Option
  • WHERE
  • Compound Comparisons
  • Comparisons Against Nulls
  • Using IN and NOT IN
  • Using the LIKE operator
  • Chapter 2: Practice Questions

Chapter 3: HELP, SHOW, EXPLAIN Commands

  • Teradata Certification SQL Objectives
  • HELP Commands
  • SHOW Commands
  • EXPLAIN
  • Chapter 3: Practice Questions

Chapter 4: Data Conversions     

  • Teradata Certification SQL Objectives
  • Data Types
  • Data Conversions
  • CAST
  • Rounding
  • FORMAT
  • Date Formats
  • User Defined Functions (UDFs)
  • User Defined Types (UDTs)
  • Formatting for Internationalizations
  • Chapter 4: Practice Questions

Chapter 5: Aggregation

  • Teradata Certification SQL Objectives
  • Aggregations
  • GROUP BY ROLLUP
  • GROUP BY GROUPING SETS
  • GROUP BY CUBE
  • Chapter 5: Practice Questions

Chapter 6: Subquery Processing              

  • Teradata Certification Objectives
  • Non-Scalar Subquery
  • Non-Scalar Correlated Subquery Processing
  • Scalar Subquery
  • Scalar Correlated Subquery
  • Subquery Processing with Derived tables
  • Chapter 6: Practice Questions

Chapter 7: Join Processing          

  • Teradata Certification SQL Objectives
  • Table Aliasing
  • Join Processing
  • INNER JOIN
  • OUTER JOIN
  • Residual Conditions
  • Evaluation Order
  • Self-Join
  • Cross Join
  • Cross Join – Continued
  • Join Consideration and PPI
  • Chapter 7: Practice Questions

Chapter 8: Date and Time Processing    

  • Teradata Certification SQL Objectives
  • Temporal Data Types
  • Temporal Functions
  • DATEFORM
  • Date Arithmetic
  • EXTRACT
  • Date and Time Literals
  • INTERVAL Processing
  • OVERLAPS
  • Chapter 8: Practice Questions

Chapter 9: Character String Processing 

  • Teradata Certification SQL Objectives
  • TRIM
  • CHARACTER_LENGTH and CHARACTERS Functions
  • OCTET Function
  • POSITION
  • INDEX
  • SUBSTRING and SUBSTR
  • Imbedded Services Functions
  • Chapter 9: Practice Questions

Chapter 10: OLAP Functions       

  • Teradata Certification SQL Objectives
  • Teradata On-Line Analytical Processing Functions
  • Cumulative SUM – SUM / OVER
  • Ranking Data using the ANSI RANK / OVER
  • RESET WHEN
  • SAMPLE and SAMPLEID
  • TOP [n] [WITH TIES]
  • Chapter 10: Practice Questions

Chapter 11: Set Operators

  • Teradata Certification SQL Objectives
  • UNION
  • UNION ALL
  • INTERSECT
  • EXCEPT/MINUS
  • Multiple Set Operators and Precedence Order
  • Chapter 11: Practice Questions

Chapter 12: Data Manipulation

  • Teradata Certification SQL Objectives
  • DELETE
  • INSERT
  • INSERT/SELECT
  • UPSERT
  • MERGE
  • Chapter 12: Practice Questions

Chapter 13: Data Interrogation 

  • Teradata Certification SQL Objectives
  • CASE
  • COALESCE
  • NULLIF
  • Chapter 13: Practice Questions

Chapter 14: View and Macro Processing              

  • Teradata Certification SQL Objectives
  • Views
  • Macro Processing
  • Parameterized Macros
  • Chapter 14: Practice Questions

Chapter 15: Transaction Processing        

  • Teradata Certification SQL Objectives
  • Transactions
  • Transaction Locking
  • Transaction Modes
  • Transaction Semantics – BTET Mode
  • ANSI Mode Transactions
  • Transaction Semantics – ANSI Mode
  • Aborting Transactions
  • Chapter 15: Practice Questions

Chapter 16: Data Definition Language   

  • Teradata Certification SQL Objectives
  • CREATE TABLE
  • Referential Integrity
  • Primary Key vs. Primary Index
  • Index Options
  • No Primary Index (NoPI)
  • Default Primary Index
  • CREATE TABLE AS
  • Altering a Table
  • Dropping Database Objects
  • Renaming Database Objects
  • Partitioned Tables
  • Queue Tables
  • Trigger Processing
  • Using Roles
  • Chapter 16: Practice Questions

Chapter 17: Temporary Tables  

  • Teradata Certification SQL Objectives
  • Before You Begin
  • Derived Tables
  • Volatile and Global Temporary Tables
  • Chapter 17: Practice Questions

Chapter 18: Temporal Tables     

  • Teradata Certification SQL Objectives
  • Period Temporal Data Types
  • EXPAND ON
  • Temporal Tables
  • Transaction Time and Valid Time
  • Transaction-Time
  • Valid-Time
  • Bitemporal Tables
  • AS OF Queries
  • Chapter 18: Practice Questions

Chapter 19: Stored Procedures 

  • Teradata Certification SQL Objectives
  • CREATE PROCEDURE
  • Stored Procedural Language (SPL) Statements
  • BEGIN / END Statements
  • Establishing Variables and Data Values
  • CALL Statement                395
  • Exception Handling
  • DML Statements
  • DDL Statements               400
  • External Stored Procedures
  • Macros or Stored Procedures for Tactical Queries
  • Chapter 19: Practice Questions

 

Paperback: 405 pages
Publisher: Cerulium Corporation (2013)
ISBN: 978-0989400503

In Stock: Yes

*http://www.teradata.com/Certification

2017-03-23T17:58:47+00:00