Teradata SQL Training Award-winning E-Learning course Interactive videos with spoken text Certified teachers Practical exercises Certificate.
Read more.
Bulk discount
No discount
1 Piece
€192,39€159,00
2% Discount
2 Pieces
€188,54€155,82/ Piece
3% Discount
3 Pieces
€186,62€154,23/ Piece
4% Discount
4 Pieces
€184,69€152,64/ Piece
5% Discount
5 Pieces
€182,77€151,05/ Piece
10% Discount
10 Pieces
€173,15€143,10/ Piece
15% Discount
25 Pieces
€163,53€135,15/ Piece
20% Discount
50 Pieces
€153,91€127,20/ Piece
Make a choice
Officieel examen Online of fysiek
Start nu – bekroonde e-learning Inclusief proefexamens & 24/7
ISO 9001 & 27001 werkwijze 1000+ organisaties gingen u voor
Maatwerk & gratis intake Inclusief nulmeting bij training
Product description
Teradata SQL E-Learning
Order this unique E-Learning Teradata SQL course online! ✔️ 1 year of 24/7 access to rich interactive videos, voice commands, and progress monitoring via reports. ✔️ Learn Teradata SQL and discover how to efficiently retrieve data from one of the most powerful relational database systems.
Why choose this course?
Teradata is one of the leading relational database systems used by companies to process large amounts of data. This course provides you with the knowledge and skills needed to use Teradata SQL efficiently and make optimal use of the possibilities of this system.
What you will learn:
Teradata Database Architecture: Learn how the Teradata database is constructed and how it uses symmetric multiprocessing systems and massively parallel processing systems.
ANSI SQL: Gain in-depth knowledge of the basics of ANSI SQL and learn how to write standard SQL queries for retrieving and managing data in Teradata.
Teradata SQL Extensions: Explore the powerful Teradata extensions Teradata offers, such as advanced analytics features and improved performance for large data sets.
Data Storage and Processing: Learn how Teradata efficiently stores and processes data in a distributed environment, which is essential for managing massive amounts of enterprise data.
Query Optimization: Learn techniques for optimizing your SQL queries to achieve faster performance and improve efficiency when working with large data sets.
Taking this course will improve your ability to use Teradata for complex data analysis tasks and give you an edge over other professionals in the field.
Who should participate?
This training is ideal for:
Database administrators who work with Teradata databases and want to improve their SQL skills.
Data analysts who work with Teradata to process and analyze large amounts of data.
SQL developers who want to delve into Teradata SQL and expand their understanding of relational databases.
Business users who want to familiarize themselves with Teradata for data analysis or business intelligence projects.
Demo Teradata SQL Training
Course content
The SELECT Statement
Course: 1 Hour, 39 Minutes
Course Introduction
Overview of SQL for Teradata
Overview of the Basic Teradata Query Utility
The SELECT Statement
Performing Basic SELECT Statements
Performing Basic WHERE Clause Searches
Performing Advanced WHERE Clause Searches
Using the ORDER BY Clause
Using the GROUP BY and HAVING Clauses
Using TOP, SAMPLE, and SAMPLEID
Using Aggregations
Using GROUPING SETS, ROLLUP, and CUBE
Using the WITH Clause
Joins
Course: 56 Minutes
Overview of Joins
Performing Natural Joins
Performing Theta Joins
Performing Inner Joins
Performing Outer Joins
Performing Self Joins and Cross Joins
Performing Multitable Joins
Subqueries and Correlated Subqueries
Course: 41 Minutes
Overview of the Types of Subqueries
Performing Subqueries in a SELECT Statement
Performing Subqueries in Search Conditions
Performing Scalar Subqueries
Performing Correlated Subqueries
Using Derived Tables
Practice: Querying a Teradata Database
Course: 9 Minutes
Exercise: Using the SELECT Statement
Functions
Course: 53 Minutes
Course Introduction
Overview of Functions and SQL Operators
Using Arithmetic Functions
Using Attribute Functions
Using String Functions
Using Regular Expression Functions
Using Analytical Functions
Using CASE Expressions
Times, Dates, and Intervals
Course: 43 Minutes
Using Calendar Functions
Using ANSI DateTime Expressions
Using ANSI Interval Expressions
Using Arithmetic DateTime and Interval Functions
Using Scalar Operations and DateTime Functions
Using DateTime and Interval Functions (Part 1)
Using DateTime and Interval Functions (Part 2)
Data Conversions and Computations
Course: 35 Minutes
Overview of Data Type Conversions
Understanding Implicit Type Conversions
Overview of Using CAST
Using Data Type Conversion Functions (Part 1)
Using Data Type Conversion Functions (Part 2)
Using Data Type Conversion Functions (Part 3)
SET Operations
Course: 23 Minutes
Overview of Using Set Operators
Using INTERSECT
Using MINUS and EXCEPT
Using Union
Using Set Operators in Advanced Queries
Practice: Using Functions and Operators
Course: 5 Minutes
Exercise: Using Teradata Functions
Data Definition Language
Course: 1 Hour, 36 Minutes
Course Introduction
Creating and Altering Databases
Creating and Managing Database Users
Creating Basic Tables
Creating Advanced Tables
Altering Tables
Creating and Altering Indexes
Creating and Altering Views
Creating Recursive Views
Creating Macros
Creating Triggers
Creating Procedures
Altering Functions and Procedures
Data Manipulation Language
Course: 34 Minutes
Using the QUALIFY Clause
Using NORMALIZED
Using the EXPAND ON Clause
Using the INSERT Statement
Using the UPDATE Statement
Using the DELETE Statement
Using MERGE
SQL Optimization
Course: 10 Minutes
Optimizing Query Design
Improving Performance of Merge Joins
Temporal Concepts
Course: 24 Minutes
Overview of Temporal Concepts
Creating Temporal Tables
Loading Data into Temporal Tables
Performing DDL on Temporal Tables
Performing DML on Temporal Tables
Practice: Use DDL, DML, and Temporal Tables
Course: 8 Minutes
Exercise: Performing DDL and DML in Teradata
Get started with Teradata SQL Training!
✔️ Learn at your own pace with interactive videos, exercises and practical examples. ✔️Test your knowledge with reports and tests per chapter to ensure you understand everything well. ✔️ Manage and analyze data effectively with the power of Teradata and SQL.
Order your course now and start optimizing your data analysis capabilities today!
Specifications
Article number
142179448
SKU
142179448
Language
English
Qualifications of the Instructor
Certified
Course Format and Length
Teaching videos with subtitles, interactive elements and assignments and tests
Lesson duration
8:56 Hours
Progress monitoring
Access to Material
365 days
Technical Requirements
Computer or mobile device, Stable internet connections Web browsersuch as Chrome, Firefox, Safari or Edge.
Support or Assistance
Helpdesk and online knowledge base 24/7
Certification
Certificate of participation in PDF format
Price and costs
Course price at no extra cost
Cancellation policy and money-back guarantee
We assess this on a case-by-case basis
Award Winning E-learning
Tip!
Provide a quiet learning environment, time and motivation, audio equipment such as headphones or speakers for audio, account information such as login details to access the e-learning platform.
Heeft u vragen over dit product of hulp nodig bij het bestellen? Onze AI-chatbot is 24/7 beschikbaar, of neem contact op via [email protected] of bel +31 36 760 1019
Heeft u vragen over dit product of hulp nodig bij het bestellen? Onze AI-chatbot is 24/7 beschikbaar, of neem contact op via [email protected] of bel +31 36 760 1019
Machine Learning with No-Code/Low-Code E-Learning Training Gecertificeerde docen...
€239,58€198,00
Specifications
Article number
142179448
SKU
142179448
Language
English
Qualifications of the Instructor
Certified
Course Format and Length
Teaching videos with subtitles, interactive elements and assignments and tests
Lesson duration
8:56 Hours
Progress monitoring
Access to Material
365 days
Technical Requirements
Computer or mobile device, Stable internet connections Web browsersuch as Chrome, Firefox, Safari or Edge.
Support or Assistance
Helpdesk and online knowledge base 24/7
Certification
Certificate of participation in PDF format
Price and costs
Course price at no extra cost
Cancellation policy and money-back guarantee
We assess this on a case-by-case basis
Award Winning E-learning
Tip!
Provide a quiet learning environment, time and motivation, audio equipment such as headphones or speakers for audio, account information such as login details to access the e-learning platform.
Wij gebruiken functionele en analytische cookies om onze website goed te laten werken en het gebruik ervan te meten met Google Analytics. Er worden geen persoonsgegevens gedeeld voor advertentiedoeleinden. Door op "Accepteren" te klikken, geeft u toestemming voor het plaatsen van deze cookies.
Manage cookies
