Writing Functions and Stored Procedures in SQL Server

Description

In this course, you will :

• Learn how to perform effective exploratory data analysis on temporal data, how to create scalar and table variables to store data, and how to manipulate dates.
• DATEDIFF(), DATENAME(), DATEPART(), CAST(), CONVERT(), GETDATE(), and DATEADD are also covered ( ).
• how to write, modify, and run user-defined functions (UDFs).
• Learn about the different types of UDFs, including scalar, inline, and multi-statement table-valued UDFs. You will also learn about best practises.
• Discover how to create, update, and run stored procedures.
• Examine the distinctions between stored procedures and user-defined functions, as well as the appropriate scenarios for each.

Syllabus :

• Temporal EDA, Variables & Date Manipulation
• User Defined Functions
• Stored Procedures
• NYC Taxi Ride Case Study