SQLearning
Introduction to SQL Create and manage databases Query execution Language elements Functions Advanced elements

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...

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

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

Triggers are a special type of stored procedures that are automatically executed when a specific event occurs in the database.