Foundations of Database Management

By Eric Frick

Master PostgreSQL, SQL, and Modern Database Design Through Hands-On Learning

Every modern application depends on a database. Whether you're building web applications, cloud services, business systems, or AI-powered solutions, understanding relational databases is one of the most valuable technical skills you can develop.

Foundations of Database Management is a practical, beginner-friendly guide that teaches you how to design, build, query, secure, and optimize relational databases using PostgreSQL, one of the world's leading open-source database management systems. Designed for aspiring software developers, IT professionals, database administrators, and students, this book emphasizes learning by doing through real-world examples and hands-on practice.

Unlike many database books that focus primarily on theory, this book helps you develop practical skills you can immediately apply to your own projects and career. You'll progress from the fundamentals of relational databases to advanced SQL querying, performance optimization, security, backup strategies, and database administration before completing a comprehensive capstone project.

FREE Companion Online Course and Hands-On Labs

Your purchase includes free access to the companion online video course and interactive hands-on labs from Destin Learning.

Watch each lesson as it's taught, then reinforce your knowledge by completing guided PostgreSQL labs in a live development environment. The online course allows you to learn at your own pace while gaining real experience creating databases, writing SQL queries, designing schemas, and administering PostgreSQL systems.

Inside This Book You'll LearnDatabase fundamentals and the relational modelInstalling and configuring PostgreSQLPostgreSQL architecture, schemas, and rolesCreating tables and selecting appropriate data typesPrimary keys, foreign keys, and database relationshipsDatabase design using Entity-Relationship Diagrams (ERDs)Database normalization and best design practicesWriting SQL queries with SELECT, WHERE, GROUP BY, and JOINAdvanced SQL using subqueries, Common Table Expressions (CTEs), and window functionsModifying data with INSERT, UPDATE, DELETE, and transactionsACID properties and concurrency controlIndexes, query optimization, and performance tuningBackup, recovery, users, permissions, and database securityBuilding a complete PostgreSQL database project from design through implementationThis Book Is Perfect ForBeginning software developersComputer science and IT studentsDatabase administratorsCloud engineersDevOps professionalsSystem administratorsAnyone learning SQL or PostgreSQLProfessionals preparing for technical interviews or certification

No previous database experience is required.

Learn by Building Real Databases

Knowledge becomes valuable when you apply it. Throughout this book you'll complete practical exercises and guided labs that reinforce every major concept. By the end of the course you'll have designed, implemented, and documented a complete relational database while developing skills used every day by professional software developers and database administrators.

Whether you're launching a new career, strengthening your technical foundation, or expanding your software development skills, Foundations of Database Management provides the knowledge, practical experience, and confidence to work with modern relational databases.

Read it. Watch it. Practice it. Build it.

Start your journey into professional database development today with Foundations of Database Management from Destin Learning.

• Format: Paperback
• Language: English
• ISBN: B0H8P85LZ2
• ISBN13: 9798187074341
• Release Date: July 2026
• Publisher: Independently Published
• Length: 322 Pages
• Weight: 0.95 lbs.
• Dimensions: 0.7" x 6.0" x 9.0"