Database skills are among the most in-demand IT skills. With its practical, accessible approach, Coronel/Morris' market-leading DATABASE SYSTEMS: DESIGN, IMPLEMENTATION, & MANAGEMENT, 14th edition, equips you with a solid foundation in database design and implementation for today's market. The authors blend foundational theory, the latest real-world practices and the skills employers want. Straightforward writing and vivid illustrations make even complex concepts easy to understand. You'll learn the key to successful database implementation as you study how to properly design databases that fit within the larger strategic data environment. Expanded coverage includes big data analytics, NoSQL and data visualization technologies. In addition, the MindTap digital platform gives you real-world, hands-on practice to help you prepare for a successful career in database design and management.
Part I: DATABASE CONCEPTS
1. Database Systems
2. Data Models
Part II: DESIGN CONCEPTS
3. The Relational Database Model
4. Entity Relationship (ER) Modeling
5. Advanced Data Modeling
6. Normalization of Database Tables
Part III: ADVANCED DESIGN AND IMPLEMENTATION
7. Introduction to Structured Query Language (SQL)
8. Advanced SQL
9. Database Design
Part IV: ADVANCED DATABASE CONCEPTS
10. Transaction Management and Concurrency Control
11. Database Performance Tuning and Query Optimization
12. Distributed Database Management Systems
13. Business Intelligence and Data Warehouses
14. Big Data Analytics and NoSQL
Part V: DATABASES AND THE INTERNET
15. Database Connectivity and Web Technologies
Part VI: DATABASE ADMINISTRATION
16. Database Administration and Security
ONLINE APPENDICES
Appendix Aa: Designing Databases with Lucicharts: A Tutorial
Appendix Ab: Designing Databases with Visio: A Tutorial
Appendix B: The University Lab: Conceptual Design
Appendix C: The University Lab: Conceptual Design Verification, Logical Design, and Implementation
Appendix D: Converting the ER Model into a Database Structure
Appendix E: Comparison of ER Model Notations
Appendix F: Client/Server Systems
Appendix G: Object-Oriented Databases
Appendix H: Unified Modeling Language (UML)
Appendix I: Databases in Electronic Commerce
Appendix J: Web Database Development with ColdFusion
Appendix K: The Hierarchical Database Model
Appendix L: The Network Database Model
Appendix M: Microsoft Access Tutorial
Appendix N: Creating a New Database Using Oracle 12c
Appendix O: Data Warehouse Implementation Factors
Appendix P: Working with MongoDB
Appendix Q: Working with Neo4j
-
Carlos Coronel
Carlos Coronel is currently the Lab Director for the College of Business Computer Labs at Middle Tennessee State University. He has more than 29 years of experience in various fields as a Database Administrator, Network Administrator, Web Manager, and Technology Specialist. He has taught courses in Web development, database design and development, and data communications at the undergraduate and graduate levels.
-
Steven Morris
Steven Morris completed his Bachelor of Science and Ph.D. from Auburn University. He has taught Database Design and Development, Database Programming with Advanced SQL and PL/SQL, Systems Analysis and Design, and Principles of MIS at Middle Tennessee State University. Steven has published many articles, and currently serves on the review boards of several journals.
-
Through MindTap's digital lab assignments, students write SQL code in an interactive environment and receive real-time feedback on their work. Module Quizzes, Problems and Use It activities help students apply what they're learning to real-world scenarios. Database for Life assignments keep students current on what's trending, and Concept Video Clips explain and illustrate database system terms and concepts. At the end of the course students can explore the Career Connection unit, which includes videos on potential career paths in the database field and a career reflection assignment.
-
A more hands-on focus on big data tools and NoSQL databases equips students with the skills employers want. Immersed in leading edge database concepts, students become familiar with emerging tools such as big data analytics.
-
Clear presentation balances theory and practice. The authors' straightforward, easy-to-understand writing style blends foundational theory with the latest practices and applications and an emphasis on key hands-on skills.
-
Expanded coverage of SQL eliminates the need for supplemental programming books. Reorganized coverage focuses first on data retrieval since this is the most central SQL programming skill for entry-level database positions.
-
Enhanced coverage addresses today's most used database systems, giving students a broad understanding of database design and programming across a range of DBMS products, including Oracle®, MySQL™, SQL Server and Microsoft® Access.
-
Auto-graded MySQL labs and homework questions confirm students’ understanding of key concepts and terms, while advanced assignments enable learners to practice database design concepts.
-
Module Quizzes, Problems and Use It activities help students apply what they're learning to real-world scenarios. Database for Life assignments keep students current on what's trending, and Concept Video Clips explain and illustrate database system terms and concepts. At the end of the course students can explore the Career Connection unit, which includes videos on potential career paths in the database field and a career reflection assignment.
-
Engaging visuals clarify concepts. Full-color, detailed illustrations, tables and diagrams enhance student comprehension of even the most complex concepts.
-
Enabling students to work with multiple databases in various formats, this edition provides opportunities for readers to gain experience using all of today's most commonly used database systems, including Microsoft® Access, Microsoft® SQL Server, MySQL™ and Oracle® databases.
-
Clear presentation balances theory and practice. The authors' straightforward, easy-to-understand writing style blends foundational theory with the latest practices and applications and an emphasis on key hands-on skills.
-
Robust teaching and learning support provides time-saving resources and online tools. PowerPoint® presentation slides, MS Access databases, Oracle®, MySQL™ and SQL Server scripts, test banks, interactive digital exercises, flashcards and other study tools help maximize student success. In addition, the comprehensive Instructor's Manual includes all end-of-chapter solutions, suggested discussion material and other resources to help you maximize your class prep time.
Cengage Testing, powered by Cognero® for Coronel/Morris' Database Systems: Design, Implementation, & Management
9780357673058
Cengage Testing, powered by Cognero® for Coronel/Morris' Database Systems: Design, Implementation, & Management, Instant Access
9780357673065
Instructor Companion Website for Coronel/Morris' Database Systems: Design, Implementation, & Management
9780357673041
Cengage eBook: Database Systems: Design, Implementation, & Management 12 Months
9788000040202
MindTap: Database Systems: Design, Implementation, & Management 12 Months
9780357891544