Support/FAQ

Data Warehousing with Teradata RDBMS Training


Course Summary


Course Title: Datawarehousing with Teradata RDBMS Training
Course Duration: 6 Weeks
Training Materials: All attendees would receive
  • Training presentation of each session,
  • Source Code for examples covered,
  • Study Material,
  • Home Work and Assignments.
Training Format: This course is delivered as a highly interactive session, with extensive live examples. This course is delivered in two modes:
  • Class Room,
  • Online using Web and Audio Conferencing.

What will you learn?

In this training, attendees will learn the following:
  1. Teradata Components & Architecture
  2. Distribution in Teradata
  3. Teradata space management
  4. Data protection
  5. The active data warehouse
  6. Teradata tools - sql assistant
  7. Creating tables
  8. Temporary tables
  9. Views
  10. Teradata utility and mechanism with example
  11. Sql basics
  12. Selecting rows
  13. Help, show, and explain
  14. Aggregates
  15. Subqueries
  16. Joins
  17. Aliasing, title, cast, and format
  18. Interrogating data
  19. Set operators
  20. Macros
  21. Dates and times
  22. With and with by for totals and subtotals
  23. Sampling
  24. Rank and quantile
  25. OLAP
  26. Stored procedures
  27. Transaction processing
  28. Project


Attendees also learn:
  1. Resume' Preparation Guidelines and Help
  2. and Interview Preparation Help

Who should attend?

Following professionals should plan on joining:
  • Anyone who is developing applications using Teradata or any RDBMS
  • Developers who want to shift from any DBMS/RDBMS to TERADATA
  • Working in DatawareHousing projects from ETL as well as BI side
  • Project Managers working on the DatawareHousing project

What will be covered?

TERADATA COMPONENTS & ARCHITECTURE:
  1. The Teradata parallel architecture
  2. A logical view of the Teradata architecture
  3. The Parsing Engine (PE)
  4. The Access Module Processors (AMPs)
  5. The BYNET

DATA DISTRIBUTION IN TERADATA
  1. Rows and columns
  2. The Primary Index
  3. Two types of Primary indexes (Unique Primary Index & Non-Unique Primary Index)
  4. Data distribution using the Unique Primary Index Value/ Non-Unique Primary Index Value
  5. The Secondary Index
  6. Data distribution using the Secondary Index Value
  7. Partition Primary Index

TERADATA SPACE MANAGEMENT
  1. Types of Spaces
  2. PERM, SPOOL and TEMP space
  3. How spool space is calculated

DATAPROTECTION
  1. Transaction concept & Transient Journal
  2. Fallback protection /clusters
  3. Redundant Array of Independent Disks (RAID)
  4. Cliques
  5. Permanent Journal
  6. Table create with Fallback and Permanent Journaling
  7. Locks and their compatibility

THE ACTIVE DATA WAREHOUSE
  1. OLTP environments
  2. The DSS environment
  3. Data marts and it’s type

TERADATA TOOLS - SQL ASSISTANT
  1. TDQM
  2. Index wizard
  3. Archive recovery
  4. Teradata Analyst Suite

CREATING TABLES
  1. CREATE / Populate Table
  2. Set tables /Multiset tables
  3. quick way to copy tables
  4. CREATE table options
  5. Defining constraints at the column level/ table level
  6. Partitioning with CASE_N
  7. Partitioning with RANGE_N
  8. NO CASE, NO RANGE, or UNKNOWN
  9. Data types /Attributes /Constraints
  10. PPI and Identity columns/Secondary index definitions
  11. COLLECT STATISTICS
  12. Hash functions

TEMPORARY TABLES
  1. Derived tables
  2. Multiple columns in a derived table
  3. Volatile table
  4. Global temporary tables

VIEWS
  1. View basics
  2. CREATE/REPLACE/DROP
  3. Placing aggregates inside a view
  4. Using “locking for access” in views
  5. UPDATE tables through views
  6. Restricting UPDATE rows with check option

TERADATA UTILITY AND MECHANISM WITH EXAMPLE
  1. BTEQ
  2. FastExport
  3. FastLoad
  4. MultiLoad
  5. TPump
  6. INMOD Processing
  7. OUTMOD Processing

SQL BASICS
  1. Rows and columns
  2. The SELECT command
  3. The WHERE clause
  4. The order BY clause
  5. Sorting by multiple columns
  6. Teradata SQL Punctuation

SELECTING ROWS
  1. Working with NULL
  2. The DISTINCT command with multiple columns
  3. The AND /OR/ NOT operator
  4. Order of precedence for (), NOT, AND, or OR
  5. USING an IN List instead of OR
  6. The BETWEEN operator
  7. The LIKE operator and percent wildcard v
  8. SQL that causes a full table scan (FTS)

HELP, SHOW, AND EXPLAIN
  1. The HELP command
  2. The SHOW command
  3. The EXPLAIN command

AGGREGATES
  1. Aggregates
  2. Aggregate example with NULL values / the GROUP BY statement
  3. Aggregates and the HAVING statement
  4. WHERE, GROUP BY and HAVING together

SUBQUERIES
  1. The IN statement (for review)
  2. Normal Subqueries (using multiple tables)
  3. Correlated Subquery
  4. NOT EXISTS vs. NOT IN

JOINS
  1. Primary key/foreign key relationships
  2. A LEFT OUTER /RIGHT OUTER / FULL OUTER)
  3. Join types vs. join strategies
  4. Big table small table join strategy
  5. Nested join
  6. Hash join
  7. Exclusion join
  8. Product joins
  9. Cartesian product join
  10. Cross join
  11. Self join

ALIASING, TITLE, CAST, AND FORMAT
  1. Title function in BTEQ adds functionality
  2. Title function used with distinct
  3. Teradata data types
  4. CAST function
  5. Derived columns /Using and ALIAS on a column
  6. Formatting a column
  7. Date, time, and timestamp FORMAT

INTERROGATING DATA
  1. SUBSTRING
  2. SUBSTR
  3. Concatenation of character strings
  4. Using SUBSTRING and concatenation together
  5. CHARACTER vs. VARCHAR
  6. The TRIM function
  7. CHARACTERS command
  8. Output results for multiple commands mixed
  9. The POSITION function
  10. The INDEX function
  11. SUBSTRING and POSITION together
  12. COALESCE with literals
  13. ZEROIFNULL
  14. NULLIFZERO
  15. NULLIF command
  16. The CASE command (vlued CASE)
  17. The CASE command (searched CASE)
  18. Nested CASE statement

SET OPERATORS
  1. INTERSECT
  2. UNION
  3. EXCEPT or MINUS

MACROS
  1. Macro basics
  2. How to create/ execute a macro
  3. Parametric macro
  4. Drop macro

DATES AND TIMES
  1. DATE Functions
  2. ADD_MONTHS /EXTRACT
  3. The system calendar
  4. INTERVAL processing for arithmetic and conversion
  5. TIMESTAMP
  6. CURRENT_TIMESTAMP


WITH AND WITH BY FOR TOTALS AND SUBTOTALS
  1. The WITH statement
  2. The WITH BY statement
  3. Combining WITH BY and WITH

SAMPLING
  1. Random sampling – number of rows sample
  2. Random sampling – percentage of the table sample
  3. SAMPLE WITH REPLACEMENT / REPLACEMENT and RANDOMIZED ALLOCATION together
  4. SAMPLE with conditional test

RANK AND QUANTILE
  1. RANK
  2. QUALIFY RANK is like a HAVING statement
  3. QUALIFY RANK with a GROUP BY
  4. QUANTILE function

OLAP
  1. Cumulative Sum (CSUM)
  2. ANSI SUM OVER with PARTITION BY for grouping
  3. Moving Sum (MSUM)
  4. Moving Average (MAVG)
  5. MAVG with ANSI AVG OVER
  6. Moving Difference (MDIFF)

STORED PROCEDURES
  1. CREATE procedure
  2. Nesting BEGIN and END statements
  3. Passing a stored procedure parameters
  4. The WHILE and END WHILE

TRANSACTION PROCESSING
  1. Transactions defined
  2. Locking
  3. Multi-statement operations

MISCELLANEOUS
  1. Single row MERGE INTO command
  2. Compression
  3. Teradata and ANSI mode
  4. SQRT function
  5. INSERT/SELECT on two exact tables
  6. Triggers


Resume Preparation Tips
  1. Resume Review
  2. Resume Preparation Tips
  3. Sample Resumes


Interview Preparation
  1. Interview Preparation Tips
  2. Sample Interview Questions
  3. Tips & Guidelines for Effective Interview
Training highlights

Sansa Technology Professional Training Programs have the following highlights:

  • Proven training programs.
  • Excellent track record.
  • Courses tailored for job placements and Interview success.
  • Best instructors in the Bay Area.
  • Exceptional marketing staff.
  • Small Class Room for Personalized Attention.
  • H1 Sponsorship Available.
  • E-Verified Employer.
  • Equal Opportunity Employer.
  • Resume and Interview Preparation.
read more

Quality Commitment

We are committed to the Quality. Quality comes first for any service we provide.
Read Testimonials from our previous Trainees, to see it yourself.

Register Now

You can register using one of many options below:

1. Online Registration:
Click Here to Register!

2. To Register By Phone:
Call (510) 244 3953, (925) 248 2249

3. To Register By Email:
Email contact@sansatechnology.com

Check Training Calendar

Our clients

"I was very satisfied with the contents of the course which covered a wide range of useful topics... I would like to attend more of his classes in the future." - Jaishree, J2EE Engineer

read more
Have you got any questions?
Call us now - Our expert Customer Service Professionals will help you choose the right course.

Contact us today!