We may earn an affiliate commission when you visit our partners.
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.
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.
Register for this course and see more details by visiting:
OpenCourser.com/course/gm6un2/t
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
Syllabus
Course Overview
Creating Measures with Aggregation Functions
Ranking Data with RANK and PARTITION
Aggregating and Summarizing Data with Functions
Read more
Substituting a Table Reference with a ROWSET Function
Query Data with Inline Queries and Scalar Functions
Query Data with Static Value Functions
Implementing IF Then Logic
Combining Queries with COALESCE
Calculating Values Using String Functions
Calculating Values Using Numeric Scalar Functions
Good to know
Good to know
Know what's good ,
what to watch for , 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
Save T-SQL Functions Playbook to your list so you can find it easily later:
Save
Save
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
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
Show steps
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
Show steps
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
Show steps
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
Show steps
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
Show steps
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
Show steps
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 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.
Data Analyst
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.
Software Engineer
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.
Business Analyst
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.
Data Scientist
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.
Statistician
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.
Financial Analyst
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.
Market Researcher
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.
Operations Research Analyst
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.
Computer Programmer
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.
Data Entry Clerk
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.
Technical Writer
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.
Quality Assurance Analyst
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.
Customer Service Representative
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.
Administrative Assistant
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.
For more career information including salaries, visit:
OpenCourser.com/course/gm6un2/t
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.
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.
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.
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.
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.
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.
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.
For more information about how these books relate to this course, visit:
OpenCourser.com/course/gm6un2/t
Share
Similar courses
Here are nine courses similar to
T-SQL Functions Playbook.
Combining and Filtering Data with T-SQL 2019
OpenCourser.com/course/c2opgf/combining
Combining and Filtering Data with T-SQL 2019
Most relevant
Understanding Query Optimization in SQL Server
OpenCourser.com/course/og3xif/understanding
Understanding Query Optimization in SQL Server
Most relevant
70-461, 761: Querying Microsoft SQL Server with Transact-SQL
OpenCourser.com/course/qq8nay/70
70-461, 761: Querying Microsoft SQL Server with Transact...
Most relevant
Querying Data Using T-SQL
OpenCourser.com/course/crrt4c/querying
Querying Data Using T-SQL
Most relevant
Troubleshooting Your First Low-performing T-SQL Query
OpenCourser.com/course/2hdz5x/troubleshooting
Troubleshooting Your First Low-performing T-SQL Query
Most relevant
SQL Mathematical Functions
OpenCourser.com/course/rufsn6/sql
SQL Mathematical Functions
Most relevant
SQL Date Time Functions
OpenCourser.com/course/71tyf6/sql
SQL Date Time Functions
Most relevant
Effective Query Analysis with SQL Server Tools
OpenCourser.com/course/2g9ivm/effective
Effective Query Analysis with SQL Server Tools
Most relevant
Become an SQL Developer: Learn (SSRS, SSIS, SSAS,T-SQL,DW)
OpenCourser.com/course/m4fmto/become
Become an SQL Developer: Learn (SSRS, SSIS, SSAS,T-SQL...
Most relevant
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:
Good to know
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
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 - 2024 OpenCourser