Font size
A-
A
A+
Site color
R
A
A
A
Side panel
You are currently using guest access (
Log in
)
Skip to main content
Database Management System
Home
Courses
ILMU TEKNIK
TEKNIK ELEKTRO DAN INFORMATIKA
Sistem Informasi
Database System Master
Week 15: Advanced SQL (Subquery, Store procedure, Trigger)
Post: Assignment Week 15
Post: Assignment Week 15
Please create Subquery, Store procedure and Trigger from your own Database
Previous activity
◄ Main Learning Activities
Jump to...
Jump to...
Announcements
Video Material
Week 1 Reading Materials
Post: Quiz Week 1
Post: Quiz Discussion with Tutor
Pre: Class Materials
Video Material
Pre: Class Materials
Video Material
Main: Collaboration using Miro
Main: RDBMS Workshop
Post: Assignment Week 3
Reading Materials
Video Material
Week 4 Online Class Session
ER Diagram Collaboration
Individual Assignment: Database modeling case study
Pre: Class Materials
Video Material
Main: Collaboration using Miro
Week 5 Online Class Session
Post: DB Modeling Workshop
Pre: Class Materials
Video Material
Main: Collaboration using Miro
Post: Quiz Week 6
Post: Quiz Discussion with Tutor
Pre: Class Materials
Video Material
Main: Collaboration using Miro
Post: Case Discussion with Tutor
MID EXAM
Pre Learning Activities
Video Material
Main Learning Activities
Post Learning Activities
Individual Assignment: Database case study 1
Pre Learning Activities
Video Material
Main Learning Activities
Post Learning Activities
Individual Assignment: Database case study 2
Pre Learning Activities
Video Material
Main Learning Activities
Post Learning Activities
Post: Assignment Week 11
Pre Learning Activities
Video Material
Main Learning Activities
Post Learning Activities
Post: MS. SQL Server Query Workshop
Pre Learning Activities
Video Material
Main Learning Activities
Post: Case Discussion with Tutor
Pre Learning Activities
Video Material
Main Learning Activities
Post: Assignment Week 14
Video Material
Pre Learning Activities
Main Learning Activities
FINAL EXAM
Next activity
FINAL EXAM ►
Home
Calendar
Course sections
Course Overview
Week 1: Introduction to Database
Week 2: Database Architecture
Week 3: Relational Database Management System
Week 4: Relational Database Modeling
Week 5: Relational Database Modeling - Case Study
Week 6: Database Normalization
Week 7: Database Normalization - Case Study
Week 8: Mid Exam
Week 9: Introduction to MS. SQL Server
Week 10: Managing Tables
Week 11: Data Manipulation (INSERT, UPDATE, DELETE)
Week 12: Data Manipulation (SELECT)
Week 13: Data Manipulation (SELECT SUM, COUNT, MIN, etc)
Week 14: Data Manipulation (SELECT JOIN)
Week 15: Advanced SQL (Subquery, Store procedure, Trigger)
Week 16: Final Exam
Feedback & Certificate