by Integrity Training | Released May 2019 | ISBN: 300000006CA316

This course will introduce students to SQL Server 2014 Transact-SQL fundamentals, as well as teach them about functions, flow, results, select, where, clauses, tables, and working with data. This course will teach students about operations and converting, null and number functions, string functions, data flow, global functions and controlling program flow. The next chapter of the course covers SELECT, WHERE, GROUPBY, ORDERBY and joining tables. The final chapter of the course covers insert, update, delete, output, bulk copy and understanding transactions. Show and hide more

1. Introduction to T-SQL
   • Topic A: Introduction to Transact-SQL - Part 1 00:00:41
   • Introduction to Transact-SQL - Part 2 00:12:04
   • Introduction to Transact-SQL - Part 3 00:00:28
   • Topic B: Operators and Converting - Part 1 00:00:24
   • Operators and Converting - Part 2 00:19:19
   • Operators and Converting - Part 3 00:00:25
   • Topic C: Null and Number Functions - Part 1 00:00:29
   • Null and Number Functions - Part 2 00:24:09
   • Null and Number Functions - Part 3 00:00:22
2. Functions, Flow, Results
   • Topic A: String Functions - Part 1 00:00:24
   • String Functions - Part 2 00:20:55
   • String Functions - Part 3 00:00:24
   • Topic B: Date and Global Functions - Part 1 00:00:18
   • Date and Global Functions - Part 2 00:14:06
   • Date and Global Functions - Part 3 00:00:22
   • Topic C: Controlling Program Flow - Part 1 00:00:32
   • Controlling Program Flow - Part 2 00:19:23
   • Controlling Program Flow - Part 3 00:00:22
   • Topic D: Ranking Results - Part 1 00:00:24
   • Ranking Results - Part 2 00:09:27
   • Ranking Results - Part 3 00:00:18
3. Select, Where, Clauses, Tables
   • Topic A: Data Selection with SELECT - Part 1 00:01:14
   • Data Selection with SELECT - Part 2 00:15:17
   • Data Selection with SELECT - Part 3 00:00:26
   • Topic B: The WHERE Clause - Part 1 00:00:40
   • The WHERE Clause - Part 2 00:18:15
   • The WHERE Clause - Part 3 00:00:40
   • Topic C: GROUPBY and ORDERBY - Part 1 00:01:01
   • GROUPBY and ORDERBY - Part 2 00:17:21
   • GROUPBY and ORDERBY - Part 3 00:00:25
   • Topic D: Joining Tables - Part 1 00:01:05
   • Joining Tables - Part 2 00:20:11
   • Joining Tables - Part 3 00:00:32
   • Topic E: Outer and Self Joins - Part 1 00:01:00
   • Outer and Self Joins - Part 2 00:18:24
   • Outer and Self Joins - Part 3 00:00:26
4. Working with Data
   • Topic A: Inserting Data - Part 1 00:01:38
   • Inserting Data - Part 2 00:20:25
   • Inserting Data - Part 3 00:00:28
   • Topic B: Temp Tables, Output, Bulk Copy - Part 1 00:00:55
   • Temp Tables, Output, Bulk Copy - Part 2 00:11:10
   • Temp Tables, Output, Bulk Copy - Part 3 00:00:45
   • Topic C: Updating and Deleting Data - Part 1 00:00:29
   • Updating and Deleting Data - Part 2 00:15:18
   • Updating and Deleting Data - Part 3 00:00:46
   • Topic D: Understanding Transactions - Part 1 00:01:18
   • Understanding Transactions - Part 2 00:23:46
   • Understanding Transactions - Part 3 00:00:54
Show and hide more