Class Central is learner-supported. When you buy through links on our site, we may earn an affiliate commission.

Independent

An introduction to Prolog for SQL programers

via Independent

Overview

I've translated the introductory example in Databases: Relational Databases and SQL into Prolog since I've personally found thinking of Prolog as a relational database query language a handy way to get started.

I think I'm using Prolog synonymously with Datalog in these examples, but don't know Datalog that well.

Syllabus

  • Basic selection
  • Table joins
  • order by
  • Searching for substrings
  • Arithmetic Functions
  • Self joins
  • Union
  • Intersection
  • Except
  • Subqueries in the where clause
  • Subqueries in the from clause
  • Subqueries in the select clause
  • Three-way Inner Join
  • Natural Join With Additional Conditions
  • group by queries
  • having
  • insert
  • delete

Taught by

Robert Laing

Reviews

Start your review of An introduction to Prolog for SQL programers

Never Stop Learning.

Get personalized course recommendations, track subjects and courses with reminders, and more.

Someone learning on their laptop while sitting on the floor.