hands-on tutorial

Hands-on for 'Introduction to SQL' tutorial

The questions this addresses are:
- How can I get data from a database?
- How can I sort a query's results?
- How can I remove duplicate values from a query's results?
- How can I select subsets of data?
- How can I calculate new values on the fly?
- How do databases represent missing information?
- What special handling does missing information require?

The objectives are:
- Explain the difference between a table, a record, and a field.
- Explain the difference between a database and a database manager.
- Write a query to select all values for specific fields from a single table.
- Write queries that display results in a particular order.
- Write queries that eliminate duplicate values from data.
- Write queries that select records that satisfy user-specified conditions.
- Explain the order in which the clauses in a query are executed.
- Write queries that calculate new values for each selected record.
- Explain how databases represent missing information.
- Explain the three-valued logic databases use when manipulating missing information.
- Write queries that handle missing information correctly.

Licence: Creative Commons Attribution 4.0 International

Keywords: data-science, SQL, jupyter-notebook

Target audience: Students

Resource type: hands-on tutorial

Authors: Avans Hogeschool, Bazante Sanders, Donny Vrins, Helena Rasche, The Carpentries

Contributors: Avans Hogeschool, Bazante Sanders, Donny Vrins, Helena Rasche, The Carpentries

Scientific topics: Software engineering


Activity log