Writing Functions and Stored Procedures in SQL Server
|
Master SQL Server programming by learning to create, update, and execute functions and stored procedures.
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.
User Reviews
Be the first to review “Writing Functions and Stored Procedures in SQL Server”
Related Products
Intermediate SQL
Accompanied at every step with hands-on practice queries, this course teaches you everything you need to know to analyze data using your own SQL code today!
Data Manipulation in SQL
Master the complex SQL queries necessary to answer a wide variety of data science questions and prepare robust data sets for analysis in PostgreSQL.
Full-Stack Engineer
A full-stack engineer can get a project done from start to finish, back-end to front-end.
Design Databases With PostgreSQL
Learn how to query SQL databases and design relational databases to efficiently store large quantities of data.
How to Transform Tables with SQL
Practice more SQL in this course that covers how to manipulate and transform data.
Data Scientist Interview Preparation
Prepare for the data science interview process, from navigating job postings to passing the technical interview.
There are no reviews yet.