|
所在平台: Udemy |
课程主页: https://www.udemy.com/course/microsoft-sql-server-management-studio-ssms-for-beginners/
课程评论：没有评论
**课程名称：** Microsoft SQL Server Management Studio (SSMS) 入门 **课程概述：** 本课程旨在为初学者介绍 Microsoft SQL Server Management Studio (SSMS)，这是一个用于管理任何 SQL 基础架构的集成环境。通过 SSMS，您可以访问、配置、管理、管理和开发 SQL Server、Azure SQL Database 以及 Azure Synapse Analytics 的所有组件。 SSMS 集成了一系列图形化工具和丰富的脚本编辑器，为不同技能水平的开发人员和数据库管理员提供访问 SQL Server 的统一且全面的工具。 **主要内容亮点：** * **管理 Analysis Services 对象：** SSMS 允许您管理 Analysis Services 对象，执行备份和处理对象等操作。 * **Analysis Services 脚本项目：** 您可以使用 SSMS 中的 Analysis Services 脚本项目，开发和保存使用 Multidimensional Expressions (MDX)、Data Mining Extensions (DMX) 和 XML for Analysis (XMLA) 编写的脚本。这些脚本可用于执行管理任务或重新创建 Analysis Services 实例上的数据库和多维数据集等对象。 * **Integration Services（SSIS）管理：** SSMS 还使您能够使用 Integration Services 服务来管理和监控正在运行的 SSIS 包。您可以将包组织到文件夹中、运行包、导入和导出包、迁移 Data Transformation Services (DTS) 包，以及升级 Integration Services 包。 **目标受众：** 本课程适合所有希望学习如何使用 SSMS 进行 SQL Server 管理和开发的初学者。
SQL Server Management Studio (SSMS) is an integrated environment for managing any SQL infrastructure. Use SSMS to access, configure, manage, administer, and develop all components of SQL Server, Azure SQL Database, and Azure Synapse Analytics. SSMS provides a single comprehensive utility that combines a broad group of graphical tools with a number of rich script editors to provide access to SQL Server for developers and database administrators of all skill levels.SQL Server Management Studio enables you to manage Analysis Services objects, such as performing back-ups and processing objects.Management Studio provides an Analysis Services Script project in which you develop and save scripts written in Multidimensional Expressions (MDX), Data Mining Extensions (DMX), and XML for Analysis (XMLA). You use Analysis Services Scripts projects to perform management tasks or re-create objects, such as database and cubes, on Analysis Services instances. For example, you can develop an XMLA script in an Analysis Services Script project that creates new objects directly on an existing Analysis Services instance. The Analysis Services Scripts projects can be saved as part of a solution and integrated with source code control.SQL Server Management Studio enables you to use the Integration Services service to manage packages and monitor running packages. You can also use Management Studio to organize packages into folders, run packages, import and export packages, migrate Data Transformation Services (DTS) packages, and upgrade Integration Services packages.
