Lesson 1
Querying the table
We have spent considerable time laying the foundation for your use of SQL.
These are important aspects and will be truly helpful as you use the databases associated with your company or endeavor.
This module dicusses the business of actually working with the table, issuing queries against it and returning information.
These are important aspects and will be truly helpful as you use the databases associated with your company or endeavor.
This module dicusses the business of actually working with the table, issuing queries against it and returning information.
Perhaps some of the most important things to keep in mind as you work with SQL are the items that make up the foundation. Ask yourself
- why a table is designed as it is,
- why is the information that is in that table placed there?
- Is there a better, more normalized way to store the information?
- Should exceptions be made to the normalization approach for this table?
It is not that everything has been created incorrectly, but rather that you can more readily use SQL if you understand exactly how information
is stored and why it was stored that way.
In the next lesson, you will create the table that is used for the rest of this module.
In the next lesson, you will create the table that is used for the rest of this module.
