Skip to content

Learning SQL A Step-by-Step Guide Using Access

Spend $50 to get a free DVD!

ISBN-10: 0321119045

ISBN-13: 9780321119049

Edition: 2003

Authors: Sikha S. Bagui, Richard Earp

List price: $58.00
Blue ribbon 30 day, 100% satisfaction guarantee!
what's this?
Rush Rewards U
Members Receive:
Carrot Coin icon
XP icon
You have reached 400 XP and carrot coins. That is the daily max!

Description:

This book is a brief, hands-on tutorial covering the basics of using SQL, as well as using the Access database engine and SQL. An introduction to beginning SQL tasks is accomplished in this book. A series of exercises at the end of each chapter takes these newly leaned SQL skills and puts them to work. While learning about SQL, readers will also gain insight on how the basics are used by professional Access programmers.
Customers also bought

Book details

List price: $58.00
Copyright year: 2003
Publisher: Addison-Wesley Longman, Incorporated
Publication date: 2/10/2003
Binding: Paperback
Pages: 336
Size: 8.00" wide x 9.50" long x 0.75" tall
Weight: 1.342
Language: English

(Each chapter, except Chapter 0, concludes with Exercises.)
The Software Engineering Process and Relational Databases
What is a Database? Database Models
A Brief Look at Normal Forms
What is the Software Engineering Process?
References
Getting into SQL in Access
Opening up the Student.mdb Database
Getting into SQL in Access
Typing in an SQL Query
Running an SQL Query
Saving an SQL Query
Editing a SQL Query in Access
Viewing Table Designs
Viewing Data in Tables
Deleting tables or Queries
Printing SQL Code and Output from Access
Beginning SQL commands in Access
The Select
Selecting Fields
Selecting Rows (tuples)
Using Aliases
Table Qualifiers
A Convention for Writing SQL Statements
Few Syntactical Notes about SQL in Access
Creating and Populating Tables
Creating a Table
Inserting Values into a Table
The Update Command
The Alter Table Command
The Delete Command
Deleting a Table
Data Types in Access
The Date type and Date Formatting
Joins
The Join
The Cartesian Product
Equi-Joins
Theta Joins
Natural Join
Joining More Than Two Tables
Outer Joins
Functions
Aggregate Functions
Calculating with Fields as Row-level Functions
Other Functions
String Functions
Date Functions
Query Development and Derived Structures
Query Development
Parentheses in SQL Expressions
Derived Structures
Query Development with Derived Structures
Set Operations
Union And Union All
The In and Not..In Predicates
Using In as a Subquery
Using Not..In
Approaching the Difference Operation