More ideas from Vincent
This picture illustrates an SQL trigger  inserting a row in the inserted and deleted temporary tables at the same time as the user is updating a row in the clients table:

This picture illustrates an SQL trigger inserting a row in the inserted and deleted temporary tables at the same time as the user is updating a row in the clients table:

This picture illustrates an SQL trigger  inserting a row in the temporary table called inserted at the same time as the user is inserting a row in the clients table:

This picture illustrates an SQL trigger inserting a row in the temporary table called inserted at the same time as the user is inserting a row in the clients table:

This picture illustrates that trigger work in two steps: creation of the trigger, then launch of the trigger on a certain condition.

This picture illustrates that trigger work in two steps: creation of the trigger, then launch of the trigger on a certain condition.

This pictures shows how users are granted rights to a stored procedure through a role: a role is assigned to users, and the role is granted rights to the stored procedure.

Learn what is a stored procedure, how to create one, how to implement input parameter validation, output parameters, privileges to execute.

This picture shows on the left an SQL statement, and on the right the creation and the execution of a stored procedure corresponding to the same SQL statement.

Use stored procedures with SQL server

This picture illustrates the 2 steps necessary to use a stored procedure: 1) storing the stored procedure in a database 2) executing the stored procedure.

This picture illustrates the 2 steps necessary to use a stored procedure: storing the stored procedure in a database executing the stored procedure.

This picture illustrates the following database normalisation rule: there are some piece of information that you can calculate or derive (with a mathematical formula or string manipulation) based on other pieces of information stored in the table. You should not store them in any table.

Database normalisation is a set of table design rules.

This picture illustrates the following database normalisation rule: rule applying when you use more than one attribute to identify a person or thing. You should put in another table columns that contain information directly related to only one of these attributes.

Database normalisation is a set of table design rules.

This picture illustrates the following database normalisation rule: a table has information about a person or thing. Put columns with information not directly related to this person or thing in a separate table.

Database normalisation is a set of table design rules. You use them when you want to save space and have faster updates.

This diagram illustrates the following database normalisation rule: Put only one piece of information in one field. This rule prevents also putting two pieces of information of the same nature in one field.

Database normalisation is a set of table design rules.

This diagram illustrates the effect of "on delete cascade" coupled with a foreign key creation. It shows also the syntax of the creation of a foreign key with "on delete cascade".

This diagram illustrates the effect of "on delete cascade" coupled with a foreign key creation. It shows also the syntax of the creation of a foreign key with "on delete cascade".

This diagram illustrates the actions you cannot undertake when due to the creation of a foreign key in SQL.

Learn what is a foreign key, how to add a foreign key with SQL, what are the consequences of adding it, how to use on delete cascade.

This diagram illustrates what is a foreign key and a parent key, and shows the syntax to create a foreign key.

Learn what is a foreign key, how to add a foreign key with SQL, what are the consequences of adding it, how to use on delete cascade.