SILABUS MATA KULIAH
Program Studi : Teknik Informatika
Kode / Nama Mata Kuliah : 16065304 / Basis Data Lanjut
Jumlah SKS / Semseter : 3 SKS /
Mata Kuliah Pra Syarat : Basis Data
Capaian Pembelajaran Lulusan :
- Mahasiswa mampu menangani permasalahan data berskala besar
- Mampu memodelkan basis data aktif yang terintegrasi dengan business rule
- Mampu memodelkan basis data di berbagai bidang industri
Capaian Pemebelajaran Mata Kuliah :
- Mahasiswa mampu memodelkan basis data di berbagai bidang
- Mahasiswa mampu menangani permasalahan data berskala besar.
- Mahasiswa mampu memodelkan basis data aktif yang terintegrasi dengan business rule
| POKOK BAHASAN | ALAT/BAHAN/SUMBER BELAJAR |
| Pemodelan Sistem Kompleks: studi kasus spesifik di bidang industri | LCD Projector, Laptop / – / Avi Silberschatz, “Database System Concepts”, 5th edition, 2002. |
| SQL Programming: trigger, stored procedure, function, view. | LCD Projector, Laptop / – / Morgan Kaufman, “Advanced Database System”, Morgan Kaufman Publisher Inc., 1993. |
| Indeks: B+Tree, Bitmap, Hash, Clustered dan Unclustered indeks. | LCD Projector, Laptop / – / Morgan Kaufman, “Advanced Database System”, Morgan Kaufman Publisher Inc., 1993. |
| Optimasi basis data: rancangan optimasi, administrative tuning. | LCD Projector, Laptop / – / Howe, David, “Data Analysis for Database Design”, 3th edition. Butterworth-‐ Heineman, 2001. |
| SQL Transaction Processing: transaction, failure and recovery, concurrency and control. | LCD Projector, Laptop / – / Morgan Kaufman, “Advanced Database System”, Morgan Kaufman Publisher Inc., 1993 |
| XML dalam basis data | LCD Projector, Laptop / – / Ramakrishnan, Raghu, Gehrke, Johannes. “Database Management Systems”, 3th ed., New York: The McGraw-‐Hill Companies Inc., 2003. |
| Basis data terdistribusi. Data warehouse | LCD Projector, Laptop / – / Ramakrishnan, Raghu, Gehrke, Johannes. “Database Management Systems”, 3th ed., New York: The McGraw-‐Hill Companies Inc., 2003. |