|
所在平台: Udemy |
课程主页: https://www.udemy.com/course/sql-server-ssis-an-introduction/
课程评论：没有评论
课程名称：SQL Server Integration Services (SSIS) - 入门介绍 课程概述：本课程旨在介绍SQL Server Integration Services（SSIS），帮助学员掌握数据处理的基本概念和操作。根据学员反馈，课程的讲解清晰易懂，例子具体，内容推进适中，既能够保持参与感，又不会忽略重要知识点。通过参与这门课程，学员可以学习如何下载和安装最新的2022 SQL Server Developer版本，并体验SSIS在数据导入和导出（ETL：提取、转化和加载）过程中的应用。 课程内容包括：数据提取、数据加载以及各类转换操作（如聚合、条件分割、合并和审计等），这些内容都是通过可视化的方式进行学习，采用任务、组件和流程图，简单易懂。在课程中，学员还会有丰富的实践活动，以巩固所学技能。 通过参与本课程，学员将在使用主要数据流组件和控制流任务方面建立信心，并能够在自己的工作中应用SSIS技术。尽管课程不与微软直接关联，但仍为学员提供了一个宝贵的学习机会，使他们在数据集成方面具备实用技能。
Reviews:"Instructor is easy to follow. He gives very clear examples. Course moves quickly enough to be engaging without skipping over material." - Sarah Hale"This course works for me because it progresses with a level of detail that will be useful as I think through each step necessary to execute my own integration packages. There are several courses to choose from and I'm glad I chose this one." - David McNickle"Very good introductory course. Didn't really know what SSIS was until recently. Working through the course opened my eyes to past projects that would have benefited from an SSIS ETL package or two." - Stephen BentonWelcome to this course about SQL Server Integration Services.In this course you'll be downloading and installing the latest 2022 SQL Server Developer - a full version for free, so that you can use it on your machine. And previous versions of SQL Server Developer have previously retailed for around $100, and now it's free. Please note: This course is not affiliated with, endorsed by, or sponsored by Microsoft.So what is SSIS? It's a way to automate in the importing and exporting and data - or ETL: extract, transform and load. It's a very visual part of SSIS, using tasks, components and flowcharts, so it's easy to learn the basics of it. We'll start by extracting some data, and then loading it into another table. I'll take nice as slow as we start to introduce transformations, such as aggregation, conditional split, merging and auditing. There'll be plenty of practice activities too, so you can get to practice your new-found skills. By the end of this course, you'll be confident in using the main Data Flow components and Control Flow tasks, and would be able to use it in your own work.
