Introduction to Data Warehouse and Teradata Basics

Name: Introduction to Data Warehouse and Teradata Basics
Rating: 4.0 (74 reviews)

Excellent overview on core components Data Warehousing system & where does Teradata Database fits in this Architecture.

Created byRajesh Venkat

Last updated 9/2014

English

English [Auto],

What you'll learn

What is Data Warehouse and Data Warehousing
Why do we need Data warehouse
Advantages of Data warehouse
Where is Data warehouse used
Core components of Data warehouse Architecture
What is Teradata Database.
Where do Teradata stand in Data Warehouse Architecture
Who use Teradata
Roles & Responsibilities of an Teradata Developer
Classifying Teradata Database Administrators as an Application DBA & System DBA
Roles & Responsibilities of an Teradata Application DBA & System DBA

Course content

1 section • 8 lectures • 30m total length

Course Summary0:45
Intended Audiences0:17
Prerequisites0:04
Goals & Objectives0:27
Introduction to Data Warehouse14:05
Discover how a data warehouse serves as a central repository that integrates disparate data sources using an ETM tool, staging areas, target areas, and datamarts for analysis and reporting.
Introduction to Teradata Database5:07
Explore how Teradata database integrates with data warehouse architecture, detailing staging, target, and datamart within a single partitioned Teradata database.
Roles and Responsibilities of Teradata Developer5:27
Master the roles and responsibilities of a Teradata developer within the IT hierarchy, from business requirements and meetings to staging, transforming, and loading data into target structures.
Roles and Responsibilities of Teradata Database Administrator (DBA)4:38
Explore Teradata database administrator roles, detailing application dba tasks like creating databases, users, roles, and access, plus system dba duties on software installation and system monitoring.

Requirements

Zeal to learn one of the biggest and advanced Technology in Information Technology Industry

Description

This tutorial is intended to give an overview on, What is Data warehouse, Why we need Data Warehouse, Components of Data Warehouse, Difference between Operational Database & Data Warehouse DataBase, Difference between Data Warehouse DataBase & DataMarts.

Next it focus on Teradata Database, Where does Teradata come in Data Warehouse Architecture, Who use Teradata.

Later in the tutorial we will cover details on Teradata Developer roles and responsibilities.

And Classification of Teradata Database Administration along with Roles and Responsibilities of Application DBA & System DBA.

Important Note:

Full, free lifetime access
All future extra lectures and upgrades to this course is always for free.
Course is charged with very very minimal amount, And its charged to meet the expenses of this course production.
After course completion if you think that my course content is not worth of what I have charged then you can always ask for full refund within 30 days.

Who this course is for:

Any enthusiastic persons who wants to know basics of DatawareHouse