Lecture 01: Introduction to databases

Lecturer

Janus Valberg-Madsen <janus@math.aau.dk>

Time

Mar 18, 08:15-12:00

Place

Skjernvej 4A, room 2.120

Contents of lecture

• Introduction to databases and PostgreSQL
• Using the psql command line tool
• Using the pgAdmin visual tool
• Basic usage of the SELECT command

Exercises

Exercise sessions during the lectures will largely be based on SQLZOO tutorials and quizzes. Solutions for each tutorial will be made available after the lecture.

Today’s exercise sessions will consist of the following:

• SELECT basics [solutions] (+quiz)
• SELECT names [solutions]
• SELECT FROM world [solutions] (+quiz)
• SELECT FROM nobel [solutions] (+quiz)

Literature and resources

• Slides
• [D&W] Chapter 3, Understanding SQL
• [D&W] Chapter 4, section Retrieving Rows with SELECT