Intro to SQL & Databases

This project is a thorough introductory course in SQL and databases based on the free and open-source database PostgreSQL (or "Postgres" for short).

Installation

To follow this course, an installation of PostgreSQL 13 or higher is expected. If you know how to do this on your own machine, you may do so at your own discretion. Yet, to ensure that each student has a development environment similar to the instructor's one, follow this extensive installation tutorial and set up a virtual machine with all the required software on it. The estimated time for this should be around one hour.

Contributing

Feedback is highly encouraged and will be incorporated. Open an issue in the issues tracker or initiate a pull request if you are familiar with the concept. Simple issues that anyone can help fix are, for example, spelling mistakes or broken links. If you feel that some topic is missing entirely, you may also mention that. The materials here are considered a permanent work-in-progress.

About the Author

Alexander Hess is a PhD student at the Chair of Logistics Management at WHU - Otto Beisheim School of Management where he conducts research on urban delivery platforms and teaches coding and data science courses based on Python & SQL in the BSc and MBA programs.

Connect with him on LinkedIn.