on-demand course

T-SQL Fundamentals LiveLessons (Video Training)

with Alison Balter

October 2014

Intermediate to advanced

4h 4m

English

Pearson

Closed Captioning available in English, Japanese, Korean, Chinese (Simplified), Chinese (Traditional)

Watch now

Unlock full access

Includes

Earns Badge

Course outline

T-SQL Fundamentals LiveLessons: Introduction
3m 23s
Learning Objectives
28s
1.1 What is a Database?
4m 44s
1.2 Creating a Database
3m 37s
1.3 Creating a Table
7m 22s
1.4 Creating Check Constraints
5m 52s
1.5 Establishing Relationships between Tables
5m 46s
Learning Objectives
28s
2.1 The SELECT Statement
3m 40s
2.2 The FROM Keyword
1m 36s
2.3 The WHERE Clause
3m 40s
2.4 IN and BETWEEN
3m 57s
2.5 The ORDER BY Clause
2m 21s
Learning Objectives
33s
3.1 The DISTINCT Keyword
2m 1s
3.2 The GROUP BY Clause
1m 31s
3.3 Aggregate Functions
4m 26s
3.4 The HAVING Clause
1m 26s
3.5 Combining Conditions
6m 39s
3.6 Top Values Queries
4m 3s
3.7 Working with Aliases
2m 4s
3.8 Working with Null
2m 23s
Learning Objectives
22s
4.1 Inner Joins
1m 55s
4.2 Outer Joins
2m 4s
4.3 Full Joins
1m 37s
4.4 Self Joins
5m 15s
Learning Objectives
37s
5.1 Union Queries
5m 59s
5.2 Subqueries
2m 0s
Learning Objectives
25s
6.1 The UPDATE Statement
3m 35s
6.2 The INSTER Statement
2m 50s
6.3 The SELECT INTO Statement
1m 23s
6.4 The DELETE Statement
1m 30s
6.5 The TRUNCATE Statement
56s
Learning Objectives
36s
7.1 Numeric Functions
3m 2s
7.2 String Functions
4m 26s
7.3 Date/Time Functions
5m 52s
7.4 Working with Nulls
4m 21s
Learning Objectives
29s
8.1 Creating a Simple View
5m 31s
8.2 Creating Views Based on Data in Multiple Tables
4m 6s
8.3 Views and Subqueries
2m 22s
8.4 Views and Outer Joins
3m 0s
8.5 Sorting View Results
3m 15s
8.6 Views and Top Values
3m 37s
8.7 Views and Functions
2m 53s
8.8 Using Views to Secure Data
58s
8.9 Modifying Data in a View
2m 48s
Learning Objectives
37s
9.1 Stored Procedures Basics
4m 19s
9.2 Declaring and Working with Variables
4m 3s
9.3 Controlling the Flow
10m 44s
9.4 The SET NOCOUNT Statement
46s
9.5 Using the @@ Functions
5m 26s
9.6 Working with Paramaters
6m 15s

Content preview from T-SQL Fundamentals LiveLessons (Video Training)

3.2 The GROUP BY Clause

Become an O’Reilly member and get unlimited access to this title plus top books and audiobooks from O’Reilly and nearly 200 top publishers, thousands of courses curated by job role, 150+ live events each month,
and much more.

Start your free trial

SQL Fundamentals LiveLessons

Arie D. Jones

DP-900: Microsoft Azure Data Fundamentals Video Course + Practise Questions

Eshant Garg

SQL for Beginners with Microsoft SQL Server Database

Anil Batra

T-SQL Querying

Itzik Ben-Gan, Adam Machanic, Dejan Sarka, Kevin Farlee

Publisher Resources

ISBN: 9780133994629

T-SQL Fundamentals LiveLessons (Video Training)

with Alison Balter

Introduction

Lesson 1: Introduction to Databases

Lesson 2: T-SQL Basics

Lesson 3: TSQL - Beyond the Basics

Lesson 4: Join Types

Lesson 5: Specialized T-SQL Queries

Lesson 6: Modifying Data with Action Queries

Lesson 7: T-SQL Functions

Lesson 8: Working with SQL Server Views

Lesson 9: Designing SQL Server Stored Procedures

Lesson 10: Enhancing the Stored Procedures that You Build

Lesson 11: Building and Working with User-Defined Functions

Lesson 12: Creating and Working with Triggers

Lesson 13: Analyzing Performance

Summary

Content preview from T-SQL Fundamentals LiveLessons (Video Training)

3.2 The GROUP BY Clause

Become an O’Reilly member and get unlimited access to this title plus top books and audiobooks from O’Reilly and nearly 200 top publishers, thousands of courses curated by job role, 150+ live events each month,
and much more.