Topics

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.

Assignments

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