Teradata SQL for Data Science and Data Analytics

A complete course on learning SQL using Teradata Database
Teradata SQL for Data Science and Data Analytics
File Size :
3.18 GB
Total length :
6h 28m



Mahyar Peysepar


Last update




Teradata SQL for Data Science and Data Analytics

What you’ll learn

Learn most commonly used SQL statements for data analytics
Learn main SQL concepts (JOINs, Aggregation, Set Operations, DDL, etc.)
Learn Teradata Studio and overview of Teradata’s main applications
Build a Real Life Database with Chess Data
Become proficient with SQL Data Types (VARCHAR, DATE, TIMESTAMP, INT, etc.)
Build different Database Objects like Volatile and Permanent Tables

Teradata SQL for Data Science and Data Analytics


An average computer (Windows or Mac) with 8GB RAM or above.


Learn SQL using a Teradata! Teradata SQL has many additional extensions that make it feel a few years ahead of the industry. Combined with its speed, performance, and integration capabilities, Teradata is the number one rated Data Warehousing product in 2020 by Gartner. Most of the biggest companies in the world use Teradata, including all 17 top communication companies.In this course you learn SQL using Teradata, which is an ANSI-compliant vendor of SQL is a future-focused way of learning SQL. The Teradata SQL skill set is easily transferable to other SQL platforms such as Amazon Redshift, MySQL, Microsoft SQL Server, and others.This course can help you if you relate with any of these descriptions:1. Are you totally new to SQL?Learning Teradata SQL is a great way to learn SQL, especially to distinguish you from the big pack of SQL developers. In my experience in interviewing many SQL candidates and in working with many interviewers, a candidate who knows Teradata SQL shines like a diamond!A candidate who knows Teradata SQL, most likely has worked with huge datasets which is already a big plus! It indicates that the candidate has gone beyond the bare minimum SQL. So join this course to upgrade your resume, and stand above the crowd!2. Do you have a background in other SQL platforms (MySQL, SQL Server, Oracle, etc.) and you need to learn Teradata SQL?This is how I started to learn Teradata myself. Teradata is one of the best relational databases and data warehouses on the planet, but the lack of reliable instructions and tutorials on the internet may drive you crazy!This course is the most complete course on Teradata SQL on the internet! It gives you an overview of the main products of Teradata in data warehousing. Then it focuses on the Teradata Database, the core of the data warehouse. That’s where the core of our course also begins by installing our relational database, and starting to talk to it by its language, Teradata SQL.3. If your role is- A Business User or Analyst in finance, marketing, healthcare (you name it) and you don’t feel confident using the data you get yourself.- A Data Scientist and your pet peeve is data cleansing! Before everything is ready for your cutting-edge ML knockout blow, you need that solid communication with your data warehouse.- A Data or BI Analyst, and your fluency in SQL is key in providing reliable meaningful results.- A SQL Developer, Data Engineer, or Data Architect and you need to interact with your databases more easily so that you can focus on other core parts of your role in development and design.I have created this course with your role in mind! I have put my experience with relational databases in these roles for over 10 years, so that you can get good at what constitutes over 80% of the practical SQL needed in the roles above.Teradata is the number one solution in Data Warehousing, and Data Warehousing is what enabled this booming era of data; be it in Data Science, Business Intelligence, or even in the growth and practicality of the internet.In this journey, we will:o Overview the main data warehousing products of Teradatao Install a fully functional database and Teradata Studio to write SQL witho Have a crash course on Teradata Studio to use it easily and benefit from its advance featureso Learn SQL statement categories of DCL, DDL, and DMLo Create different types of tables and database objectso Learn data types, logical expressions, joins, aggregation, SET operators, string functions, and many more topicso Learn by creating a chess database with data about players, chess tournaments and games, and more.Feel free to check out the free preview videos.If you are ready for this journey together, I will see you inside in the course!


Section 1: Why Teradata SQL

Lecture 1 Why to learn Teradata SQL

Section 2: Teradata Products

Lecture 2 Section Intro

Lecture 3 Teradata Corporation

Lecture 4 Teradata Vantage

Lecture 5 Query Submitting Tools

Lecture 6 Load and Unload Utilities

Lecture 7 Viewpoint and other Administrative Tools

Section 3: Installation and Getting Started

Lecture 8 The Teradata Database Setup

Lecture 9 Installing Teradata on Windows

Lecture 10 Installing Teradata on Mac

Lecture 11 A Note for Installation Issues

Section 4: Teradata Studio Crash Course

Lecture 12 Section Intro

Lecture 13 Intro for Mac Users

Lecture 14 Initial Setup of Teradata Studio and Connection Types

Lecture 15 Overview of Teradata Studio Modules

Lecture 16 Customizing the Interface and Result Set Viewer

Lecture 17 History View

Lecture 18 Data Source Explorer

Lecture 19 Files and Project Explorer

Lecture 20 Additional Features of Teradata Studio

Section 5: Introduction to SQL and RDBMS

Lecture 21 Relational Model

Lecture 22 Role of Intelligence

Lecture 23 Types of SQL Statements

Lecture 24 OLTP and OLAP

Lecture 25 Facts and Dimensions, Star and Snowflake

Lecture 26 Structured and Unstructured Data

Section 6: DDL Statements in SQL

Lecture 27 Section Intro

Lecture 28 Database Objects

Lecture 29 Challenge – Database Objects

Lecture 30 Answer – Database Objects

Lecture 31 CREATE TABLE – Using Existing Tables

Lecture 32 CREATE TABLE -Table and Column Attributes

Lecture 33 Data Types

Lecture 34 Column Attributes and Indices

Lecture 35 Temporary Tables – Derived, Volatile, and Global Temporary Tables

Lecture 36 Challenge, CREATE TABLE

Lecture 37 Answer – CREATE TABLE

Section 7: DML & DQL Statements in SQL

Lecture 38 Section Intro

Lecture 39 INSERT UPDATE & DELETE Statements

Lecture 40 INSERT Statements – Assignment

Lecture 41 INSERT Statements – Answer

Lecture 42 SELECT Statements

Lecture 43 Logical Expressions and Filters

Lecture 44 Pattern Matching with Escape Characters

Lecture 45 SAMPLE and TOP


Lecture 47 Aggregation

Lecture 48 Ordered Analytical Functions

Lecture 49 SET Operators

Lecture 50 String Functions

Lecture 51 Conditional Processing

Lecture 52 Data Type Conversions

Lecture 53 DATE Functions

Lecture 54 TIME Functions

Lecture 55 TIMESTAMP Functions

Section 8: Macros

Lecture 56 Macros Part 1

Lecture 57 Macros Part 2

Section 9: Final Project

Lecture 58 Final Project Assignment

Lecture 59 Final Project Solution

Section 10: Conclusion

Lecture 60 Conclusion

Anyone interested in learning SQL,SQL Developers,Data Scientists,Data Analysts,IT Professionals,Business Analysts

Course Information:

Udemy | English | 6h 28m | 3.18 GB
Created by: Mahyar Peysepar

You Can See More Courses in the IT & Software >> Greetings from CourseDown.com

New Courses

Scroll to Top