Teradata Fundamentals - Comprehensive SQL course on Teradata
4.3 (289 ratings)
Course Ratings are calculated from individual students’ ratings and a variety of other signals, like age of rating and reliability, to ensure that they reflect course quality fairly and accurately.
1,180 students enrolled

Teradata Fundamentals - Comprehensive SQL course on Teradata

A comprehensive course on Teradata Fundamentals and SQL
Bestseller
4.3 (289 ratings)
Course Ratings are calculated from individual students’ ratings and a variety of other signals, like age of rating and reliability, to ensure that they reflect course quality fairly and accurately.
1,180 students enrolled
Created by Saad Qureshi
Last updated 6/2020
English
English [Auto]
Current price: $139.99 Original price: $199.99 Discount: 30% off
5 hours left at this price!
30-Day Money-Back Guarantee
This course includes
  • 6.5 hours on-demand video
  • 48 downloadable resources
  • 1 Practice Test
  • Full lifetime access
  • Access on mobile and TV
  • Assignments
  • Certificate of Completion
Training 5 or more people?

Get your team access to 4,000+ top Udemy courses anytime, anywhere.

Try Udemy for Business
What you'll 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
Course content
Expand all 57 lectures 06:38:55
+ Teradata Getting Started
12 lectures 01:33:51

Dear Students,

I think Teradata has done some updates in TTU due to which you may not find Teradata SQL assistant tool option while installing TTU.As an alternative,I would recommend you to  install Teradata Studio Express to write SQL Queries.

Below is the link to download Teradata Studio.

https://downloads.teradata.com/download/tools/teradata-studio-express

Sorry for the inconvenience.

Thanks

Installation and Configuration Teradata Tools(Updated Version)
13:47
Teradata Architecture
08:48
Primary Index in Teradata
12:15
Secondary Index in Teradata
14:19
NOPI in Teradata
10:22
Types of Spaces in Teradata
09:47
Primary Index and Primary Key Difference
06:12
Important Message..!!
00:44
RAID Technology
06:01
+ Teradata SQL Startup Lectures
5 lectures 31:53
CREATE,INSERT,DELETE AND DROP COMMANDS
09:31
ALTER and UPDATE Command
09:10
Select Statement and Where clause
02:30
Order by Clause
05:20
EXTRACT Command
05:22
+ String Manipulation in Teradata
5 lectures 17:18
Concatenate Function
03:40
Substring Function
04:56
Index Function
02:25
Trim Function
05:21
Upper and Lower Function
00:56
+ Basic Operators in Teradata SQL
8 lectures 37:24
Arithmetic Operators
02:57
AND Operator
04:24
OR Operator
03:15
Between Operator
06:29
IN Operator
03:15
Like Operator
06:23
IS NULL Operator
01:07
Practice Questions
09:34
+ Aggregate Functions
3 lectures 24:38
Overview of Aggregate Functions
06:41
Having and Where Clause
09:43
Aggregate Functions Practice
08:14
All Questions Will be on aggregate Functions.
Aggregate Functions Practice Questions
6 questions
Quiz on Aggregate Functions
5 questions
+ Subqueries
4 lectures 27:17
Subquery with SELECT statement
12:55
Subquery with INSERT, UPDATE, and DELETE
07:31
Correlated Subquery
04:40
Correlated Subquery and Non Correlated Subquery
02:11
+ Teradata SQL: Joins
3 lectures 33:59
Inner Join,Outer Join and Cartesian Product Overview
10:24
Self Join
03:28
Join Practice Questions
20:07
Assignment
Assignment on Joins
4 questions
+ Analytical Functions
5 lectures 47:48
Row Number
11:44
Rank and Dense Rank Part 1
07:52
Rank and Dense Rank Part 2
06:10
Where,Having and Qualify Explanation and Difference
06:29
Cummulative Sum,Moving Average and Moving Count Examples
15:33
+ Teradata Advanced SQL Concepts
5 lectures 35:32
Case Statement in SQL
09:24
Coalesce Function
02:49
Partitioning in Teradata
08:13
Views in Teradata SQL
05:11
Macros in Teradata SQL
09:55
Requirements
  • No Experience of SQL and database are required
  • No High Level programming knowledge/Background is required.
  • All you need a Computer machine; windows, Mac, and Linux users are all welcome
Description

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..!!!

Who this course is for:
  • Students/Professionals curious about learning Teradata SQL
  • Professionals who wants to learn Teradata SQL for further enhancement of their knowledge and skill sets.
  • University Students/Fresh Graduates looking for a career in the field of Database,DWH,BI or Data Science