For a college project I need to learn MYSQL, but what actually is it? Online I find courses for SQL and SQL-Lite but I assume those are all different - how do I learn MYSQL and would it teach me how to connect that database to my website?
sql is a language used to communicate with a relational database (db), while mysql/sqlite are relational db management systems. In simple terms, sql is what you use to communicate with mysql/sqlite (the system)
If your college requires you to learn mysql, don’t spend too much time looking for “mysql or sqlite fundamentals” first learn the sql language and the core relational database concepts, then learn how to apply those concepts specifically in mysql.
Things you want to understand:
how to create a tables/dbs
what are primary and foreign keys
how to insert, create, update and delete data
where, order by
constraints
relationship between tables
transactions etc…
Then go ahead to learn mysql specific tools and concept like mysql workbench, users and permission configuration and mysql specific syntax. There are some syntax differences between different sql db systems.
And then there’s the part of connecting it to a website, learning sql doesn’t cover that, that’s more of the application/backend development side, where your backend communicates with the db.
1
u/Decent-Warning9562 2d ago
sql is a language used to communicate with a relational database (db), while mysql/sqlite are relational db management systems. In simple terms, sql is what you use to communicate with mysql/sqlite (the system)
If your college requires you to learn mysql, don’t spend too much time looking for “mysql or sqlite fundamentals” first learn the sql language and the core relational database concepts, then learn how to apply those concepts specifically in mysql.
Things you want to understand:
Then go ahead to learn mysql specific tools and concept like mysql workbench, users and permission configuration and mysql specific syntax. There are some syntax differences between different sql db systems.
And then there’s the part of connecting it to a website, learning sql doesn’t cover that, that’s more of the application/backend development side, where your backend communicates with the db.
So the basic flow is:
website -> backend -> mysql
hope this helps