Course SQL Server Triggers stored procedures and functions

CURS-311

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.


Description


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

Technical data:

Format: .MP4
Resolution: 1280x720p
Size: 185 MB
Spanish Language
Formators: Bernardo Pineda
Content: 22 Videos
Duration: 1:28 hours
Software: PHP
Base Files: Yes Includes


See Catch


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.

Download area


Advertising.

   DOWNLOAD NOW FREE

Contraseña/Password: www.intarcesoft.com.ve

Grade 
11/03/2017

Excelente

Gran curso

    Write your review!

    Write a review

    Course SQL Server Triggers stored procedures and functions

    Course SQL Server Triggers stored procedures and functions

    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.


    Ask a question

    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.

    (optional)
    *(Required to be notified when an answer is available)
    • Asked by joel
      on 11/05/2017
      gracias por compartirlo lo e descargado bien, y tambien e descargado otros video tutoriales de bases de datos y programación. estoy muy agradecido gracias XD Answer:
      Hola Joel, muchas gracias por tomarte el tiempo de agradecernos, realmente nos gratifica muchismo poderte ayudar. Bueno, ya sabes cualquier cosa por aca estamos a la orden.
    • Asked by Lina Sierra
      on 04/23/2018
      cordial saludo,estoy interesada en adquirir el curso, me gustaria saber como es la metodología, el valor, tiempo, si tiene certificación y toda la información porsible.muchas gracias. Answer:
      Que tal Lina, los cursos que tenemos aca son todos gratuitos. Solo vas al enlace de descarga, lo bajas a tu PC y los vez cuando tu quieras. Saludos.

    If the download link redirects to another product that is not described in the article or is broken, report it using our Reporting Form