A beginners guide to Data Warehouse and Big Data

A beginners guide to Data Warehouse and Big Data, available at $19.99, has an average rating of 3.45, with 35 lectures, based on 34 reviews, and has 386 subscribers.

You will learn about 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 This course is ideal for individuals who are Data Analyst or Aspiring SQL developers or SQL Developers or Database Developers or Aspiring Data Analyst or Aspiring Data Warehouse Professionals or Anyone interested in data It is particularly useful for Data Analyst or Aspiring SQL developers or SQL Developers or Database Developers or Aspiring Data Analyst or Aspiring Data Warehouse Professionals or Anyone interested in data.

Enroll now: A beginners guide to Data Warehouse and Big Data

Summary

Title: A beginners guide to Data Warehouse and Big Data

Price: $19.99

Average Rating: 3.45

Number of Lectures: 35

Number of Published Lectures: 35

Number of Curriculum Items: 35

Number of Published Curriculum Objects: 35

Original Price: $109.99

Quality Status: approved

Status: Live

What You Will 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

Who Should Attend

Data Analyst
Aspiring SQL developers
SQL Developers
Database Developers
Aspiring Data Analyst
Aspiring Data Warehouse Professionals
Anyone interested in data

Target Audiences

Data Analyst
Aspiring SQL developers
SQL Developers
Database Developers
Aspiring Data Analyst
Aspiring Data Warehouse Professionals
Anyone interested in data

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

Course Curriculum

Chapter 1: Getting Started

Lecture 1: Introduction

Lecture 2: Important -Please Read

Lecture 3: System requirements for MSDN Virtual Labs

Lecture 4: What are MSDN Virtual Labs

Lecture 5: MSDN pros and cons

Lecture 6: Data Warehouse Vs Databases

Lecture 7: How to test sample data

Chapter 2: Setting Your Own Lab – An alternative to using MSDN Labs

Lecture 1: What is SQL Server

Lecture 2: Database Concepts

Lecture 3: Hardware and Software Requirements

Lecture 4: Download SQL Server Express 2014

Lecture 5: Install SQL Server Express 2014

Lecture 6: Download and install AdventureworksDW2014

Lecture 7: Download and Install SQL Server Data Tools -SSDT

Chapter 3: How to design a basic Data Warehouse

Lecture 1: What is a Data Warehouse

Lecture 2: How to design a basic data warehouse

Lecture 3: A logical Data Warehouse Design

Lecture 4: Designing dimension tables

Lecture 5: Physical data warehouse design with views

Chapter 4: How to implement Data Warehouse

Lecture 1: Introduction

Lecture 2: SSIS and SSDT

Lecture 3: ETL

Lecture 4: Creating ETL using SSIS and SSDT

Chapter 5: Big Data

Lecture 1: What is Big Data

Lecture 2: High Volume Data

Lecture 3: High Variety Data

Lecture 4: High Velocity Data

Lecture 5: Google's big data approach

Lecture 6: Cluster

Lecture 7: Node

Lecture 8: Google File System (GFS)

Lecture 9: Google's Big Table

Lecture 10: MapReduce

Lecture 11: Hadoop

Lecture 12: Thank You

Instructors

Tech Academy
Real Skills For The Real World

Rating Distribution

1 stars: 4 votes
2 stars: 4 votes
3 stars: 8 votes
4 stars: 6 votes
5 stars: 12 votes

Frequently Asked Questions

How long do I have access to the course materials?

You can view and review the lecture materials indefinitely, like an on-demand channel.

Can I take my courses with me wherever I go?

Definitely! If you have an internet connection, courses on Udemy are available on any device at any time. If you don’t have an internet connection, some instructors also let their students download course lectures. That’s up to the instructor though, so make sure you get on their good side!

Menu