The Complete SQL Queries Training Course, Student Edition

The Complete SQL Queries Training Course, Student Edition

4 (2 ratings by Goodreads)
By (author) 

List price: US$84.50

Currently unavailable

Add to wishlist

AbeBooks may have this title (opens in new window).

Try AbeBooks

Description

For courses in Database Management Applications and Database Design.

With The Complete SQL Queries Training Course, students can learn SQL hands on with no prior experience in the language. Providing both hard copy and electronic format, this package combines the industry's #1 interactive SQL training CD-ROM, the SQL Multimedia Cyber Classroom, with the world's best SQL book used by business professionals, SQL Queries for Mere Mortals. Regardless of which database is used, students will master SQL by practicing with hundreds of live queries and exercises-and learn from hours of animations and audio commentary by two world-renowned database consultants. The course focuses on solutions for problems encountered by real businesspeople.
show more

Product details

  • Mixed media product
  • 193.04 x 246.38 x 68.58mm | 952.54g
  • Prentice Hall
  • Upper Saddle River, United States
  • English
  • 0130897264
  • 9780130897268

Table of contents

Foreword.


Preface and Acknowledgements.


About the Authors.


Introduction.
I. RELATIONAL DATABASES AND SQL.

1. What is Relational?
2. Ensuring Your Database Structure is Sound.
3. A Concise History of SQL.
II. SQL BASICS.

4. Creating a Sample Query.
5. Getting More than Simple Columns.
6. Filtering Your Data.
III. WORKING WITH MULTIPLE TABLES.

7. Thinking in Sets.
8. INNER JOINs.
9. OUTER JOINs.
10. UNIONs.
11. Subqueries.
IV. SUMMARIZING AND GROUPING DATA.

12. Simple Totals.
13. Grouping Data.
14. Filtering Grouped Data.
In Closing.
Appendix A. SQL Standard Diagrams.
Appendix B. Schema for the Sample Databases.
Appendix C. Recommended Reading References.
Index.
show more

About Hernandez

Michael J. Hernandez is a well-known relational database consultant, and is the owner of DataTex Consulting Group in Seattle. He has been a featured speaker at a variety of database conferences and is the author of Database Design for Mere Mortals.

John L. Viescas is President of Viescas Consulting, Inc., a respected provider of database consulting services. He is also the author of the best-selling Running Microsoft Access 2000 and Programmer's Quick Reference Guide to SQL.
show more

Rating details

2 ratings
4 out of 5 stars
5 50% (1)
4 0% (0)
3 50% (1)
2 0% (0)
1 0% (0)
Book ratings by Goodreads
Goodreads is the world's largest site for readers with over 50 million reviews. We're featuring millions of their reader ratings on our book pages to help you find your new favourite book. Close X