|
所在平台: Udemy |
课程主页: https://www.udemy.com/course/querying-microsoft-sql-server-data-with-transact-sql/
课程评论：没有评论
课程名称：使用Transact-SQL查询数据 课程概述：SQL Server是一个由微软开发和推广的关系数据库管理系统（RDBMS）。与其他RDBMS软件类似，SQL Server建立在SQL之上，SQL是一种与关系数据库交互的标准编程语言。SQL Server与Transact-SQL（T-SQL）紧密关联，T-SQL是微软实现的SQL，增加了一些专有的编程结构。 课程内容包括： - SQL的定义：结构化查询语言（Structured Query Language），使用户能够访问和操作数据库。SQL于1986年成为美国国家标准协会（ANSI）的标准，1987年成为国际标准化组织（ISO）的标准。 - SQL的功能：执行数据库查询、检索数据、插入记录、更新记录、删除记录、创建新数据库、创建新表、创建存储过程、创建视图以及设置表、过程和视图的权限。 - 本课程将使用T-SQL从安装在微软SQL Server中的示例数据库中查询数据。 主要主题包括： - 数据过滤 - 数据排序 - 聚合函数 此课程适合希望深入了解T-SQL并运用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 constructs.What is SQL?SQL stands for Structured Query LanguageSQL lets you access and manipulate databasesSQL became a standard of the American National Standards Institute (ANSI) in 1986, and of the International Organization for Standardization (ISO) in 1987SQL is a standard language for accessing and manipulating databases.What is SQL?SQL stands for Structured Query LanguageSQL lets you access and manipulate databasesSQL became a standard of the American National Standards Institute (ANSI) in 1986, and of the International Organization for Standardization (ISO) in 1987What Can SQL do?SQL can execute queries against a databaseSQL can retrieve data from a databaseSQL can insert records in a databaseSQL can update records in a databaseSQL can delete records from a databaseSQL can create new databasesSQL can create new tables in a databaseSQL can create stored procedures in a databaseSQL can create views in a databaseSQL can set permissions on tables, procedures, and viewsIn this course we are going to query data from a sample database installed inside Microsoft SQL Server using T-SQLTopics Covered include:Filtering DataSorting DataAggregate Functions
