|
所在平台: Udemy |
课程主页: https://www.udemy.com/course/how-to-create-databases-and-tables-in-microsoft-sql-server/
课程评论：没有评论
课程名称：如何在Microsoft SQL Server中创建数据库和表 课程概述：SQL Server是一种关系数据库管理系统（RDBMS），由微软开发和销售。与其他RDBMS软件类似，SQL Server建立在SQL之上，SQL是一种与关系数据库交互的标准编程语言。SQL Server与Transact-SQL（T-SQL）紧密相关，T-SQL是微软对SQL的实现，增加了一套专有的编程结构。SQL Server的核心组件是数据库引擎。数据库引擎由处理查询的关系引擎和管理数据库文件、页、索引等的存储引擎组成。数据库对象如存储过程、视图和触发器也由数据库引擎创建和执行。 在SQL Server中，数据库由一组表组成，这些表存储一组特定的结构化数据。每个表包含若干行（也称为记录或元组）和列（也称为属性）。表中的每一列旨在存储特定类型的信息，例如日期、姓名、金额和数字。表用于在数据库中存储数据。每个表在数据库和模式中都有唯一的名称。每个表包含一个或多个列，每列都有一个相关的数据类型，定义了它可以存储的数据种类，例如数字、字符串或时间数据。 通过本课程，您将学习如何在Microsoft SQL Server中有效创建和管理数据库及表，掌握使用SQL与数据交互的基本技能。
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 construct.The 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.A database in SQL Server is made up of a collection of tables that stores a specific set of structured data. A table contains a collection of rows, also referred to as records or tuples, and columns, also referred to as attributes. Each column in the table is designed to store a certain type of information, for example, dates, names, dollar amounts, and numbers.Tables are used to store data in the database. Tables are uniquely named within a database and schema. Each table contains one or more columns. And each column has an associated data type that defines the kind of data it can store e.g., numbers, strings, or temporal data.
