Structured Query Language (SQL)

Course Learning Outcomes

Students will be able to: 

●        Understand strategies for normalising data (how to represent a flat file of data in terms of multiple related tables.

●        CREATE and DROP Database objects.

●        INSERT, UPDATE and DELETE rows of data.

●        Interrogate large datasets using a wide range of SELECT statements

●        Create Views and Stored Procedures