Microsoft SQL for beginners : ( MS-SQL Server,T-SQL, SSMS )

可用的数据量巨大，并且每天都在增加。结构化查询语言-SQL（发音为续集）是用于与存储在关系管理数据库系统（例如Microsoft SQL Server Oracle，PostgreSQL，MySQL等）中的数据进行通信和交互的标准语言。

不同的数据库管理系统具有自己的SQL语言专有版本，但是它们都遵循以相同方式在SQL中使用某些命令的要求。Microsoft SQL Server的SQL版本称为Transact-SQL（T-SQL）。在本课程中，您将学习SQL语言和Transact-SQL的基础知识，因为两者都以相同的方式使用某些命令。

T-SQL也被普遍称为T-Sequel。在本课程中，您将学习T-SQL的所有基础知识。我们将逐步讨论T-SQL功能。我们将使用SQL Server Express 2014（免费下载）。作为示例，我们将使用AdventureWorks 2014作为我们的数据库。在此过程中，我们将创建自己的t-SQL查询，以将数据获取到数据库中以及从数据库中获取。但是AdventureWorks 2014将是我们的主要重点。就T-SQL而言，我们将从简单的select语句开始，并不断添加新功能。我将向您介绍可用的数据类型，以便在创建列时进行适当的选择。然后，我们将讨论联接，函数，表，过程，触发器，索引等。到完成本课程时，您将非常熟悉使用T-SQL。
本课程将为您提供使用Transact-SQL创建查询的基本知识和技能。它将教您如何从多个表中选择，过滤和排序数据，以及如何使用视图和存储过程。您还将熟悉SQL Server Management Studio 2014（在技术行业中也称为SSMS）。这是您用来编写和查看T-SQL查询输出的工具。

MP4 | Video: h264, 1280×720 | Audio: AAC, 44.1 KHz, 2 Ch
Genre: eLearning | Language: English + .srt | Duration: 53 lectures (5 hour, 1 mins) | Size: 2.05 GB
Practical Hands-on Data Query and Manipulation with SQL

What you’ll learn

Create database and Tables
Write SELECT Statements
Write UPDATE Statements
Write DELETE Statements
Write SQL Table Join Statements
Group data using GROUP BY Clause
Filter data various operators
Sort data with ORDER BY Clause
Exclude duplicate records using DISTINCT
Create Stored Procedures
Backup and Restore Database
Joining data from multiple tables
Truncating Tables
Aggregating data with Aggregate functions

Requirements

Computer and internet required.

Description

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 Server

Install SSMS

Basic Database Concepts

Creating Database

Creating Table

Creating Views

Creating stored procedures

Reading data from a database

Updating database records

Backing up database

Deleting Records

Truncating Table

Dropping Table

Dropping Database

Restore Database

Query Multiple Database Tables

Change query output column names using case expressions

Perform Various table joins

Filter records and remove duplicates

Write basic T-SQL Statements

Understand T-SQL TOP Command

Understand Normalisation

Know how to use SSMS

Create Views

Create Stored Procedures

Understand NULL Values

Data Types

Functions

Who this course is for:

Beginners to Microsoft SQL
Beginners to SQL