Learn about Data warehouse and big 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
Describe data warehouse .
Design a data warehouse
Implement Data warehouse
7 Lectures
7 Lectures
5 Lectures
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...
A good high level overview of Data Housing and Big Data. (beginning of a conceptual foundation)
MSDN Labs are different now. Information is a bit obsolete. Course name is very misleading. If you are looking for ETL/SSIS sample of loading DW you came to the wrong place. Not clear what Big Data has to do with DW, not really related things. Very light scratch and just definitions of some things.
I cannot access the MSDN Virtual Lab even though I have a Microsoft Account and I have followed the steps discussed in the sessions.
Nuevos conocimientos y mejores practicas para el area laboral.
good
Instructor talks so slowly at 2x speed appears normal paced.
Whole sections of video repeated -- especially around logging into tools. Seems like the total time could be cut to about a fifth if it were limited to content at a normal pace.
This highlights how little content there is.
In my opinion, the course provides very basic information from DWH area. I think it is useful only for beginners who want to know what DWH is and from which parts it consists. It is pity that they don't focus on practical side of DWH and some parts of DWH aren't described more deeply, for example SSIS and SSDT package.
Excellent course and it has been updated well.
So far, the course is informative and easy to understand.
Your email address will not be published. Required fields are marked *
Iftekhar A.
I liked the course because it was a very beginner course(good for people starting in data warehouse for the first time). But it lacks real-world examples and hands-on labs. Those would have helped a lot more.