Introduction To Transact-SQL

WEBRip | English | MP4 | 960 x 540 | AVC ~328 kbps | 29.970 fps

AAC | 160 Kbps | 48.0 KHz | 2 channels | 4h 46mn | 923.9 MB

Genre: Video Tutorial / Development, Programming

Learn how to utilize Transact-SQL to address real business requirements and gain a solid understanding of your SQL Server database. Jeff Jones, an IT professional with over forty years of experience shows you how to use the tools available in Transact-SQL to discover the database definition, access tables, submit queries, and view the results.

Content:

Introduction

Welcome1. Discovering the Database

Using SQL Server Management Studio (SSMS)

Identifying table relationships

SSMS diagram support

Preparing to write SQL

2. Accessing Tables

The basic SELECT statement

Combining two tables with a join

Combining multiple tables with a join

3. Filtering the Data

Filtering the data

Using functions

4. Displaying Data

Defining the result set

Manipulating numbers and data types

Using conditional column output

Controlling output rows

5. Aggregating Data

Grouping gata