Contents Menu Expand Light mode Dark mode Auto light/dark, in light mode Auto light/dark, in dark mode Skip to content
← All courses  ·  New videos every day. Subscribe to Parottasalna on YouTube
Database Engineering with PostgreSQL
Logo
Database Engineering with PostgreSQL

Lessons

  • Need of Database
  • Database and Database Management System
  • What is Relational Database Model ?
  • Installing Postgresql
    • Installing PostgreSQL on Linux
    • Installing PostgreSQL on Windows
    • Installing PostgreSQL on Mac
    • Postgres in Docker
  • What happens during the initial installation ?
    • Roles, Users & Groups
    • More examples on Roles
  • Sample Databases
    • DVD Rental Database

Querying Data

  • SELECT Query
  • Column Aliases
  • Order By
  • SELECT DISTINCT
  • DB-TASK-001

Filtering Data

  • WHERE ?
  • AND Operator
  • OR Operator
  • LIMIT
  • FETCH
  • IN
  • BETWEEN
  • LIKE
  • SIMILAR TO
  • IS NULL
  • ESCAPE
  • DB-TASK-002

Entity Relationship Diagram

  • What is an ER Diagram ?
  • Entity
  • Identifiers
  • Relationship
  • Attributes
  • Cardinality
  • Entity Relationship Diagram Tutorial
  • DB-TASK-003

Joins

  • Joins
  • Joins With Employee and Departments
  • Joins on E-Commerce
Back to top

Installing Postgresql¶

  • Installing PostgreSQL on Linux
  • Installing PostgreSQL on Windows
  • Installing PostgreSQL on Mac
  • Postgres in Docker
Next
Installing PostgreSQL on Linux
Previous
What is Relational Database Model ?
Made with Sphinx and @pradyunsg's Furo