|
所在平台: Udemy |
课程主页: https://www.udemy.com/course/introduction-to-sql-server-reporting-services-ssrs-i/
课程评论：没有评论
课程名称：SQL Server 报告服务入门 - SSRS 课程概述：本课程介绍了微软的 SQL Server 报告服务 2014（SSRS）工具，适用于 SQL Server 2016 及 SQL Server 2008 R2 版本及后续版本。此课程面向希望开发报告但没有 SQL Server 报告服务经验的学员。我将逐步指导您如何有效地使用开发工具来创建、增强和呈现报告。课程首先将设定环境，其中包括安装 Microsoft SQL Server、SQL Server 数据工具、Microsoft Visual Studio 和 AdventureWorks 2014 示例数据库的下载与安装。接下来，我们将探讨 SQL Server 报告服务配置工具，用于配置 SSRS。无论您是报告服务的新手，还是对早期版本有经验的用户，我们都会教您如何设计和构建报告，并利用 SSRS 从数据中提取商业智能。我们将从数据源中创建数据集，并使用 T-SQL 创建别名、聚合函数、表连接、以及使用 HAVING 子句对数据进行分组。课程内容包括：SQL Server 报告服务的配置、授予用户对报告服务服务器的访问权限、创建报告服务器、定义数据源、定义数据集、定制报告参数、格式化报告、在报告中分组数据、向报告添加总计以及通过报告服务器发布和部署报告。课程结束时，您将开发出完整的报告解决方案，并准备好使用 SQL Server 报告服务分析和可视化自己的商业数据。
This course introduces Microsoft's SQL Server Reporting Services 2014 (SSRS) utility but is also applicable to Microsoft SQLserver Reporting Services 2016 as well as SQL Server 2008 R2 release and later versions. This course is for anyone who wants to develop reports and has no prior experience with SQL Server Reporting Services. I will walk you through how to use the development tools effectively to create, enhance and present reports. The course starts off by setting up the environment which includes the installation of Microsoft SQL Server,SQL server Data Tools, Microsoft Visual Studio and also the download and installation of AdventureWorks 2014 sample database. We Will then explore the SQL Server Reporting Services Configuration which is configuration tool used to configure SSRS.Whether you're new to reporting services, or experienced with earlier versions, we'll show you how to design and build reports and Leverage SSRS to extract business intelligence from your data. We will create dataset from our data source and use T-SQL to create aliases ,aggregate functions,table-joins,grouping data with the having clause. Topics include:Configuration of SQL Server Reporting ServicesGranting user access to the Reporting Services ServerCreating a Report ServerDefining a data sourceDefining a DatasetCustomizing report parametersFormatting ReportsGrouping Data in ReportsAdding Totals to ReportsPublishing and Deploying Reports through Report Server By the end of the course, you'll have developed a complete reporting solution and be ready to analyse and visualize your own business data with SQL Server Reporting Services.
