Title:
Learning SQL : a step by step guide using Access
Personal Author:
Publication Information:
Boston, MA : Addison Wesley, 2003
ISBN:
9780321119049
Added Author:
Available:*
Library | Item Barcode | Call Number | Material Type | Item Category 1 | Status |
|---|---|---|---|---|---|
Searching... | 30000010019168 | QA76.73.S67 B33 2003 | Open Access Book | Book | Searching... |
On Order
Summary
Summary
Learning SQL: A Step-By-Step Guide Using Access is a brief, hands-on tutorial that covers the basics of using SQL and using the Access database engine with SQL. It assumes no previous knowledge of programming or databases.
Table of Contents
| (Each chapter, except Chapter 0, concludes with Exercises.) |
| 0 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 |
| 1 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 |
| 2 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 |
| 3 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 |
| 4 Joins |
| The Join |
| The Cartesian Product |
| Equi-Joins |
| Theta Joins |
| Natural Join |
| Joining More Than Two Tables |
| Outer Joins |
| 5 Functions |
| Aggregate Functions |
| Calculating with Fields as Row-level Functions |
| Other Functions |
| String Functions |
| Date Functions |
| 6 Query Development and Derived Structures |
| Query Development |
| Parentheses in SQL Expressions |
| Derived Structures |
| Query Development with Derived Structures |
| 7 Set Operations |
| Union And Union All |
| The In and Not..In Predicates |
| Using In as a Subquery |
| Using Not..In |
| Approaching the Difference Operation |
