|
所在平台: Udemy |
课程主页: https://www.udemy.com/course/sql-data-analysis-for-beginners-ms-sql-sql-server-ssms/
课程评论：没有评论
课程名称：SQL 数据分析入门：MS SQL SQL Server SSMS 课程概述：当今可用的数据量巨大，并且每天都在增加。结构化查询语言(SQL)是与存储在关系数据库管理系统中的数据进行沟通和交互的标准语言，比如微软 SQL Server、Oracle、PostgreSQL、MySQL等。尽管不同的数据库管理系统有自己专有版本的 SQL 语言，但它们在某些命令上是相同的。微软 SQL Server 的 SQL 版本称为 Transact-SQL (T-SQL)，也常被称为 T-Sequel。 在本课程中，您将学习 SQL 语言和 T-SQL 的基础知识。我们将逐步讨论 T-SQL 的特性，并使用 SQL Server Express 2014（可免费下载）。本课程将主要使用 AdventureWorks 2014 数据库作为示例。我们将创建自己的 T-SQL 查询，从数据库中获取数据并将数据存入数据库。课程开始时将介绍简单的 SELECT 语句，随后逐步添加新特性。 您将学习可用的数据类型，以便在创建列时做出适当选择。此外，我们还将讨论联接、函数、表、存储过程、触发器、索引等内容。完成本课程后，您将能够熟练使用 T-SQL，并具备使用 Transact-SQL 创建查询的基本知识和技能。您将学会如何从多个表中选择、过滤和排序数据，以及如何使用视图和存储过程。此外，您还将熟悉被称为 SSMS 的 SQL Server Management Studio 2014，这是您编写和查看 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.
