/tech/ - Technology★

>>888591 (OP)

>all this shit

pajeet will install postgres for 30 rupees

>>888605

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

>>888605

>anything in tech is pointless because pajeet will do it for 30 rupees

th-thanks for the motivation and inspiration

>>888591 (OP)

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.

>>888605

>there's no DB jobs because pajeet will do it for peanuts

>>888780

>there's DB jobs everywhere because DBs are everywhere

make up your mind, anons

>>888874

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.

http://www.redbook.io

>>888886

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?

>>888886

>secretaries using SQL directly rather than using normie-compliant frontends to interface with the db

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

>>889196

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

>>889223

>let secretary and HR nigger touch database

>"Oh dear. Our data appears to have been breached."

>>888591 (OP)

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.

>>889318

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!

>>889223

>>889322

>Programming skills

>develop an application in Oracle

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

inb4 Java

>>888591 (OP)

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

>>888605

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

>>889791

Why? Any worse than COBOL?

>>889435

>the field may change completely from what it currently is 20 years from now

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

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

>>889435

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

>>890022

Legalities.

>>888780

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.

>>890620

>zillow

>amazon

>autotrader

>self checkout

>prescriptions

>signing for UPS

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.

>>890021

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)

>>890634

>tinder

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

>>890021

sql way more intuitive than cobol

>>890641

his post didn't mention tinder?

>>888591 (OP)

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

>>891332

>databases equals java

where does that conception come from?

>>891360

>databases equals java

>where does that conception come from?

Pajeets.

hey /tech/ 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.

>>892027

no

>>892028

why anon?

>>892032

>specialize in SQL

>doesn't want to be a DBA

durr

>>890640

>>890021

>>889791

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.

>>892035

>what is business analyst