Home > Store > Data > SQL

T-SQL Fundamentals LiveLessons (Video Training), Downloadable Video

Downloadable Video

  • Your Price: $119.99
  • List Price: $149.99
  • About this video
  • Accessible from your Account page after purchase. Requires the free QuickTime Player software.

    Videos can be viewed on: Windows 8, Windows XP, Vista, 7, and all versions of Macintosh OS X including the iPad, and other platforms that support the industry standard h.264 video codec.

Register your product to gain access to bonus material or receive a coupon.

Buy Lessons

DRM-Free Video Downloads. Purchase and immediately download individual lessons from this video. Make your lesson selections below and click on the Buy button.

Videos can be viewed on: Windows 8, Windows XP, Vista, 7, and all versions of Macintosh OS X including the iPad, and other platforms that support the industry standard h.264 video codec. Requires the free QuickTime Player software.

$17.99

Lesson 1

Lesson 1: Introduction to Databases, Downloadable Version

Review relational database essentials, including tables, normalization, denormalization, field types, relationships, and how to create databases and tables

Duration: 00:27:50  File Size: 49 MB

$9.99

Lesson 2

Lesson 2: T-SQL Basics, Downloadable Version

Get started with basic T-SQL, including SELECT statements, FROM keywords, WHERE clauses, IN and BETWEEN, and the ORDER BY clause

Duration: 00:15:41  File Size: 32 MB

$15.99

Lesson 3

Lesson 3: TSQL - Beyond the Basics, Downloadable Version

Gain more power and control: master the DISTINCT keyword, GROUP BY clause, aggregate functions, the HAVING clause, combining conditions, top values queries, aliases, null, and the COMPUTE clause

Duration: 00:25:05  File Size: 50 MB

$7.99

Lesson 4

Lesson 4: Join Types, Downloadable Version

Learn how joins work, understand what each type of join does, and walk through using each of them: inner, outer, full, and self

Duration: 00:11:14  File Size: 23 MB

$7.99

Lesson 5

Lesson 5: Specialized T-SQL Queries, Downloadable Version

Start building powerful union queries and subqueries

Duration: 00:08:36  File Size: 19 MB

$7.99

Lesson 6

Lesson 6: Modifying Data with Action Queries, Downloadable Version

Change existing data with UPDATE, INSERT, SELECT INTO, DELETE, and TRUNCATE statements

Duration: 00:10:38  File Size: 23 MB

$9.99

Lesson 7

Lesson 7: T-SQL Functions, Downloadable Version

Learn how to use three essential types of functions: numeric, string, and date/time; practice working with nulls

Duration: 00:18:17  File Size: 39 MB

$6.99

Lesson 8

Lesson 8: Working with SQL Server Views, Downloadable Version

Use T-SQL to create or modify views based on one or multiple tables... use views with subqueries and outer joins... sort your view results... use views with top values and functions (both built-in and user-defined)... use views to secure data... modify data within a view... learn when and how to create indexed views... optimize your views for performance

Duration: 00:28:59  File Size: 54 MB

$19.99

Lesson 9

Lesson 9: Designing SQL Server Stored Procedures, Downloadable Version

Understand and build stored procedures; declare and work with variables... control flow with IF..ELSE, BEGIN..END, GOTO, RETURN, Labels, CASE, and WHILE... use the SET NOCOUNT statement... work with @@Functions and Parameters

Duration: 00:32:10  File Size: 70 MB

$19.99

Lesson 10

Lesson 10: Enhancing the Stored Procedures that You Build, Downloadable Version

Work with cursors... handle runtime errors... return success and failure information from a stored procedure... modify data with stored procedures... use transactions, temporary tables, and cursors... secure and debug your stored procedures

Duration: 00:31:05  File Size: 67 MB

$19.99

Lesson 11

Lesson 11: Building and Working with User-Defined Functions, Downloadable Version

Understand and build key types of user-defined functions: scalar functions, inline table-valued functions, and multi-statement table-valued functions... use functions, views, and stored procedures together

Duration: 00:14:40  File Size: 30 MB

$9.99

Lesson 12

Lesson 12: Creating and Working with Triggers, Downloadable Version

Understand and create triggers, including INSTEAD OF triggers

Duration: 00:07:09  File Size: 15 MB

$7.99

Lesson 13

Lesson 13: Analyzing Performance, Downloadable Version

Determine your Query Execution Plan... view and interpret query statistics... use the SQL Profiler

Duration: 00:08:41  File Size: 20 MB

Description

  • Copyright 2015
  • Edition: 1st
  • Downloadable Video
  • ISBN-10: 0-7897-5395-2
  • ISBN-13: 978-0-7897-5395-3

Nearly 6 Hours of Video Instruction

Overview

Learn T-SQL from the world's #1 SQL Server developer and author, Alison Balter! Gain deep mastery in just six hours… just watch!

Description

In just six hours, you'll gain the in-depth practical understanding of T-SQL you need to create superior solutions with SQL Server. Your video instructor, Alison Balter, has spent nearly 25 years building Microsoft database solutions for top organizations… she's the world's #1 Microsoft database author. Now, Balter guides you step-by-step through every skill you'll need, from simple SELECT statements to powerful query and view techniques… flexible stored procedures, triggers, and UDFs… even query analysis and optimization. Whether you're a DBA, database or web developer, or power user, these LiveLessons deliver practical knowledge for writing high-quality T-SQL code—fast!

About the Instructor

Alison Balter has 24 years of real-life experience developing Access and SQL Server applications with T-SQL and related technologies. Her clients include USC, MIT, Southern California Edison, Cisco Systems, the Drug Enforcement Administration, and many other corporate and government entities. She has written 15 books and authored more than 300 computer training videos on Access and SQL Server development: work that has earned exceptionally high ratings at Amazon.com and elsewhere.

Skill Level

  • Intermediate
  • Advanced

What You Will Learn

  • Database fundamentals every T-SQL developer needs to know
  • How to make the most of common T-SQL statements, keywords, clauses, and functions
  • How to write powerful queries using joins, subqueries, and other techniques
  • How to take full advantage of Views to display, modify, index, and secure data
  • How to design and improve SQL Server stored procedures
  • How to create and work with triggers and User-Defined Functions (UDFs)
  • How to analyze query performance

Who Should Take This Course

  • SQL Server database administrators (DBAs) who need to efficiently create tables, views, stored procedures, functions, and triggers
  • Database developers who cannot rely on DBAs and must perform all T-SQL-related tasks on their own
  • .NET, web, and client/server developers whose responsibilities include data/database access
  • Microsoft Access power users seeking to deepen their skills in creating new solutions
  • Microsoft Access developers moving to SQL Server

Course Requirements

  • Experience with either the SQL Server or Access databases as a DBA, developer, or intermediate-to-advanced user

Table of Contents

Lesson 1. Introduction to Databases

1.1. What is a Database?

1.2. What Field Types are Available?

1.3. What is a Relationship?

1.4. Creating a Database

1.5. Creating a Table

Lesson 2. T-SQL Basics

2.1. Introduction to T-SQL

2.2. The SELECT Statement

2.3. The FROM Keyword

2.4. The WHERE Clause

2.5. IN and BETWEEN

2.6. The ORDER BY Clause

Lesson 3. T-SQL - Beyond the Basics

3.1. The DISTINCT Keyword

3.2. The GROUP BY Clause

3.3. Aggregate Functions

3.4. The HAVING Clause

3.5. Combining Conditions

3.6. Top Values Queries

3.7. Working with Aliases

3.8. Working with Null

3.9. The COMPUTE Clause

Lesson 4. Join Types

4.1. Inner Joins

4.2. Outer Joins

4.3. Full Joins

4.4. Self-Joins

Lesson 5. Specialized T-SQL Queries

5.1. Union Queries

5.2. Subqueries

Lesson 6. Modifying Data with Action Queries

6.1. The UPDATE Statement

6.2. The INSERT Statement

6.3. The SELECT INTO Statement

6.4. The DELETE Statement

6.5. The TRUNCATE Statement

Lesson 7. T-SQL Functions

7.1. Numeric Functions

7.2. String Functions

7.3. Date/Time Functions

7.4. Working with Nulls

Lesson 8. Working With SQL Server Views

8.1. Using T-SQL to Create or Modify a View

8.2. Creating Views Based on Data in Multiple Tables

8.3. Views and Subqueries

8.4. Views and Outer Joins

8.5. Sorting View Results

8.6. Views and Top Values

8.7. Views and Functions

8.8. Using Views to Secure Data

8.9. Modifying Data in a View

8.10. Indexed Views

8.11. Optimizing the Views that You Build

Lesson 9. Designing SQL Server Stored Procedures

9.1. Stored Procedure Basics

9.2. Declaring and Working with Variables

9.3. Controlling the Flow

9.4. The SET NOCOUNT Statement

9.5. Using the @@Functions

9.6. Working with Parameters

Lesson 10. Enhancing the Stored Procedures that You Build

10.1. Working with Cursors

10.2. Errors and Error Handling

10.3. Modifying Data with Stored Procedures

10.4. Stored Procedures and Transactions

10.5. Stored Procedures and Temporary Tables

10.6. Stored Procedures and Cursors

10.7. Stored Procedures and Security

10.8. Debugging the Stored Procedures that You Build

Lesson 11. Building and Working with User-Defined Functions

11.1. User-defined Functions Explained

11.2. Scalar Functions

11.3. Inline Table-Valued Functions

11.4. Multi-Statement Table-Valued Functions

11.5. Functions, Views, and Stored Procedures

Lesson 12. Creating and Working with Triggers

12.1. Triggers Explained

12.2. Creating Triggers

12.3. INSTEAD OF Triggers

Lesson 13. Analyzing Performance

13.1. Determining the Query Execution Plan

13.2. Viewing Query Statistics

13.3. Using the SQL Profiler

About LiveLessons Video Training

LiveLessons Video Training series publishes hundreds of hands-on, expert-led video tutorials covering a wide selection of technology topics designed to teach you the skills you need to succeed. This professional and personal technology video series features world-leading author instructors published by your trusted technology brands: Addison-Wesley, Cisco Press, IBM Press, Pearson IT Certification, Prentice Hall, Sams, and Que. Topics include: IT Certification, Programming, Web Development, Mobile Development, Home and Office Technologies, Business and Management, and more. View all LiveLessons on InformIT at: http://www.informit.com/livelessons

Sample Content

Table of Contents

Lesson 1. Introduction to Databases

1.1. What is a Database?

1.2. What Field Types are Available?

1.3. What is a Relationship?

1.4. Creating a Database

1.5. Creating a Table

Lesson 2. T-SQL Basics

2.1. Introduction to T-SQL

2.2. The SELECT Statement

2.3. The FROM Keyword

2.4. The WHERE Clause

2.5. IN and BETWEEN

2.6. The ORDER BY Clause

Lesson 3. T-SQL - Beyond the Basics

3.1. The DISTINCT Keyword

3.2. The GROUP BY Clause

3.3. Aggregate Functions

3.4. The HAVING Clause

3.5. Combining Conditions

3.6. Top Values Queries

3.7. Working with Aliases

3.8. Working with Null

3.9. The COMPUTE Clause

Lesson 4. Join Types

4.1. Inner Joins

4.2. Outer Joins

4.3. Full Joins

4.4. Self-Joins

Lesson 5. Specialized T-SQL Queries

5.1. Union Queries

5.2. Subqueries

Lesson 6. Modifying Data with Action Queries

6.1. The UPDATE Statement

6.2. The INSERT Statement

6.3. The SELECT INTO Statement

6.4. The DELETE Statement

6.5. The TRUNCATE Statement

Lesson 7. T-SQL Functions

7.1. Numeric Functions

7.2. String Functions

7.3. Date/Time Functions

7.4. Working with Nulls

Lesson 8. Working With SQL Server Views

8.1. Using T-SQL to Create or Modify a View

8.2. Creating Views Based on Data in Multiple Tables

8.3. Views and Subqueries

8.4. Views and Outer Joins

8.5. Sorting View Results

8.6. Views and Top Values

8.7. Views and Functions

8.8. Using Views to Secure Data

8.9. Modifying Data in a View

8.10. Indexed Views

8.11. Optimizing the Views that You Build

Lesson 9. Designing SQL Server Stored Procedures

9.1. Stored Procedure Basics

9.2. Declaring and Working with Variables

9.3. Controlling the Flow

9.4. The SET NOCOUNT Statement

9.5. Using the @@Functions

9.6. Working with Parameters

Lesson 10. Enhancing the Stored Procedures that You Build

10.1. Working with Cursors

10.2. Errors and Error Handling

10.3. Modifying Data with Stored Procedures

10.4. Stored Procedures and Transactions

10.5. Stored Procedures and Temporary Tables

10.6. Stored Procedures and Cursors

10.7. Stored Procedures and Security

10.8. Debugging the Stored Procedures that You Build

Lesson 11. Building and Working with User-Defined Functions

11.1. User-defined Functions Explained

11.2. Scalar Functions

11.3. Inline Table-Valued Functions

11.4. Multi-Statement Table-Valued Functions

11.5. Functions, Views, and Stored Procedures

Lesson 12. Creating and Working with Triggers

12.1. Triggers Explained

12.2. Creating Triggers

12.3. INSTEAD OF Triggers

Lesson 13. Analyzing Performance

13.1. Determining the Query Execution Plan

13.2. Viewing Query Statistics

13.3. Using the SQL Profiler

Updates

Submit Errata

More Information

Unlimited one-month access with your purchase
Free Safari Membership