Learn how to use common T-SQL functions to process various types of data with ease. Soon, you’ll be able to modify textual data, perform calculations, round numbers up or down, change date and time formats, and even adjust time zone info!
T-SQL, which is used in Microsoft SQL Server, has many built-in functions. Understanding T-SQL functions is essential to anyone who wants to work with SQL Server. Data analysts use these functions to prepare accurate reports. SQL developers and software developers use them to write concise and readable queries. In both cases, T-SQL functions make it easier to get the right results!
The course offers 150 interactive exercises. You’ll read clear explanations on what each SQL Server function does, and then you’ll write your own T-SQL queries to solve realistic problems. The practice exercises are fun and engaging, and they’ll give you confidence in using T-SQL.
Try our T-SQL course and become proficient in SQL Server functions!
Plus, you'll get to practice your skills on 149 interactive exercises.
*The material in Common Functions in MS SQL Server is intended for intermediate users. To complete this course, you’ll need to know:
92%
off
Reg. price
$1372
Includes 36 courses Python Basics. Part 1, Python Basics. Part 2, Python Basics. Part 3, Python Data Structures in Practice, Built-in Algorithms in Python, Working with Strings in Python, SQL Basics, SQL Practice Set, SQL JOINs, Standard SQL Functions, Creating Basic SQL Reports, Window Functions, Revenue Trend Analysis in SQL, How to INSERT, UPDATE, and DELETE Data in SQL, Recursive Queries, Creating Tables in SQL, Statistics 101, SQL Basics in MS SQL Server, How to Insert, Update, or Delete Data in MS SQL Server, Common Functions in MS SQL Server, Revenue Trend Analysis in SQL Server, Creating Basic SQL Reports in SQL Server, Window Functions in MS SQL Server, Recursive Queries in MS SQL Server, GROUP BY Extensions in MS SQL Server, Introduction to Python for Data Science, How to Read and Write CSV Files in Python, How to Read and Write JSON Files in Python, SQL Basics in PostgreSQL, PostgreSQL JOINs, SQL Practice Set in PostgreSQL, Window Functions in PostgreSQL, Recursive Queries in PostgreSQL, Writing User-Defined Functions in PostgreSQL, PostGIS, How to Read and Write Excel Files in Python
Bundle price $99
36 hours left at this price!
81%
off
Reg. price
$240
Includes 6 courses SQL Basics in MS SQL Server, How to Insert, Update, or Delete Data in MS SQL Server, Common Functions in MS SQL Server, Window Functions in MS SQL Server, Recursive Queries in MS SQL Server, GROUP BY Extensions in MS SQL Server
Bundle price $45
36 hours left at this price!
In this course, we assume you know the basics of T-SQL: selecting information from a single table, joining queries, and grouping results. Take the test to see if you know SQL Server well enough to continue with the course.
0% completed 0 of 7 exercises done
Learn the basic SQL Server text functions to transform text values and make your reports look pretty.
0% completed 0 of 30 exercises done
Master numeric functions in SQL Server. Learn about the caveats of mathematical operators in T-SQL, various rounding functions, and computing proportions.
0% completed 0 of 27 exercises done
Study date and time functions and learn how to select events from a period of time.
0% completed 0 of 54 exercises done
Learn about SQL Server functions working with NULLs and other useful functions.
0% completed 0 of 19 exercises done
Check your knowledge of SQL Server functions in this quiz.
0% completed 0 of 12 exercises done
