Teradata Fundamentals - Comprehensive SQL course on Teradata
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
- Preview02:40
- 13:47Installation and Configuration Teradata Tools(Updated Version)
- 08:48Teradata Architecture
- 12:15Primary Index in Teradata
- 14:19Secondary Index in Teradata
- Preview05:13
- 10:22NOPI in Teradata
- 09:47Types of Spaces in Teradata
- Preview03:43
- 06:12Primary Index and Primary Key Difference
- 00:44Important Message..!!
- 06:01RAID Technology
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](data:image/svg+xml,%3Csvg xmlns="http://www.w3.org/2000/svg" viewBox="0 0 64 64"%3E%3C/svg%3E){kind=avatar}
Instructor
- 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..