• Relational Database Design or have equivalent knowledge

Students will learn:

• Use SQL DML to query and modify data in an Informix database
• Write simple SELECT statements, including joins, subqueries, temporary tables, and unions
• Write complex SELECT statements, including outer joins, self-joins, and correlated subqueries
• Add and modify data using the INSERT, UPDATE, and DELETE statements
• Use LOAD and UNLOAD for bulk data operations

Course overview:

• An introduction to SQL
• The demonstration database
• Single table SELECT statements
• SELECT clauses and aggregates
• Date and time functions
• String functions
• Additional functions
• Joins
• Complex joins
• The UNION operator
• Subqueries
• INSERT, UPDATE, DELETE, LOAD, and UNLOAD