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.
Passionate about Business Intelligence and delivering knowledge and insight to support better decisions. An advocate of Self-Service Reporting, Analytics Data Visualisation.
Andi has delivered face to face Business Intelligence training covering topics such as Report Design, Dimensional modeling, and Data Visualisation.
Andi is a keen cyclist and amateur cook and lives with his wife in Southern Spain.
Course Overview Hi, everyone. My name is Andrew Max. Wiggle on. Welcome to my course. T s u L functions Playbook. I'm a data specialist and I use the t SQL language to structure and analyze data. T s u l offers an array of powerful functions that enabled the initiated to extract meaning from data stored inside SQL server databases. I introduce you to aggregation on ranking functions that will enable you to elevate the data to something concise and insightful. Every function you learn will provide you with the solution a common analytical problem. Everything you learn along the way and empower you to take control of your data. Some of the key topics that I explore with t SQL are creating measures with aggregation functions, implementing logical expressions that evaluate transform columns for every road returned by a query bedding one query inside another within line views and correlative sub queries putting out parts of dates and text fields rounding on former numbers as forming content toe meaning By the end of the course, you will know how to use the analytical functions provided by the tea SQL language. Before beginning the course, you should have a working knowledge of the tea SQL language, the rudimentary, the standing of Data Analytics. I hope that you will join me on this journey to learn how to use analytical functions with T SQL Functions Playbook Course Pluralsight.