Database Systems: Design, Implementation, & Management

by Carlos Coronel, Steven Morris

Overview

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.

Product Details

ISBN-13:	9780357673034
Publisher:	Cengage Learning
Publication date:	12/15/2022
Series:	MindTap Course List
Edition description:	14th ed.
Pages:	816
Product dimensions:	8.40(w) x 10.70(h) x 1.30(d)

About the Author

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 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.

Table of Contents

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