Congratulations!

Writing Functions and Stored Procedures in SQL Server

Meghan Kwartler

IT Consultant

Continued practice

• Download
  • CapitalBikeShare
  • YellowTripTaxi

Accomplishments

• EDA for distributed transactional data
• CONVERT(), CAST(), DATEDIFF(), DATENAME(), DATEADD(), DATEPART(), GETDATE()
• DECLARE & SET scalar variables
• DECLARE & INSERT INTO table variables
• CREATE, EXEC, UPDATE, DROP user defined functions (scalar, ITVF, MSTVF)
• CREATE, EXEC, UPDATE, DROP stored procedures
• Solved real world business problems

Next Steps

• Error Handling in stored procedures with TRY CATCH THROW
• FORMAT()
• Data imputation

• SQL for Exploratory Data Analysis
• Intermediate SQL Server
• Intermediate SQL

Good Luck!

Writing Functions and Stored Procedures in SQL Server