Relational Databases and SQL

data training event mashup

 

This page is related to a 5-week course delivered in 2019 with the aim of giving attendees an introductory overview of the principles of Relational Databases and how to use SQL to build or query databases.

The course comprises two modules:

1) Relational Databases (2 weeks)

2) SQL Essential Training (3 weeks)

The course covers the essential topics related to the design, construction and mining of relational databases, with a blend of video presentations, hands-on exercises and troubleshooting real project issues.

Learning objectives

Part 1: Relational Databases

  • Identify the three rules of relations.
  • Summarise the four stages of developing a relational database.
  • Describe a strategy one might use to ensure a database remains flexible in terms of the questions a user can ask.
  • Explain how to avoid scope creep.
  • Recall the characteristics of a Lookup Table.
  • Recognise situations in which denormalisation would be beneficial.
  • Understand the types of relationships modelled by junction tables.
  • Define referential integrity.

Part 2: SQL essential

  • Understanding SQL terminology and syntax
  • Creating new tables
  • Inserting and updating data
  • Writing basic SQL queries
  • Sorting and filtering
  • Accessing related tables with JOIN
  • Working with strings
  • Understanding numeric types
  • Using aggregate functions and transactions
  • Automating data with triggers
  • Creating views
  • Defining functions in PHP

 

Below you can find the link to the webpages created by the instructor with detailed instructions and the code.

Material designed by: Lucia Michielin

Copyright: CC-BY-NC

Link to the GitHub Repository