|
所在平台: Udemy |
课程主页: https://www.udemy.com/course/learn-to-program-with-t-sql/
课程评论：没有评论
课程名称：学习使用 T-SQL 编程 课程概述：SQL（结构化查询语言）是从关系数据库（如 SQL Server、Oracle、MySQL、MariaDB 和 PostgreSQL）中检索数据的常用工具。SQL 技能是全球招聘者和企业最常请求的三大 IT 技能之一。T-SQL 通常被称为 T-Sequel。在本课程中，您将学习 T-SQL 的所有基础知识。我们将逐步讨论 T-SQL 的各项特性，并使用 SQL Server Express 2014（可免费下载）。作为样本数据库，我们将使用 AdventureWorks 2014。在学习过程中，我们将创建自己的 T-SQL 查询，以向数据库中插入和提取数据。AdventureWorks 2014 将是我们主要的研究对象。 在 T-SQL 学习方面，我们将从简单的选择语句开始，并逐逐渐增加新特性。此课程将为您提供使用 Transact-SQL 创建查询的基本知识和技能。您将学习如何选择、过滤和排序多个表中的数据，以及如何使用视图和存储过程。此外，您还将熟悉 SQL Server Management Studio 2014（在技术行业被称为 SSMS），这是您编写和查看 T-SQL 查询输出所使用的工具。 本初学者课程提供了对这一核心编程语言的基础介绍。您将学习如何： - 从服务器请求数据 - 限制和排序数据响应 - 使用聚合函数获取单个输出值 - 使用连接合并多个表中的数据 - 修改数据：添加、更新和删除 - 过滤记录和删除重复值 - 编写基本的 T-SQL 语句 - 理解 T-SQL 的 TOP 命令 - 理解规范化 这是一门专为初学者设立的课程，旨在帮助学员掌握 T-SQL 编程的基本技能。
SQL (Structured Query Language) is a common tool for retrieving data from relational databases such as SQL Server,Oracle, MySQL, MariaDB, and PostgreSQL. SQL skills is in the Top 3 of requested IT Skills by recruiters and companies all over the world. T-SQL is also popularly referred 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. 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. This beginner course provides an introduction to this core programming language. Learn how to: Request data from a server, Limit and sort the data responses Get single output value using aggregate functions Combine data from multiple tables with joins Modify data: Add, Update and Delete Filter records and remove duplicates Write basic T-SQL Statements Understand T-SQL TOP Command Understand Normalisation
