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.
Advanced Teradata SQL
Duration
2 Days
Course
CFLQ-150
Available Formats
Classroom Training, Online Training
Course Description
Overview
This Advanced Teradata SQL course is designed to provide students with more sophisticated usages of the Teradata database. While it does incorporate more functionality associated with the SELECT, it goes beyond data mining to include data maintenance.Additionally, it focuses on techniques that provide a high degree of flexibility as well as performance opportunities. This course uses methodologies to enhance data integrity as well as looking for opportunities to enhance performance of queries. This course is designed for experienced SQL users.
This course can be taught using Version 12, 13, or 14. Please inform your sales representative of which version you are currently using.
Objectives
Upon completion of the Advanced Teradata SQL course, students will be able to:
- Increase overall knowledge and experience with Teradata
- Describe the EXPLAIN
- Increase SQL proficiency
- Apply performance advantages related to transactions
- List and apply alternatives, tricks and techniques for data mining
Audience
- IT Professionals
Prerequisites
- Successful completion of CFLQ-105 Teradata SQL course or equivalent knowledge
- Strong experience in using SQL
Topics
- Correlated subqueries only
- Joins with correlated subquery (inner and outer joins)
- INTERSECT
- UNION
- EXCEPT
- INSERT
- INSERT / SELECT
- UPDATE
- DELETE
- CASE only
- Transactions defined
- Locking
- Multi-statement operations
- Data types
- Attributes
- Constraints
- PPI and Identity columns
- Secondary index definitions
- COLLECT STATISTICS
- Hash functions
- Derived tables
- Volatile tables
- Global tables as needed
- SPL
- Variables and parameters
- Single row selection vs multi-row via cursor
- New SQL version of SELECT
- Dynamic SQL
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??
Exam Terms & Conditions
??exam-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
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.