|
所在平台: Udemy |
课程主页: https://www.udemy.com/course/connect-and-query-sql-database-server-using-t-sql-and-ssms/
课程评论：没有评论
课程名称：使用 T-SQL 和 SSMS 连接和查询 SQL 数据库服务器 课程概述：SQL SERVER 是由微软开发的一种关系数据库管理系统（RDBMS），旨在与 MySQL 和 Oracle 数据库竞争。SQL Server 支持 ANSI SQL，这是标准的 SQL（结构化查询语言）。然而，SQL Server 采用了自己独特的 SQL 实现，即 T-SQL（Transact-SQL）。T-SQL 是微软专有的语言，提供了进一步的功能，如变量声明、异常处理、存储过程等。 SQL Server 管理工作室（SSMS）是 SQL Server 的主要界面工具，支持 32 位和 64 位环境。SQL Server 有四个主要版本，包含不同的服务和工具。两个版本是免费的：用于数据库开发和测试的 SQL Server Developer 版本，以及适用于小型数据库（存储容量最多 10 GB）的 SQL Server Express 版本。对于更大和更重要的应用，SQL Server 提供了包含所有功能的企业版。而标准版则含有企业版的部分功能，并对服务器的处理器核心数量和内存配置设置了限制。 SQL Server 管理工作室（SSMS）是一个集成环境，用于管理任何 SQL 基础设施。用户可以使用 SSMS 访问、配置、管理和开发 SQL Server、Azure SQL 数据库及 Azure Synapse Analytics 的所有组件。SSMS 提供了一个综合性的实用工具，结合了广泛的图形工具和丰富的脚本编辑器，旨在为所有技能水平的开发者和数据库管理员提供访问 SQL Server 的途径。
SQL SERVER is a relational database management system (RDBMS) developed by Microsoft. It is primarily designed and developed to compete with MySQL and Oracle database.SQL Server supports ANSI SQL, which is the standard SQL (Structured Query Language) language. However, SQL Server comes with its own implementation of the SQL language, T-SQL (Transact-SQL).T-SQL is a Microsoft propriety Language known as Transact-SQL. It provides further capabilities of declaring variable, exception handling, stored procedure, etc.SQL Server Management Studio (SSMS) is the main interface tool for SQL Server, and it supports both 32-bit and 64-bit environments.SQL Server has four primary editions that have different bundled services and tools. Two editions are available free of charge:SQL Server Developer edition for use in database development and testing.SQL Server Expression for small databases with the size up to 10 GB of disk storage capacity.For larger and more critical applications, SQL Server offers the Enterprise edition that includes all SQL server's features.SQL Server Standard Edition has partial feature sets of the Enterprise Edition and limits on the Server regarding the numbers of processor core and memory that can be configured.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.
