FeaturedUdemy
Writing Functions and Stored Procedures in SQL Server
4.9(366)27k studentsINTERMEDIATEEnglish
Korshub's take
Course Overview
Advance your SQL Server programming expertise by mastering modular database code. This intermediate course covers temporal data analysis, user-defined functions, and stored procedures through real-world transactional datasets.
Who Is This Course For?
Designed for intermediate SQL developers and database professionals who want to structure maintainable, reusable, and efficient database logic in T-SQL.
Key Takeaways
- Temporal Analysis: Perform datetime data manipulation using the Washington DC BikeShare dataset.
- Modular SQL Programming: Create, update, and execute user-defined functions and stored procedures following industry best practices.
- Practical Business Case: Apply modular SQL techniques to analyze New York City yellow taxi utilization and driver shift scheduling.
About this course
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.
Price
Free
This course is free to enrol.
Advertisement