OpenCourser brand icon
Sign in
We may earn an affiliate commission when you visit our partners.
Course Discontinued We've found some alternatives for you:

Top Active Alternatives

T-SQL Functions Playbook is no longer accepting new enrollments. We've matched the highest-rated active courses in this subject:

Read Reviews → Enroll Active
Coursera ★ 4.9
Splunk Query Language and Data Analysis
By George Washington University
Read Reviews → Enroll Active
Coursera ★ 4.9
Practical SAS Programming and Certification Review
By Coursera - DELETE
Read Reviews → Enroll Active
Pluralsight logo

T-SQL Functions Playbook

Andrew McSwiggan

In this course you will explore the functions of the T-SQL language that support data access, manipulation, aggregation, and analysis. Completing this course will provide you with the skills to shape and analyze data in SQL Server.

Read more

In this course you will explore the functions of the T-SQL language that support data access, manipulation, aggregation, and analysis. Completing this course will provide you with the skills to shape and analyze data in SQL Server.

As a data professional you often need to write queries to summarize and gain insight from data. In this course, T-SQL Functions Playbook, you will learn how to use powerful functions inside your T-SQL queries to reshape and interrogate data. First, you will learn how to aggregate data with aggregation functions. Next, you will see how to merge data from multiple queries from within and outside of your local SQL Server environment. Finally, you will discover how to apply logic calculations and formatting to transform data and make it more readable. When you have completed this course, you will have the skills to take control of and analyze your data. Software required: SQL Server Management Studio.

This course is no longer available. Find something similar by browsing:
T-SQL Functions Data Aggregation Data Manipulation SQL Server Data Analysis Data Summarization Inline Queries

What's inside

Syllabus

Course Overview
Creating Measures with Aggregation Functions
Ranking Data with RANK and PARTITION
Aggregating and Summarizing Data with Functions
Read more

Traffic lights

Read about what's good
what should give you pause
and possible dealbreakers
Teaches essential data access, manipulation, aggregation, and analysis functions within T-SQL
Suitable for data professionals seeking to enhance their SQL Server data shaping and analysis skills
Provides practical hands-on experience through exercises and real-world examples
Covers industry-standard T-SQL functions, ensuring relevance to real-world applications

Save this course

Create your own learning path. Save this course to your list so you can find it easily later.
Save

Reviews summary

T-sql functions: clear & practical playbook

According to students, the "T-SQL Functions Playbook" is a largely positive and highly recommended course for data professionals aiming to enhance their skills. Learners frequently highlight the instructor's clear explanations and the practical, real-world examples that make complex T-SQL functions understandable and directly applicable. The course is praised for its well-structured content and useful hands-on labs and demos. While some learners suggest the pace can be fast and might wish for deeper dives into certain advanced topics or more challenging exercises, the overall consensus is that it provides a solid and practical foundation for mastering T-SQL functions.
Demos and labs are highly effective for consolidating understanding.
"I especially appreciated the hands-on labs, which really helped solidify my understanding."
"The demonstrations were clear..."
"The demos are very useful."
Content is directly applicable to real-world data analysis tasks.
"The content is directly applicable to my job. I learned new ways to manipulate and analyze data efficiently."
"Good course, especially for understanding the practical application of T-SQL functions."
"The examples were spot on, and I immediately started using what I learned at work."
Instructor excels at making complex topics accessible.
"The instructor explains complex concepts with incredible clarity and provides practical, real-world examples."
"Absolutely brilliant!... I found the explanations concise and the flow logical."
"Very clear and practical. This course demystified many T-SQL functions for me."
Could benefit from more challenging exercises and advanced context.
"I wish there were more challenging exercises beyond the guided examples."
"My only minor gripe is that some of the advanced examples could have had more context or alternative scenarios."
"Some of the exercises were a bit too simple."
Some found the pace fast, desiring more in-depth coverage.
"I found the pace a bit too fast in some sections, especially the more complex ones."
"While the instructor is knowledgeable, I felt some topics could have been explored in greater depth."
"It touched on many functions but didn't always go deep enough for me."

Activities

Be better prepared before your course. Deepen your understanding during and after it. Supplement your coursework and achieve mastery of the topics covered in T-SQL Functions Playbook with these activities:
Gather your favorite T-SQL resources
Centralize your learning materials by creating a compilation of resources, such as tutorials, articles, and code snippets, that you can easily access and reference during the course.
Show steps
  • Bookmark or save useful online resources
  • Organize your resources into a folder or notebook
Read 'SQL Server T-SQL Recipes' by Itzik Ben-Gan
Supplement your learning by reading a respected book on T-SQL, providing you with additional insights and a deeper understanding of the concepts.
View Inside Microsoft® SQL Server® 2008: T-SQL... on Amazon
Show steps
  • Obtain a copy of the book
  • Read and study the relevant chapters
  • Take notes and highlight important concepts
Practice SQL queries
Get a head start and prepare for successful course participation by working on SQL queries and becoming comfortable with basic usage.
Browse courses on Aggregation Functions
Show steps
  • Write a query to aggregate data using aggregation functions
  • Write a query to rank data using RANK and PARTITION Functions
  • Write a query to summarize data using functions
Three other activities
Expand to see all activities and additional details
Show all six activities
Join a study group for T-SQL
Enhance your learning through collaboration by joining a study group where you can discuss concepts, share knowledge, and work together on exercises.
Show steps
  • Find a study group or create your own
  • Meet regularly to discuss course material and work on assignments
  • Collaborate on projects and share your insights
Build a data visualization dashboard
Demonstrate your proficiency in data analysis by creating a comprehensive dashboard that showcases your skills in extracting meaningful insights from data.
Browse courses on Data Access
Show steps
  • Gather and clean your data
  • Design your dashboard, including visualizations and metrics
  • Develop the dashboard using SQL Server Management Studio
  • Present your dashboard to stakeholders
Develop a data-driven application
Showcase your ability to apply your T-SQL skills by developing a real-world application that leverages data to solve a specific problem.
Browse courses on Data Access
Show steps
  • Identify a problem or opportunity that can be addressed with data
  • Design and develop your application using T-SQL
  • Test and deploy your application

Career center

Learners who complete T-SQL Functions Playbook will develop knowledge and skills that may be useful to these careers:
Database Administrator
Database Administrators ensure that databases are running smoothly, securely, and efficiently. They handle database backups, performance monitoring, and data security. This course can help aspiring Database Administrators gain a solid understanding of T-SQL functions, which are essential for data manipulation and analysis. By learning how to use these functions effectively, individuals can improve their ability to manage and maintain databases.
See salaries and explore the career path for Database Administrator
Data Analyst
Data Analysts use data to solve business problems. They collect, clean, and analyze data to identify trends and patterns. This course can help aspiring Data Analysts enhance their skills in data analysis by providing them with a comprehensive understanding of T-SQL functions. By learning how to use these functions effectively, individuals can become more proficient in extracting insights from data and communicating their findings to stakeholders.
See salaries and explore the career path for Data Analyst
Software Engineer
Software Engineers design, develop, and maintain software applications. They use programming languages and tools to create software that meets user needs. This course may be useful for aspiring Software Engineers who want to develop their skills in data manipulation and analysis. By learning how to use T-SQL functions effectively, individuals can enhance their ability to work with data and build more robust software applications.
See salaries and explore the career path for Software Engineer
Business Analyst
Business Analysts bridge the gap between business and technology. They analyze business needs and translate them into technical requirements. This course can help aspiring Business Analysts gain a better understanding of data analysis and manipulation. By learning how to use T-SQL functions effectively, individuals can improve their ability to analyze data and make informed recommendations to stakeholders.
See salaries and explore the career path for Business Analyst
Data Scientist
Data Scientists use data to solve complex problems. They develop and apply statistical and machine learning models to extract insights from data. This course may be useful for aspiring Data Scientists who want to enhance their skills in data manipulation and analysis. By learning how to use T-SQL functions effectively, individuals can become more proficient in working with data and developing predictive models.
See salaries and explore the career path for Data Scientist
Statistician
Statisticians collect, analyze, and interpret data. They use statistical methods to draw conclusions from data and make predictions. This course may be useful for aspiring Statisticians who want to develop their skills in data manipulation and analysis. By learning how to use T-SQL functions effectively, individuals can enhance their ability to work with data and apply statistical techniques.
See salaries and explore the career path for Statistician
Financial Analyst
Financial Analysts use financial data to make investment recommendations. They analyze financial statements, market trends, and economic data to identify investment opportunities. This course may be useful for aspiring Financial Analysts who want to develop their skills in data analysis and manipulation. By learning how to use T-SQL functions effectively, individuals can enhance their ability to analyze financial data and make informed investment recommendations.
See salaries and explore the career path for Financial Analyst
Market Researcher
Market Researchers collect and analyze data about markets and consumers. They use this data to help businesses understand their customers and make marketing decisions. This course may be useful for aspiring Market Researchers who want to develop their skills in data analysis and manipulation. By learning how to use T-SQL functions effectively, individuals can enhance their ability to analyze market data and make informed marketing recommendations.
See salaries and explore the career path for Market Researcher
Operations Research Analyst
Operations Research Analysts use mathematical and analytical methods to solve business problems. They develop and apply models to optimize processes and make decisions. This course may be useful for aspiring Operations Research Analysts who want to develop their skills in data manipulation and analysis. By learning how to use T-SQL functions effectively, individuals can enhance their ability to work with data and develop optimization models.
See salaries and explore the career path for Operations Research Analyst
Computer Programmer
Computer Programmers write and maintain computer programs. They use programming languages to create software that meets user needs. This course may be useful for aspiring Computer Programmers who want to develop their skills in data manipulation and analysis. By learning how to use T-SQL functions effectively, individuals can enhance their ability to work with data and build more robust software applications.
See salaries and explore the career path for Computer Programmer
Data Entry Clerk
Data Entry Clerks enter data into computer systems. They ensure that data is accurate and complete. This course may be useful for aspiring Data Entry Clerks who want to develop their skills in data manipulation and analysis. By learning how to use T-SQL functions effectively, individuals can enhance their ability to work with data and ensure its accuracy and completeness.
See salaries and explore the career path for Data Entry Clerk
Technical Writer
Technical Writers create and maintain technical documentation. They write user manuals, training materials, and other documents that explain technical concepts. This course may be useful for aspiring Technical Writers who want to develop their skills in data manipulation and analysis. By learning how to use T-SQL functions effectively, individuals can enhance their ability to understand and explain technical concepts.
See salaries and explore the career path for Technical Writer
Quality Assurance Analyst
Quality Assurance Analysts test software to ensure that it meets quality standards. They identify and report bugs and defects. This course may be useful for aspiring Quality Assurance Analysts who want to develop their skills in data manipulation and analysis. By learning how to use T-SQL functions effectively, individuals can enhance their ability to work with data and identify potential problems.
See salaries and explore the career path for Quality Assurance Analyst
Customer Service Representative
Customer Service Representatives provide support to customers. They answer questions, resolve problems, and provide information. This course may be useful for aspiring Customer Service Representatives who want to develop their skills in data manipulation and analysis. By learning how to use T-SQL functions effectively, individuals can enhance their ability to work with data and provide better support to customers.
See salaries and explore the career path for Customer Service Representative
Administrative Assistant
Administrative Assistants provide administrative support to organizations. They perform a variety of tasks, such as scheduling appointments, answering phones, and managing email. This course may be useful for aspiring Administrative Assistants who want to develop their skills in data manipulation and analysis. By learning how to use T-SQL functions effectively, individuals can enhance their ability to work with data and provide better support to their organizations.
See salaries and explore the career path for Administrative Assistant

Reading list

We've selected six books that we think will supplement your learning. Use these to develop background knowledge, enrich your coursework, and gain a deeper understanding of the topics covered in T-SQL Functions Playbook.
Cover image
T-SQL Fundamentals
Save
Provides a comprehensive overview of T-SQL fundamentals, covering topics such as data types, operators, control flow, and functions. It valuable resource for learners who are new to T-SQL or who want to refresh their knowledge of the basics.
T-SQL Fundamentals (Developer Reference)
Paperback
$$
T-SQL Fundamentals (Developer Reference)
Paperback
$$
Microsoft SQL Server 2012 T-SQL Fundamentals
Paperback
$$
Microsoft SQL Server 2012 T-SQL Fundamentals...
Kindle Edition
$$
Microsoft SQL Server 2012 T-SQL Fundamentals by...
Unknown Binding
$$$
Cover image
Inside XML
Save
Provides a comprehensive overview of T-SQL fundamentals. It valuable resource for learners who are new to T-SQL or who want to refresh their knowledge of the basics.
Inside XML
Paperback
Check
Inside XML
Kindle Edition
Check
Cover image
Programming Hive
Save
Provides a comprehensive overview of T-SQL programming for developers. It valuable resource for learners who want to learn how to develop custom database solutions.
Programming Hive: Data Warehouse and Query Language...
Paperback
$$
Programming Hive: Data Warehouse and Query Language...
Kindle Edition
$$
Cover image
SQL Server T-SQL Recipes
Save
Provides a collection of practical T-SQL recipes that solve common database problems. It valuable resource for learners who want to learn how to solve real-world database problems.
SQL Server T-SQL Recipes
Kindle Edition
$$
SQL Server 2012 T-SQL Recipes: A Problem-Solution...
Paperback
$$$
Cover image
T-SQL Querying
Save
Provides a collection of practical Transact-SQL solutions for common database development tasks. It valuable resource for learners who want to learn how to solve real-world database problems.
T-SQL Querying (Developer Reference)
Paperback
$$$
T-SQL Querying (Developer Reference)
Kindle Edition
$$
Cover image
MySQL Crash Course
Save
Provides a quick and easy introduction to T-SQL. It valuable resource for learners who are new to T-SQL or who want to get up to speed quickly.
MySQL Crash Course
Paperback
$$
MySQL Crash Course
Kindle Edition
$$
(中文) MySQL必知必会 (图灵程序设计丛书 97) (Chinese Edition)
Kindle Edition
$
(中文) MySQL Crash Course(Chinese Edition)
Paperback
$$

Share

Help others find this course page by sharing it with your friends and followers:
Facebook
LinkedIn
Reddit
X
Link
Email

Similar courses

Here are nine courses similar to T-SQL Functions Playbook.
Building a Company’s database using MySQL and SQL
Most relevant
Preparing for the SAS Programming Certification Exam
Most relevant
Introduction to SQL Window Functions
Most relevant
Data Analysis Using SQL
Most relevant
The Ultimate SQL Bootcamp: Zero to Hero in 9 Hours
Most relevant
Mastering Data Analysis with Pandas: Learning Path Part 3
Most relevant
Introduction to SQL and relational databases
Most relevant
Tableau Fundamentals
Most relevant
Applying Python for Data Analysis
Most relevant

Pluralsight Buyer Protection & Guarantee

Verified partner policies & purchase protections

Enterprise Technology Platform
Free Trial & Audit

10-Day Free Trial

10-day free trial (up to 200 minutes of content) with access to the Skills video library and skill assessments. Cancel before day 10 to avoid automatic conversion.

Return & Refund Policy

Cancel Anytime (Non-Refundable Once Billed)

Cancel easily online anytime before the 10-day trial expires to prevent billing. Once subscription fees are paid, individual subscriptions are non-refundable (cancellation stops future renewals).

Buyer Protections

Verified Academic & Industry Partner

Skill IQ and Role IQ diagnostic benchmark assessments, hands-on lab environments, and curated learning paths designed by technology leaders.

Key Purchase Protections
10-day free trial on individual Skills plans
Skill IQ assessments to benchmark proficiency
Cancel anytime online before trial ends without fees
Hands-on interactive labs and enterprise-grade tech content
OpenCourser Verified Partner Policy details last reviewed: 2026-10-22
Course image
Time
184 hours
Level
Intermediate
Via
Pluralsight
Instructor
Andrew McSwiggan
Language
English
This course belongs to a collection called Querying Data with T-SQL from SQL Server. It's comprised of seven courses:
  1. Querying Data Using T-SQL
  2. Combining and Filtering Data with T-SQL 2019
  3. T-SQL Data Manipulation Playbook
  4. Capturing Logic with Stored Procedures in T-SQL
  5. Querying JSON, XML, and Temporal Data with T-SQL
  6. Handling Errors in T-SQL
  7. T-SQL Functions Playbook (viewing)
Traffic lights
Read about what's good
what should give you pause
and possible dealbreakers
Teaches essential data access, manipulation, aggregation, and analysis functions within T-SQL
Suitable for data professionals seeking to enhance their SQL Server data shaping and analysis skills
Provides practical hands-on experience through exercises and real-world examples
Covers industry-standard T-SQL functions, ensuring relevance to real-world applications
Share this
Share to help others discover this course.
Facebook LinkedIn X Reddit Link Email
Begin learning today
This course is currently discontinued or unavailable. See active alternatives above.
Course Unavailable
Save for later
Add this course to your list. Find it anytime.
Save
Our mission

OpenCourser helps millions of learners each year. People visit us to learn workspace skills, ace their exams, and nurture their curiosity.

Our extensive catalog contains over 50,000 courses and twice as many books. Browse by search, by topic, or even by career interests. We'll match you to the right resources quickly.

Find this site helpful? Tell a friend about us.

Affiliate disclosure

We're supported by our community of learners. When you purchase or subscribe to courses and programs or purchase books, we may earn a commission from our partners.

Your purchases help us maintain our catalog and keep our servers humming without ads.

Thank you for supporting OpenCourser.

© 2016 - 2025 OpenCourser