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

Advanced Querying and Data Extraction

IT603 · Advanced Database Management Systems — Week 6 of 16

CourseIT603
Week6 of 16
SemesterI
TutorOnline in the course chat

This week’s topics

Advanced Querying and Data Extraction

  1. Complex joins and subqueries
  2. Window functions
  3. Common table expressions
  4. Aggregation and analytical reporting
  5. Joins in SQL
  6. Aggregate Functions in SQL

What you will be able to do

  • 3.2 Extract data from tables.

Activity

Start with this week’s 2 videos, then: Seminar, guided reading and a short written task: extract data from tables.

Study materials

Videos

  • Joins in SQL · YouTube · Neso Academy · 24 min · for registered students
  • Aggregate Functions in SQL · YouTube · Neso Academy · 12 min · for registered students
  • 02 - Advanced SQL (CMU Databases Systems / Fall 2019) · YouTube · CMU Database Group · 80 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
  • Workplace Software and Skills, ch. 14: Advanced Database Use · PDF · OpenStax, textbook chapter; pp. 893–962 · 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 5Week 7
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