Core Database Concepts

However, the application of those concepts was limited to simple multiple choice quizzes without any programming assignments.

Nice introduction to core concepts.Assignment 2 was a bit frustrating, it built on the result of assignment 2 but the "name" field of the movies table changed to "title" and unless you re-created all tables in your local test environment using the "optional" solution.sql 50% of the test cases fail without any explanation.

The course is good for like people who are aleady familiar with a bit of SQL and have knowledge of software that handles SQL queries.

These topics would be very relevant for the databases sequence but are not broached.I did enjoy the final 2 weeks of content more and the course introduced more ideas in those classes that I was not already familiar with.

But from my perspective there are several drawbacks:1) SQL Functions, Procedures were not taught at all2) Transactions were not part of an assignment or practially shown.

still one question left, if a single SQL Query is a Transaction on its own or not3) For the assignments many things were unclear, like alias for columns with (AS) and Joining data4) JOIN was not taught at all, neither was OUTER, INNER, FULL or CROSS JOIN5) Pl/pgSQL was not taught at all6) I enrolled the full specialisation, but after the the first course all others were gone with still 2 enrolled weeks left.

A Youtube tutorial on Databases would probably have taught me the same (besides the theorertical background, which was not taught why it is important to know, if the database already handles it?