SQL: Week 4 April 18 2011


Advanced Querying

We have covered basic SQL querying, data structure definition, data design and now we will circle back to look at data query in more depth, exploring a variety of specialized table joins, self-joins, aliases, summary reporting, transactions and data storage options.

Class Objectives Checkpoint

Obviously, this half-semester class in SQL can only go so deep into any one topic, and can sometimes seem frustrating when we only have a week to review a complex and novel concept such as data modeling.   SQL has many aspects and even database professionals can only specialize in one or two aspects of database operations.    There are Database Administrators, Database Designers, Database Programmers, Data Analysts and Data Architects, each specialty requiring a unique set of skills and knowledge and each often  naive about the other aspects of  database operations.

Therefore, I consider this class a ‘survey’ of the various aspects of a database with a focus on web development, to complement the majority of student objectives here at SRJC.   You should probably expect to feel a little frustration with the fact that there is much more to explore about each of these subjects, but  I hope you are finding the class useful and will let me know if your objectives are not being met.


  1. Reading & exercises in Chapter 07 Advanced Querying
  2. Quiz 3 – open April 21- April 27
  3. Project 3 -  due April 27
    Using the wine sales data from Project 2, create the following management reports.   Send me an email with the SQL select statement(s) and results for each: 

    • List each branch and the total of each branch’s sales to date.
    • List each salesperson and their total sales to date, in descending order
    • List the  salesperson, customer and order total (price x tons) ordered by order total in descending order

4 comments for “SQL: Week 4 April 18 2011

  1. April 20, 2011 at 3:22 pm

    For the first query is the total of each branch’s sales the total price or the total of price x tons?
    For the second query is the descending sort order for salesperson or total sales?

  2. April 20, 2011 at 6:56 pm

    - The total sales (price x tons)
    - descending order by total sales

  3. Paul Clark
    April 27, 2011 at 9:01 pm

    Are we supposed to turn in the Exercises in the chapter to you as well? Or are we just supposed to do them for a better understanding and not turn them in?

    • April 28, 2011 at 7:15 am

      No, SQL class, you do not need to send me the exercises from the textbook or other readings. Just the projects will be graded,

Leave a Reply