Databases

Is this a field worth getting into? What are the prerequisites? What are the most important things/subjects/technologies/products to learn about (and in what order/to what depth)? What are the possible career paths/different positions and how does day-to-day work generally look like? How well is the field (and associated jobs) expected to be resilient against being eroded by general current and future trends in technology?

Attached: db.jpg (191x264, 4.11K)

Other urls found in this thread:

redbook.io
twitter.com/SFWRedditVideos

pajeet will install postgres for 30 rupees

So you say it's a field overrun with pajeets?

th-thanks for the motivation and inspiration

Everything in a capitalist society is an item in a database. Homes, cars, toothbrushes, people, etc. It's like asking is text editing is a field worth getting into.

make up your mind, anons

You'll need more than SQL knowledge to set yourself apart from the secretaries, accountants, and yes pajeets who will do it for nearly free.

redbook.io

What specifically? Knowledge of all the theoretical/mathematical foundations of data structures and databases? Expertise in designing them? Practical knowledge in administrating specific db products/software?

It hasn't been since the 90s that normies have used DBMS software directly.

Programming skills, unless you want to be a secretary or human resources.

...

I have the impression that there are not many good DB people around. Especially when it comes to develop applications with the tools Oracle or MSSQL provide. Many simple applications can be developed within Oracle for example. But people still think they need to program something that then runs on an application sever that needs to be updated and maintained etc.

Maybe people just don't WANT to fucking develop an application in Oracle. Ever think of that?

It's kinda up in the air right now if you should dive into a DB oriented career. Typically this goes hand in hand with Data Science and Data Mining. With the recent backlash from FB users whining about their data being mined and algorithms used with it, the field may change completely from what it currently is 20 years from now. But I don't see SQL being phased out for a while, at least for small business applications. Best of luck!

Meaning what, PL/SQL (or the kinda equivalent that PostgreSQL has), or something else?
inb4 Java

It's high paying because it's fucking awful and literally no one wants to do it.

Ah yes pajeet could not possibly install a web scale meme db like mongo

Why? Any worse than COBOL?

What would be possible ways of radical change in that field?

Reminder: Oracle is shit and so is their database. Use Maria instead.

It should change, but it won't, it's only going to get bigger.

Legalities.

Yes if data science.

Data scientists you work with data, often not processed. Then you can apply all kinds of interesting stuff such as machine learning / regression techniques. Which are very valuable for business.

How it is future proof? You need statistical knowledge = value. You need business process knowledge = value. You need economic knowledge (or something else to make meaning of data) = value. Being able to use programming tools and understand how to handle data is a lot of value since not many people know how to and it's very much in demand. In the future those skills will continue to be relevant.

You probably touch a dozen databases throughout the week without even thinking about it. Did you know Amazon has caches throughout the US based on items most bought in their respective region? This is how you are able to order some items and receive them the same day without paying insane shipping fees for airfare.

Well, if COBOL scares you, it would be wise to check few tutorials first. SQL isn't exactly most intuitive thing on earth, especially when you get into advanced stuff (eg. windowing functions, recursive cte)

Wew, totally not a reclusive shut in with no human contact here.

sql way more intuitive than cobol

his post didn't mention tinder?

Why is the commonly used graphical symbol for database a couple of literal disks stacked on top of one another?

welcome to java. leave if you can. it really is brighter on the other side of the tunnel
t. Sun Microsystems

where does that conception come from?

Pajeets.

hey Zig Forums i'm currently making $80k maintaining bullshit legacy java web app. Is it worth it to switch over to specialize in sql? No, I don't want to be a dba.

no

why user?

durr

SQL is a declarative language, so programmers who are more familiar with imperative languages have trouble using it. You have to describe the data you want in the query, and system will choose what it thinks is the best way to retrieve the it. It's really different from writing step-by-step instructions to retrieve and manipulate data.
Being familiar with set math, normal forms, and when to use a relational database are all useful.
I've only had one bad client in my life. His original data wasn't normalized, so the relationships became irretrievably broken. I had to explain to him with simple examples why I couldn't fix it. On the next project, he insisted I use a relational database, but I warned him that it would be very slow to insert the amount of data he wanted, and the data wouldn't benefit from relationships anyways. Each of his projects failed due to his micromanagement and incompetence. He was a professor of data analysis.

...

bump