Udemyintermediateen

Learn Procedural SQL by Building a Chess Game in PostgreSQL

Learn PL/pgSQL! Build a chess game with PostgreSQL & Python. Hands-on experience with database programming. Perfect for aspiring developers.

7students
4h 20m
Certificate
Konstantinos Malonas
Konstantinos MalonasData Engineer | AI Practitioner | Python & SQL Expert

Course Content

Learn Procedural SQL by Building a Chess Game in PostgreSQL is an intermediate-level Udemy course taught by Konstantinos Malonas. It runs 4h 20m, is taught in English, and includes a certificate of completion. 7 students have enrolled. It is a paid course, first published July 2025.

Unlock the power of procedural SQL with a hands-on PostgreSQL course! Build a complete chess game from scratch and master PL/pgSQL, the procedural extension of PostgreSQL. This isn't just about syntax; you'll delve deep into how to use SQL for powerful backend logic.

Learn to transform your SQL skills into a robust game engine. You'll gain practical experience building core game mechanics like:

  • Chess board implementation using PostgreSQL arrays.
  • Piece movement functions for every chess piece (pawn, bishop, rook, knight, queen, king).
  • Legal move validation – ensuring only valid moves are allowed.
  • Enemy king detection and implementing RUA (check) logic.
  • Resurrection mechanics using stored procedures for a unique gameplay element.
  • A fully functional game loop in Python for interactive gameplay control.

This course integrates Python with PostgreSQL to manage game flow, handle player moves, and create a dynamic, engaging experience.

Technologies & Tools:

  • PostgreSQL (with PL/pgSQL)
  • Python
  • DBeaver (database tool)
  • VSCode (code editor)

By the end of this project-based course, you’ll be proficient in PL/pgSQL and equipped to apply procedural programming logic to any database application. Perfect for developers, data engineers, and database enthusiasts looking to enhance their backend logic skills with a fun and rewarding project. Develop sophisticated database backend capabilities and create dynamic applications.

$ whoami — the devs behind tutorialsearch.io

Hire the developers behind TutorialSearch.io

We built this site — full-stack web apps, AI integration & automation. Tell us what you need and we'll build yours.

skillshare
5.0
2h 42m
intermediate
pluralsight
5.0(28)
1h 31m
all
skillshare
5.0
1h 28m
beginner
pluralsight