Learning SQL A Step-by-Step Guide Using Access

Name: Learning SQL A Step-by-Step Guide Using Access
Price: 4.91 USD
Availability: InStock
ISBN: 9780321119049

ISBN-10: 0321119045

ISBN-13: 9780321119049

Edition: 2003

Authors: Sikha S. Bagui, Richard Earp

List price: $58.00

30 day, 100% satisfaction guarantee!

Marketplace

1 new & used from $4.91

what's this?

Rush Rewards U
Members Receive:

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.

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