Introduction to T-SQL

£395.00

What Will You Learn?

  • How to write queries that involve multiple tables and summary queries
  • How to modify data and understand the logical programming aspects of T-SQL

Category:

DESCRIPTION

This course is designed to get you developing with T-SQL very quickly. First, you will learn the structure of a SQL Server database, then you will dive into how to query the tables. Next, we will cover sorting and filtering the results.

INSTRUCTOR

MANUEL QUINTANAMANUEL QUINTANA

Training Content Manager
As a Training Content Manager with Pragmatic Works, Manuel uses his knowledge with the BI Stack (SSRS, SSIS, SSAS) to deliver exciting and engaging content. He also has experience with T-SQL, DAX and Power Pivot and is always looking to expand his knowledge. A native of Puerto Rico, Manuel graduated from the University of Central Florida and loves being involved in the world of Business Intelligence.

WHAT TO KNOW BEFORE THE CLASS

nPrevious SQL Server knowledge is not required. Ideally, students should be proficient using the Windows operating system and performing typical tasks like uploading or zipping files.


Duration: 8:38:57
The Introduction to T-SQL virtual class is an intensive course that is designed to get you developing with T-SQL very quickly. You will first learn about the structure of a SQL Server database, then you will dive right in learning how to query the tables. Next, we will cover how to sort and filter the results. Then we will dive into how to write queries that involve multiple tables and summary queries. You will also learn how to modify data and finally about the logical programming aspects of T-SQL.
Introduction to T-SQL - What do you need to get started
Module 00 - Getting Started
15:49
Module 01 - Introduction to SQL Server Databases
24:31
Module 02 - SQL Server Management Studio (SSMS)
26:09
Module 03 - The SELECT Statement
40:55
Module 04A - Expressions (Concatenating Columns)
09:56
Module 04B - Expressions (Mathematical Expressions)
15:37
Module 04C - Expressions (Other Functions)
51:54
Module 04D - Expressions (Working with NULLs, DISTINCT and TOP)
16:07
Module 05 - Indexes
16:52
Module 06 - The WHERE Clause
30:29
Module 07 - Complex WHERE Clauses
27:21
Module 08 - Using a Sub-Query to Filter Data
36:41
Module 09 - Joining Tables
34:18
Module 10 - Outer Joins
33:15
Module 11 - Other Query Patterns
39:36
Module 12 - Aggregate Queries
26:23
Module 13A - Modifying Data (Create Tables)
05:18
Module 13B - Modifying Data (INSERT and SELECT INTO)
11:59
Module 13C - Modifying Data (UPDATE Statement)
16:37
Module 13D - Modifying Data (DELETE Statement)
06:20
Module 14A - T-SQL Programming (Variables)
06:24
Module 14B - T-SQL Programming (Conditional Logic)
13:09
Module 14C - T-SQL Programming (Looping)
05:31
Module 14D - T-SQL Programming (Stored Procedures)
07:46
Class Survey

SYSTEM REQUIREMENTS

  • Microsoft Windows XP Professional, Microsoft Windows Server 2003, Microsoft Vista, Windows 7 or Windows 8
  • 1 GHz or faster CPU
  • 1 GB of available RAM (recommended 2 GB)
  • 20 GB of free hard drive space
  • SQL Server Developer, Standard or Enterprise Edition 2008/2008R2/2012/2014
  • AdventureWorks2008R2 or AdventureWorks2012 databases installed on the instance
  • AdventureWorksDW2008R2 or AdventureWorksDW2012 databases installed on the instance