YoVDO

An introduction to Prolog for SQL programers

Offered By: Independent

Tags

Prolog Courses Programming Courses SQL Courses Relational Databases Courses Data Manipulation Courses

Course Description

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

Related Courses

Excel 2010
Miríadax
Intro to Data Science
Udacity
Data Manipulation at Scale: Systems and Algorithms
University of Washington via Coursera
Statistical Computing with R - a gentle introduction
University College London via Independent
Introducción a Data Science: Programación Estadística con R
Universidad Nacional Autónoma de México via Coursera