AVAILABLE AS AN
E-BOOK ON CD
|
Contents
1. Intro to SQL (PDF
File)
2. Basic Single Table Select Statements
3. Aggregates & Sub Queries (PDF
File)
4.Joining Tables (PDF
File)
5. DBMS Specific Functions
6. Advanced Queries
7. Data Manipulation
8. Database Definition Language
9. Privileges
Appendix A: Lyric Music Database
Appendix B: Datatypes
Appendix C: Data Normalization
Appendix D: SQL Quick Reference
|
|
I THINK THE BOOK has two competitive advantages. One
is the clear and specific focus on the four main DBMSs. I think
this gives the students a practical heads up on how to use their
particular database and how it compares to the others. ...The
other competitive advantage is the breadth and depth of the SQL
covered. Most books cover advanced SQL or beginning SQL. This
book covers all the beginning SQL and some intermediate and advanced
topics.
—Steve Conger, Seattle Central
Community College
|
|
This textbook is designed to be used as
a supplemental book in a database theory course where more coverage
of SQL topics is needed. It is also well suited for a course
covering just SQL with a few design concepts during a typical
15-week semester. To support this use a small appendix covering
the principles of database design is included. No prior knowledge
of SQL is assumed.
Comparisons are shown between Oracle, Microsoft
SQL Server, Microsoft Access, and MySQL. The presentation sticks
as close to ANSI-SQL as possible. This is done because ANSI-SQL
is the most portable. When necessary the database specific code
is used to accomplish common tasks.
|