Teradata Fundamentals - Comprehensive SQL course on Teradata

A comprehensive course on Teradata Fundamentals and SQL

4.35 (805 reviews)

Udemy

platform

English

language

Databases

What you will learn

Learn Teradata Architecture and it's components

Learn the concepts of Primary,Secondary and No Primary Index in Teradata

Create a Database,User and Profile in Teardata

Learn Basic SQL fundamentals

Learn SQL concepts like Aggregate Functions,Joins,Subquery

See the difference between Rank,Dense_Rank and Row number

See the difference between Cumulative Sum,Moving Average and Moving Count

See the difference b/w Views and Macros in Teradata

Case Statement,Coalesce Function and Partitioning in Teradata

Learn the Teradata famous utilities: FASTLOAD,MULTILOAD,BTEQ and FASTEXPORT

Why take this course?

Why Teradata Database:

Teradata is considered to be one of the most popular database management system,famous for large data warehousing applications .Also, It is capable of handling large volumes of data and is highly scalable.

Why to Learn SQL:

SQL aka Structured Query Language is the most popular database language so it's use is everywhere whether we talk about Database,Data warehousing,Data Science or BI.Many big companies like Deloitte,Amazon,Netflix etc using this language to retrieve data from database.Important thing needs to understand that,the basic syntax of SQL for all databases is the same, so, if you have mastered SQL on Teradata, the use of SQL on other databases would not be a problem for you.

Career Perspective:

If you want to pursue a career in one of the above fields this course is right for you.In this course, we will make your foundation by starting from very basic and then later in the course,we'll cover some advance topics , so, in-case you are very new or have no knowledge of SQL,by the end this course,you will attain maximum knowledge of SQL.

Another aspect of this course is that not only I am going through all the concepts but also give the practical demonstration by writing SQL queries in Teradata SQL assistant tool.

The pace of this course is very slow,means,I will emphasize ample time on the subject and will try to cover everything that I can.

After this Course:

Once your are done with the course,you will have maximum knowledge of SQL and can apply these concepts in different fields as mentioned above.

Cheers..!!

Have a Great Learning..!!!

Screenshots

Teradata Fundamentals - Comprehensive SQL course on Teradata - Screenshot_01

Teradata Fundamentals - Comprehensive SQL course on Teradata - Screenshot_02

Teradata Fundamentals - Comprehensive SQL course on Teradata - Screenshot_03

Teradata Fundamentals - Comprehensive SQL course on Teradata - Screenshot_04

Reviews

Teradus

March 14, 2023

If you are a beginner and looking for the basics of Teradata along with the basics Of SQL then go for it, Simple profound and well presented, and if you are Asian then definitely go for it cause its the accent that helps you to feel like in school.

Hamza

February 3, 2023

Instructor does not respond to questions. Also the class material is not provided to follow along with the class lectures. Other than that the class and explanation is pretty good.

Jeevan

February 1, 2023

Excellent and explanation are given with quick examples which give pretty good idea where and how we can use.

Maria

November 2, 2022

The easiest and most complete guide on Teradata. From setting up the database to configuring Teradata studio. Very clear instructions and tasks to create your own local database and run commands.

Mark

September 6, 2022

Some good information however quite old and out of date. Example, using TD Assistant which is no longer available to download. Also, the instructor could prepare better - have a plan, prep some scripts and avoid thinking on the fly, making errors then correcting them.

Eduard

July 22, 2022

There is a lot of useful material in this course. Also, the author has created many slides to visually present it. That having been said, there are a lot of rough edges in this course. The order of presentation of the material is on occasion peculiar. Sometimes, the presenter just mentions the words on the slides without any "verbal smoothing".

Gary

April 12, 2022

covered the major points with details and great examples. Test questions were sometime not worded as precise as needed to understand what is being asked.

Manu

February 2, 2022

This is a great course on SQL programming, specifically tailored to Teradata and not general SQL programming.

Anjali

December 24, 2021

Till now I have learnt so many thing like basics concept of Teradata.i was searching these type of tutorial but i am glat that i found your course through your youtube channel.Thanks in advance.

Robert

December 9, 2021

This course seems to cover two separate topics, architecture and development, and these should be in two different courses because they focus on different requirements.

Sateswar

July 5, 2021

More details should have covered for view and all other DB objects. There are many teradata function which need to know. Only SQL is covered no pl sql

Thribhuvan

May 26, 2021

Good content for beginners and more of general SQL. If possible link more info on teradata atleast present use tools like Viewpoint etc.

Arati

March 24, 2021

All practical scenarios like no more room, duplicates in table, numeric overflow, partitioning should be covered

Sharadhi

December 21, 2020

Bad training. Software configurations not explained properly. Spent almost 3 hours trying to set up but no use.

Ahmed

December 23, 2019

So far, I think it's a good experience, and I feel that this course could be better introduced with exercise files and organized way of training through the exercise files.

Charts

Price

Rating

Enrollment distribution

Teradata Fundamentals - Comprehensive SQL course on Teradata - Distribution chart