title
Please take a moment to fill out this form. We will get back to you as soon as possible.
All fields marked with an asterisk (*) are mandatory.
Teradata SQL
Duration
3 Days
Course
CFLQ-215
Available Formats
Classroom Training, Online Training
Course Description
Overview
This Teradata SQL course is designed to provide students with a deeper knowledge and understanding of the Teradata SQL and how to write it. Students will learn the Teradata SQL starting at the most basic level and going to the most advanced level with many examples.This course can be taught using Teradata Versions 12, 13, 14 and 15. Please inform your sales representative of which version you are currently using.
Objectives
Upon completion of the Teradata SQL course, students will be able to:
- Identify and apply basic SQL functions
- Understand the WHERE clause
- Contrast Distinct vs. Group by
- Recognize and apply functions, such as:
- Aggregation, Join, Date, OLAP, View, Sub-query and Statistical Aggregate
- Recognize and produce Temporary Tables
- Define and distinguish Strings
- Interrogate the Data
- Set Operators
- Demonstrate knowledge of the Data Manipulation Language (DML)
Audience
- Anyone who has a desire to learn Teradata SQL from beginners to an advanced audience
Prerequisites
- None
Topics
- Introduction
- SELECT * (All Columns) in a Table
- SELECT Specific Columns in a Table
- Using the Best Form for Writing SQL
- Place your Commas in front for better Debugging Capabilities
- Sort the Data with the ORDER BY Keyword
- NULL Values sort First in Ascending Mode (Default)
- NULL Values sort Last in Descending Mode (DESC)
- Major Sort vs. Minor Sorts
- Multiple Sort Keys using Names vs. Numbers
- Sorts are Alphabetical, NOT Logical
- Using A CASE Statement to Sort Logically
- How to ALIAS a Column Name
- The Title Command and Literal Data
- Comments using Double Dashes are Single Line Comments
- Comments for Multi-Lines
- A Great Technique for Comments to Look for SQL Errors
- The WHERE Clause limits Returning Rows
- Using a Column ALIAS throughout the SQL
- Double Quoted Aliases are for Reserved Words and Spaces
- Character Data needs Single Quotes in the WHERE Clause
- Use IS NULL or IS NOT NULL when dealing with NULLs
- Using Greater Than OR Equal To (>=)
- Using GE as Greater Than or Equal To (>=)
- AND in the WHERE Clause
- Troubleshooting AND
- OR in the WHERE Clause
- Troubleshooting OR
- OR must utilize the Column Name Each Time
- Troubleshooting Character Data
- Using Different Columns in an AND Statement
- What is the Order of Precedence?
- Using Parentheses to change the Order of Precedence
- Using an IN List in place of OR
- The IN List is an Excellent Technique
- IN List vs. OR brings the same Results
- Using a NOT IN List
- A Technique for Handling Nulls with a NOT IN List
- An IN List with the Keyword ANY
- A NOT IN List with the Keywords NOT = ALL
- BETWEEN is Inclusive
- LIKE uses Wildcards Percent ‘%’ and Underscore ‘_’
- LIKE ALL means ALL conditions must be Met
- LIKE ANY means ANY of the Conditions can be Met
- IN ANSI Transaction Mode Case Matters
- In Teradata Transaction Mode Case Doesn’t Matter
- LIKE Command Works Differently on Char Vs. Varchar
- Troubleshooting LIKE Command on Character Data
- Introducing the TRIM Command
- Numbers are Right Justified and Character Data is Left
- An Example of Data with Left and Right Justification
- A Visual of CHARACTER Data vs. VARCHAR Data
- Use the TRIM command to remove spaces on CHAR Data
- TRIM Eliminates Leading and Trailing Spaces
- Escape Character in the LIKE Command changes Wildcards
- Escape Characters Turn off Wildcards in the LIKE Command
- The Distinct Command
- Distinct vs. GROUP BY
- Rules of Thumb for DISTINCT vs. GROUP BY
- GROUP BY Vs. DISTINCT – Good Advice
- TOP Command
- TOP Command is brilliant when ORDER BY is used!
- The TOP Command WITH TIES
- How the TOP Command WITH TIES Decides
- The TOP Command will NOT work with Certain Commands
- Testing Your Knowledge 1-7
- Determining the Release of your Teradata System
- HELP Commands
- HELP DATABASE
- HELP USER
- HELP TABLE
- Adding a Comment to a Table/View
- SELECT SESSION
- USER Information Functions
- HELP SESSION
- HELP SQL
- Show Commands
- SHOW Table command for Table DDL
- SHOW View command for View Create Statement
- SHOW Macro command for Macro Create Statement
- SHOW Trigger command for Trigger Create Statement
- The 3 Rules of Aggregation
- There are Five Aggregates
- Troubleshooting Aggregates
- GROUP BY when Aggregates and Normal Columns Mix
- GROUP BY Delivers one row per Group
- GROUP BY Dept_No or GROUP BY 1 the same thing
- Limiting Rows and Improving Performance with WHERE
- WHERE Clause in Aggregation limits unneeded Calculations
- Keyword HAVING tests Aggregates after they are Totaled
- Keyword HAVING is like an Extra WHERE Clause for Totals
- Getting the Average Values per Column
- Three types of Advanced Grouping
- GROUP BY Grouping Sets
- GROUP BY Rollup
- GROUP BY Cube
- Use the Nexus for all Groupings
- Testing Your Knowledge:
- Basic Aggregation
- Multiple Aggregates
- Group By
- Using a Where Clause
- Using Having
- A two-table join using Non-ANSI Syntax
- A two-table join using Non-ANSI Syntax with Table Alias
- Aliases and Fully Qualifying Columns
- A two-table join using ANSI Syntax
- Both Queries have the same Results and Performance
- LEFT OUTER JOIN
- RIGHT OUTER JOIN
- FULL OUTER JOIN
- Which Tables are the Left and which are the Right?
- INNER JOIN with Additional AND Clause
- ANSI INNER JOIN with Additional AND and WHERE Clause
- OUTER JOIN with Additional WHERE and AND Clause
- Results from OUTER JOIN with Additional AND Clause
- The DREADED Product Join
- Result Set of the DREADED Product Join
- The Horrifying Cartesian Product Join
- The ANSI Cartesian Join will ERROR
- The CROSS JOIN
- The Self Join
- An Associative Table is a Bridge that Joins Two Tables
- The 5-Table Join – Logical Insurance Model
- The Nexus Query Chameleon Writes the SQL for Users.
- Date, Time, and Current_Timestamp Keywords
- Dates are stored internally as INTEGERS from a Formula
- Displaying Dates for INTEGERDATE and ANSIDATE
- DATEFORM
- Changing the DATEFORM in Client Utilities such as BTEQ
- Date, Time, and Timestamp Recap
- Timestamp Differences
- Finding the Number of Hours between Timestamps
- Troubleshooting Timestamp
- Add or Subtract Days from a date
- A Summary of Math Operations on Dates
- Find What Day of the week you were Born
- The ADD_MONTHS Command
- The EXTRACT Command
- EXTRACT from DATES and TIME
- CURRENT_DATE and EXTRACT or Current_Date and Math
- The System Calendar
- Using the System Calendar in Its Simplest Form
- How to really use the Sys_Calendar.Calendar
- Storing Dates, Time, and Timezone Internally
- Storing TIME with TIME ZONE Internally
- Storing Timestamp with TIME ZONE Internally
- Storing Date, Time, and Timestamp with Zone Internally
- Time Zones
- Intervals for Date, Time and Timestamp
- Interval Data Types and the Bytes to Store Them
- The Basics of a Simple Interval
- Interval Arithmetic Results
- Interval Examples
- Date
- Time
- Time Interval using CAST
- The OVERLAPS Command
- The OVERLAPS Command using TIME
- The OVERLAPS Command using a NULL Value
- The FORMAT Command
- The Basics of the FORMAT Command
- Formatting with MMM for the Abbreviated Month
- Formatting with MMMM for the Full Month Name
- Formatting with DDD for the Julian Day
- Formatting with EEE or EEEE for the Day of the Week
- Placing Spaces inside your Formatting Commands with a B
- Formatting Spaces with B or b
- Formatting with 9
- Troubleshooting when Formatted Data Overflows
- Formatting with X or x
- Formatting with Z
- Formatting with 9
- Formatting with $
- Formatting with $ and Commas
- Formatting with $ and Commas and 9
- Formatting with $ and Commas and 9 with Zero Dollars
- A Trick to get SQL Assistant to Format Data
- Using the CASESPECIFIC (CS) Command in Teradata Mode
- Using NOT CASESPECIFIC (CS) in ANSI Mode
- Using the LOWER Command
- Using the UPPER Command
- On-Line Analytical Processing (OLAP) or Ordered Analytics
- Cumulative Sum (CSUM) Command and how OLAP Works
- OLAP Commands always Sort (ORDER BY) in the Command
- Calculate the Cumulative Sum (CSUM) after Sorting the Data
- The OLAP Major Sort Key and the Minor Sort Key(s)
- Troubleshooting OLAP – My Data isn’t coming back correct
- GROUP BY in Teradata OLAP Syntax Resets on the Group
- CSUM the Number 1 to get a Sequential Number
- A Single GROUP BY Resets each OLAP with Teradata Syntax
- A Better Choice – The ANSI Version of CSUM
- The ANSI Version of CSUM – The Sort Explained
- The ANSI CSUM
- Troubleshooting the ANSI OLAP on a GROUP BY
- The ANSI OLAP – Reset with a PARTITION BY Statement
- PARTITION BY only Resets a Single OLAP not ALL of them
- The Moving SUM (MSUM) and Moving Window
- How the Moving Sum is calculated
- How the Sort works for Moving SUM (MSUM)
- GROUP BY in the Moving SUM does a Reset
- Both the Teradata Moving SUM and ANSI Version
- The ANSI Moving Window is Current Row and Preceding
- How ANSI Moving Average Handles the Sort
- Moving SUM every 3-rows Vs. a Continuous Average
- Partition BY Resets an ANSI OLAP
- The Moving Average (MAVG) and Moving Window
- How the Moving Average is calculated
- How the Sort works for Moving Average (MAVG)
- GROUP BY in the Moving Average does a Reset
- Both the Teradata Moving Average and ANSI Version
- The ANSI Moving Window is Current Row and Preceding
- How ANSI Moving Average Handles the Sort
- Moving Average every 3-rows Vs. a Continuous Average
- Partition BY Resets an ANSI OLAP
- The Moving Difference (MDIFF)
- Moving Difference (MDIFF) Visual
- Moving Difference using ANSI Syntax
- Trouble Shooting the Moving Difference (MDIFF)
- Using the RESET WHEN Option in Teradata (V13)
- How Many Months per Product_ID has Revenue Increased?
- The RANK Command
- RANK () OVER and PARTITION BY (with a QUALIFY)
- QUALIFY and WHERE
- The QUALIFY Statement without Ties
- The QUALIFY Statement with Ties
- The QUALIFY Statement with Ties Brings back Extra Rows
- Mixing Sort Order for QUALIFY Statement
- PERCENT_RANK () OVER
- COUNT OVER for a Sequential Number
- Troubleshooting COUNT OVER
- The MAX OVER Command
- The MIN OVER Command
- Finding Gaps between Dates
- The CSUM for Each Product_ID for the First 3 Days
- The Row_Number Command
- Row_Number with Qualify to get the Typical Rows per Value
- A Second Typical Rows per Value Query on Sale_Date
- Testing Your Knowledge
- The Quantile Function and Syntax
- QUALIFY to find Products in the top Partitions (DESC/ASC)
- QUALIFY to find Products in top Partitions with Tiebreaker
- Using Tertiles (Partitions of Four)
- How Quantile Works
- There are three types of Temporary Tables
- A Derived Table
- CREATING a Derived Table using the WITH Command
- The Same Derived Query shown Three Different Ways
- WITH RECURSIVE Derived Table
- Defining the WITH Recursive Derived Table
- Looping Through the WITH Recursive Derived Table
- Volatile Table
- You Populate a Volatile Table with an INSERT/SELECT
- Why Would You Use the ON COMMIT DELETE ROWS?
- Four Examples of Creating a Volatile Table Quickly
- Creating Partitioned Primary Index (PPI) Volatile Tables
- Using a Volatile Table to Get Rid of Duplicate Rows
- Using a Simple Global Temporary Table
- The Joining of Two Tables Using a Global Temporary Table
- CREATING A Global Temporary Table
- An IN List is much like a Subquery
- An IN List Never has Duplicates – Just like a Subquery
- An IN List Ignores Duplicates
- The Subquery
- How a Basic Subquery Works
- Should you use a Subquery of a Join?
- The Basics of a Correlated Subquery
- The Top Query always runs first in a Correlated Subquery
- The Bottom Query runs last in a Correlated Subquery
- Correlated Subquery Example vs. a Join with a Derived Table
- Correlated Subquery that Finds Duplicates
- How the Double Parameter Subquery Works
- More on how the Double Parameter Subquery Works
- How to handle a NOT IN with Potential NULL Values
- IN is equivalent to =ANY
- Using a Correlated Exists
- How a Correlated Exists matches up
- The Correlated NOT Exists
- The CHARACTERS Command Counts Characters
- CHARACTERS and CHARACTER_LENGTH equivalent
- OCTET_LENGTH
- The TRIM Command trims both Leading and Trailing Spaces
- Trim and Trailing is Case Sensitive
- Trim Combined with the CHARACTERS Command
- How to TRIM Trailing Letters and use CHARACTER_Length
- The SUBSTRING Command
- How SUBSTRING Works with NO ENDING POSITION
- Using SUBSTRING to move Backwards
- SUBSTRING and SUBSTR are equal, but use differe,nt syntax
- The POSITION Command finds a Letters Position
- The POSITION Command is brilliant with SUBSTRING
- The POSITION Command is brilliant with SUBSTRING
- Using the SUBSTRING to Find the Second Word On
- Concatenation
- Concatenation and SUBSTRING
- Four Concatenations Together
- Troubleshooting Concatenation
- The NULLIFZERO Command
- The ZEROIFNULL Command
- Answer to the ZEROIFNULL Question
- The COALESCE Command
- CAST (Convert and Store)
- A Teradata Extension – The Implied Cast
- The Basics of the CASE Statements
- Valued Case vs. Searched Case
- When an ELSE is present in CASE Statement
- When NO ELSE is present in CASE Statement
- When an Alias is NOT used in a CASE Statement
- When NO ELSE is present in CASE Statement
- Combining Searched Case and Valued Case
- A Trick for getting a Horizontal Case
- Nested Case
- Put a CASE in the ORDER BY
- Creating a Simple View
- Basic Rules for Views
- How to Modify a View
- Exceptions to the ORDER BY Rule inside a View
- How to Get HELP with a View
- Views sometimes CREATED for Formatting or Row Security
- Another Way to Alias Columns in a View CREATE
- Resolving Aliasing Problems in a View CREATE
- CREATING Views for Complex SQL such as Joins
- WHY certain columns need Aliasing in a View
- Aggregates on View Aggregates
- Locking Row for Access
- Creating Views for Temporal Tables
- Altering a Table
- Altering a Table after a View has been created
- A View that errors After an ALTER
- Troubleshooting a View
- Updating Data in a Table through a View
- Maintenance Restrictions on a Table through a View
- The 14 rules of Macros
- CREATING and EXECUTING a Simple Macro
- Multiple SQL Statements inside a Macro
- Complex Joins inside a Macro
- Passing an INPUT Parameter to a Macro
- Troubleshooting a Macro with INPUT Parameters
- An UPDATE Macro with Two Input Parameters
- Executing a Macro with Named (Not Positional) Parameters
- Troubleshooting a Macro
- Rules of Set Operators
- INTERSECT Explained Logically
- UNION Explained Logically
- UNION ALL Explained Logically
- EXCEPT Explained Logically
- Minus Explained Logically
- An Equal Amount of Columns in both SELECT List
- Columns in the SELECT list should be from the same Domain
- The Top Query handles all Aliases
- The Bottom Query does the ORDER BY (a Number)
- Great Trick: Place your Set Operator in a Derived Table
- UNION vs. UNION ALL
- Using UNION ALL and Literals
- USING Multiple SET Operators in a Single Request
- Changing the Order of Precedence with Parentheses
- Using UNION ALL for speed in Merging Data Sets
- Using UNION to be same as GROUP BY GROUPING SETS
- Using UNION to be same as GROUP BY ROLLUP
- Using UNION to be the same as GROUP BY Cube
- Using UNION to be same as GROUP BY Cube
- Creating a Table with a Unique Primary Index
- Creating a Table with a Non-Unique Primary Index
- Creating a Table without entering a Primary Index
- Creating a Set Table
- Creating a Multiset Table
- Creating a Set Table with a Unique Primary Index/Secondary Index
- Creating a Table with an UPI and USI
- Creating a Table with a Multicolumn Primary Index
- Creating a Unique Secondary Index (USI) after a table is created
- Creating a Non-Unique Secondary Index (NUSI) after a table is created
- Creating a Value-Ordered NUSI
- Data Types
- Major Data Types and the number of Bytes they take up
- Making an exact copy a Table
- Making a NOT-So-Exact Copy a Table
- Copying a Table
- Copying only specific columns of a table
- Copying a Table with Statistics
- Copying a table Structure with NO Data but Statistics
- Creating a Table with Fallback
- Creating a Table with No Fallback
- Creating a Table with a Before Journal
- Creating a Table with a Dual Before Journal
- Creating a Table with an After Journal
- Creating a Table with a Dual After Journal
- Creating a Table with a Journal Keyword Alone
- Why Use Journaling?
- Creating a Table with Customization of the Data Block Size
- Creating a Table with Customization with FREESPACE Percent
- Creating a QUEUE Table
- Example of how a Queue Table Works
- Creating a Columnar Table
- How to Load into a Columnar Table
- Creating a Columnar Table with NO AUTO COMPRESS
- CREATING a Bi-Temporal Table
- Creating a PPI Table with Simple Partitioning
- Creating a PPI Table with RANGE_N Partitioning per Day/Month
- A Visual of One Year of Data with Range_N per Month
- Creating a PPI Table with RANGE_N Partitioning per Week
- A Clever Range_N Option
- Creating a PPI Table with CASE_N
- A Visual of Case_N Partitioning
- Number of PPI Partitions Allowed
- NO CASE and UNKNOWN Partitions Together
- Combining Older Data and Newer Data in PPI
- A Visual for Combining Older Data and Newer Data in PPI
- Multi-Level Partitioning Combining Range_N and Case_N
- A Visual of Multi-Level Partitioning
- NON-Unique Primary Indexes (NUPI) in PPI
- PPI Table with a Unique Primary Index (UPI)
- Tricks for Non-Unique Primary Indexes (NUPI)
- Character Based PPI for RANGE_N
- Character-Based PPI for CASE_N
- Dates and Character-Based Multi-Level PPI
- TIMESTAMP Partitioning
- Using CURRENT_DATE to define a PPI
- ALTER to CURRENT_DATE the next year
- ALTER to CURRENT_DATE with Save
- Altering a PPI Table to Add or Drop Partitions
- Deleting a Partition and saving its content
- Using the PARTITION Keyword in your SQL
- SQL for RANGE_N
- SQL for CASE_N
- User Defined Functions
- Creating a Multi-Table Join Index
- Outer Join Multi-Table Join Index
- Visual of a Left Outer Join Index
- Compressed Multi-Table Join Index
- Creating a Single-Table Join Index
- Compressed Single-Table Join Index
- Aggregate Join Index
- Sparse Join Index
- A Global Multi-Table Join Index
- Creating a Hash Index
- INSERT Syntax #’s 1-3
- Using NULL for Default Values
- INSERT/SELECT Command
- INSERT/SELECT to Build a Data Mart
- Fast Path INSERT/SELECT
- NOT quite the Fast Path INSERT/SELECT
- UNION for the Fast Path INSERT/SELECT
- BTEQ for the Fast Path INSERT/SELECT
- The UPDATE Command Basic Syntax
- Subquery UPDATE Command Syntax
- Join UPDATE Command Syntax
- Fast Path UPDATE
- The DELETE Command Basic Syntax
- A DELETE Example Deleting only Some of the Rows
- Subquery and Join DELETE Command Syntax
- Fast Path DELETE
- MERGE INTO
- OReplace
- Stored Procedures vs. Macros
- Creating a Stored Procedure
- How you CALL a Stored Procedure
- Label all BEGIN and END statements except the first ones
- How to Declare a Variable
- The IN, OUT and INOUT Parameters
- Using IF inside a Stored Procedure
- Using Loops in Stored Procedures
- You can Name the First Begin and End if you choose
- Using Keywords LEAVE vs. UNTIL for LEAVE vs. REPEAT
- Stored Procedure Basic Assignment
- Stored Procedure Advanced Assignment
- The Fundamentals of Triggers
- CREATING A Trigger
- FOR EACH STATEMENT vs. FOR EACH ROW
- Using ORDER when Similar Triggers Exist
- What is the Order of Precedents?
- What is the Answer to this Math Question?
- What is the Answer to this Math Question?
- What is the Answer to this Math Question?
- The SAMPLE Function and Syntax
- SAMPLE Function Examples
- A Randomized SAMPLE
- A SAMPLE with Conditional Logic
- Aggregates and A SAMPLE using a Derived Table
- Random Number Generator
- Using Random to SELECT a Percentage of Rows
- Using Random and Aggregations
- The Stats Table
- The KURTOSIS Function
- The SKEW Function
- The STDDEV_POP Function
- The STDDEV_SAMP Function
- The VAR_POP Function
- The VAR_SAMP Function
- The CORR Function
- The COVAR_POP Function
- The REGR_INTERCEPT Function
- A REGR_INTERCEPT Example
- Another REGR_INTERCEPT Example so you can compare
- The REGR_SLOPE Function
- A REGR_SLOPE Example
- Another REGR_SLOPE Example so you can compare
- Using GROUP BY
- No Having Clause vs. Use of HAVING
- EXPLAIN Keywords
- Explain Examples:
- Full Table Scan
- Unique Primary Index (UPI)
- Non-Unique Primary Index (NUPI)
- Unique Secondary Index (USI)
- Redistributed to All-AMPs
- Row Hash Match Scan
- Duplicated on All-AMPs
- Low Confidence
- High Confidence
- Product Join
- BMSMS
- From a Single Partition
- From N Partitions
- Partitions and Current_Date
- The Teradata Parsing Engine (Optimizer) is Cost Based
- The Purpose of Collect Statistics
- When Teradata Collects Statistics, it creates a Histogram
- The Interval of the Collect Statistics Histogram
- What to COLLECT STATISTICS On?
- Why Collect Statistics?
- How do you know if Statistics were collected on a Table?
- A Huge Hint that No Statistics Have Been Collected
- The Basic Syntax for COLLECT STATISTICS
- COLLECT STATISTICS Examples for a better Understanding
- The New Teradata V14 Way to Collect Statistics
- Where Does Teradata Keep the Collected Statistics?
- The Official Syntaxes for COLLECT STATISTICS
- How to Recollect STATISTICS on a Table
- Teradata Always Does a Random AMP Sample
- Random Sample is kept in the Table Header in FSG Cache
- Multiple Random AMP Samplings
- How a Random AMP gets a Table Row count
- Random AMP Estimates for NUSI Secondary Indexes
- USI Random AMP Samples are Not Considered
- There’s No Random AMP Estimate for Non-Indexed Columns
- Summary of the PE Plan if No Statistics Were Collected
- Stale Statistics Detection and Extrapolation
- Extrapolation for Future Dates
- How to Copy a Table with Data and the Statistics?
- COLLECT STATISTICS Directly From another Table
- How to Copy a Table with NO Data and the Statistics?
- When to COLLECT STATISTICS Using only a SAMPLE
- How to Collect Statistics on a PPI Table on the Partition
- Teradata V12 and V13 Statistics Enhancements
- Teradata V14 Statistics Enhancements
- Teradata V14 Summary Statistics
- Teradata V14 MaxValueLength
- Teradata V14 MaxIntervals
- Teradata V14 Sample N Percent
- Teradata Statistics Wizard
- Hashing Functions on Teradata
- The HASHROW Function
- The HASHBUCKET Function
- The HASHAMP Function
- A Great HASHAMP Function for Large Tables
- The HASHBAKAMP Function
- A Great way to see distribution for Primary and Fallback rows
- BTEQ – Batch Teradata Query Tool
- How to Logon to BTEQ in Interactive Mode
- Running Queries in BTEQ in Interactive Mode
- BTEQ Commands vs. BTEQ SQL Statements
- WITH BY Command for Subtotals
- WITH Command for a Grand Total
- WITH and WITH BY Together for Subtotals and Grand Totals
- How to Logon to BTEQ in a SCRIPT
- Running Queries in BTEQ through a Batch Script
- Running a BTEQ Batch Script through the Command Prompt and Run Command
- Using Nexus to Build Your BTEQ Scripts
- Using BTEQ Scripts to IMPORT Data
- What Keywords Mean in a BTEQ Script
- Creating a BTEQ IMPORT for a Comma Separated Value File
- Four Great Examples/Ways to Run a Teradata BTEQ Script
- BTEQ Export – Four types of Export Variations
- Creating a BTEQ Export Script in Record Mode
- The Appearance of Record Mode Vs Report Mode Data
- Using Report Mode to Create a Comma Separated Report
- Creating a BTEQ IMPORT for a Comma Separated Value File
- Using Multiple Sessions in BTEQ
- BTEQ Fast Path Inserts
- BTEQ Can Use Conditional Logic
- Using a BTEQ Export and Setting a Limit In a UNIX System
- SELECT All Columns from a Table and Sort
- Select Specific Columns and Limiting the Rows
- Changing your Default Database
- Keywords that describe you
- Select TOP Rows in a Rank Order
- Find Information about a Database and Table
- Using Aggregates
- Performing a Join (using ANSI Syntax)
- Using Date, Time and Timestamp
- Using the System Calendar
- Formatting Data
- Using Rank, a Derived Table, Subquery
- Correlated Subquery
- Using Substring
- CASE Statement
- Using an Access Lock in your SQL
- Collect Statistics
- CREATING a Volatile Table with a Primary Index
- CREATING a Volatile Table that is Partitioned (PPI)
- CREATING a Volatile Table that is deleted after the Query
- Finding the Typical Rows per Value for specific column
- Finding out how much Space you have
- How much Space you have Per AMP
- Finding your Space
- Finding Space Skew in Tables in a Database
- Finding the Number of rows per AMP for a Column
- Finding Account Information
- Ordered Analytics
Related Courses
-
Teradata Basics
CFLQ-100- Duration: 1 Day
- Delivery Format: Classroom Training, Online Training
- Price: 765.00 USD
-
Teradata SQL
CFLQ-105- Duration: 3 Days
- Delivery Format: Classroom Training, Online Training
- Price: 2,295.00 USD
Self-Paced Training Info
Learn at your own pace with anytime, anywhere training
- Same in-demand topics as instructor-led public and private classes.
- Standalone learning or supplemental reinforcement.
- e-Learning content varies by course and technology.
- View the Self-Paced version of this outline and what is included in the SPVC course.
- Learn more about e-Learning
Course Added To Shopping Cart
bla
bla
bla
bla
bla
bla
Self-Paced Training Terms & Conditions
??spvc-wbt-warning??
??group-training-form-area??
??how-can-we-help-you-area??
??personalized-form-area??
??request-quote-area??
Sorry, there are no classes that meet your criteria.
Please contact us to schedule a class.
STOP! Before You Leave
Save 0% on this course!
Take advantage of our online-only offer & save 0% on any course !
Promo Code skip0 will be applied to your registration
Nothing yet
Purchase Information
??elearning-coursenumber?? ??coursename??
View Cart