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

Tổng quan các chủ đề

• Chung
  

  Chung

  • Announcements Diễn đàn
  • Syllabus ICT Advanced Databases-v2 File
  • Quiz1 Trắc nghiệm
• 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

  • 05-ComplexData-DbProgramming File
  • Write a json file describing yourself Bài tập
  • Working with ORM Bài tập
• Lab-04
  

  Lab-04

  Chưa mở
• NoSQL
  

  NoSQL

  • 06-NoSQL File
• Lab-05
  

  Lab-05

  Chưa mở
• Big Data - Data Analysis
  

  Big Data - Data Analysis

  • 07-BigData-DataAnalysis File
  • AdventureWorks Sales (PowerBI) File
• Final Exam (1:15pm, 20-Dec, A21 Hall)
  

  Final Exam (1:15pm, 20-Dec, A21 Hall)

  Chưa mở
• Retake Exam (10h45, 25 Mar)
  

  Retake Exam (10h45, 25 Mar)

  Chưa mở