Lecture Database system concepts (5/e): Chapter 3 - Silberschatz, Korth, Sudarshan 

This chapter presents the following content: Data definition, basic query structure, set operations, aggregate functions, null values, nested subqueries, complex queries, views, modification of the database.