|
所在平台: Udemy |
课程主页: https://www.udemy.com/course/microsoft-sql-for-beginners-ms-sql-servert-sql-ssms/
课程评论：没有评论
课程名称：初学者Microsoft SQL课程：（MS-SQL服务器，T-SQL，SSMS） 课程概述：数据的数量庞大且每日都在增加，结构化查询语言（SQL）是与存储在关系管理数据库系统（如Microsoft SQL Server，Oracle，PostgreSQL，MySQL等）中的数据进行交互的标准语言。不同的数据库管理系统有其自己的SQL语言专有版本，但所有版本都遵循相同的SQL命令。Microsoft SQL Server的SQL版本称为Transact-SQL（T-SQL），常被称为T-Sequel。本课程将教授SQL语言和T-SQL的基础知识，因为两者在某些命令的使用上相似。 在本课程中，您将逐步学习T-SQL的基本功能，使用SQL Server Express 2014（可免费下载），并以AdventureWorks 2014作为示例数据库。过程中，您将创建自己的T-SQL查询以从数据库中获取数据，同时也将专注于AdventureWorks 2014。 课程内容包括： - 安装SQL Server - 安装SSMS - 基本数据库概念 - 创建数据库 - 创建表 - 创建视图 - 创建存储过程 - 从数据库读取数据 - 更新数据库记录 - 备份数据库 - 删除记录 - 清空表 - 删除表 - 删除数据库 - 恢复数据库 - 查询多个数据库表 - 使用CASE表达式更改查询输出列名 - 执行各种表连接 - 过滤记录并去除重复项 - 编写基本的T-SQL语句 - 理解T-SQL的TOP命令 - 了解规范化 - 使用SSMS的能力 - 创建视图 - 创建存储过程 - 理解NULL值 - 数据类型 - 函数 完成本课程后，您将对T-SQL的使用非常熟悉，并具备用Transact-SQL创建查询的基本知识和技能，能够选择、过滤和排序来自多个表的数据，以及使用视图和存储过程。您还将熟悉SQL Server管理工作室（SSMS），这是您编写和查看T-SQL查询输出的工具。
The volume of data available is huge and increasing daily. Structured Query Language -SQL (pronounced as sequel) is the standard language used to communicate and interact with data stored in relational management database systems like Microsoft SQL Server Oracle, PostgreSQL,MySQL etc.Different database management systems have their own proprietary version of the SQL language but they all conform to using some commands in SQL the same way. Microsoft SQL Server's version of SQL is known as Transact-SQL (T-SQL). In this course you will learn the basics of the SQL language and Transact-SQL since both use certain commands in the same way.T-SQL is also popularly referenced to as T-Sequel.In this course you will learn all the basics of T-SQL. We will discuss the T-SQL features step by step. We will be using SQL Server Express 2014 (which is a free download). As a sample, we will use AdventureWorks 2014 as our database. Along the way, we will be creating our own t-SQL queries to get data into a database and also out of a database. But AdventureWorks 2014 will be our main focus. As far as T-SQL, we will start with the simple select statements and add new features as we go. I will introduce you to the data types available so you can make the appropriate selection when creating a column. Then, we will talk about joins, functions, tables, procedures, triggers, indexes, and much more. By the time you are done with this course, you will be very comfortable using T-SQL. This course will provide you with the basic knowledge and skills to create queries using Transact-SQL. It will teach you how to select, filter and sort data from multiple tables and how to use views and stored procedures. You will also be familiar with SQL Server Management Studio 2014 also known in the tech industry as SSMS. This is the tool you will use to write and see the output of your T-SQL queries.What You will learn includes:Installing SQL ServerInstall SSMSBasic Database ConceptsCreating DatabaseCreating TableCreating ViewsCreating stored proceduresReading data from a databaseUpdating database recordsBacking up databaseDeleting RecordsTruncating TableDropping TableDropping DatabaseRestore DatabaseQuery Multiple Database TablesChange query output column names using case expressionsPerform Various table joinsFilter records and remove duplicatesWrite basic T-SQL StatementsUnderstand T-SQL TOP CommandUnderstand NormalisationKnow how to use SSMSCreate ViewsCreate Stored ProceduresUnderstand NULL ValuesData TypesFunctions
