New videos every day. Subscribe to Parottasalna on YouTube

Database Engineering with PostgreSQL Database Engineering with PostgreSQL Database Engineering with PostgreSQL
  • Home
  • Courses
  • Interview prep
  • System design
  • Blog
  • More
    • Learning paths
    • Pro and live batches
    • Jobs
    • Resume review
    • Stories
    • Q&A forum ↗
    • YouTube ↗
/
  • Discussion

Sessions

  • Session 1 · Why we need a database
  • Session 2 · Database and DBMS
  • Session 3 · The relational model
  • Session 4 · Querying data with SELECT
  • Session 5 · Filtering rows with WHERE
  • Session 6 · Entity relationship diagrams
  • Session 7 · Joins
  • Session 8 · Joins on an e-commerce database

Reference: install and sample data

  • 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
  1. Database Engineering with PostgreSQL /
  2. Sample Databases

Sample Databases#

  • DVD Rental Database
Previous
More examples on Roles
Next
DVD Rental Database

Stuck on this chapter? Ask in the Q&A forum, or book a 30-minute call.

Ask in Q&A ↗ Book a call ↗

© Parottasalna · Syed Jafer K · Privacy Policy