Free Shipping In the UK
Hands-On SQL By Robert Groth

Hands-On SQL
by Robert Groth

In Stock
Shows how anyone working with a database can familiarize themselves with SQL in three hours using the DC and become conversant by following the hands-on approach. This package contains Centura Software Corporation's SQL Wilndows Solo, Quest (what the enduser uses to query a database) and exercises relating to the book.
Only 1 left

Hands-On SQL Summary

Hands-On SQL: The Language, Querying, Reporting and the Marketplace (Bk/CD-ROM) by Robert Groth

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.

Why buy from World of Books

Our excellent value books literally don't cost the earth
Free delivery in the UK
Read more here
Every used book bought is one saved from landfill

Table of Contents


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.


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.


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.


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.


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. Connectivity: Direct Access Solution Vendors. Connectivity: Vendors with ODBC Drivers. Connectivity: Vendors with Multidatabase APIs. Connectivity: Gateways. Connectivity: Vendors with Middleware Products. End-User Query Vendors. EIS Players. Report Generation Vendors. Data Warehousing Vendors. Parallel Database Vendors. Object-Oriented Databases with SQL Extensions. Decentralized Replication Vendors. Database Internet Vendors.

B. Installing SQL Solo.

Installing CD-ROM Software. Installing SQL Solo on Windows 95.

C. The LEAD Toolkit: A Demonstration.

Additional information

Hands-On SQL: The Language, Querying, Reporting and the Marketplace (Bk/CD-ROM) by Robert Groth
Robert Groth
Used - Good
Pearson Professional Education
Book picture is for illustrative purposes only, actual binding, cover or edition may vary.
This is a used book - there is no escaping the fact it has been read by someone else and it will show signs of wear and previous use. Overall we expect it to be in very good condition, but if you are not entirely satisfied please get in touch with us.