Learn Teradata: A Beginner to Advanced Guide
What you'll learn
- This course will introduce the participants to work with Teradata. The course will cover in detail about Teradata Architecture, Indexing mechanism and how data is stored and retrieved.
- It will cover basic and advanced SQL operations in Teradata. It will also cover various utilities provided by Teradata to process, import and export data.
Course content
- Preview03:10
- Preview01:34
- Preview01:43
- Preview04:12
- 01:00Applications of Teradata
- 01:49Downloading and Installing VMWare Workstation Player
- 02:47Downloading and Installing Teradata
- 02:05Relational Concepts
- 01:58Datatypes
- 01:45Table Types
- 04:37Set Vs Multiset Table
- 06:10Creating and Deleting Tables
- 05:59Insert Records
- 01:48Update Records
- 01:20Delete Records
- 04:43SELECT Statement
- 04:13Logical and Conditional Operators
- 05:21SET Operators
- 05:10String Manipulation
- 09:14Date and Time Functions
- 03:06Aggregate Functions
- 02:20Sample Function
- 02:36TOP Function
- 05:22CASE and COALESCE Statement
- 05:09Primary Index
- 06:14Joins
- 01:51SubQueries
- 07:08Explain Plan
- 03:17NOPI (No Primary Index) Table
- 09:32Secondary Index
- 09:45Join Index
- 04:28Partition Primary Index
- 02:14Join Strategies
- 03:14Space Management
- 05:22Statistics
- 03:47Compression
- 04:01Permanent Journal
- 02:01Recovery Journal
- 04:25Locks in Teradata
- 03:32Views
- 03:40Macros
- 01:11Stored Procedures
- 04:20OLAP Function
- 03:04Data Protection
- 04:16Users Management
- 02:46Performance Tuning
- 03:55Teradata BTEQ
- 09:25FastLoad
- 09:22MultiLoad
- 06:00FastExport
Requirements
- Basic Knowledge in SQL
- General relational database
- basic unix commands
Description
Teradata provides market leading data and analytics platform. Built from scratch using parallelism, Teradata has been a market leader for decades. It is used by world’s largest and competitive organizations to derive insights from their data and make decisions.
In addition to its data warehousing platform, Teradata provides Analytics platform and connectors to integrate seamlessly with Hadoop.
The Teradata database management system can be applied in a number of areas. It can be used for enterprise or active data warehousing and even for customer relationship management in large scale organizations and MNCs that cater to a wide variety of clients at the same time.
Who this course is for:
- Developers/Designers who want to gain acceleration in their careers as an Teradata Developer/Designer
- Analytics Managers who are subject matter experts, leading a team of analysts
- Individual Contributors in the field of Enterprise Business Intelligence.
Instructor
![Techno Crats](data:image/svg+xml,%3Csvg xmlns="http://www.w3.org/2000/svg" viewBox="0 0 64 64"%3E%3C/svg%3E){kind=avatar}
- 3.4 Instructor Rating
- 247 Reviews
- 4,955 Students
- 10 Courses
Our goal is to bring interesting, cost-effective and impressive training courses to the world. We look to empower our learners to excel in their professions. Our objective is to develop courses which have a high demand in the industry.
We understand that learning is a continuous process and a person needs to keep on upgrading his knowledge to remain relevant in today's dynamic industry. Thus, our training makes sure that you are upgraded with the latest, in the technical field. Our teaching methodology acknowledges that there is less of passive listening and more active doing.
Our aim is to provide education which not only increases your knowledge but also makes an impact on your life.