Learn SQL in a funny way by building a social media database. The database will contain users, profiles, posts with likes and users will also be able to follow each other.
I will reference to w3schools.com during this series so you can learn a bit more about the theory and this series will teach you how to put it into practice.
Setup
I am using SQLite for this course. If you use another database it’s fine but maybe the syntax will be slightly different. But w3schools gives examples of different syntax.
I am also using Replit for this tutorial as IDE. You can easily create an account and create a new Repl with the SQLite template. That makes it easy to set up and you can also code in your browser or on your phone or IPad so you can take this tutorial on the go.
What we will learn
- Creating Tables with primary and foreign keys.
- One to one relationships.
- One to many relationships.
- Many to many relationships.
- Query data.
- Inner joins, left joins and self joins and nested joins.
Top comments (0)