Writing Functions and Stored Procedures in SQL Server

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.