|
所在平台: Udemy |
课程主页: https://www.udemy.com/course/learnmssql2019/
课程评论：没有评论
**课程名称：** 从零开始学习MS SQL Server **课程概述：** 本课程将带您从基础开始，全面了解和掌握Microsoft SQL Server。 **核心内容：** * **SQL 基础：** 学习SQL（Structured Query Language）是什么，它的发音（"SQL" 或 "sequel"），以及它在数据库中的作用——用于修改和访问数据。 * **SQL 命令分类：** * **DDL (Data Definition Language)：** 用于数据库对象的创建、修改和删除，命令包括 CREATE, ALTER, DROP, RENAME, TRUNCATE。 * **DML (Data Manipulation Language)：** 用于数据的存储、检索、修改和删除，命令包括 SELECT, INSERT, UPDATE, DELETE。 * **TCL (Transaction Control Language)：** 用于管理数据更改，命令包括 COMMIT, ROLLBACK, SAVEPOINT。 * **DCL (Data Control Language)：** 用于数据库对象的安全控制，命令包括 GRANT, REVOKE。 * **CREATE TABLE 语句：** 学习如何使用 `CREATE TABLE` 语句定义表的结构，包括表名、列名和相应的数据类型（如 char, date, number 等）。 * **SQL Server 版本覆盖：** 课程将涵盖 SQL Server 2016 和 SQL Server 2019 的相关内容。 * **进阶主题：** 课程还将探讨 SQL 性能调优和故障排除的概念。 * **SQL Agent 作业：** 学习如何创建 SQL Agent 作业以及相关的故障排除思路。 **学习目标：** 通过本课程，您将能够理解 SQL Server 的基本概念，熟练运用各种 SQL 命令操作数据库，并初步掌握性能优化和故障排除的技巧。
SQL (Structured Query Language)SQL stands for "Structured Query Language" and can be pronounced as "SQL" or "sequel - (Structured English Query Language)".SQL (Structured Query Language) is used to modify and access data or information from a storage area called database.SQL Commands:SQL commands are instructions used to communicate with the database to perform specific task that work with data.Data Definition Language (DDL) - These SQL commands are used for creating, modifying, and dropping the structure of database objects. The commands are CREATE, ALTER, DROP, RENAME, and TRUNCATE.Data Manipulation Language (DML) - These SQL commands are used for storing, retrieving, modifying, and deleting data. These commands are SELECT, INSERT, UPDATE, and DELETE.Transaction Control Language (TCL) - These SQL commands are used for managing changes affecting the data. These commands are COMMIT, ROLLBACK, and SAVEPOINT.Data Control Language (DCL) - These SQL commands are used for providing security to database objects. These commands are GRANT and REVOKE.CREATE TABLECREATE TABLE table name(column_name1 datatype,column_name2 datatype,column name datatype);table name - is the name of the table.column_name1, column_name2..- is the name of the columnsdatatype - is the datatype for the column like char, date, number etc.Many more examples on SQL Server 2016 and SQL Server 2019Will try to cover sql performance tuning and trouble shooting concepts as well.how to create jobs in sql agents and trouble shooting concepts
