A beginners guide to Data Warehouse and Big Data
3.8 (15 ratings)
Instead of using a simple lifetime average, Udemy calculates a course's star rating by considering a number of different factors such as the number of ratings, the age of ratings, and the likelihood of fraudulent ratings.
299 students enrolled
Wishlisted Wishlist

Please confirm that you want to add A beginners guide to Data Warehouse and Big Data to your Wishlist.

Add to Wishlist

A beginners guide to Data Warehouse and Big Data

Learn about Data warehouse and big data
3.8 (15 ratings)
Instead of using a simple lifetime average, Udemy calculates a course's star rating by considering a number of different factors such as the number of ratings, the age of ratings, and the likelihood of fraudulent ratings.
299 students enrolled
Created by Tech Academy
Last updated 4/2017
English
Current price: $10 Original price: $125 Discount: 92% off
5 hours left at this price!
30-Day Money-Back Guarantee
Includes:
  • 2 hours on-demand video
  • 1 Article
  • Full lifetime access
  • Access on mobile and TV
  • Certificate of Completion
What Will I Learn?
  • Describe data warehouse .
  • Design a data warehouse
  • Implement Data warehouse
  • Develop ETL process.
  • Implement ETL process using SSIS packages.
  • Define Big Data
  • Define High Variety Data
  • Define High Velocity
  • Understand a Cluster
  • Understand Nodes
  • Define MapReduce
  • Define Apache Hadoop
View Curriculum
Requirements
  • Basic understanding of database concepts
  • Basic understanding of SQL or T-SQL
  • Basic knowledge of using a computer
  • How to use SQL Server Management Studio -SSMS
Description

This course is a beginner’s course that will show you how to implement a basic data warehouse solution using Microsoft SQL Server, Microsoft SQL Server Integration Services SSIS and Microsoft SQL Server Data Tools -SSDT. Also covered in this course is an introduction to Big data and it's concepts.
Big data is a big buzz word and everyone seems to be talking about it, but what exactly is big data ? Where is this data coming from, how is it being processed, and how are the results being used?
Big data can be characterised as data that has high volume, high variety and high velocity. Data includes numbers, text, images, audio, video, or any other kind of information you might store on your computer. Volume, velocity, and variety are sometimes called "the 3 V's of big data."
Examples includes social media network analysing their members' data to learn more about them and connect them with content and advertising relevant to their interests, or search engines looking at the relationship between queries and results to give better answers to users' questions.
You will learn how to implement ETL ( Extract, Transform, Load) process using SQL Server Integration services .
This course will show you how to design fact and dimension tables which are the two main types of table used in data warehouse . You will learn the star and starflake techniques used to design dimension tables.

What You Will Learn :

• Understanding Star and Snowflakes techniques for schema designs
• Implementing ETL process
• Developing ETL process using SSIS and SSDT
• Physical data warehouse design using SQL views
• Designing a data warehouse
• Implementing a data warehouse
• Big data Concepts
• High volume data
• High variety data
• High variety data
• Google's big data approach
• Understanding Clusters
• Concept of a Node
• Google File System
• MapReduce
• Hadoop

Who is the target audience?
  • Data Analyst
  • Aspiring SQL developers
  • SQL Developers
  • Database Developers
  • Aspiring Data Analyst
  • Aspiring Data Warehouse Professionals
  • Anyone interested in data
Students Who Viewed This Course Also Viewed
Curriculum For This Course
34 Lectures
02:09:23
+
Getting Started
7 Lectures 19:08

Important -Please Read
00:09




Data Warehouse Vs Databases
03:15

How to test sample data
04:10
+
Setting Your Own Lab - An alternative to using MSDN Labs
7 Lectures 34:41
What is SQL Server
04:26

Database Concepts
03:50

Hardware and Software Requirements
02:49

Download SQL Server Express 2014
04:07

Install SQL Server Express 2014
06:47

Download and install AdventureworksDW2014
06:39

Download and Install SQL Server Data Tools -SSDT
06:03
+
How to design a basic Data Warehouse
5 Lectures 24:11
What is a Data Warehouse
02:08

How to design a basic data warehouse
00:55

A logical Data Warehouse Design
06:15

Designing dimension tables
06:50

Physical data warehouse design with views
08:03
+
How to implement Data Warehouse
4 Lectures 21:59
Introduction
05:28

SSIS and SSDT
04:29

ETL
02:57

Creating ETL using SSIS and SSDT
09:05
+
Big Data
11 Lectures 29:24
What is Big Data
02:43

High Volume Data
03:03

High Variety Data
03:22

High Velocity Data
03:10

Google's big data approach
00:33

Cluster
00:56

Node
01:29

Google File System (GFS)
01:38

Google's Big Table
03:35

MapReduce
06:14

Hadoop
02:41
About the Instructor
Tech Academy
4.1 Average rating
81 Reviews
3,267 Students
5 Courses
Real Skills For The Real World

Tech Academy is a UK based e-learning provider that offers a range of high quality elearning solutions that teach real life  technical skills that are essential and relevant in today's commercial environment.

Our instructors have a wealth of experience in their respective courses and currently provide consultancy services to fortune 100 companies.

Our courses are presented in HD and are clear and concise to enable retention and provide intuitive learning experience for absolute beginners.