CO558 DB11 - Web Tutor

Week 11 Activities - Advanced SQL

Task	Lesson Activity	Learning Assessment	Skill Developed
11.1	PPT 30 min Multiple Table Queries PPT 30 min Multiple Table Queries DreamHouse Examples PPT 30 min Avon Sales Queries download the Excel data table here	SQL Examples	SQL Queries
11.2	PPT 30 min ANSWERS: Donut & Easy Drinks PPT 30 min ANSWERS: Easy Drinks PPT 30 min ANSWERS: Avon Sales Queries PPT 30 min ANSWERS: DreamHouse PPT 30 min ANSWERS: Week 10 Queries	SQL Examples	SQL Queries

Wesbite TutorialsPoint: Learn SQL
Wesbite SQL Aggregate Queries this site is better that TutorialsPoint for aggregate queries (MAX, AVG etc.)
Video 40 min SQL Basics for Beginners this covers most of the SQL commands you need to know
Data Generator An online realistic data generator for testing databases.