Database

PostgreSQL Foundations

MyLoginn Learning Team · Free beginner course

4 weeks6 modules · 77 subtopicsFREEFoundationsPostgreSQLBeginner

Learn PostgreSQL: SQL queries, tables and constraints, joins, indexes, JSON, window functions, and transactions.

Level

Foundations

Modules

6

Topics

77

Duration

4 weeks

Course roadmap

A clear path through the material

Build your understanding one focused lesson at a time, from core ideas to practical programming.

Enroll free to unlock the lessons.

  1. 01
    PostgreSQL Foundations0/22 topics · 0%
    • 1PostgreSQL Intro
    • 2PostgreSQL Install
    • 3PostgreSQL Get Started
    • 4PostgreSQL psql Shell
    • 5PostgreSQL Create Table
    • 6PostgreSQL Insert Into
    • 7PostgreSQL Fetch Data
    • 8PostgreSQL ADD COLUMN
    • 9PostgreSQL UPDATE
    • 10PostgreSQL ALTER COLUMN
    • 11PostgreSQL DROP COLUMN
    • 12PostgreSQL DELETE
  2. 02
    PostgreSQL Queries and Joins0/14 topics · 0%
    • 23PostgreSQL Aggregate Functions
    • 24PostgreSQL Group By
    • 25PostgreSQL Having
    • 26PostgreSQL Joins
    • 27PostgreSQL Inner Join
    • 28PostgreSQL Left Join
    • 29PostgreSQL Right Join
    • 30PostgreSQL Full Join
    • 31PostgreSQL Cross Join
    • 32PostgreSQL Union
    • 33PostgreSQL Subqueries
    • 34PostgreSQL Exists
  3. 03
    PostgreSQL Database Design0/13 topics · 0%
    • 37PostgreSQL Data Types
    • 38PostgreSQL Constraints
    • 39PostgreSQL Primary Key
    • 40PostgreSQL Foreign Key
    • 41PostgreSQL Unique
    • 42PostgreSQL Check
    • 43PostgreSQL Serial and Identity
    • 44PostgreSQL Indexes
    • 45PostgreSQL Views
    • 46PostgreSQL Schemas
    • 47PostgreSQL Normalization
    • 48PostgreSQL Roles and Privileges
  4. 04
    PostgreSQL Advanced Features0/14 topics · 0%
    • 50PostgreSQL Common Table Expressions
    • 51PostgreSQL Recursive CTEs
    • 52PostgreSQL Window Functions
    • 53PostgreSQL JSON and JSONB
    • 54PostgreSQL Arrays
    • 55PostgreSQL Full-Text Search
    • 56PostgreSQL Transactions
    • 57PostgreSQL Isolation Levels
    • 58PostgreSQL EXPLAIN
    • 59PostgreSQL Functions
    • 60PostgreSQL Triggers
    • 61PostgreSQL Materialized Views
  5. 05
    PostgreSQL Projects and Practice0/8 topics · 0%
    • 64PostgreSQL Examples
    • 65PostgreSQL Quiz
    • 66PostgreSQL Exercises
    • 67PostgreSQL Code Challenges
    • 68PostgreSQL Library Database Project
    • 69PostgreSQL Reporting Project
    • 70PostgreSQL Study Plan
    • 71PostgreSQL Interview Prep
  6. 06
    PostgreSQL References0/6 topics · 0%
    • 72PostgreSQL Reference
    • 73PostgreSQL Keywords
    • 74PostgreSQL Data Types Reference
    • 75PostgreSQL Functions Reference
    • 76PostgreSQL psql Commands
    • 77PostgreSQL Operators