|
所在平台: Udemy |
课程主页: https://www.udemy.com/course/implementing-a-data-warehouse-with-sql-server-2012/
课程评论：没有评论
课程名称：使用 SQL Server 2012 实施数据仓库 课程概述：本课程介绍了微软最新的数据管理系统——SQL Server 2012，帮助学习者理解如何构建和使用数据库。作为 Microsoft SQL Server 2012 的进阶课程，它为学生提供了一个平台，以构建和实施数据仓库。该课程面向所有数据专业人士，包括数据分析师以及希望为 70-463 考试做好准备的其他专业人士。课程结束时，参与者将深入了解数据仓库及维度的使用，还将掌握事实表的重要性以及实施 SQL Server 2012 数据仓库所涉及的各种概念。 本课程还探讨了控制流的不同元素，使学习者能够理解如何使用变量。学习内容包括 SSIS 中不同类型的转换、如何部署和管理包、调试和保护包等。课程旨在帮助学生掌握 SQL Server 2012 数据库管理的基础知识，了解与 SQL Server 安装和配置相关的各种问题及决策。 SQL Server 2012 是企业和云中广泛使用的平台，许多关键系统以其为基础。考试 70-463 也是掌握该平台认证系列的一部分。学生将在课程中学习涉及数据仓库建设和管理、维度架构与实施的各类操作，包括与变量的各种交互。此外，课程还将讨论实例、数据库和对象的安全策略，实施和自动化 ETL 解决方案，以及高可用性技术。 培训共分为 90 讲，涵盖所有学习目标。作为附加内容，课程还提供了其他主要概念的演示，帮助参与者理解所学步骤在实际中的应用。
Adding to its data management system Microsoft has come up with a new Server, Microsoft SQL Server 2012 which familiarizes us with the construction and usage of databases in SQL Server platform. This course is the successor of Microsoft SQL Server 2012, a step higher into the administration of the data sytem. It is an excellent platform for students to build and implement a data warehouse. The course intends to target all data professionals including data analysts and other aspiring professionals who wants to get ready for exam 70-463, also known as Implementing a Data Warehouse with SQL Server 2012. Towards the end of this course our participants will have a thorough knowledge on data warehouses and the uses of dimensions. Apart from that our learner will also understand the importance of Fact Table along with the various concepts that are involved in the implementation of Data Warehouse with SQL Server 2012. This course also looks into the different elements of Control Flow and allows the learner to comprehend how to work with variables. In this course you will learn about the different types of Transforms available in SSIS, apart from how to deploy and manage packages. Finally you will understand how to debug and secure packages.This course is that is the basis for all other SQL Server-related disciplines-Database Development, Database Administration, and Business Intelligence. The main idea of this course is to make our students cognize SQL Server 2012 databases administration. You will be comprehending a lot about the various issues and other decisions that are part of SQL Server installation and configuration. SQL Server 2012 is a prevailing platform that is widely used in the enterprise and cloud. There are many critical systems based on it. This Exam 70-463 is also a part of the series of certifications to master this platform.Apart from this as a student you will keen to look into the various operations involved including building and managing data warehouse and architecturing and implementing dimensions.You will also find it both challenging and interesting to work with various variables. There will also be a discussion on some of the important topics namely, instance, database and object security strategies. You will be also interested in implementing and automating ETL Solution. Some of the high availability technologies will also be discussed as part of the training by looking into deploying and managing packages along with debugging and securing themOur training is broken down to 90 lecture sessions that will cover all objectives. As add ons, we are also providing demos on other major concepts so that participants understand how the steps learned are implemented in real time.
