This course will show you how to create each of these tools, and the solutions that each of them propose to daily problems. Detonators, stored procedures and functions can help you not to repeat code and make it simpler.
This product is no longer in stock
Information from: SQL Server: Triggers
SQL Server: Triggers, functionality and usability
SQL Server, the Microsoft database manager, has triggers, stored procedures and functions that allow you to make a useful database application. This course will show you how to create each of these tools, and the solutions that each of them propose to daily problems. The detonators, the stored procedures and the functions can help you not to repeat code and make it simpler.
Configuration and basics of the SQL Server course
This course has exercises, files and an environment that we need to complete them. Let's see along several lessons how to raise our environment, the configuration and a review of the syntax and control structures of T-SQL.
Technical requirements for the SQL Server course 00:36
The files of the SQL Server course 00:27
Creating the local environment with SQL Server 01:42
Variables and SET in T-SQL 03:12
Control structures in T-SQL 04:14
True, false and null values in SQL Server 02:05
SQL Server functions
SQL Server has a series of tools that can help us abstract a very complex business rule or simply create some functionality that we use a lot with the help of functions. While it already has some built-in functions, we can also create our own custom functions.
What are the functions of SQL Server 02:34
Built-in functions in SQL Server 06:50
Personalized scalar functions 04:58
Custom ITVF functions (Table-Valued Function) 03:47
Custom Functions MTVF (Table-Valued Function) 05:58
Implementation of SQL Server Triggers
In addition to built-in and customized functions, SQL Server has a great tool called Triggers. Triggers can help us to intercept events, with the exception of data selection events, since they do not modify data in the database. Come with me to see the benefits and dangers of the Triggers.
What are the Triggers 01:36
Insertion Trigger with AFTER and INSERTED 05:37
Update Trigger with AFTER and INSERTED 07:23
Removal Trigger with AFTER and INSERTED 05:03
Implementation of SQL Server stored procedures
The stored procedures are a very useful tool, since it gives us the opportunity to be able to mask a very complex business logic in a simple call. It can also help us reduce traffic to our server by not having to send the complete commands to the server but simply the name of the procedure and the parameters that it receives.
What are the stored procedures 02:51
Create a simple stored procedure 07:14
Default parameters in stored procedures 05:08
Output parameters for a stored procedure 04:43
Handling errors in T-SQL 04:51
Cursors and their advantages within T-SQL 07:46
Farewell of the SQL Server course 00:24
Size: 185 MB
Formators: Bernardo Pineda
Content: 22 Videos
Duration: 1:28 hours
Base Files: Yes Includes
Totally free of viruses and malicious software, so do not wait any longer to download it now.
Do not forget to give us an opinion about the course, to improve the content.
NO registration required!
2 Question(s) answered
If the question you have has not yet been answered here, use the form below to ask something about this addon.