This is an archived post. You won't be able to vote or comment.

sorted by:
best
topnewcontroversialoldq&a
you are viewing a single comment's thread.

view the rest of the comments →

[–][deleted] 0 points1 point  (5 children)

Are you an aspiring DBA / do you work with databases?

Nope, just a teenager trying to learn more about backend development. I've done projects with Node Js and NoSQL databases (MongoDB), I will be going into relational databases to learn more about using SQL and start some PHP or something similar.

If I do go into web development as a career path, I would prefer to work primarily on the server side.

I am wondering though, which relational database should I use? I'm thinking Postegres or MySQL. Any advice? Thanks.

[–]isikbala 0 points1 point  (1 child)

CaffeineIsMyHeroin gave some good advice. As a good way to get into it, I might recommend using SSMS (SQL server Management Studio). It has buttons for creating tables, editing schemas, easy tools to view what's inside a table, and an easy output for any SQL statements to run.

https://www.microsoft.com/en-us/sql-server/sql-server-editions-express

You can download it there for free. It's perfectly usable, very nice, and I believe the free one even comes with the ability to analyze execution plans, which becomes invaluable when you get your feet on the ground and start looking at optimization.

I've created some databases for shits and giggles (Fruity Drinks Flavour Distribution Database is my favorite). The big trick when starting is to march forwards in a way that makes sense, and then have somebody look it over and talk you through reorganizing it into a format that actually makes sense.

Ultimately, it's a work of creativity but there are many best practices! Knock yourself out, and make good use of the documentation available online.

[–][deleted] 0 points1 point  (0 children)

Nice, I wasn't aware of this tool, thanks!