Teradata SQL E-Learning Training

Verdiep je in de wereld van geavanceerde data-analyse met onze Teradata SQL Training! Deze cursus is ideaal voor data-analisten, ontwikkelaars, en IT-professionals die willen leren werken met de krachtige Teradata SQL-software. Teradata biedt uitgebreide mogelijkheden voor het beheren en analyseren van grote datasets en is een veelgebruikte tool in enterprise data warehousing.

In deze training leer je de basisprincipes van Teradata SQL, waaronder het schrijven van SQL-query’s, het uitvoeren van complexe bewerkingen, en het optimaliseren van data-opvragingen. Je krijgt inzicht in essentiële concepten zoals joins, subqueries, indexen en datamanagement, zodat je efficiënt kunt werken met grote hoeveelheden data. Na afloop van de training heb je de vaardigheden om Teradata SQL effectief toe te passen in dagelijkse data-analyse en bedrijfsrapportages.

Voordelen van deze training:

• Grondige kennis van Teradata SQL en zijn toepassingen
• Vaardigheden voor het schrijven van complexe SQL-query's en datamanipulatie
• Praktijkervaring met data-analyse en rapportage
• Ondersteuning door een online mentor en toegang tot oefenexamens

Cursusinhoud

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