Relational Database Design & SQL
Edition 2.0 | Copyright 2025 | Publication Date: September 2024
Overview
Features
Table of Contents
Supplements
Overview
Using a hands-on and easy to understand approach, this textbook guides students through every phase of database design and SQL implementation. A practical how-to book that is clear, concise, but comprehensive with easy-to-follow examples illustrating each topic in detail. Designed with clarity and practicality in mind, this book provides all the tools to master essential database skills.
Students are guided through the database design process including (1) analyzing user requirements and constructing data models using entity-relationship diagrams (ERD), normalization, and relational data models; (2) using Data Definition Language (DDL) to create and alter database objects and implement database constraints; (3) using Data Manipulation Language (DML) to add, delete, and modify data in database tables; (4) developing single-table and multi-table database queries; and (5) implementing views and indexes. By the end of this book, students are equipped to design and implement a sophisticated multi-table database tailored to real-world business needs, bridging theory with practical application.
Textbook Features
- Designed for two-year and four-year database courses.
- Includes detailed examples throughout the book.
- Includes real-life business problems at the end of each chapter.
- The only source needed for learning and referencing database design and SQL.
Relational Database Design
- Learn how to analyze user requirements and construct robust data models using entity-relationship diagrams (ERDs).
- Delve into the principles of normalization and the relational data model to ensure your database design is both efficient and scalable.
Data Definition Language (DDL)
- Discover how to utilize Data Definition Language (DDL) for creating and altering database objects.
- Learn to enforce database constraints to maintain data integrity and structure.
Data Manipulation Language (DML)
- Gain proficiency in Data Manipulation Language (DML) to effectively add, delete, and modify data within database tables.
- Develop skills to manage and manipulate data with precision.
SQL Query Development
- Master the art of crafting single-table and multi-table queries.
- Build complex queries to extract and analyze data, enhancing your ability to answer business questions and support decision-making.
Views and Indexes
- Explore the creation and implementation of views and indexes to optimize query performance and simplify data access.
Chapter 1 Introduction to Database Design
Chapter 2 Entity Relationship Diagrams using IE Notation
Chapter 3 Advanced ER Diagrams using IE Notation
Chapter 4 Entity Relationship Diagrams using Barker Notation
Chapter 5 Normalization
Chapter 6 Relational Data Model and Business Rules
Chapter 7 Create Table Structure and Modify Data
Chapter 8 Database Constraints and Constraint Testing
Chapter 9 SQL SELECT Statement
Chapter 10 Restricting Rows and Sorting Data
Chapter 11 SQL Functions
Chapter 12 Group Functions & GROUP BY
Chapter 13 Multiple-Table JOINs
Chapter 14 Subqueries
Chapter 15 Views and Indexes
Appendix A DBeaver
Cooper Books provides instructor resources for each title. These resources are available to instructors only and are password protected. For additional information contact info@cooperbooks.com.
Tools & Resources for this Title
Resources for Instructors
To support instructors that use our titles, we have put together resources such as activities and tests that can be used. These resources are free if you are an instructor.
Resources for Students
If you are a student using our titles for school we are happy to provide you with resources to support your studies. These resources are free for everyone.
Coming Soon
Additional Resources
If you are looking for something specific to support your teachings or studies, you can reach out and let us know. We are happy to help you find what you’re looking for.