|
所在平台: Udemy |
课程主页: https://www.udemy.com/course/microsoft-sql-analyst-ms-sql-azure-sql-ssms-data-studio/
课程评论：没有评论
课程名称：Microsoft SQL Analyst - MS SQL Azure SQL SSMS Data Studio 概述：本课程旨在提供对微软MSSQL数据库软件的全面理解，MSSQL是一个广泛应用于企业的数据库套件。该套件通常包括一个关系数据库引擎，用于以表格、列和行的形式存储数据；数据集成服务（SSIS），用于数据的导入、导出和转化；报告服务（SSRS），用于创建和发送报告给最终用户；以及分析服务（SSAS），一个用于查询主数据库引擎的多维数据库。 Azure SQL是一个系列受管、可靠且智能的产品，基于Azure云中的SQL Server数据库引擎构建。SQL Server管理工作室（SSMS）是一个集成环境，用于管理任何SQL基础设施。用户可以通过SSMS访问、配置、管理、维护和开发所有SQL Server、Azure SQL数据库和Azure Synapse Analytics的组件。SSMS结合了丰富的图形工具和脚本编辑器，为各类开发人员和数据库管理员提供了全面的访问能力。 Transact-SQL（T-SQL）是微软和Sybase专有的SQL（结构化查询语言）扩展，用于与关系数据库交互。T-SQL扩展了SQL标准，包括过程编程、本地变量，以及多种字符串处理、日期处理和数学计算等支持功能，并对DELETE和UPDATE语句进行了更改。T-SQL是使用微软SQL Server的核心，所有与SQL Server实例通信的应用程序均通过向服务器发送T-SQL语句来进行交互。 Azure数据工作室是一个跨平台的数据库工具，适用于使用Windows、macOS和Linux的本地和云数据平台的数据专业人士。Azure数据工作室提供现代编辑体验，包括智能感知（IntelliSense）、代码片段、源代码控制集成和集成终端。 本课程将为学员提供必要的技能，以高效管理和分析数据库，并掌握Microsoft SQL相关工具和技术。
MSSQL is a suite of database software published by Microsoft and used extensively within our enterprise. Typically, it includes a relational database engine, which stores data in tables, columns and rows, Integration Services (SSIS), which is a data movement tool for importing, exporting and transforming data, Reporting Services (SSRS), which is used to create reports and serve reports to end users, and also Analysis Services (SSAS), which is a multidimensional database used to query data from the main database engine.Azure SQL is a family of managed, secure, and intelligent products that use the SQL Server database engine in the Azure cloud.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.Transact-SQL (T-SQL) is Microsoft's and Sybase's proprietary extension to the SQL (Structured Query Language) used to interact with relational databases. T-SQL expands on the SQL standard to include procedural programming, local variables, various support functions for string processing, date processing, mathematics, etc. and changes to the DELETE and UPDATE statements.Transact-SQL is central to using Microsoft SQL Server. All applications that communicate with an instance of SQL Server do so by sending Transact-SQL statements to the server, regardless of the user interface of the application.Azure Data Studio is a cross-platform database tool for data professionals using on-premises and cloud data platforms on Windows, macOS, and Linux. Azure Data Studio offers a modern editor experience with IntelliSense, code snippets, source control integration, and an integrated terminal.
