Database skills are among the most in-demand IT skills today. Now you can gain a solid foundation in database design and implementation with the practical, easy-to-understand approach in the market-leading DATABASE SYSTEMS: DESIGN, IMPLEMENTATION, AND MANAGEMENT, 13E. Diagrams, illustrations, and tables clarify in-depth coverage of database design. You learn the key to successful database implementation as you study how to properly design databases to fit within the larger strategic data environment. Clear, straightforward writing supports an outstanding balance of theory and practice with hands-on skills today’s employers want. Revised SQL coverage offers more SQL examples and simpler explanations that focus on the areas most important for a database career. More coverage of Big Data Analytics and NoSQL, including related Hadoop technologies, now provides a stronger hands-on approach.
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 Visio 2010 Professional: A Tutorial.
Appendix Ab: Designing Databases with Visio 2013 Professional: 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.
-
MINDTAP® FOR DATABASE SYSTEMS OFFERS AN ONLINE, PERSONALIZED LEARNING EXPERIENCE WITH AUTO-GRADED MySQL LABS. MindTap® combines readings, multimedia activities, and assessments into a learning path that guides students through your course. You’ll find a full e-book as well as auto-gradable homework problems. End-of-chapter SQL problems can be completed and graded automatically in a completely online environment. Homework questions confirm students’ understanding of concepts and key terms while advanced assignments enable students to practice database design concepts.
-
IN MAY 2020, A COMPLETELY REDESIGNED MINDTAPV2.0 WILL BE AVAILABLE with loads of new features including How it Works in MySQL user notes to complement the existing coverage of Oracle SQL and Microsoft SQL Server, new auto-graded mySQL labs and coding snippets created to give students step-by-step practice in mySQL, additional UseIt! Activities (formerly known as Critical Thinking exercises), various types of Quick Lesson videos including Concept Clips, How-To and Career videos, and revised Appendices, with new coverage of Visio 2019 and LucidChart.
-
REVISED HANDS-ON FOCUS ON BIG DATA TOOLS AND NOSQL DATABASES PREPARES STUDENTS WITH THE SKILLS EMPLOYERS WANT. Students remain on the leading edge of database concepts as they become familiar with emerging tools, such as Big Data Analytics. This edition examines traditional and digital sources inside and outside of the company for ongoing discovery and analysis. Students also study NoSQL databases that are designed for fast storage and retrieval of data without strictly using the tabular structure of relational databases.
-
NEW TOPICS ENSURE YOUR COURSE COVERS THE LATEST DEVELOPMENTS IN THE FIELD. This edition’s expanded coverage addresses Big Data, NoSQL, and Hadoop technologies, as well as other topics reshaping today’s approach to database systems.
-
REVISED, REORGANIZED FOCUSED COVERAGE OF SQL. The 13th edition reorganizes coverage of SQL to focus first on data retrieval since this is the most central SQL programming skill for entry-level database positions. Restructured coverage now includes more examples and simplified explanations that eliminate the need for supplemental SQL programming books.
-
ENHANCED COVERAGE ADDRESSES TODAY’S MOST COMMONLY USED DATABASE SYSTEMS. To provide students with a breadth of understanding of database design and programming across a range of DBMS products, this edition now introduces all of today’s most commonly used database systems, including Oracle®, MySQL™, SQL Server, and Microsoft® Access.
-
REVIEW QUESTIONS, PROBLEM SETS, AND CASES CHECK STUDENTS’ COMPREHENSION OF KEY CONCEPTS. A variety of review questions, cases, and problem sets throughout this edition provide multiple opportunities for students to apply concepts, examine applications, and test their understanding of chapter material.
-
MEANINGFUL VISUALS CLARIFY CONCEPTS. This book’s full-color, detailed illustrations, tables, and diagrams enhance student comprehension and facilitate understanding of more complex concepts.
-
STUDENTS WORK WITH MULTIPLE DATABASES IN VARIOUS FORMATS. This edition introduces and provides opportunities for readers to gain experience in implementation 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. This book’s straightforward writing style offers an outstanding and understandable blend of foundational theory and today’s latest practices and applications with an emphasis on key hands-on skills.
-
FULL SET OF TEACHING SUPPORT PROVIDES TIME-SAVING RESOURCES AND ONLINE TOOLS. This edition includes PowerPoint® presentation slides, MS Access databases, Oracle®, MySQL™ and SQL Server scripts, test banks, and digital interactive student exercises that provide flashcards and other study tools. A comprehensive Instructor's Manual includes all end-of-chapter solutions, suggested discussion material, and other resources to ensure you have a complete teaching tool.
Cengage Testing, powered by Cognero® for Coronel's Database Systems: Design, Implementation, & Management
9781337627986
Cengage Testing, powered by Cognero® for Coronel's Database Systems: Design, Implementation, & Management, Instant Access
9781337627993
Instructor's Website for Coronel's Database Systems: Design, Implementation, & Management, 13th
9781337627917
VitalSource eBook: Database Systems 12 Months
9788000012391
MindTap: Database Systems 12 Months
9781337674867