Book description
Learn standard database design and management techniques applicable to any type of database. Featuring clear examples using both Microsoft Access and Oracle, Databases: A Beginner's Guide begins by showing you how to use Structured Query Language (SQL) to create and access database objects. Then, you'll discover how to implement logical design using normalization, transform the logical design into a physical database, and handle data and process modeling. You'll also get details on database security, online analytical processing (OLAP), connecting databases to applications, and integrating XML and object content into databases.
Designed for Easy Learning
- Key Skills & Concepts--Chapter-opening lists of specific skills covered in the chapter
- Ask the Expert--Q&A sections filled with bonus information and helpful tips
- Try This--Hands-on exercises that show you how to apply your skills
- Notes--Extra information related to the topic being covered
- Self Tests--Chapter-ending quizzes to test your knowledge
Table of contents
- Cover Page
- Databases: A Beginner's Guide
- Copyright Page
- Contents
- ACKNOWLEDGMENTS
- INTRODUCTION
-
PART I Database Concepts
- 1 Database Fundamentals
- 2 Exploring Relational Database Components
-
3 Forms-based Database Queries
- QBE: The Roots of Forms-based Queries
- Getting Started in Microsoft Access
- The Microsoft Access Relationships Panel
- The Microsoft Access Table Design View
- Creating Queries in Microsoft Access
- Try This 3-1: List All Customers
- Try This 3-2: Choose Columns to Display
- Try This 3-3: Sorting Results
- Try This 3-4: Advanced Sorting
- Try This 3-5: Choosing Rows to Display
- Try This 3-6: Compound Row Selection
- Try This 3-7: Using Not Equal
- Try This 3-8: Joining Tables
- Try This 3-9: Limiting Join Results
- Try This 3-10: Outer Joins
- Try This 3-11: Microsoft Access SQL
- Try This 3-12: Multiple Joins and Calculated Columns
- Try This 3-13: Aggregate Functions
- Try This 3-14: Self-Joins
-
4 Introduction to SQL
- A Brief History of SQL
- Getting Started with Oracle SQL
- Try This 4-1: Unlock the HR Account and Log in as HR
- Where's the Data?
- Try This 4-2 Using the Application Express Object Browser
- Data Query Language (DQL): The SELECT Statement
- Data Manipulation Language (DML)
- Data Definition Language (DDL) Statements
- Data Control Language (DCL) Statements
-
PART II Database Development
- 5 The Database Life Cycle
- 6 Database Design Using Normalization
- 7 Data and Process Modeling
- 8 Physical Database Design
-
PART III Database Implementation
- 9 Connecting Databases to the Outside World
- 10 Database Security
- 11 Deploying Databases
- 12 Databases for Online Analytical Processing
- 13 Integrating XML Documents and Objects into Databases
-
PART IV Appendices
-
A Answers to Self Tests
- Chapter 1: Database Fundamentals
- Chapter 2: Exploring Relational Database Components
- Chapter 3: Forms-based Database Queries
- Chapter 4: Introduction to SQL
- Chapter 5: The Database Life Cycle
- Chapter 6: Database Design Using Normalization
- Chapter 7: Data and Process Modeling
- Chapter 8: Physical Database Design
- Chapter 9: Connecting Databases to the Outside World
- Chapter 10: Database Security
- Chapter 11: Deploying Databases
- Chapter 12: Databases for Online Analytical Processing
- Chapter 13: Integrating XML Documents and Objects into Databases
-
B Solutions to the Try This Exercises
- Try This 5-1 Solution: Project Database Management Tasks
- Try This 6-1 Solution: UTLA Academic Tracking
- Try This 6-2 Solution: Computer Books Company
- Try This 7-1 Solution: Draw an ERD in Information Engineering (IE) Format
- Try This 8-1 Solution: Mapping a Logical Model to a Physical Database Design
- Try This 10-1 Solution: Database Object Privileges
- Try This 11-1 Solution: SQL Transaction Support
- Try This 12-1 Solution: Design Star Schema Fact and Dimension Tables
- Try This 13-1 Solution: Using SQL/XML Functions
-
A Answers to Self Tests
- Index
Product information
- Title: Databases A Beginner's Guide
- Author(s):
- Release date: May 2009
- Publisher(s): McGraw-Hill
- ISBN: 9780071608473
You might also like
video
Introducing SQL and Relational Databases
Start on the road to mastery of SQL and databases: two of the most important topics …
book
Data Modeling, A Beginner's Guide
Essential Skills--Made Easy! Learn how to create data models that allow complex data to be analyzed, …
book
Next Generation Databases: NoSQL, NewSQL, and Big Data
This is a book for enterprise architects, database administrators, and developers who need to understand the …
book
Learn PostgreSQL
A comprehensive guide to building, managing, and securing scalable and reliable database and data warehousing applications …