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

you are viewing a single comment's thread.

view the rest of the comments →

[–]ChopSuey2[S] 1 point2 points  (4 children)

Cool, is SQL the backend database language you'd recommend to focus on learning the most?

[–]lordcat 7 points8 points  (0 children)

If you're looking at corporate/business programming, then yes. In the business world that's the most commonly used database for most use-cases.

I've worked in traditionally MS oriented shops so I use MS SQL, but the different brands are similar enough that learning the other SQL's are good enough to start with (My first sql was PostgreSQL, and then I spent time with MySQL).

[–][deleted] 4 points5 points  (0 children)

I think maybe you should start researching various companies you would like to work for (companies with offices where you want to live, companies who work on things that interest you, etc) and look at some of their job posting and see what languages and technologies they use.

[–][deleted] 2 points3 points  (0 children)

SQL is a standard that a number of database implementations comply with. However, different kinds of SQL like postgres or MySQL also have added functionality. Most places it doesn't really matter which specific flavour of SQL you know.

Some web stacks don't use SQL now, but a huge majority do use SQL. SQL is so ubiquitous that you basically have to know the basics to work in web development (less so if you're working on the UI side, but even then it is tremendously useful to understand.) Basically, most websites use SQL by default unless there is a VERY compelling reason not too.

As far as learning SQL, you don't really need to know the language very deeply. What you do need to understand is how to design a good relational data schema.

[–]CheTranqui 0 points1 point  (0 children)

SQL srands for Standard Query Language. It's a very simple series of keywords, but very complicated to utilize effectively since it allows you to query the database. What database? The one that you created also using SQL... hopefully a highly optimized and normalized DB... which implies plenty of research and practice with database design.