Introduction to a relational database

Five management queries

A list of customers and their accounts

A list of account types and the average balance in each type

A cross-table of the number of accounts by customer city and account type

A list of customers in a zip code that is specified dynamically

A list of customers in a zip code selected from a drop down list of valid zip codes

Building the queries

Query 1 -- A simple table linking multiple tables in the relational database

Query 2 -- A PivotTable from data in the relational database

Query 3 -- A PivotTable cross-tabulation using data in the relational database

Query 4 -- A parameterized query to list of customers in a zip code that is specified dynamically

Query 5 -- A parameterized query to list of customers in a zip code selected from a drop down list of valid zip codes

For custom technology solutions, operations consulting, or training contact web-underscore-contact@tushar-hyphen-mehta-dot-cee-oh-em.
By accessing any page or link on this web site other than this page, you agree to the terms and conditions.

Ads from amazon.com