May 1, 2024
Updated June 21, 2025
21 minute read
Navigating the World of Database Programming
rfbmbx|
Find a path to becoming a Database Programming. Learn more at:
OpenCourser.com/topic/rfbmbx/database
Reading list
We've selected 27 books
that we think will supplement your
learning. Use these to
develop background knowledge, enrich your coursework, and gain a
deeper understanding of the topics covered in
Database Programming.
This contemporary book explores the challenges and solutions for building modern data systems. It covers a wide range of topics including data models, storage, retrieval, distributed systems, consistency, and reliability. It's highly relevant for professionals and graduate students dealing with large-scale data and distributed databases, offering insights into current practices and trade-offs.
Serves as a foundational text for anyone entering the field of database programming. It covers the core concepts of database design, query languages like SQL, and the internal workings of database systems. It is frequently used as a textbook in academic settings and provides the necessary background for understanding more advanced topics.
Another highly regarded textbook in the field, this book offers a thorough introduction to database systems. It covers data modeling, database design theory, SQL, and the implementation of database systems. It's suitable for both undergraduate and graduate levels and strong choice for building a solid foundation in database concepts and programming.
For those looking to understand the inner workings of databases, this book provides a detailed exploration of storage engines, indexing, and the architecture of distributed data systems. It's particularly useful for advanced students and professionals who need to optimize database performance and troubleshoot complex issues.
Provides a practical and easy-to-understand guide to relational database design. It walks through the process of designing a database from requirements gathering to creating tables and relationships. It's an excellent starting point for beginners and those who need a clear methodology for database design.
Given the mention of Oracle PL/SQL in the course list, this book highly relevant resource for learning Oracle's procedural extension to SQL. It covers the fundamentals of PL/SQL programming, including stored procedures, functions, and packages. It's valuable for developers working with Oracle databases.
For those focusing on Microsoft SQL Server, this book provides a strong foundation in T-SQL, the dialect of SQL used by SQL Server. It covers essential T-SQL concepts and programming techniques, making it a valuable resource for developers working in the Microsoft ecosystem.
Focuses on common mistakes and bad practices in SQL and database design. It provides practical advice and solutions for avoiding these antipatterns, leading to more efficient and maintainable database code. It's a valuable resource for developers and database professionals looking to improve their SQL skills and database design practices.
Offers a practical and approachable introduction to SQL using the PostgreSQL database. It focuses on using SQL for data analysis and provides hands-on examples with real-world data. It's well-suited for beginners and those who want to learn SQL for data manipulation and analysis.
Focuses specifically on SQL performance tuning, explaining how to write efficient SQL queries and understand database query execution plans. It's a valuable resource for developers and DBAs who need to optimize the performance of their database applications.
A classic and in-depth book on transaction processing, this resource covers the fundamental concepts and techniques for ensuring data consistency and reliability in database systems. While technically challenging and older, the principles remain highly relevant for understanding how databases manage concurrent access and failures.
Practical guide to writing SQL queries. It is written in a clear and concise style and good choice for beginners.
Covers modern Oracle database programming techniques, including SQL, PL/SQL, and JSON. It's a relevant resource for developers working with recent versions of Oracle Database and looking to leverage its latest features.
Practical guide to PostgreSQL. It covers all aspects of the database, from installation to administration.
Comprehensive reference for MySQL. It covers all aspects of the database, from installation to administration.
Comprehensive guide to MongoDB. It covers all aspects of the database, from installation to administration.
Comprehensive guide to Elasticsearch. It covers all aspects of the database, from installation to administration.
For more information about how these books relate to this course, visit:
OpenCourser.com/topic/rfbmbx/database
Save
