Lab 5
Objectives:
- Retrieves data from two tables using:
- Select Query
- JOINS
- INNER JOIN
- LEFT JOIN
- RIGHT JOIN
- FULL JOIN
- UNION
- Retrieve Data from Table by groups
- Using LIKE keyword and WILDCARD Operator to search database content
Instructions:
- Download the lab slides from links.
- Update the database content based on the code and data in slide 4 and slide 5.
- Execute all the SQL statements in Lab Exercise section and documents the results.
- Screenshot all the operation exercise above and save it in a Microsoft Documents named "lab5-[matric no]". *each lab document will be different because your matric number is included in your table name. For example: 56788_students for student with matric number 56788.
- Group 06/07 are required to submit in eleap after the lab sessions by 30 Nov 2017.
- The other group depends on your lecturer’s instruction.
