2.2 Advanced Concepts

Table of Contents Previous Next


2 SQL Tutorial : 2.2 Advanced Concepts

The previous section discussed the basics of using SQL to store and access your data in Advanced Server. This section discusses more advanced SQL features that may simplify management and prevent loss or corruption of your data.
2.2.1 Views
The view name, employee_pay, can now be used like an ordinary table name to perform the query.
Making liberal use of views is a key aspect of good SQL database design. Views provide a consistent interface that encapsulate details of the structure of your tables which may change as your application evolves.

2 SQL Tutorial : 2.2 Advanced Concepts

Table of Contents Previous Next