Oracle Database Management System

Announcement:

Assessment:

• Assiduity: 10% - attendance at least 75% of the course
• Quiz: 20% - work in group
• Final Test: 70% - close book, multi-choice+written test
• Quiz will be reviewed at the end of the course (week 10)
• Topic: link
• Review questions: link
• Score - Lớp thứ 5 - Lớp thứ 6

Class 12DHTH07 - from 12h30 to 14h45- THursday - room B307 - Registration link - google classroom code: gblcufu
Class 12DHTH11 - from 12h30 to 14h45- Friday - room B207 - Registration link - google classroom code: 2ze4x37

Contents:

Week 1:  Welcome to the course - Slide

Welcome to the course: discussing about the course, regulations, and related issues - forming presentation group for the assignment and the project.

Week 2-3: Oracle DBMS Introduction - Slide

Week 4: Managing an Oracle Instance - Slide; ref

Initialization Parameters

Shut down and Start up Oracle Instance

Week 5: User Control Management - ref - Stu's Slide

Privileges, Role, Profile concepts

Week 6: Oracle Auditing, Oracle Transaction Management - ref

Week 7: Oracle Database Storage Structure - ref

Week 8: Oracle PL/SQL - ref

DDL, DML: select, insert, update, delete operations

Week 9: Oracle PL/SQL - ref - Students slide

P/L: If-then-else statement, Case statement, Iterative processing with loops

Cursors, Procedure, Function, Triggers.

Week 10: Exam & Project report - Good luck!