|
所在平台: Udemy |
课程主页: https://www.udemy.com/course/microsoft-sql-server-for-beginners-d/
课程评论：没有评论
课程名称：初学者的Microsoft SQL Server 课程概述： Microsoft SQL Server是一种关系数据库管理系统（RDBMS），由微软开发和营销。与其他RDBMS软件类似，SQL Server基于SQL，这是一种与关系数据库交互的标准编程语言。SQL Server使用Transact-SQL（T-SQL），这是微软对SQL的实现，增加了一套专有的编程结构。 数据库引擎是SQL Server的核心组成部分。数据库引擎包括一个处理查询的关系引擎和一个管理数据库文件、页面、索引等的存储引擎。数据库对象如存储过程、视图和触发器也由数据库引擎创建和执行。 关系引擎包含了确定执行查询最佳方式的组件，也被称为查询处理器。关系引擎根据输入查询向存储引擎请求数据并处理结果。其主要任务包括查询处理、内存管理、线程和任务管理、缓冲区管理以及分布式查询处理。 SQL Server有四个主要版本，提供不同的服务和工具。其中两个版本是免费的：SQL Server开发者版用于数据库开发和测试；SQL Server Express适用于大小不超过10GB的较小数据库。对于更大和更关键的应用，SQL Server提供企业版，包含所有SQL Server的功能。此外，SQL Server标准版则具有企业版的部分功能集，并在处理器核心数量和内存配置上有限制。
SQL Server is a relational database management system, or RDBMS, developed and marketed by Microsoft.Similar to other RDBMS software, SQL Server is built on top of SQL, a standard programming language for interacting with the relational databases. SQL server is tied to Transact-SQL, or T-SQL, the Microsoft's implementation of SQL that adds a set of proprietary programming constructs. Database EngineThe core component of the SQL Server is the Database Engine. The Database Engine consists of a relational engine that processes queries and a storage engine that manages database files, pages, pages, index, etc. The database objects such as stored procedures, views, and triggers are also created and executed by the Database Engine.Relational EngineThe Relational Engine contains the components that determine the best way to execute a query. The relational engine is also known as the query processor. The relational engine requests data from the storage engine based on the input query and processed the results.Some tasks of the relational engine include querying processing, memory management, thread and task management, buffer management, and distributed query processing.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.
