Writing Functions and Stored Procedures in SQL Server

Name: Writing Functions and Stored Procedures in SQL Server
Brand: Careervira
Price: 125 GBP
Availability: InStock
Rating: 5.0 (3 reviews)

DataCamp

(3)

Course Report

Find detailed report of this course which helps you make an informed decision on its relevance to your learning needs. Find out the course's popularity among Careervira users and the job roles that would find the course relevant for their upskilling here. You can also find how this course compares against similar courses and much more in the course report.

Visit Course Report

Course Features

Duration

4 hours

Delivery Method

Online

Available on

Limited Access

Accessibility

Mobile, Desktop, Laptop

Language

English

Subtitles

English

Level

Intermediate

Teaching Type

Self Paced

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

Virtual Labs

International Faculty

Case Based Learning

Post Course Interactions

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

Skills You Will Gain

Prerequisites/Requirements

Functions for Manipulating Data in SQL Server

What You Will Learn

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

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 Content

Expand all sections

Module 1: Temporal EDA, Variables Date Manipulation

Module 2: User Defined Functions

Module 3: Stored Procedures

Module 4: NYC Taxi Ride Case Study

Course Instructors

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%