SQL is nonprocedural, meaning that the database decides how to execute the SQL statement. The extensions discussed in this hour were procedural.
Normalization is the process used to ensure that a database is properly designed according to relational database principles.
Stored procedures are used to centralize the logic or business rules to abstract the security management and to improve performance.
When we want to process logical operations at the server side instead of the client side, we can use stored procedures.
Trigger is like a dynamic stored procedure. A trigger is a group of T-Sql statements that is executed automatically when specified events occur.
Simply to say a view is a stored sql select statement.
The most common use of views is the simplification of data access.