|
所在平台: Udemy |
课程主页: https://www.udemy.com/course/create-reports-with-ssrs-ssdt-visual-studio-sql-server/
课程评论：没有评论
课程名称：使用SSRS、SSDT、Visual Studio和SQL Server创建报告 课程概述： 本课程主要介绍SQL Server Reporting Services（SSRS），这是一款能够生成格式化报告的工具。通过SSRS，用户可以创建包含数据表、图形、图片和图表的报告，这些报告可以托管在服务器上，根据用户定义的参数随时执行。课程中将使用Visual Studio和SQL Server数据工具（SSDT）中的报表设计器工具来创建可分页的SSRS报告。 SSDT是一个革命性的工具，改变了数据库开发，它引入了一种普遍适用、声明性模型，涵盖了数据库开发的所有阶段。学员将学习如何利用SSDT的Transact-SQL设计能力来构建、调试、维护和重构数据库。课程内容涵盖在本地或云端直接与数据库实例工作，以及使用熟悉的Visual Studio工具进行数据库开发的方式，包括代码导航、IntelliSense、语言支持及平台特定的验证、调试和声明性编辑。 此外，学员将了解SSDT提供的可视化表设计器，用于在数据库项目或连接的数据库实例中创建和编辑表。在团队环境中，学员还可以使用版本控制来管理文件，发布项目到所有受支持的SQL平台，包括SQL数据库和SQL Server。同时，SSDT的平台验证能力确保脚本在指定目标上能够正常运行。 在Visual Studio中，SQL Server对象资源管理器提供类似SQL Server管理工作室的数据库对象视图，使学员能够轻松进行基础的数据库管理和设计工作，包括创建、编辑、重命名和删除表、存储过程、类型和函数。学员还能通过上下文菜单轻松编辑表数据、比较架构或执行查询。 此课程适合希望掌握SSRS报告生成与数据库开发的学员。
SQL Server Reporting Services (SSRS) is a reporting software that allows you to produce formatted reports with tables in the form of data, graph, images, and charts. These reports are hosted on a server that can be executed any time using parameters defined by the users. It is part of Microsoft SQL Server Services suite.use the Report Designer tool in Visual Studio / SQL Server Data Tools (SSDT) to create a SQL Server Reporting Services (SSRS) paginated report. SQL Server Data Tools (SSDT) transforms database development by introducing a ubiquitous, declarative model that spans all the phases of database development inside Visual Studio. You can use SSDT Transact-SQL design capabilities to build, debug, maintain, and refactor databases. You can work with a database project, or directly with a connected database instance on or off-premise.Developers can use familiar Visual Studio tools for database development. Tools such as: code navigation, IntelliSense, language support that parallels what is available for C# and Visual Basic, platform-specific validation, debugging, and declarative editing in the Transact-SQL editor. SSDT also provides a visual Table Designer for creating and editing tables in either database projects or connected database instances. While you are working on your database projects in a team-based environment, you can use version control for all the files. When it's time to publish your project, you can publish to all supported SQL platforms; including SQL Database and SQL Server. SSDT platform validation capability ensures that your scripts work on the target you specify.The SQL Server Object Explorer in Visual Studio offers a view of your database objects similar to SQL Server Management Studio. SQL Server Object Explorer allows you to do light-duty database administration and design work. You can easily create, edit, rename and delete tables, stored procedures, types, and functions. You can also edit table data, compare schemas, or execute queries by using contextual menus right from the SQL Server Object Explorer.
