Advanced SQL  «Prev  Next»

Lesson 4 SQL Course Expectations
Objective Key course features for Advanced SQL

SQL Course Expectations

This course is a hands-on, interactive tour and learning system that will help you understand how to get the most out of reports you use to query your SQL databases. At the end of this course, you should be comfortable using your SQL database to create reports with grouping and sorting.
This class is based on completing a project in which you will be creating reports that summarize sales information, by pulling information from several related tables. You will need to present this information broken down by state and sales information found in the database. The project for this class will use several different aspects of SQL.

While it may sound like a tall order right now, you will see that if you take the time to both break down
  1. the request for information and
  2. the approach to the SQL statements you will need,
it is achievable.
After having read about the advantages of learning from the Advanced Structured Query Language course, it is now easy to forget those other SQL courses you were considering.

SQL and Relational Theory

After many years working in the database community in various capacities, I have come to realize there is a real need for a coursre for practitioners that explains the basic principles of relational theory in a way not tainted by the peculiarities of existing products. My intended audience is thus experienced database practitioners who are honest enough to admit they do not understand the theory underlying their own field as well as they might, or should. That theory is the relational model, and while it is true that the fundamental ideas of that theory are all quite simple, it is also true that they are widely misrepresented. Often, in fact, they do not seem to be understood at all. For example, here are a few relational questions?
  1. What exactly is first normal form?
  2. What is the connection between relations and predicates?
  3. What is semantic optimization?
  4. What is an image relation?
  5. Why is semidifference important?
  6. Why doesn't deferred integrity checking make sense?
  7. What is a relation variable?
  8. What is prenex normal form?
  9. Can a relation have an attribute whose values are relations?
  10. Is SQL relationally complete?
  11. Why is The Information Principle important?
  12. How does XML fit with the relational model?

This course provides answers to these and many related questions. It is meant to help database practitioners understand relational theory in depth and make good use of that understanding in their professional day-to-day activities.