What will you learn in Database Design and Basic SQL in PostgreSQL Course
How to use SQL in PostgreSQL to implement CRUD operations, manage database schema, and work in the
psqlconsole.Relationships modeling in relational databases: primary, foreign, and logical keys, as well as one-to-many and many-to-many structures.
Core principles of database design, including normalization and schema planning, grounded in real-world examples.
Comparisons between SQL and NoSQL design paradigms and when to use each.
Program Overview
Module 1: Introduction to SQL & CRUD
⌛ 1 week
Topics: History of relational databases, basic SQL operations (INSERT, SELECT, UPDATE, DELETE)
Hands-on: Building and manipulating tables using
psqland CLI commands
Module 2: Single-Table SQL & Data Retrieval
⌛ 1 week
Topics: Filtering with WHERE, ordering with ORDER BY, SELECT DISTINCT, grouping basics
Hands-on: Query exercises on flat and simple relational datasets
Module 3: Relational Modeling: One-to-Many & Many-to-Many
⌛ 1 week
Topics: Entity relationships, join logic, referential integrity enforcement
Hands-on: Designing and querying normalized relational data structures
Module 4: Advanced Relationships, Indexing & Design Reflection
⌛ 1 week
Topics: Final schema designs for many-to-many relationships, normalization schemes
Hands-on: End-of-course modeling assignment building a working relational example
Get certificate
Job Outlook
Skills in SQL and database design are fundamental for roles in backend development, data engineering, BI analysis, and digital analytics.
Proficiency in PostgreSQL is especially valued in tech industries, cloud-based applications, and data-driven enterprises.
Typical salary range: $70K–$110K+, depending on role and region.
Strong portfolio value for technical roles and system design planning.
Specification: Database Design and Basic SQL in PostgreSQL
|
