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
Learn Intermediate SQL for Marketers and Product Managers
Perform data analysis on funnels, churn, and attribution. This course contains advanced SQL content for new Marketers and Product Managers.
Intro to SQL
Use SQL to create, access, and update tables of data in a relational database.
Business Intelligence Data Analyst
BI Data Analysts use Python and SQL to query, analyze, and visualize data — and Tableau and Excel to communicate findings.
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.
Data Scientist: Inference Specialist
Inference Data Scientists run A/B tests, do root-cause analysis, and conduct experiments. They use Python, SQL, and R to analyze data.
Analyze Data with SQL
Learn to analyze data with SQL and prepare for technical interviews.
There are no reviews yet.