|
所在平台: Udemy |
课程主页: https://www.udemy.com/course/a-beginners-guide-to-data-warehouse-and-big-data/
课程评论：没有评论
课程名称：初学者的数据仓库与大数据指南 课程概述：本课程是针对初学者的课程，旨在教授如何使用 Microsoft SQL Server、Microsoft SQL Server 集成服务 (SSIS) 和 Microsoft SQL Server 数据工具（SSDT）来实施基础的数据仓库解决方案。课程还将介绍大数据及其相关概念。大数据是一个热门话题，但究竟什么是大数据？这些数据来自哪里，如何处理，以及结果如何使用？大数据的特点主要包括高容量、高多样性和高速度，数据可以是数字、文本、图像、音频、视频或任何其他存储在计算机上的信息。这些特性通常被称为“大数据的三大特征”。 课程中将使用示例，比如社交媒体网络分析用户数据，以更好地了解他们，并将其与相关内容和广告连接；或者搜索引擎分析查询和结果之间的关系，以更好地回答用户问题。 您将学习如何使用 SQL Server 集成服务 (SSIS) 实现 ETL（提取、转换、加载）过程。课程将展示如何设计事实表和维度表，这两种表是数据仓库中使用的主要类型。您将学习用于设计维度表的星型和雪花技术。 学习内容包括： - 理解星型和雪花技术的模式设计 - 实施 ETL 过程 - 使用 SSIS 和 SSDT 开发 ETL 过程 - 使用 SQL 视图进行物理数据仓库设计 - 设计数据仓库 - 实施数据仓库 - 大数据概念 - 高容量数据 - 高多样性数据 - 高速度数据 - 谷歌的大数据方法 - 理解集群 - 节点的概念 - 谷歌文件系统 - MapReduce - Hadoop 本课程将帮助您建立扎实的数据仓库和大数据基础，适合希望进入数据分析和管理领域的初学者。
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
