Teradata Fundamentals - Comprehensive SQL course on Teradata (Udemy.com)

A comprehensive course on Teradata Fundamentals and SQL

( 63 Reviews )

Created by: Saad Qureshi

Produced in 2021

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

Quality Score

Content Quality

Video Quality

Qualified Instructor

Course Pace

Course Depth & Coverage

Overall Score : 82 / 100

Course 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 SQLProfessionals 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

Time: 6.5h

Instructor Details

Saad Qureshi

4.1 Rating
63 Reviews

Background:
Computer Scientist with several years of industry experience. Other than this,I am passionate about teaching and guiding students learning programming languages.
Life Philosophy
1: He who is not courageous enough to take risks will accomplish nothing in life.
2: Do not dwell in the past,do not dream of the future,concentrate the mind on the present moment.
3: Service to others is the rent you pay for your room here on earth..

SQL Server - zapytania. Querying. Exam 70-761

SQL Server - zapytania. Querying. Exam 70-761 (2021)
4.8 (99 Reviews)

- Provider: Udemy
- Time: 5h

$11.99

Oracle Database 12c SQL Certified Associate 1Z0-071

Oracle Database 12c SQL Certified Associate 1Z0-071 (2021)
4.7 (336 Reviews)

- Provider: Udemy
- Time: 20h

$11.99

Introduction to Structured Query Language (SQL)

Introduction to Structured Query Language (SQL) (2017)
4.7 (313 Reviews)

- Provider: Coursera
- Time: 3h

Free

Learn C# With Windows Forms and SQL Server

Learn C# With Windows Forms and SQL Server (2021)
4.7 (269 Reviews)

- Provider: Udemy
- Time: 12.5h

$11.99

Microsoft Access SQL: SQL for Non-Programmers

Microsoft Access SQL: SQL for Non-Programmers (2021)
4.7 (240 Reviews)

- Provider: Udemy
- Time: 3.5h

$11.99

The Ultimate Oracle SQL Course (2021)
4.7 (237 Reviews)

- Provider: Udemy
- Time: 11.5h

$11.99

All sql courses

Reviews

4.1

63 total reviews

5 star 4 star 3 star 2 star 1 star

Write a Review

By Akram Hussain on 11/4/2020

It could have been better, if creating Database, users, profiles and Grant permissions are provided using commands instead of GUI.

By Rama Rayulu Papineni on 11/4/2020

Good Course. If you know the basics and wants to refresh the subject then it is fantastic course.

By Naveen Kumar Tavva on 10/16/2020

Excellent Explanation with practical scenarios with in the short time.

By Rebekah Worsfold on 10/14/2020

The installation took much longer than it should due to out-of-date installation instructions, which led to uncertainty about which versions and features of the software to install.

By Maiya Perceny on 9/25/2020

I really enjoyed this course, I was able to take fantastic notes to reference later and as a visual learner it really helped to see each function and clause in action.

By Mayank Agarwal on 9/11/2020

Very basics and needs to be a bit in detail about Utilities.

By R.M Keshav on 8/27/2020

This course is really helpful. Giving short examples which are simplae and easy to understand.

By Jonas Malave Campos on 8/18/2020

Installation steps are not clear.

By Sara Check on 8/17/2020

Instructor explains the subject very well to be sure that we understand it.
I was very happy with this course.

By Sandeep kumar on 8/15/2020

It is good . We will see in details ,once we will go ahead.

By Rahul Dorai on 8/11/2020

Yes, this course is right fit to the beginner and Intermediate level. The training was very comprehensive and detailed, the trainer is very calm and each every topic has been explained in clear way

By Shivani Sushilkumar Dhopekar on 8/10/2020