Course: Fundamentals of Teradata SQL
duration: 14 hours |
Language: English (US) |
access duration: 90 days |
Details
In this course you will learn the basics of SQL with Teradata. You will learn to use select statement, joins, subqueries, you will get an demonstration of the different features such as strings, perform data conversions, using SET operations, timestamps and far more. Finally you will learn to perform DDL and DML operations in a database.
Result
After completing this course you are familiar with the basics of SQL with Teradata.
Prerequisites
You have basic knowledge of databases.
Target audience
Database Administrators
Content
Fundamentals of Teradata SQL
Teradata SQL: The SELECT Statement, Joins, and Subqueries
- start the course
- describe SQL and how it can be used in Teradata
- launch and use the BTEQ command line tool and identify how it is used as a query management tool
- describe the different clauses in a SELECT statement
- perform basic SELECT statements in Teradata
- use basic WHERE clause in a SELECT statement to perform conditional queries in Teradata
- perform advanced WHERE clause searches in a SELECT statement to limit results in Teradata
- use the ORDER BY clause in a SELECT statement to perform a query in Teradata
- use the GROUP BY and HAVING clauses to perform grouping in query results in Teradata
- use TOP, SAMPLE, and the SAMPLEID expression in a SELECT statement to limit results in Teradata
- use MIN, MAX, COUNT, AVG, SUM aggregates in a SELECT statement in Teradata
- use GROUPING SETS, ROLLUP, and CUBE to analyze data across a dimension in Teradata
- use the WITH clause in a SELECT statement in Teradata
- describe the different types of joins that can be performed in Teradata
- perform natural joins in Teradata
- perform theta joins in Teradata
- perform inner joins in Teradata
- perform outer joins in Teradata
- perform self joins and cross joins in Teradata
- perform multitable joins in Teradata
- describe subqueries, scalar subqueries, and correlated subqueries, and how they are used in Teradata to retrieve results
- perform basic subqueries in a SELECT statement to return results from Teradata
- perform subqueries in the search condition of a WHERE clause
- perform scalar subqueries to return results from Teradata
- perform correlated subqueries to return results from Teradata
- create and use derived tables in Teradata
- use the SELECT statement to perform queries, including performing joins and subqueries
Teradata SQL: Functions, Data Conversions, and Working with Time
- start the course
- identify the different types of functions in Teradata and how expressions and SQL operators are used
- use arithmetic functions and operators on data in Teradata
- use attribute functions to return descriptive information about their operand in Teradata
- use string functions to perform operations on strings of data in Teradata
- use regular expression functions on data in Teradata
- use the analytical functions in Teradata
- use CASE expressions to evaluate a set of expressions in Teradata
- use calendar functions to work with dates, months, and years in Teradata
- use ANSI DateTime expressions to do computations with Time Zones and interval values in Teradata
- use ANSI Interval expressions to perform calculations on Interval values in Teradata
- use arithmetic operators, ANSI DateTime, and Interval Data Types in Teradata
- use scalar operations with DateTime functions to work with dates and times in Teradata
- use the different DateTime and Interval functions, ADD_MONTHS, OADD_MONTHS, AND MONTHS_BETWEEN in Teradata
- use the different DateTime and Interval functions, LAST_DAY, NEXT_DAY, TRUNC, ROUND, EXTRACT in Teradata
- identify the three ways data types are converted in Teradata
- identify when implicit data conversion is performed and what the supported data types are
- identify the syntax and rules for using CAST to perform data conversions in Teradata
- use data type conversion functions to convert characters in Teradata with CAST
- use data type conversion to convert numbers, times, and intervals in Teradata with CAST
- identify and use the data type conversion functions to convert data in Teradata
- describe the set operators, their syntax, and order precedence for use in Teradata
- use the INTERSECT set operator in Teradata
- use the MINUS and EXCEPT set operators in Teradata
- use the UNION set operator in Teradata
- use set operators in derived tables, subqueries, and SELECT...INSERT statements in Teradata
- use functions, expressions, and operations in Teradata to work with data
Teradata SQL: DDL, DML, and SQL Optimization
- start the course
- create and alter a database in Teradata
- create and manage database users for Teradata
- create a table in Teradata using the CREATE TABLE statement
- create a table in Teradata using the CREATE TABLE statement which includes defining an index, column definitions, and table options
- alter, manage, and drop tables in Teradata
- create and alter indexes in Teradata
- create and alter views in Teradata
- create recursive views in Teradata
- create macros in Teradata
- create triggers in Teradata
- create procedures in Teradata
- alter, rename, and drop functions and stored procedures in Teradata
- use the QUALIFY clause in Teradata
- use NORMALIZED in a SELECT statement in Teradata
- use the EXPAND ON clause in a SELECT statement in Teradata
- use the INSERT statement to insert data into Teradata
- use the UPDATE statement to update data in Teradata
- use the DELETE statement to remove data from Teradata
- use MERGE to merge data into a table in Teradata
- identify how to optimize query design in Teradata
- identify how to improve the performance of merge joins in Teradata
- describe the basic temporal concepts in Teradata
- create temporal tables in Teradata
- load data into temporal tables in Teradata
- perform DDL operations using their temporal form in Teradata
- perform DML operations using their temporal form in Teradata
- perform DDL and DML operations on regular and temporal tables in Teradata
Course options
We offer several optional training products to enhance your learning experience. If you are planning to use our training course in preperation for an official exam then whe highly recommend using these optional training products to ensure an optimal learning experience. Sometimes there is only a practice exam or/and practice lab available.
Optional practice exam (trial exam)
To supplement this training course you may add a special practice exam. This practice exam comprises a number of trial exams which are very similar to the real exam, both in terms of form and content. This is the ultimate way to test whether you are ready for the exam.
Optional practice lab
To supplement this training course you may add a special practice lab. You perform the tasks on real hardware and/or software applicable to your Lab. The labs are fully hosted in our cloud. The only thing you need to use our practice labs is a web browser. In the LiveLab environment you will find exercises which you can start immediately. The lab enviromentconsist of complete networks containing for example, clients, servers,etc. This is the ultimate way to gain extensive hands-on experience.
Sign In
WHY_ICTTRAININGEN
Betaal in termijnen
| Cursusnaam | |
| Looptijd | |
| Rentebedrag financiering | |
| Totaal bedrag | |
| Maandbedrag |
Gespreid betalen met Spraypay
Met de betaaloptie SprayPay kun je jouw bestelling van € 250,- tot € 3.500,- veilig en gespreid betalen in gelijke termijnen van 12, 18, 24 of 36 maanden. Je hebt op die manier een minimale financiële belasting en je kunt eenvoudig de termijnbetalingen opnemen in jouw vaste lasten.
Hoe werkt het kopen op afbetaling? De beoordeling van de kredietaanvraag vindt online plaats. Binnen enkele seconden weet je of je in aanmerking komt voor een krediet. Is de aanvraag akkoord dan kun je meteen genieten van je aankoop.
Let op: deze betaalmetode is aleen beschikbaar voor particulieren! Bekijk voor je aankoop ook de SprayPay voorwaarden.
Via ons opleidingsconcept bespaar je tot 80% op trainingen
Start met leren wanneer je wilt. Je bepaalt zelf het gewenste tempo
Spar met medecursisten en profileer je als autoriteit in je vakgebied.
Ontvang na succesvolle afronding van je cursus het officiële certificaat van deelname van Icttrainingen.nl
Krijg inzicht in uitgebreide voortgangsinformatie van jezelf of je medewerkers
Kennis opdoen met interactieve e-learning en uitgebreide praktijkopdrachten door gecertificeerde docenten
Orderproces
Once we have processed your order and payment, we will give you access to your courses. If you still have any questions about our ordering process, please refer to the button below.
read more about the order process
Een zakelijk account aanmaken
Wanneer u besteld namens uw bedrijf doet u er goed aan om aan zakelijk account bij ons aan te maken. Tijdens het registratieproces kunt u hiervoor kiezen. U heeft vervolgens de mogelijkheden om de bedrijfsgegevens in te voeren, een referentie en een afwijkend factuuradres toe te voegen.
Betaalmogelijkheden
U heeft bij ons diverse betaalmogelijkheden. Bij alle betaalopties ontvangt u sowieso een factuur na de bestelling. Gaat uw werkgever betalen, dan kiest u voor betaling per factuur.
Cursisten aanmaken
Als u een zakelijk account heeft aangemaakt dan heeft u de optie om cursisten/medewerkers aan te maken onder uw account. Als u dus meerdere trainingen koopt, kunt u cursisten aanmaken en deze vervolgens uitdelen aan uw collega’s. De cursisten krijgen een e-mail met inloggegevens wanneer zij worden aangemaakt en wanneer zij een training hebben gekregen.
Voortgangsinformatie
Met een zakelijk account bent u automatisch beheerder van uw organisatie en kunt u naast cursisten ook managers aanmaken. Beheerders en managers kunnen tevens voortgang inzien van alle cursisten binnen uw organisatie.
What is included?
| Certificate of participation | Yes |
| Monitor Progress | Yes |
| Award Winning E-learning | Yes |
| Mobile ready | Yes |
| Sharing knowledge | Unlimited access to our IT professionals community |
| Study advice | Our consultants are here for you to advice about your study career and options |
| Study materials | Certified teachers with in depth knowledge about the subject. |
| Service | World's best service |
Platform
Na bestelling van je training krijg je toegang tot ons innovatieve leerplatform. Hier vind je al je gekochte (of gevolgde) trainingen, kan je eventueel cursisten aanmaken en krijg je toegang tot uitgebreide voortgangsinformatie.
FAQ
Niet gevonden wat je zocht? Bekijk alle vragen of neem contact op.