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

Queries and views; introduction to SQL: SELECT, INSERT, UPDATE, DELETE and JOIN

CYB502 · Databases — Week 4 of 16

CourseCYB502
Week4 of 16
SemesterI
TutorOnline in the course chat

This week’s topics

Queries and views; introduction to SQL: SELECT, INSERT, UPDATE, DELETE and JOIN

  1. Queries and views
  2. Introduction to SQL: SELECT, INSERT, UPDATE, DELETE and JOIN

What you will be able to do

  • 1.3 Explain the principle of queries and views in databases.
  • 1.4 Explain the use of the SQL query language in databases.

Activity

Seminar, guided reading and a short written task: explain the principle of queries and views in 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.
Week 3Week 5
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