This content originally appeared on DEV Community and was authored by Emanuel Gustafzon
Learn SQL in a funny way by building a social media database.
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.
This content originally appeared on DEV Community and was authored by Emanuel Gustafzon
Emanuel Gustafzon | Sciencx (2024-07-01T13:27:30+00:00) SQL Course Get Started.. Retrieved from https://www.scien.cx/2024/07/01/sql-course-get-started/
Please log in to upload a file.
There are no updates yet.
Click the Upload button above to add an update.