|
所在平台: Udemy |
课程主页: https://www.udemy.com/course/t-sql-transact-sql-for-beginners-with-microsoft-sql-server/
课程评论:没有评论
课程名称:初学者的T-SQL(Transact-SQL)与微软SQL Server 课程概述:本课程涵盖微软SQL Server中SQL语言的基础知识,旨在为学生提供使用SQL Server Management Studio (SSMS)开发环境手动编写Transact-SQL语句的实际经验。课程中,我们将编写Transact-SQL语句来执行对SQL Server数据库的CRUD(创建、读取、更新、删除)操作。CRUD操作是对数据库执行的最常见操作之一。SQL Server是由微软开发和营销的关系数据库管理系统(RDBMS),像其他RDBMS软件一样,SQL Server基于SQL这个标准编程语言,用于与关系数据库进行交互。SQL Server与Transact-SQL(T-SQL)紧密相关,T-SQL是微软对SQL的实现,增加了一系列专有的编程结构。 您将学习并掌握的技能包括: - 编写CREATE查询 - 编写INSERT INTO查询 - 编写SELECT查询 - 编写UPDATE查询 - 编写DELETE查询 课程目标:提供在微软SQL Server数据库中查询和修改数据所需的Transact-SQL (T-SQL)编码技能。
This course covers the basics of the SQL language as implemented by Microsoft SQL Server. The course is designed to give students practical experience in writing Transact-SQL statements by hand using the SQL Server Management Studio (SSMS) development environment.We will write Transact-SQL statements to perform CRUD(create Read update delete) operations on SQL Server database.CRUD operations are the most common operations performed on a database.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.Skills you learn and acquire Includes:Writing CREATE queriesWriting INSERT INTO queriesWriting SELECT queriesWriting UPDATE queriesWriting DELETE queriesCourse ObjectivesTo provide the Transact-SQL (T-SQL) coding skills needed to query and modify data held within a Microsoft SQL Server database.