Online Courses > Development > Databases > Teradata SQL A-Z: Hands-On SQL Training for Beginners
4.25 out of 5
4.25
26 reviews on Udemy

Teradata SQL A-Z: Hands-On SQL Training for Beginners

Learn Teradata SQL and build a career in the field of Data Warehousing, Business Intelligence or Data Analysis
Instructor:
Saad Qureshi
105 students enrolled
English [Auto-generated]
Learn the Teradata SQL from Scratch.
Practical Implementation of Teradata SQL Concepts.
Use Teradata SQL to query a database.
Industry Specific Knowledge of SQL

Before taking this course,I would say rate yourselves in SQL out of 10.If you lie in between 1 and 5,would definitely recommend  this course,but not recommend for those whose skill set >= 7.Nevertheless,if you still want to refresh all the concepts,you are most welcome..!!!

The course content is designed in such a way that a newbie or a less experienced person may find this course very fresh and helpful but the experts may find the content very basic.

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

Course Introduction

1
Database Overview
2
Important Message..!!
3
Teradata Introduction and Architecture
4
Primary Index in Teradata
5
Primary Index and Primary Key Difference
6
Installation and Configuration Teradata Tools

Teradata SQL Startup Lectures

1
Create Database and Tables in Teradata SQL Assistant Tool

Create Database and Tables

2
Select Statement and Where clause
3
Order by Clause
4
Multiset and Set Tables
5
Types of Spaces in Teradata
6
Teradata SQL:Union and Union All
7
CREATE,INSERT,DELETE AND DROP COMMANDS
8
ALTER and UPDATE Command
9
EXTRACT Command

String Manipulation in Teradata

1
Concatenate Function
2
Substring Function
3
Index Function
4
Trim Function
5
Upper and Lower Function

Basic Operators in Teradata SQL

1
Arithmetic Operators
2
AND Operator
3
OR Operator
4
Between Operator
5
IN Operator
6
Like Operator
7
IS NULL Operator
8
Practice Questions

Aggregate Functions

1
Overview of Aggregate Functions
2
Aggregate Functions Practice
3
Having and Where Clause
4
Aggregate Functions Practice Questions
5
Quiz on Aggregate Functions

Subqueries

1
Subquery with SELECT statement
2
Subquery with INSERT, UPDATE, and DELETE
3
Correlated Subqueries
4
Correlated Subquery and Non Correlated Subquery

Teradata SQL: Joins

1
Inner Join,Outer Join and Cartesian Product Overview
2
Self Join
3
Join Practice Questions
4
Assignment on Joins

Analytical Functions

1
Row Number
2
Rank and Dense Rank Part 1
3
Rank and Dense Rank Part 2
4
Where,Having and Qualify Explanation and Difference
5
Cummulative Sum,Moving Average and Moving Count Examples

Teradata Some Advanced Concepts

1
Case Statement in SQL
2
Coalesce Function
3
Partitioning in Teradata
4
Views in Teradata SQL
5
Macros in Teradata SQL

Teradata Utilities

1
FastLoad Utility in Teradata
2
MultiLoad Utility in Teradata
3
BTEQ Utility in Teradata
4
FASTEXPORT Utility in Teradata

SQL Exam

1
Teradata SQL Exam

Basic Teradata SQL multiple-choice questions  

2
SQL Query Practice Test
You can view and review the lecture materials indefinitely, like an on-demand channel.
Definitely! If you have an internet connection, courses on Udemy are available on any device at any time. If you don't have an internet connection, some instructors also let their students download course lectures. That's up to the instructor though, so make sure you get on their good side!
4.3
4.3 out of 5
26 Ratings

Detailed Rating

Stars 5
9
Stars 4
9
Stars 3
5
Stars 2
2
Stars 1
1
3e55d57e8bb2b4412c374dd408d9a83f
Get on Udemy
30-Day Money-Back Guarantee

Includes

6 hours on-demand video
Full lifetime access
Access on mobile and TV
Certificate of Completion