Advanced SQL elements
This section will encompass the most complex and advanced elements in handling SQL Server. We will see, among other things, how to manage stored procedures and Triggers, how to create and execute views...
We can define a VIEW as a virtual table with its set of rows and columns, whose content is defined by a SELECT query on one or more tables
Stored procedures are sets of one or more instructions stored in the database, which can be called from another part of the application. Stored procedures allow you to receive input and/or output parameters
Triggers are a special type of stored procedures that are automatically executed when a specific event occurs in the database.