Information Technology
Hands on Training icon
Hands On Training
Hands on Training icon

Writing Functions and Stored Procedures in SQL Server

Course Cover

5

(3)

compare button icon

Course Features

icon

Duration

4 hours

icon

Delivery Method

Online

icon

Available on

Limited Access

icon

Accessibility

Mobile, Desktop, Laptop

icon

Language

English

icon

Subtitles

English

icon

Level

Intermediate

icon

Teaching Type

Self Paced

icon

Video Content

4 hours

Course Description

Learn SQL Server programming at the highest level. First, we will show you how to manipulate datetime data by using temporal exploratory analysis with the Washington DC BikeShare transactional database. Next, we'll show you how to create and update user-definable functions. You will learn the context and best practices of each modular programming tool. In the final chapter, you will learn how to apply your new skills in solving real-world problems. This will include determining the pickup points for each driver's shift and identifying the New York City yellow taxi usage per borough.

Course Overview

projects-img

Virtual Labs

projects-img

International Faculty

projects-img

Case Based Learning

projects-img

Post Course Interactions

projects-img

Case Studies,Hands-On Training,Instructor-Moderated Discussions

Skills You Will Gain

Prerequisites/Requirements

check-card-img

Functions for Manipulating Data in SQL Server

What You Will Learn

check-card-img

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

check-card-img

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

Course Instructors

Author Image

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 le...

Course Reviews

Average Rating Based on 3 reviews

5.0

100%

Course Cover