Skip to main content
Grzegorz Gąsiewski avatar

Grzegorz Gąsiewski has completed

Writing Functions and Stored Procedures in SQL Server

Start course For Free
4 hours
4,700 XP
Statement of Accomplishment Badge

Loved by learners at thousands of companies


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.
For Business

GroupTraining 2 or more people?

Get your team access to the full DataCamp library, with centralized reporting, assignments, projects and more
Try DataCamp for BusinessFor a bespoke solution book a demo.
  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( ).

    Play Chapter Now
    Introduction to the course
    50 xp
    Transactions per day
    100 xp
    Seconds or no seconds?
    100 xp
    Which day of week is busiest?
    100 xp
    Find the outliers
    100 xp
    Variables for datetime data
    50 xp
    DECLARE & CAST
    100 xp
    DECLARE a TABLE
    100 xp
    INSERT INTO @TABLE
    100 xp
    Date manipulation
    50 xp
    Parameters matter with DATEDIFF
    50 xp
    First day of month
    100 xp
  2. 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.

    Play Chapter Now
  3. 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?

    Play Chapter Now
For Business

GroupTraining 2 or more people?

Get your team access to the full DataCamp library, with centralized reporting, assignments, projects and more

datasets

Trip DataBike Share Data

collaborators

Collaborator's avatar
Chester Ismay
Collaborator's avatar
Amy Peterson
Meghan Kwartler HeadshotMeghan Kwartler

IT Consultant

See More

Join over 14 million learners and start Writing Functions and Stored Procedures in SQL Server today!

Create Your Free Account

GoogleLinkedInFacebook

or

By continuing, you accept our Terms of Use, our Privacy Policy and that your data is stored in the USA.