Keywords: python, real-course

Learning objectives:

• Define aggregation and give examples of its use.
• Distinguish between atomic and non-atomic values.
• Explain how databases represent missing information.
• Explain how missing data is handled during aggregation.
• Explain how to restrict the output of a query containing a join to only include meaningful combinations of values.
• Explain the difference between a database and a database manager.
• Explain the difference between a table, a record, and a field.
• Explain the operation of a query that joins two tables.
• Explain the order in which the clauses in a query are executed.
• Explain the three-valued logic databases use when manipulating missing information.
• Explain what a primary key is and why every record should have one.
• Explain what an atomic value is.
• Explain what primary and foreign keys are, and why they are useful.
• Explain why database entries should not contain redundant information.
• Explain why every value in a database should be atomic.
• Explain why most database applications are written in a general-purpose language rather than in SQL.
• Explore SQL City and discover who committed the murder
• Identify primary keys in database tables.
• Identify redundant information in databases.
• Reinforce your experiences with SQL such as querying, filtering, and joining data.
• Trace the execution of a program that contains an SQL query.
• Trace the execution of a query that performs aggregation.
• Write a query to select all values for specific fields from a single table.
• Write queries that calculate new values for each selected record.
• Write queries that compute aggregated values.
• Write queries that display results in a particular order.
• Write queries that eliminate duplicate values from data.
• Write queries that handle missing information correctly.
• Write queries that join tables on equal keys.
• Write queries that select records that satisfy user-specified conditions.
• Write short programs that execute SQL queries.
• Write statements that create tables.
• Write statements to insert, modify, and delete records.

Event types:

• Workshops and courses

Sponsors: Avans Hogeschool