Business and technology qualifications, Levels 3-6, in Brussels. Explore qualifications
Portal login
Level 6 Diploma in Information Technology

Database Functional and Performance Testing

IT603 · Advanced Database Management Systems — Week 10 of 16

CourseIT603
Week10 of 16
SemesterI
TutorOnline in the course chat

This week’s topics

Database Functional and Performance Testing

  1. Query execution plan analysis
  2. Index optimization
  3. Concurrency and transaction isolation testing
  4. Benchmark load testing
  5. #15 - Database Query Optimizers Part 1 (CMU Intro to Database Systems)
  6. #13 - Query Execution Part 1 (CMU Intro to Database Systems)
  7. #17 - Concurrency Control Theory (CMU Intro to Database Systems)

What you will be able to do

  • 3.4 Test the system for functionality and performance

Activity

Start with this week’s 3 videos, then: Seminar, guided reading and a short written task: test the system for functionality and performance

Study materials

Videos

  • #15 - Database Query Optimizers Part 1 (CMU Intro to Database Systems) · YouTube · CMU Database Group · 80 min · for registered students
  • #13 - Query Execution Part 1 (CMU Intro to Database Systems) · YouTube · CMU Database Group · 80 min · for registered students
  • #17 - Concurrency Control Theory (CMU Intro to Database Systems) · YouTube · CMU Database Group · 81 min · for registered students

Further resources

  • MIT 6.830 Database Systems (Fall 2010), lecture notes · Reading · MIT OpenCourseWare, course · for registered students
  • Readings in Database Systems ('Red Book', 5th ed., Bailis, Hellerstein & Stonebraker) · PDF · Other, textbook · for registered students
  • Operating Systems: Three Easy Pieces (v1.10), ch. 26: Concurrency: An Introduction · PDF · Other, textbook chapter; 16 pages · for registered students
Materials marked “for registered students” open in the student portal, which is set up as soon as you receive final acceptance.
Week 9Week 11
Course chat

Admitted students ask questions on this week’s page in the student portal: an AI assistant trained on the course answers first, and during the course’s timetabled classes Connect to your tutor brings your tutor into the chat, who may start a call if needed.

Open this week in the portal
Course plan
  • Week 1: Relational Theory and Normalisation
  • Week 2: Database Modelling Languages
  • Week 3: Database Engine Architecture and Platform Selection
  • Week 4: Logical Modelling and Normalisation Practice
  • Week 5: Physical Database Design and Build
  • Week 6: Advanced Querying and Data Extraction
  • Week 7: Database Access Control and Granular Security
  • Midterm: Midterm evaluation
  • Week 9: Database Threat Landscape and Risk Evaluation
  • Week 10: Database Functional and Performance Testing
  • Week 11: Database Administration and Enterprise Resilience
  • Week 12: Applying Advanced Database Management Systems in practice: …
  • Week 13: Assignment workshop: research, planning and referencing
  • Week 14: Assignment workshop: drafting, feedback and improvement
  • Week 15: Review and coursework completion
  • Final: Final assessment and submission
Back to the course
Scroll