Watch movie | Han Solo: Uma História Star Wars DUBLADO E LEGENDADO ONLINE | The Vision of Escaflowne

T-SQL For Beginners: Learn to Query SQL Server Databases

其他教程 killking 1评论

T-SQL For Beginners: Learn to Query SQL Server Databases

MP4 | Video: AVC 1280x720 | Audio: AAC 44KHz 2ch | Duration: 3 Hours | 428 MB
Genre: eLearning | Language: English
Learn how to use Microsoft's version of SQL to Query Microsoft SQL Server Databases

Welcome everyone to the T-SQL course. T-SQL is also popularly referefered 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 in this course includes:

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

This is a video based course of about hours with lots of practical hands on examples to follow along.

T-SQL For Beginners: Learn to Query SQL Server Databases

Download uploaded

Download nitroflare

Download 百度云


sorry! The following hidden content sponsorship VIP members only.

您必须 登录 才能发表评论!

网友最新评论 (1)

  1. 欢迎学习T-SQL教程。在本教程中,你将学习所有T-SQL的基础知识。我们将会一步步地讲解T-SQL功能。我们将使用免费的SQL Server Express 2014,并使用AdverntureWorks 2014作为演示数据库。在教程中,我们将创建我们自己的T-SQL查询,从数据库中读取数据。但是AdventureWorks 2014将会是我们的重点。对于T-SQL,我们会从简单的语句和添加新功能开始。我们会讲到创建列数据时,做出正确选择而需要的掌握的数据类型。然后,我们会讲到合并、函数、表、过程、触发器、索引等。 主要内容:查询多个数据库表;使用case expression表达式改变查询输出列;执行多个表合并;筛选记录和删除重复;编辑基本的T-SQL语句;理解正则范式;掌握如何使用SSMS;创建视图;创建存储过程;理解NULL值;数据类型;函数。
    wilde(特殊组-翻译)2年前 (2016-01-29)