Business and technology qualifications, Levels 3-6, in Brussels. Explore qualifications
Portal login
Level 5 Diploma in Cyber Security

SQL queries for extracting, updating and manipulating records and tables

CYB502 · Databases — Week 9 of 16

CourseCYB502
Week9 of 16
SemesterI
TutorOnline in the course chat

This week’s topics

SQL queries for extracting, updating and manipulating records and tables

  1. SQL queries for extracting, updating and manipulating records and tables
  2. Writing efficient queries

What you will be able to do

  • 3.1 Use SQL to formulate queries to extract data from databases.
  • 3.2 Use SQL to formulate queries to manipulate and update data in databases.

Activity

Seminar, guided reading and a short written task: use SQL to formulate queries to extract data from databases.

Study materials

The teaching notes, exercises and videos of this week are in the student portal. Your portal is set up as soon as you receive final acceptance, so you can open them before the semester starts.
MidtermWeek 10
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: Database concepts: tables (entities), attributes and relati…
  • Week 2: Database models (hierarchical, network, relational) compare…
  • Week 3: Database management systems: MySQL, PostgreSQL and MongoDB …
  • Week 4: Queries and views; introduction to SQL: SELECT, INSERT, UPD…
  • Week 5: Requirements gathering and entity-relationship diagrams for…
  • Week 6: Normalisation using normal forms: reducing redundancy and i…
  • Week 7: Converting an ER diagram to SQL and deploying the schema in…
  • Midterm: Midterm evaluation
  • Week 9: SQL queries for extracting, updating and manipulating recor…
  • Week 10: Server-side programming with PHP: HTTP GET and POST, connec…
  • Week 11: Building a PHP web application on the database, including a…
  • Week 12: Applying Databases in practice: case studies
  • 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