Class Central is learner-supported. When you buy through links on our site, we may earn an affiliate commission.

Database Design and Modeling with PostgreSQL and MySQL

Packt via Coursera

Go to class Write review

Details

Go to class

Provider

Coursera
Pricing

Paid Course
Languages

English
Certificate

Certificate Available
Effort

8 weeks, 1 hour a week
Sessions

Self-Paced
Level

Intermediate
Subtitles

English

Found in

Overview

Google, IBM & Meta Certificates – 40% Off

One plan covers every Professional Certificate on Coursera.

Unlock All Certificates

Modern applications rely on efficient, scalable, and well-structured databases to manage growing volumes of data. This course explores database design and modeling using PostgreSQL and MySQL, helping learners build strong foundations in relational database architecture, schema design, and optimization strategies for real-world systems. Throughout the course, learners will develop practical skills in database normalization, query optimization, scalability planning, and advanced modeling techniques. By working through hands-on examples and real-world database scenarios, learners will gain the confidence to design reliable databases that support modern business and application requirements. What sets this course apart is its balance of foundational theory and practical implementation using two of the industry's most widely used database systems. It combines conceptual understanding with applied techniques, including database maintenance, scalability considerations, and emerging trends shaping the future of database technologies. This course is ideal for software developers, database administrators, data analysts, and IT professionals seeking practical database design skills. Beginners can follow along comfortably, while those with basic relational database knowledge will gain deeper technical expertise and hands-on experience.

Syllabus

SQL and NoSQL Databases: Characteristics, Design, and Trade-Offs

This module examines the fundamental differences between SQL and NoSQL databases, focusing on their data models, scalability, and design trade-offs. Learners will explore relational, document, and graph data models, understand the implications of the CAP theorem, and compare transaction management approaches. By the end, you'll be equipped to make informed decisions about database selection and design for various application needs.

Building a Strong Foundation for Database Design

This module introduces the essential principles of database design, including the relational model, entity-relationship diagrams, and normalization up to third normal form. Learners will gain practical skills to ensure data integrity and create efficient, well-structured databases.

Getting Your Hands Dirty with PostgreSQL and MySQL

This module provides hands-on experience with setting up and managing PostgreSQL and MySQL databases using the command line. Learners will practice designing schemas, ensuring data integrity, and writing complex SQL queries to analyze real-world datasets. By the end, you'll be equipped to administer databases and extract meaningful insights from data.

Mastering the Building Blocks of Database Design and Modeling

This module delves into essential concepts of database design, including data types, constraints, and keys, to ensure data integrity and consistency. Learners will explore how to implement and manage primary and foreign keys, check constraints, and ACID transactions, as well as techniques for handling concurrency in multi-user environments.

Advanced Techniques for Advanced Databases

This module delves into advanced database optimization techniques, including the use of indexing, views, stored procedures, user-defined functions, and common table expressions. Learners will gain practical skills to enhance query performance, simplify complex data retrieval, and improve database maintainability across platforms like MySQL and PostgreSQL.

Understanding Database Scalability

This module introduces key strategies for scaling databases, including horizontal and vertical scaling, replication, sharding, and serverless architectures. Learners will explore practical solutions such as Citus for PostgreSQL and InnoDB Cluster for MySQL, gaining insights into how modern technologies enhance database performance and reliability.

Best Practices for Building and Maintaining Your Database

This module guides learners through essential strategies for designing, optimizing, and maintaining robust databases. You will explore topics such as schema design, data type selection, query optimization, replication, and data governance, with practical insights for both PostgreSQL and MySQL environments. By the end, you'll be equipped to enhance database performance, reliability, and data quality.

The Future of Databases and Their Designs

This module examines the latest advancements in relational and distributed database technologies, including enhancements in MySQL and PostgreSQL, cloud-native architectures, and emerging solutions like YugabyteDB and YDB. Learners will explore real-time analytics, advanced monitoring, and scalability features that are shaping the next generation of database systems.