O'Reilly logo

Stay ahead with the world's most comprehensive technology and business learning platform.

With Safari, you learn the way you learn best. Get unlimited access to videos, live online training, learning paths, books, tutorials, and more.

Start Free Trial

No credit card required

SQL Server 2014: T-SQL Fundamentals

Video Description

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.

Table of Contents

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