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 …
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 Balterhas 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
What You Will Learn
Who Should Take This Course
Course Requirements
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
Introduction
T-SQL Fundamentals LiveLessons: Introduction
Lesson 1: Introduction to Databases
Learning Objectives
1.1 What is a Database?
1.2 Creating a Database
1.3 Creating a Table
1.4 Creating Check Constraints
1.5 Establishing Relationships between Tables
Lesson 2: T-SQL Basics
Learning Objectives
2.1 The SELECT Statement
2.2 The FROM Keyword
2.3 The WHERE Clause
2.4 IN and BETWEEN
2.5 The ORDER BY Clause
Lesson 3: TSQL - Beyond the Basics
Learning Objectives
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
Lesson 4: Join Types
Learning Objectives
4.1 Inner Joins
4.2 Outer Joins
4.3 Full Joins
4.4 Self Joins
Lesson 5: Specialized T-SQL Queries
Learning Objectives
5.1 Union Queries
5.2 Subqueries
Lesson 6: Modifying Data with Action Queries
Learning Objectives
6.1 The UPDATE Statement
6.2 The INSTER Statement
6.3 The SELECT INTO Statement
6.4 The DELETE Statement
6.5 The TRUNCATE Statement
Lesson 7: T-SQL Functions
Learning Objectives
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
Learning Objectives
8.1 Creating a Simple 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
Lesson 9: Designing SQL Server Stored Procedures
Learning Objectives
9.1 Stored Procedures 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 Paramaters
Lesson 10: Enhancing the Stored Procedures that You Build
Learning Objectives
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
Lesson 11: Building and Working with User-Defined Functions
Learning Objectives
11.1 User-defined Functions Explained
11.2 Scalar Functions
11.3 Inline Table-Valued Functions
11.4 Multi-Statement Table-Valued Functions
Lesson 12: Creating and Working with Triggers
Learning Objectives
12.1 Triggers Explained
12.2 Creating Triggers
Lesson 13: Analyzing Performance
Learning Objectives
13.1 Determining the Query Execution Plan
13.2 Viewing the Query Statistics
13.3 Using the SQL Profiler
Summary
T-SQL Fundamentals LiveLessons: Summary