Udemy
  •  
  •  
  •  
  •  
  •  
  •  
  •  
  •  
  •  
  •  
  •  
  •  
  •  
Development
Web Development Data Science Mobile Development Programming Languages Game Development Database Design & Development Software Testing Software Engineering Development Tools No-Code Development
Business
Entrepreneurship Communications Management Sales Business Strategy Operations Project Management Business Law Business Analytics & Intelligence Human Resources Industry E-Commerce Media Real Estate Other Business
Finance & Accounting
Accounting & Bookkeeping Compliance Cryptocurrency & Blockchain Economics Finance Finance Cert & Exam Prep Financial Modeling & Analysis Investing & Trading Money Management Tools Taxes Other Finance & Accounting
IT & Software
IT Certification Network & Security Hardware Operating Systems Other IT & Software
Office Productivity
Microsoft Apple Google SAP Oracle Other Office Productivity
Personal Development
Personal Transformation Personal Productivity Leadership Career Development Parenting & Relationships Happiness Esoteric Practices Religion & Spirituality Personal Brand Building Creativity Influence Self Esteem & Confidence Stress Management Memory & Study Skills Motivation Other Personal Development
Design
Web Design Graphic Design & Illustration Design Tools User Experience Design Game Design Design Thinking 3D & Animation Fashion Design Architectural Design Interior Design Other Design
Marketing
Digital Marketing Search Engine Optimization Social Media Marketing Branding Marketing Fundamentals Marketing Analytics & Automation Public Relations Advertising Video & Mobile Marketing Content Marketing Growth Hacking Affiliate Marketing Product Marketing Other Marketing
Lifestyle
Arts & Crafts Beauty & Makeup Esoteric Practices Food & Beverage Gaming Home Improvement Pet Care & Training Travel Other Lifestyle
Photography & Video
Digital Photography Photography Portrait Photography Photography Tools Commercial Photography Video Design Other Photography & Video
Health & Fitness
Fitness General Health Sports Nutrition Yoga Mental Health Dieting Self Defense Safety & First Aid Dance Meditation Other Health & Fitness
Music
Instruments Music Production Music Fundamentals Vocal Music Techniques Music Software Other Music
Teaching & Academics
Engineering Humanities Math Science Online Education Social Science Language Teacher Training Test Prep Other Teaching & Academics
AWS Certification Microsoft Certification AWS Certified Solutions Architect - Associate AWS Certified Cloud Practitioner CompTIA A+ Cisco CCNA Amazon AWS CompTIA Security+ AWS Certified Developer - Associate
Graphic Design Photoshop Adobe Illustrator Drawing Digital Painting InDesign Character Design Canva Figure Drawing
Life Coach Training Neuro-Linguistic Programming Personal Development Mindfulness Meditation Personal Transformation Life Purpose Emotional Intelligence Neuroscience
Web Development JavaScript React CSS Angular PHP WordPress Node.Js Python
Google Flutter Android Development iOS Development Swift React Native Dart Programming Language Mobile Development Kotlin SwiftUI
Digital Marketing Google Ads (Adwords) Social Media Marketing Google Ads (AdWords) Certification Marketing Strategy Internet Marketing YouTube Marketing Email Marketing Retargeting
SQL Microsoft Power BI Tableau Business Analysis Business Intelligence MySQL Data Analysis Data Modeling Big Data
Business Fundamentals Entrepreneurship Fundamentals Business Strategy Online Business Business Plan Startup Freelancing Blogging Home Business
Unity Game Development Fundamentals Unreal Engine C# 3D Game Development C++ 2D Game Development Unreal Engine Blueprints Blender
30-Day Money-Back Guarantee
Development Database Design & Development Teradata

Teradata Fundamentals - Comprehensive SQL course on Teradata

A comprehensive course on Teradata Fundamentals and SQL
Rating: 4.0 out of 54.0 (420 ratings)
1,756 students
Created by Saad Qureshi
Last updated 1/2021
English
English [Auto]
30-Day Money-Back Guarantee

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

12 sections • 57 lectures • 6h 38m total length

  • Preview02:40
  • 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
  • Preview05:13
  • NOPI in Teradata
    10:22
  • Types of Spaces in Teradata
    09:47
  • Preview03:43
  • Primary Index and Primary Key Difference
    06:12
  • Important Message..!!
    00:44
  • RAID Technology
    06:01

  • Preview02:14
  • Create a User in Teradata
    11:01
  • Create Profile for Users
    05:33

  • 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

  • Concatenate Function
    03:40
  • Substring Function
    04:56
  • Index Function
    02:25
  • Trim Function
    05:21
  • Upper and Lower Function
    00:56

  • 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

  • Overview of Aggregate Functions
    06:41
  • Having and Where Clause
    09:43
  • Aggregate Functions Practice
    08:14
  • Aggregate Functions Practice Questions
    6 questions
  • Quiz on Aggregate Functions
    5 questions

  • 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

  • Inner Join,Outer Join and Cartesian Product Overview
    10:24
  • Self Join
    03:28
  • Join Practice Questions
    20:07
  • Assignment on Joins
    4 questions

  • 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

  • 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

Featured review

Hector Oses
Hector Oses
29 courses
3 reviews
Rating: 5.0 out of 5a year ago
The course is well presented and everything in it is explained in detail. For the money I paid, this is the best of the few courses I know about Teradata, that anyone can pay without hurting one's pocket. Though I would include more explanations about the last concepts. This course is very good!

Instructor

Saad Qureshi
Computer Scientist || Freelancer || Programmer
Saad Qureshi
  • 4.0 Instructor Rating
  • 1,003 Reviews
  • 8,610 Students
  • 8 Courses

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

  • Udemy for Business
  • Teach on Udemy
  • Get the app
  • About us
  • Contact us
  • Careers
  • Blog
  • Help and Support
  • Affiliate
  • Terms
  • Privacy policy
  • Cookie settings
  • Sitemap
  • Featured courses
Udemy
© 2021 Udemy, Inc.