x

Our Privacy Policy has changed. By using this site, you agree to the Privacy Policy.

Inside Relational Databases with Examples in Access

ISBN-10: 1846283949
ISBN-13: 9781846283949
Edition: 2007
List price: $54.95 Buy it from $29.05
This item qualifies for FREE shipping

*A minimum purchase of $35 is required. Shipping is provided via FedEx SmartPost® and FedEx Express Saver®. Average delivery time is 1 – 5 business days, but is not guaranteed in that timeframe. Also allow 1 - 2 days for processing. Free shipping is eligible only in the continental United States and excludes Hawaii, Alaska and Puerto Rico. FedEx service marks used by permission."Marketplace" orders are not eligible for free or discounted shipping.

30 day, 100% satisfaction guarantee

If an item you ordered from TextbookRush does not meet your expectations due to an error on our part, simply fill out a return request and then return it by mail within 30 days of ordering it for a full refund of item cost.

Learn more about our returns policy

Description: The first two editions of Inside Relational Databases have both been best sellers. These new editions will also cover the relational database model but will use different engines to illustrate the model. In doing so, readers will be able to apply  More...

New Starting from $39.92
what's this?
Rush Rewards U
Members Receive:
coins
coins
You have reached 400 XP and carrot coins. That is the daily max!
You could win $10,000

Get an entry for every item you buy, rent, or sell.

Study Briefs

Limited time offer: Get the first one free! (?)

All the information you need in one place! Each Study Brief is a summary of one specific subject; facts, figures, and explanations to help you learn faster.

Add to cart
Study Briefs
SQL Online content $4.95 $1.99
Add to cart
Study Briefs
MS Excel® 2010 Online content $4.95 $1.99
Add to cart
Study Briefs
MS Word® 2010 Online content $4.95 $1.99
Add to cart
Study Briefs
MS PowerPoint® 2010 Online content $4.95 $1.99

Customers also bought

Loading
Loading
Loading
Loading
Loading
Loading
Loading
Loading
Loading
Loading

Book details

List price: $54.95
Copyright year: 2007
Publisher: Springer
Publication date: 10/31/2006
Binding: Paperback
Pages: 372
Size: 7.00" wide x 9.25" long x 1.00" tall
Weight: 1.496
Language: English

The first two editions of Inside Relational Databases have both been best sellers. These new editions will also cover the relational database model but will use different engines to illustrate the model. In doing so, readers will be able to apply the model using their preferred database engine. Initially three versions are planned starting with Access, SQL Server and my SQL. The books show just how simple and useful databases can be. No prior knowledge is required i.e. real world examples show how to manage data efficiently. A significant amount of new material is included in the core of the book and particular emphasis is given to showing how to make a database run faster and more efficiently.

Preface
Introduction
Who are we?
What is a database?
Databases vs. Database Management Systems
Relational Database Management Systems
Why this book?
Who should read this book?
Organization of the book
Some ground rules
Downloading files from the website
Acknowledgements
We don't have problems...
Outroduction
A simple, single-table database
Introduction to Part 1
Tables
Queries/Views
Forms
Reports
Tables
Rows & columns - records & fields
Building a table
Types of data
Meaningful operations
Excluding certain errors
Making storage more efficient
Making data recall more rapid
Field size
General notes on table design
Queries/Views
Queries usually find subsets of the data
Queries, answer tables and base tables finally defined properly and closure mentioned briefly
Summarizing data
Other useful queries
Graphical querying tools
SQL and Views
Forms
Multiple forms per table
Text boxes can be made read only
Text boxes don't have to present data from just one field
It isn't necessary for each field in a table to appear on the form
Controlling data entry
Use of forms can be controlled
Forms can be web pages
Summary
Reports
Summary of Part 1
A multi-table database
Introduction to Part 2
Serious problems with single tables
Redundant data
Typographical errors
Modifying data
Summary
Multiple tables cure serious problems
Redundant data
Typographical errors
Modifying data
Making multiple tables work together
Databases are designed to model the real world
Getting the data into the correct tables
Not normalization (and not ER modeling either)
Object identification
Relationships in the real world
One-to-many
One-to-one
Many-to-many
None
Mapping real world relationships to tables
How are relationships modeled?
Primary keys
Foreign keys
Summary so far
Joins
General lessons about joins
Revisiting the big four - the synergy begins
Closure
Tables
Queries (and a bit on forms)
Forms
Reports
Integrity
Data integrity - is it worth the effort?
Types of data integrity error (and some cures)
Declarative and procedural referential integrity
Nulls in foreign keys
These options in context
Other integrity issues
Integrity - where should you set it?
Summary of Part 2
Database Design & Architecture
Database design
Designing databases - user, logical and physical models
The Logical model - overview
More about the logical model
CASE tools
Summary so far
The final big advantage of CASE tools
More about the differences between the Logical and Physical models
Reality check
Normalization can help
Reverse engineering
Methodologies
Summary of design models
The seven layers of wisdom
The seven layers of wisdom
Database architecture
Default Architecture in Access
Access - PC front end - data on file server
Client-server (or two-tier) architecture
Three-tier architecture (also known as multi-tier)
Web-based applications
Choosing a database architecture
What comes next
Related database topics
What exactly is a relational database?
Do multiple tables a relational database make?
Triggers and stored procedures
Triggers
Stored procedures
Summary - triggers and stored procedures
Transactions, logs, backup, locking and concurrency
Transactions
Logs
Locking
Concurrency
Row locking and page locking
Access and the features described in this chapter
Answers from earlier
Codd's rules
Codd's rules
Economy vs. readability
A little background
The rules themselves
Summary
Normalization
A first look at normalization
First normal form (first level of normalization): 1NF
Second normal form (second level of normalization): 2NF
Third normal form (third level of normalization): 3NF
Summary so far
Adding some definitions
Summary (again)
More about normalization
Higher normal forms
Normalization doesn't automatically remove all redundancy
Summary
The system tables
More on queries: data manipulation
Relational operators
Summary
SQL
SELECT and FROM
DISTINCT
WHERE
Conditions
ORDER BY
Wildcards
Sub-queries
Built-in functions
GROUP BY - collecting information
GROUP BY...HAVING - collecting specific information
Working with multiple tables
Inner (Natural) joins
Outer joins
UNION
SELECT summary
INSERT
UPDATE
DELETE
A question (and a free SQL diagnostic tool)
Summary
Domains
What does null mean?
Primary keys
Candidate keys
Speeding up your database
Hardware considerations
CPUs
Memory
Disks
Data volume vs. disk capacity
Don't put all your eggs in one basket
Indexing
Indexing techniques
Applying indexes - which fields/columns should be indexed?
Intelligent use of indexes
More on optimization
Query optimization
Update statistics
Query analysis
Writing good SQL code
Denormalization
Mirroring tables
Splitting tables
Redundant data
Repeating groups (breaking 1NF)
Derived columns
Summary
GUIs, macros and control languages
Creating a very simple user interface
Other languages - SQL
Index

×
Free shipping on orders over $35*

*A minimum purchase of $35 is required. Shipping is provided via FedEx SmartPost® and FedEx Express Saver®. Average delivery time is 1 – 5 business days, but is not guaranteed in that timeframe. Also allow 1 - 2 days for processing. Free shipping is eligible only in the continental United States and excludes Hawaii, Alaska and Puerto Rico. FedEx service marks used by permission."Marketplace" orders are not eligible for free or discounted shipping.

Learn more about the TextbookRush Marketplace.

×