A virtual column is a field which appears as part of a table but does not actually exist in the physical database table. Its value is dynamically derived based on the fields in the table. Virtual fields provide flexibility, since you can combine or extract data from fields in a table and extend the information already contained in the table.
Objectives:
To achieve these objectives, you will complete the following:
Step 1. Add Virtual Columns to Employee Table
Step 2. Calculation Virtual Column
Step 3. Concatenation Virtual Column
Step 4. Virtual Column for Note Length
Step 5. Virtual Column for Years Employed
Before you Begin
To complete this exercise, you must have completed the previous exercises.
