Main Learning Activities
In this section, we would like to invite you to practice about how to retrieve data from database using Subquery, create Store procedure and Trigger on MS. SQL Server.
Student required to take and understand the post-activity of the previous Chapter and complete the reading required prior the Main class activity. Read the following lecturer presentation notes before we start with the class session. You may also need to watch the video about Advanced SQL (how to create Store procedure and Trigger)