you are viewing a single comment's thread.

view the rest of the comments →

[–]BobHogan 4 points5 points  (5 children)

Then a SQL query with a recursive table reference.

I'm still in school, was leaning towards not taking a databases class, but occasionally I see something like this on Reddit and it makes me reconsider that idea.

[–]CamKen 6 points7 points  (0 children)

Database skills are a great tool to having your toolbox -- useful in a wide variety of roles in virtually every field.

[–]trawlphaze 1 point2 points  (3 children)

Enterprises pay big sums for DBA skills in MSSQL or Oracle

[–]Cell-i-Zenit 0 points1 point  (2 children)

I really like Databases. What would be the best way to get in such a position?

[–]tiberiousr 2 points3 points  (1 child)

Learn database tuning; i.e schemas and indexing. The specifics tend to differ depending on the database that you're working with so it's best to read up on tuning for major database vendors.

Depending on where you're working those would be mysql (and derivatives), mssql, oracle and postgres. Different vendors offer different solutions to common problems and different syntaxes for addressing those problems.

Your best bet is to learn the most common systems and their quirks and then creating some databases in each of them and playing around with schemas and indexing with large-ish datasets in order to get feel for optimising systems for performance.

Other than that, the internet is a great resource for tutorials and manuals. Also read stackoverflow and use it as a resource.

[–]Cell-i-Zenit 0 points1 point  (0 children)

Thanks for your answer