Interactive Course

Writing Functions and Stored Procedures in SQL Server

Master SQL Server programming by learning to create, update and execute functions and stored procedures.

  • 4 hours
  • 16 Videos
  • 57 Exercises
  • 3,490 Participants
  • 4,700 XP

Loved by learners at thousands of top companies:

3m-grey.svg
whole-foods-grey.svg
roche-grey.svg
forrester-grey.svg
paypal-grey.svg
mls-grey.svg

Course Description

Get ready to take your SQL Server programming to the next level! First, you will demystify how to manipulate datetime data by performing temporal exploratory data analysis with the Washington DC BikeShare transactional dataset. Then, you will master how to create, update & execute both User Defined Functions and Stored Procedures. You will learn the proper context for each modular programming tool as well as best practices. In the final chapter, you will apply all of your new skills to solve a real-world business case identifying the NYC yellow taxi utilization for each borough and identify which pickup locations should be scheduled for each driver shift.

  1. User Defined Functions

    This chapter will explain how to create, update and execute user defined functions. You will learn about the various types of UDFs; scalar, inline and multi statement table valued. It also includes best practice recommendations.

  2. NYC Taxi Ride Case Study

    Apply your new skills in temporal EDA , user defined functions and stored procedures to solve a business case problem. Analyze the NYC taxi ride dataset to identify average fare per distance, ride count & total ride time for each NYC borough on each day of the week. Which pickup locations within the borough should be scheduled for each of the driver shifts?

  1. 1

    Temporal EDA, Variables & Date Manipulation

    Free

    Learn how to do effective exploratory data analysis on temporal data, create scalar and table variables to store data as well as how to execute date manipulation. This chapter will also cover the following SQL functions DATEDIFF( ), DATENAME( ), DATEPART( ), CAST( ), CONVERT( ), GETDATE( ) and DATEADD( ).

  2. User Defined Functions

    This chapter will explain how to create, update and execute user defined functions. You will learn about the various types of UDFs; scalar, inline and multi statement table valued. It also includes best practice recommendations.

  3. Stored Procedures

    Chapter three will teach you how to create, update and execute stored procedures. You will learn the differences between stored procedures and user defined functions including appropriate scenarios to use each.

  4. NYC Taxi Ride Case Study

    Apply your new skills in temporal EDA , user defined functions and stored procedures to solve a business case problem. Analyze the NYC taxi ride dataset to identify average fare per distance, ride count & total ride time for each NYC borough on each day of the week. Which pickup locations within the borough should be scheduled for each of the driver shifts?

What do other learners have to say?

Devon

“I've used other sites, but DataCamp's been the one that I've stuck with.”

Devon Edwards Joseph

Lloyd's Banking Group

Louis

“DataCamp is the top resource I recommend for learning data science.”

Louis Maiden

Harvard Business School

Ronbowers

“DataCamp is by far my favorite website to learn from.”

Ronald Bowers

Decision Science Analytics @ USAA

Meghan Kwartler
Meghan Kwartler

IT Consultant

As an IT consultant, Meghan has helped business and technology leaders implement IT systems to improve business outcomes. Most often she works at the intersection of technology and senior business leaders helping both get the most value from their respective operation. Meghan has worked in various industries including manufacturing, marketing, and financial services. She holds a Management Information Systems degree from The Ohio State University. SQL is one of her favorite tools so she is grateful to share this knowledge with Datacamp students.

See More
Collaborators
  • Chester Ismay

    Chester Ismay

  • Amy Peterson

    Amy Peterson

Icon Icon Icon professional info