|
所在平台: Udemy |
课程主页: https://www.udemy.com/course/microsoft-sql-for-beginners-perform-crud-operations/
课程评论：没有评论
课程名称：初学者的Microsoft SQL：执行CRUD操作 课程概述：Transact-SQL是微软和Sybase公司对SQL的专有扩展，主要用于与关系数据库进行交互。本课程将介绍SQL的基本概念及其特性。SQL（结构化查询语言）用于访问和操作数据库，早在1986年，它就被美国国家标准协会（ANSI）确认为标准，并在1987年被国际标准化组织（ISO）认可。 SQL的功能包括： - 执行针对数据库的查询 - 从数据库中检索数据 - 在数据库中插入记录 - 更新数据库中的记录 - 删除数据库中的记录 - 创建新的数据库和表 - 创建存储过程和视图 - 设置对表、存储过程和视图的权限 虽然SQL是ANSI/ISO的标准，但不同的SQL版本之间存在差异。为符合ANSI标准，所有版本至少支持主要命令（如SELECT、UPDATE、DELETE、INSERT、WHERE）以类似方式进行操作。此外，大多数SQL数据库程序还拥有自己的专有扩展。 在本课程中，您将学习如何： - 创建数据库 - 在数据库中创建表 - 向表中插入数据 - 更新数据 - 读取数据 - 删除数据 - 删除表 - 创建视图 - 备份和恢复数据库 通过本课程的学习，您将掌握SQL的基本操作，为进一步的数据库管理和开发打下坚实基础。
Transact-SQL is Microsoft's and Sybase's proprietary extension to the SQL used to interact with relational 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 viewsSQL is a Standard - BUT....Although SQL is an ANSI/ISO standard, there are different versions of the SQL language.However, to be compliant with the ANSI standard, they all support at least the major commands (such as SELECT, UPDATE, DELETE, INSERT, WHERE) in a similar manner.Note: Most of the SQL database programs also have their own proprietary extensions in addition to the SQL standard!This course you will learn how to create a database, create a table in the database, insert data into the table, update the data, read the data, delete the data, and then delete the table. You will create views ,backup and restore database.
