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
  • 4,065 Participants
  • 4,700 XP

Loved by learners at thousands of top companies:

ebay-grey.svg
mercedes-grey.svg
forrester-grey.svg
deloitte-grey.svg
dell-grey.svg
ikea-grey.svg

Course Description

Take your SQL Server programming to the next level. First, we demystify how to manipulate datetime data by performing temporal exploratory data analysis with the Washington DC BikeShare transactional dataset. Then, you’ll master how to create, update, and execute user-defined functions and stored procedures. You will learn the proper context for each modular programming tool and best practices. In the final chapter, you will apply all of your new skills to solve a real-world business case identifying the New York City yellow taxi utilization for each borough, and 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 (UDFs). You will learn about the various types of UDFs: scalar, inline, and multi-statement table-valued. You’ll also learn best practices.

  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 New York City taxi ride dataset to identify average fare per distance, ride count, and total ride time for each borough on each day of the week. And which pickup locations within the borough should be scheduled for each driver shift?

  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, and learn 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 (UDFs). You will learn about the various types of UDFs: scalar, inline, and multi-statement table-valued. You’ll also learn best practices.

  3. Stored Procedures

    Learn how to create, update, and execute stored procedures. Investigate the differences between stored procedures and user defined functions, including appropriate scenarios for 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 New York City taxi ride dataset to identify average fare per distance, ride count, and total ride time for each borough on each day of the week. And which pickup locations within the borough should be scheduled for each driver shift?

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