Vincent Luciani

Vincent Luciani

www.graspsql.com
Warsaw / Created http://www.graspsql.com, an SQL tutorial with a lot of diagrams to pin.
Vincent Luciani
More ideas from Vincent
Detecting Fraud through Data Analysis #Bigdata #BI #Analytics

You can detect fraud with thorough data analysis! Are businesses leveraging this effectively?

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.

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

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.