Software EngineeringEngineeringFrançais

Database and SQL

SWE 202 · Semester 3

5 credits · 17 learning units

Lessons

17 of 17 learning units provide interactive tutorials with worked examples, diagrams, knowledge checks and subject mastery questions. Each check draws five questions from the available bank; question counts vary by unit. The remaining units provide preparation, guided practice or an independent project.

Subunit titles retain the curriculum’s original language.

Start here

  1. Lesson 1Relational thinking before SQL syntaxInteractive tutorial

Curriculum topics

  1. Lesson 2Relational database conception principlesInteractive tutorial
  2. Lesson 3Relational design, anomalies and normalizationInteractive tutorial
  3. Lesson 4The SQL language and the SELECT statementInteractive tutorial
  4. Lesson 5Filtering rows with WHEREInteractive tutorial
  5. Lesson 6Range, set membership and pattern matchingInteractive tutorial
  6. Lesson 7NULL and three-valued logicInteractive tutorial
  7. Lesson 8Sorting results with ORDER BYInteractive tutorial
  8. Lesson 9Aggregate functionsInteractive tutorial
  9. Lesson 10Grouping with GROUP BY and HAVINGInteractive tutorial
  10. Lesson 11Joining tables and relationship cardinalityInteractive tutorial
  11. Lesson 12Subqueries, ANY and ALLInteractive tutorial
  12. Lesson 13Changing data: INSERT, UPDATE and DELETEInteractive tutorial
  13. Lesson 14Transactions and safe changesInteractive tutorial
  14. Lesson 15Database administration in practiceInteractive tutorial

Put it into practice

  1. Lesson 16Guided laboratory: joins, groups and updates on real dataInteractive tutorial

Work independently

  1. Lesson 17Independent project: a tested query and transaction setInteractive tutorial
Curriculum source

HND Computer Engineering Software Engineering Curriculum.pdf · SWE 202 · Course table: p. 10 · Outline pages: 38