Download PDF A GUIDE TO SQL Eighth Edition by Philip J. Pratt

Sinopsis

Structured Query Language (or SQL, which is pronounced “se-quel,” or “ess-cue-ell”) is a popular computer language that is used by diverse groups such as home computer users, owners of small businesses, end users in large organizations, and programmers. Although this text uses the SQL implementation in the Oracle Database 10g Express Edition as a vehicle for teaching SQL, its chapter material, examples, and exercises can be completed using any SQL implementation. A Guide to SQL, Eighth Edition is written for a wide range of teaching levels, from students taking introductory computer science classes to those students in advanced information systems classes. This text can be used for a standalone course on SQL or in conjunction with a database concepts text where students are required to learn SQL.

The chapters in this text should be covered in order. Students should complete the end-ofchapter exercises and the examples within the chapters for maximum learning. Because the content of Chapter 8 assumes that the reader has had instruction or experience in at least one programming language, the instructor should determine whether students will understand its concepts. Students without a programming background will have difficulty understanding the topic of embedded SQL. Instructors can easily omit Chapter 8 from the text in situations where students are not comfortable with programming examples.

The Eighth Edition builds on the success of previous editions by presenting basic SQL commands in the context of a business that uses SQL to manage orders, parts, customers, and sales reps. Like in previous editions, this edition uses Oracle as the vehicle to present SQL commands. Like the last edition, this edition addresses SQL in Access™ by showing the Access versions of the same commands when they differ from the Oracle versions. This new edition also shows SQL Server commands when they differ from the Oracle versions. Differences for Access and SQL Server users are featured in “User” notes, which make it easy for students to identify differences for the SQL implementation they are using. Students can download the Oracle 10g Database Express Edition from the Oracle Web site for free and use it to complete this text without having to purchase or install the full Oracle program.

The Eighth Edition includes an entire chapter on database design, showing students how to create an appropriate design that satisfies a given set of requirements, and includes coverage of the important topics of stored procedures and triggers. The text also contains updated exercises for the Premiere Products, Henry Books, and Alexamara Marina Group cases.

Content

1. Introduction to Premiere Products, Henry Books, and Alexamara Marina Group
2. Database Design Fundamentals
3. Creating Tables
4. Single-Table Queries
5. Multiple-Table Queries
6. Updating Data
7. Database Administration
8. SQL Functions and Procedures

Click here to download