Introduction to Database Systems and Cloud Computing - Cloud Database Development and Management - page 4

Figure 1.1 Databases hosted by an SQL Database Server in Windows Azure SQL Database.

Stored Procedures : A stored procedure contains programming code to perform a sequence of
operations or call other procedures. It is precompiled and stored in SQL Server for better perfor-
mance and security. Figure 1.4 shows a stored procedure.
Functions : A function also contains programming code to perform a sequence of operations. It
can be called by its name by other programs and returns a single value to the calling program. Windows
Azure SQL Database provides many built-in functions to assist the development of databases.
Database Triggers : A database trigger is a speciic kind of stored procedure. It will be exe-
cuted automatically when a speciic database event occurs.
In this section, you have briely gone over some of the commonly used database objects. here
are more to come in later chapters. You will learn in more detail about these database objects.

Figure 1.2 STUDENT table.