Overview
Context
Take your SQL Server programming to the next level with this Writing Functions and Stored Procedures in SQL Server course offered by Data Camp.
First, we demystify how to manipulate datetime data by performing temporal exploratory data analysis with the Washington DC BikeShare transactional dataset.
Then, you’ll 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.
Programme Structure
Chapters include:
- Temporal EDA, Variables & Date Manipulation
- Stored Procedures
- User Defined Functions
- NYC Taxi Ride Case Study
Key information
Duration
- Part-time
- 1 days
Start dates & application deadlines
Language
Delivered
Campus Location
- New York City, United States
Disciplines
Software Engineering Data Analytics View 179 other Short Courses in Data Analytics in United StatesWhat students do after studying
Academic requirements
We are not aware of any specific GRE, GMAT or GPA grading score requirements for this programme.
English requirements
We are not aware of any English requirements for this programme.
Other requirements
General requirements
Prerequisites:
- Functions for Manipulating Data in SQL Server
Tuition Fees
-
International Applies to you
Applies to youNon-residentsFree - Out-of-StateFree
-
Domestic
Applies to youIn-StateFree
Additional Details
This course can be accessed for free with the Data Camp Premium or Teams subscriptions