Writing Functions and Stored Procedures in SQL Server
Master SQL Server programming by learning to create, update, and execute functions and stored procedures.
Comece O Curso Gratuitamente4 horas16 vídeos57 exercícios23.934 aprendizesDeclaração de Realização
Crie sua conta gratuita
ou
Ao continuar, você aceita nossos Termos de Uso, nossa Política de Privacidade e que seus dados são armazenados nos EUA.Treinar 2 ou mais pessoas?
Tentar DataCamp for BusinessAmado por alunos de milhares de empresas
Descrição do Curso
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.
Treinar 2 ou mais pessoas?
Obtenha acesso à sua equipe à plataforma DataCamp completa, incluindo todos os recursos.Nas seguintes faixas
SQL Server Developer
Ir para a trilhaSQL Server para administradores de banco de dados
Ir para a trilha- 1
Temporal EDA, Variables & Date Manipulation
GratuitoLearn how to do effective exploratory data analysis on temporal data, create scalar and table variables to store data, and learn how to execute date manipulation. This chapter will also cover the following SQL functions: DATEDIFF( ), DATENAME( ), DATEPART( ), CAST( ), CONVERT( ), GETDATE( ), and DATEADD( ).
Introduction to the course50 xpTransactions per day100 xpSeconds or no seconds?100 xpWhich day of week is busiest?100 xpFind the outliers100 xpVariables for datetime data50 xpDECLARE & CAST100 xpDECLARE a TABLE100 xpINSERT INTO @TABLE100 xpDate manipulation50 xpParameters matter with DATEDIFF50 xpFirst day of month100 xp - 2
User Defined Functions
This chapter will explain how to create, update, and execute user-defined functions (UDFs). You will learn about the various types of UDFs: scalar, inline, and multi-statement table-valued. You’ll also learn best practices.
Scalar user defined functions50 xpWhat was yesterday?100 xpOne in one out100 xpMultiple inputs one output100 xpTable valued UDFs50 xpInline TVF100 xpMulti statement TVF100 xpUDFs in action50 xpExecute scalar with select100 xpEXEC scalar100 xpExecute TVF into variable100 xpMaintaining user defined functions50 xpCREATE OR ALTER100 xpBest practices50 xp - 3
Stored Procedures
Learn how to create, update, and execute stored procedures. Investigate the differences between stored procedures and user defined functions, including appropriate scenarios for each.
Stored procedures50 xpCREATE PROCEDURE with OUTPUT100 xpOutput parameters vs. Return values50 xpOh CRUD!50 xpUse SP to INSERT100 xpUse SP to UPDATE100 xpUse SP to DELETE100 xpLet's EXEC!50 xpEXECUTE with OUTPUT parameter100 xpEXECUTE with return value100 xpEXECUTE with OUTPUT & return value100 xpTRY & CATCH those errors!50 xpYour very own TRY..CATCH100 xpCATCH an error100 xp - 4
NYC Taxi Ride Case Study
Apply your new skills in temporal EDA, user-defined functions, and stored procedures to solve a business case problem. Analyze the New York City taxi ride dataset to identify average fare per distance, ride count, and total ride time for each borough on each day of the week. And which pickup locations within the borough should be scheduled for each driver shift?
Case study EDA & imputation50 xpUse EDA to find impossible scenarios100 xpSPs vs UDFs50 xpMean imputation100 xpHot Deck imputation100 xpCase study UDFs50 xpCREATE FUNCTIONs100 xpTest FUNCTIONs100 xpFormatting tools50 xpLogical weekdays with Hot Deck100 xpFormat for Germany100 xpCase study stored procedures50 xpNYC Borough statistics SP100 xpNYC Borough statistics results100 xpPickup locations by shift100 xpPickup locations by shift results100 xpCongratulations!50 xp
Treinar 2 ou mais pessoas?
Obtenha acesso à sua equipe à plataforma DataCamp completa, incluindo todos os recursos.Nas seguintes faixas
SQL Server Developer
Ir para a trilhaSQL Server para administradores de banco de dados
Ir para a trilhacolaboradores
pré-requisitos
Functions for Manipulating Data in SQL ServerMeghan Kwartler
Ver MaisIT Consultant
O que os outros alunos têm a dizer?
Junte-se a mais de 15 milhões de alunos e comece Writing Functions and Stored Procedures in SQL Server hoje mesmo!
Crie sua conta gratuita
ou
Ao continuar, você aceita nossos Termos de Uso, nossa Política de Privacidade e que seus dados são armazenados nos EUA.