Course: ICT3.006 Advanced Databases (2024-2025) Dr. Le Hong Hai

Topic outline

General
General
Relational databases & advanced queries
Relational databases & advanced queries
- 01-Relational databases advanced queries File
SQL Roadmap
SQL Roadmap
- https://roadmap.sh/sql URL
View - Stored Procedure, Function - Trigger
View - Stored Procedure, Function - Trigger
- 02-View, stored procedure, function, and trigger File
Lab-01
Lab-01
- lab01-relational databases advanced queries File
Indexing-Partitioning
Indexing-Partitioning
- 03-Indexing-Partitioning File
Lab-02
Lab-02
- Lab-02-Indexing-Partitioning File
Transaction-Replication
Transaction-Replication
- 04-Transaction-Replication File
Lab-03
Lab-03
- 1. Create MySQL Asynchronous Replication between 2 local servers
  https://chatgpt.com/share/6739ad36-da54-8007-8da5-7140349ed0ad
  2. Working with your friend MySQL server for MySQL Replication.
Complex Data Types & DB Programming
Complex Data Types & DB Programming
Lab-04
Lab-04
- Lab-04-Programming-DB File
NoSQL
NoSQL
- 06-NoSQL File
- database-landscape-what-are-the-different URL
Lab-05
Lab-05
- Download softwares:
  
  https://www.mongodb.com/try/download/community (zip package)
  
  https://www.mongodb.com/try/download/compass
- Lab-05-MongoDB File
- https://chatgpt.com/share/674d0d5f-6aec-8007-b3d5-63dd4ca99763 URL
Big Data - Data Analysis
Big Data - Data Analysis
Final Exam (1:15pm, 20-Dec, A21 Hall)
Final Exam (1:15pm, 20-Dec, A21 Hall)
Not available
Retake Exam (10h45, 25 Mar)
Retake Exam (10h45, 25 Mar)
Not available