10最好的T-SQL教程推荐

“Session 1 – Let’s begin, and let’s download SQL Server
Session 1 – Starting SQL Server
Session 1 – Creating tables – First pass
Session 1 – Number types and functions
Session 1 – String data types and functions
Session 1 – Date data types and functions
Session 1 – Conclusion
Welcome to Session 2
Session 2 – Creating and querying part of a table
Session 2 – Summarising and ordering data
Session 2 – Adding a second table
Session 2 – Find missing data, and delete and update data
End of Session 2
Session 3 – Introduction
Session 3 – Objective 4 – Create and modify constraints (simple statements)
Session 3 – Objectives 2 and 3: Views
Session 3 – Objective 5: Create and alter DML triggers
Session 3 – Conclusion
Session 4 – Introduction
Session 4 – Objective 13: Combine datasets
Session 4 – Objective 11 – Create and alter stored procedures (simple statements
Session 4 – Objective 18a – Implement try/catch/throw
End of Session 4!
Session 5 – Introduction
Session 5 – Objective 9: Implement aggregate queries
Session 5 – Objective 9d: Ranking functions
Session 5 – Objective 9a: New analytic functions
Section 5 – Objective 9b: Grouping sets
Session 5 – Objective 9c: Spatial aggregates
End of Session 5
Session 6 – Introduction
Session 6 – Objective 7: Sub-queries
Session 6 – Objective 7e: WITH statement
Session 6 – Objective 7b: PIVOTing and UNPIVOTing
Session 6 – Objective 7d: CTE statement
Session 6 – Objective 14: Functions
Session 6 – Objectives 6b and 6c: Synonyms and Dynamics
Session 6 – Objectives 8c: GUIDs; and Sequences
Session 6 – Objective 10: Query and manage XML data – converting tables to XML
Session 6 – Objective 10: Shredding XML data
Session 6 – Objective 10: Other XML considerations
Session 6 – Manipulating JSON data (SQL Server 2016 onwards)
Session 6 – Temporal Tables
Session 6 – Conclusion
Session 7 – Introduction
Session 7 – Manage transactions
Session 7 – Indexes
Session 7 – Optimise queries
Session 7 – Dynamic Management Views and Functions
Session 7 – Evaluate the use of row-based operations vs. set-based operations
Congratulations
Bonus – Installing SQL Server 2016 Developer Edition
Bonus – Installing SQL Server 2014 Developer Edition (for Windows 7 and Vista)
Bonus Lecture”

Become a Production SQL Server Database Administrator

Introduction
Writing Transact-SQL Overview
Data Manipulation Language
Functions
More Advanced Transact-SQL
Conclusion

Getting Started
Miscellaneous Functions ( Transact-SQL )
Transact-SQL (T-SQL) Aggregate Functions
Ranking Functions (Transact-SQL)
Analytic Functions (Transact-SQL)
SET OPERATORS ( Transact-SQL)
Stored Procedures (Transact-SQL)

Introduction
Setup Your Learning Lab (Optional)
Stored Procedure Walk Through
Debugging Stored Procedures
Programming Concepts
Error Catching
Creating and Executing Stored Procedures
Cursors and Transactions
Wrap-up

“Introduction
Module1 – SSMS & DML Tricks , Solution Files and Identity etc
Module 2 – Window Functions (Ranking , Aggregate and Analytical Functions)
Module 3 – CTE , Recurssive CTE, Coalesce Function & Merge Commands etc
Module 4 – Stored Procedure, Error Handling , Batch ,Pagination and Synonyms etc”

Introduction
Getting Started
Working With Data
Refining SQL
Functions and Stored Procedures
Built-In Functions and SQL Tips
Conclusion

Introduction to T-SQL for Data Analysts using Microsoft SQL Server

Introduction To Some Basic Database Concepts
Setting Up T-SQL Development Test Environment
Retrieving Data with T-SQL
T-SQL COMMANDS
Using T-SQL To Query Multiple Tables
Filtering Records from a Table with T-SQL
Sorting Returned Records
Using Aggregate Functions with T-SQL Query
Modifying Data

Course Overview
Advanced Tips
Conclusion