The item you selected is unavailable, but we found something similar.

Picture 1 of 2

Stock photo

Hands on SQL : The Language, Querying, Reporting and the Marketpl - Picture 1 of 2

Hands on SQL : The Language, Querying, Reporting and the Marketpl - Picture 2 of 2

Hands on SQL : The Language, Querying, Reporting and the Marketplace by Robert Groth (1996, CD-ROM / Trade Paperback)

Be the first towrite a review.

Better World Books (2607976)
98.8% positive feedback

Price:

$6.96

Free shipping

Estimated delivery Mon, Apr 29 - Wed, May 1

Returns:

30 days returns. Buyer pays for return shipping.

Condition:

Good

Book

About this product

Product Information

Understanding SQL is pretty basic to anyone usig a database. Yet most books take a theoretical, academic approach. Groth shows how anyone working with a database can familiarize themselves with SQL in only three hours using the DC and become completely onversant by following the hands-on approach. Contains Centura Software Corporation's SQL Wilndows Solo, Quest (what the enduser uses to query a database) and exercises relating to the book.

Product Identifiers

Publisher
Prentice Hall PTR
ISBN-10
0134861434
ISBN-13
9780134861432
eBay Product ID (ePID)
910726

Product Key Features

Author
Robert Groth
Publication Name
Hands on Sql : the Language, Querying, Reporting and the Marketplace
Format
CD-ROM / Trade Paperback
Language
English
Publication Year
1996
Type
Textbook
Number of Pages
550 Pages

Dimensions

Item Length
9.3in
Item Height
0.9in
Item Width
7in
Item Weight
32.1 Oz

Additional Product Features

Lc Classification Number
Qa76.73.S67g77 1997
Edition Number
1
Table of Content
I. STARTING OUT. 1. Introduction to SQL. What Is SQL? SQL Parts. Example of an SQL Command. SQL and the Relational Model. Relationa l Model. Definition of Terms. Relational Database Vendors. Summary. 2. Database Design. Approaching Database Design. Steps of Database Design. Creation of a Logical Model. Normalization. Database Diagram. Logical Data Modeling Tools. Summary. II. RAPID TUTORIAL. 3. Creation of a Database. Physical Database Creation. Exercises: Creation of a Database. Data Types. Data Type Guidelines. Indexes and Primary and Foreign Keys. Exercises Summary. 4. Insert, Update, and Delete. INSERT Command. Exercises: Using the INSERT Command. UPDATE Command. Search Conditions with the UPDATE Command. Predicates with the UPDATE Command. Exercises: The UPDATE Command. DELETE Command. Exercises: The DELETE Command. Summary. 5. Retrieving Data: The SELECT Statement. SELECT Command. Using Expressions. Exercises with the SELECT Command. Examples: Using the SELECT Commands with UPDATE and DELETE. Exercises with INSERT, UPDATE, and DELETE with SELECT. Summary 5-25. 6. Functions and the Clauses ORDER BY, GROUP BY, and HAVING. ORDER BY Clause. Functions. Aggregate Functions. GROUP BY, HAVING, and Aggregate Functions. Exercises with the SELECT Command. Summary. 7. Joins and Unions Joins. Unions. Exercises with SELECT and Joins and Unions. Summary. 8. Complex Queries and Performance. Subqueries. Performance Considerations. Database Design and Performance. Exercises with Complex Queries. Summary. 9. Views. Introduction to Views. CREATE VIEW and DROP VIEW Command Diagrams. Creation of an External Schema. Exercises with Views. Summary. 10. Privileges and Use of GRANT and REVOKE. Privileges and the GRANT Command. GRANT Command Diagrams. Privileges and the REVOKE Command. REVOKE Command Diagrams. Exercises with GRANT and REVOKE. Summary. 11. System Tables and Stored Procedures. Introduction to System Tables. How Vendors Vary System Tables. Exercises with System Tables. Stored Procedures and Triggers. Summary. 12. Data Integrity and Constraints. Data Integrity. Foreign Keys: More on Delete Rules. Foreign Key Guidelines. Implications for SQL Operations. Transaction Analysis and Integrity. Summary. 13. SQL Variations. Differences in SQL. Differences in Database Systems. SQL Language Variations. SQL Statement Elements. Summary. III. EMBEDDED SQL. 14. Writing Applications Using SQL. Introduction to Embedded SQL. Definition of Terms. Examples of Embedded SQL Using SQL API. ODBC Overview. Using ODBC with Embedded SQL. Summary. 15. Fourth Generation Languages. Past, Present, Future. 4GL (Rapid Application Development) Vendors. 4GL Checklist. Exercises. Summary. 16. Database Middleware. Overview of Database Middleware. Direct, Proprietary Access to RDBMS. Multidatabase Connectivity. Gateways and Vendors. Extended Middleware Connectivity. Summary. IV. EXPANDING HORIZONS. 17. A Look at Query Tools. Query Tools. End-User Query Vendors. Checklist. EIS Systems. Exercises. Summary. 18. Report Writers. Report Writers. Report Generation Vendors. Report Writer Checklist. Exercises with Report Writers. Summary. 19. Database Directions. Data Warehousing. Parallel Databases. Object-Oriented Databases (OODBMS). Replication Strategies. Performance and the 64-bit OS. Relational Technology and the Internet. Summary. A. SQL Vendors. Relational Database Players. Logical Modeling Vendors. Data Translation Tool Vendors. 4GL Vendors. Connecti
Copyright Date
1997
Target Audience
College Audience
Topic
Programming Languages / Sql, Databases / General
Lccn
96-017526
Dewey Decimal
005.75/6
Dewey Edition
20
Illustrated
Yes
Genre
Computers

All listings for this product

item 1 Hands on SQL : The Language, Querying, Reporting and the Marketpl
$6.96
Free shipping
item 2 Hands-On SQL: The Language, Querying, Reporting and the Marketplac - ACCEPTABLE
$7.45
Free shipping
item 3 Hands-On SQL: The Language, Querying, Reporting and the Marketplace (Bk - GOOD
$7.45
Free shipping
item 4 Hands-on SQL: The Language, Querying,..., Groth, Robert
$8.19
Free shipping
item 5 Hands-on SQL: The Language, Querying,..., Groth, Robert
$8.19
Free shipping
item 6 Hands-on SQL: The Language, Querying, Re... by Groth, Robert Mixed media product
$9.29
Free shipping
item 7 Hands-On SQL: The Language, Querying, Reporting and the Marketpl
$15.28
Free shipping

See all 8

Best Selling in Textbooks

See all

Current slide {CURRENT_SLIDE} of {TOTAL_SLIDES}- Best Selling in Textbooks

Desk Reference to the Diagnostic Criteria from DSM-5-TR by American Psychiatric Association (2022, Trade Paperback)
5.0 out of 5 stars based on 6 product ratings
$12.19 New
---- Used
Self Heal by Design : The Role of Micro-organisms for Health by Barbara O'Neill (2018, Trade Paperback)
5.0 out of 5 stars based on 14 product ratings
$33.00 New
$32.00 Used
Diagnostic and Statistical Manual of Mental Disorders DSM-5-TR by American Psychiatric Association (2022, Trade Paperback)
4.6 out of 5 stars based on 15 product ratings
$34.89 New
$34.00 Used
PMBOK® Guide Ser.: Guide to the Project Management Body of Knowledge (PMBOK Guide) and the Standard for Project Management by Project Management Institute (2021, Trade Paperback)
4.9 out of 5 stars based on 7 product ratings
$17.42 New
$13.00 Used
Cognitive Behavior Therapy : Basics and Beyond by Judith S. Beck (2020, Hardcover)
5.0 out of 5 stars based on 4 product ratings
$18.95 New
$17.66 Used
Research Design : Qualitative, Quantitative, and Mixed Methods Approaches by J. David Creswell and John W. Creswell (2022, Trade Paperback)
4.0 out of 5 stars based on 4 product ratings
$19.00 New
$5.27 Used
National Electrical Code 2023 by (NFPA) National Fire Protection Association (2022, Trade Paperback)
5.0 out of 5 stars based on 2 product ratings
$25.00 New
---- Used

Save on Textbooks

Current slide {CURRENT_SLIDE} of {TOTAL_SLIDES}- Save on Textbooks

Diagnostic and Statistical Manual of Mental Disorders DSM-5-TR w/ PAGE TABLE
$25.00
Trending at $40.00
PMBOK A Guide to the Project Management Body of Knowledge 7th Ed NEW READ No Cov
$17.42
Trending at $33.15
usa stock Cognitive Behavior Therapy : Basics and Beyond by Judith S. Beck(2020)
$19.90
Trending at $20.80
NEW NFPA 70® NEC Handbook with Index Tabs : 2023 Edition by NFPA USA
$59.50
Trending at $67.45
Designing Data-Intensive Applications : The Big Ideas Behind Reliable Brand New
$15.00
Trending at $18.95
Diagnostic & Statistical Manual of Mental Disorders: DSM-5-TR(Hardcover) Fast...
$41.45
Trending at $43.95

Shop by category

Picture 1 of 2

Hands on SQL : The Language, Querying, Reporting and the Marketplace by Robert Groth (1996, CD-ROM / Trade Paperback)

About this product

Product Information

Product Identifiers

Product Key Features

Dimensions

Additional Product Features

All listings for this product

item 1 Hands on SQL : The Language, Querying, Reporting and the Marketpl

item 2 Hands-On SQL: The Language, Querying, Reporting and the Marketplac - ACCEPTABLE

item 3 Hands-On SQL: The Language, Querying, Reporting and the Marketplace (Bk - GOOD

item 4 Hands-on SQL: The Language, Querying,..., Groth, Robert

item 5 Hands-on SQL: The Language, Querying,..., Groth, Robert

item 6 Hands-on SQL: The Language, Querying, Re... by Groth, Robert Mixed media product

item 7 Hands-On SQL: The Language, Querying, Reporting and the Marketpl

Best Selling in Textbooks

Desk Reference to the Diagnostic Criteria from DSM-5-TR by American Psychiatric Association (2022, Trade Paperback)

Self Heal by Design : The Role of Micro-organisms for Health by Barbara O'Neill (2018, Trade Paperback)

Diagnostic and Statistical Manual of Mental Disorders DSM-5-TR by American Psychiatric Association (2022, Trade Paperback)

PMBOK® Guide Ser.: Guide to the Project Management Body of Knowledge (PMBOK Guide) and the Standard for Project Management by Project Management Institute (2021, Trade Paperback)

Cognitive Behavior Therapy : Basics and Beyond by Judith S. Beck (2020, Hardcover)

Research Design : Qualitative, Quantitative, and Mixed Methods Approaches by J. David Creswell and John W. Creswell (2022, Trade Paperback)

National Electrical Code 2023 by (NFPA) National Fire Protection Association (2022, Trade Paperback)

Save on Textbooks

Diagnostic and Statistical Manual of Mental Disorders DSM-5-TR w/ PAGE TABLE

PMBOK A Guide to the Project Management Body of Knowledge 7th Ed NEW READ No Cov

usa stock Cognitive Behavior Therapy : Basics and Beyond by Judith S. Beck(2020)

NEW NFPA 70® NEC Handbook with Index Tabs : 2023 Edition by NFPA USA

Designing Data-Intensive Applications : The Big Ideas Behind Reliable Brand New

Diagnostic & Statistical Manual of Mental Disorders: DSM-5-TR(Hardcover) Fast...

You may also like

CD-ROM Language Courses

Paperbacks Books CD-ROM

CD-ROM Language Courses in English

CD-ROM Language Courses in French

Workbook CD-ROM Language Courses

CD-ROM Language Courses 2000-2009 Publication Year