We may earn an affiliate commission when you visit our partners.

T-SQL Functions Playbook

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

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

Show steps

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

Show steps

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

Show steps

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

Show steps

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

Show steps

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

Show steps

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.

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

$$$

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.

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

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

$$$

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