Using the industry-standard Oracle Relational Database Management System, the course teaches database design and manipulation concepts, including entity modelling, normalisation, table creation and integrity constraints and SQL statements such as joins, nested queries and group by. There is also an overview of Oracle metadata and security privileges, using views and main principles in performance management
By the end of this course, students will be apple to do the following:
- Database Manipulation Language-DML
- Database Definition Language – DDL
- Nested SQL Queries
- Tables and Table Joins
- Filtering and Sorting Data
- Functions with Partical Approach
The entire course is 30 hours (2 weeks). 5 days per week, 3 hours per day.
Students will fail if they miss more than 80 percent of the 30 hour course.
Student Test Grades:
Students are graded according to their attendance, participation, assignments, and tests.
|Level||Start Date||End Date|
|Or-SQL||To Be Decided|
Class schedule and timing:
|To Be Decided|