In this course you will be introduced to the advanced features of the SQL language, and how it can be used to query a database in order to answer business questions. In this course you will examine the following advanced features: querying with unions, advanced joins and sub queries, add, update and remove data, manipulate tables, views and various indexes, ensure data integrity with transactions, and create databases.

Textbook:Groff, J. R., Weinberg, P. N., Oppel, A.J., SQL: The Complete Reference, 3rd edition. Mc Graw Hill, 2010, ISBN: 978-0-07-159255-0