how realistic is it to get good enough at python and sql to the point where you can write automation scripts and go around as independent contractor and build tools and processes for companies? (while charging alot of money, of course)

File: 218 KB, 959x1200, 1518132225828.jpg [View same] [iqdb] [saucenao] [google]

Anonymous Tue Feb 20 22:58:20 2018 No.7837946 [Reply] [Original]

how realistic is it to get good enough at python and sql to the point where you can write automation scripts and go around as independent contractor and build tools and processes for companies? (while charging alot of money, of course)

>>	Anonymous Tue Feb 20 23:00:47 2018 No.7837995 >>7837946 can you ask that question referencing a coin please?

>>	Anonymous Tue Feb 20 23:02:40 2018 No.7838044 File: 430 KB, 416x312, 1518234371551.gif [View same] [iqdb] [saucenao] [google]

Anonymous Tue Feb 20 23:04:38 2018 No.7838087

>>7837946
Automating what?
If you re-phrase the question as; can software developers go wherever the hell they like and still be able to economically flourish on their skills? The answer is yes.
But if you insist on using python and SQL, and you define "automation" as the commissioning and decomissioning of windows desktops or something silly like that, then no. So it really does depend on how flexible you are on means and ends.

>>	Anonymous Tue Feb 20 23:05:02 2018 No.7838092 DYOR faggot

>>	Anonymous Tue Feb 20 23:05:43 2018 No.7838106 is that chloe lee?

>>	Anonymous Tue Feb 20 23:07:03 2018 No.7838130 bbbrrrrrrppppffffffttt

Anonymous Tue Feb 20 23:07:36 2018 No.7838144

>>7838087
itd be something like going into some sort of saas company which is dependent on their own archaic software a) not showing them what it needs to do and b) not doing what it needs to do.

with python glue and a sql database i can create daily KPI performance reports and automate key business practices

>>	Anonymous Tue Feb 20 23:11:23 2018 No.7838216 >>7838144 No money in that desu

>>	Anonymous Tue Feb 20 23:12:25 2018 No.7838234 File: 431 KB, 643x487, latest.png [View same] [iqdb] [saucenao] [google] >>7837946

>>	Anonymous Tue Feb 20 23:12:39 2018 No.7838240 >>7838216 fuck, really? why not? id assume most companies would find this to be a very valuable tool.

Anonymous Tue Feb 20 23:15:22 2018 No.7838292

>>7838144
No but you could do this with python and golang and java and groovy and SQL and postgres and mariadb and dynamodb and mongodb and grafana and Elasticsearch and a massive list of other technologies.

You don't solve these problems with a one-tool-fits-all approach.

Anonymous Tue Feb 20 23:17:59 2018 No.7838348

>>7838292
i see... i was always under the impression that python was the best glue irregardless of framework.

if you don't mind, would you please explain some of the more useful functions of the other languages/frameworks you had listed, as well as how i would learn how to best implement them for specific problems?

>>	Anonymous Tue Feb 20 23:19:03 2018 No.7838371 >>7837946 As an independent contracter, you have to be top shit. If you want a permanent job doing that at half the rate at some rando corporation, about one year + college.

>>	Anonymous Tue Feb 20 23:20:38 2018 No.7838394 There's nothing better than a thick asian with no tattoos.

>>	Anonymous Tue Feb 20 23:21:10 2018 No.7838405 >>7838240 Just get a normal database job

>>	Anonymous Tue Feb 20 23:23:02 2018 No.7838439 >>7838405 I want independence and flexibility

>>	Anonymous Tue Feb 20 23:23:31 2018 No.7838450 File: 296 KB, 1024x768, 1518184843817.jpg [View same] [iqdb] [saucenao] [google] >>7837946 >asian >brapable this is the future of biz

>>	Anonymous Tue Feb 20 23:24:42 2018 No.7838474 BRAP PANTHER

>>	Anonymous Tue Feb 20 23:25:12 2018 No.7838486 File: 642 KB, 879x659, image.png [View same] [iqdb] [saucenao] [google] >>7837946 stop right there, im out.

>>	Anonymous Tue Feb 20 23:29:32 2018 No.7838588 >>7838439 hahaha, if it were that easy every idiot would be doing it

>>	Anonymous Tue Feb 20 23:29:38 2018 No.7838589 >>7838144 >with python glue and a sql database i can do what any pajeet can do

Anonymous Tue Feb 20 23:29:53 2018 No.7838595

>>7838348
There's no one tool that's best regardless of the situation, generally

That's like saying "I thought a wrench is the best tool, do I really need a screwdriver/hammer?"

The upside is that once you know one language, transitioning to another is mostly trivial

>>	Anonymous Tue Feb 20 23:30:50 2018 No.7838616 >>7838588 is that true? if thats the case then why havent most businesses automated key areas of their work operations

>>	Anonymous Tue Feb 20 23:31:59 2018 No.7838642 >>7838616 what key areas? op you sound every inexperienced

>>	Anonymous Tue Feb 20 23:33:42 2018 No.7838679 >>7838642 key areas like payroll and time check ins and productivity metrics, etc.

Anonymous Tue Feb 20 23:34:02 2018 No.7838685

>>7838348
The whole problem is that you're thinking of these as "frameworks" that will let you go and write new code. When the reality is that millions of people have already solved the same problems. Just use their solutions. Grafana is an open source project written expressly for data visualization.

The glue languages don't do what you seem to think they do. They bootstrap existing solutions together. They don't write new solutions from scratch.

Anonymous Tue Feb 20 23:34:33 2018 No.7838693
File: 576 KB, 1439x1595, 1517879002854.jpg [View same] [iqdb] [saucenao] [google]

SQL & Python are a beautiful combination, but what you're asking about is being done like crazy right now. I do fraud data analytics for a major gaming website in NYC, and my linkedin is constantly full of this exact shit. Companies like 'Guardian Analytics' or whatever, trying to shill me their machine learning garbage. I work on a team of fraud analysts and our own querying based on trends and patterns is smarter than any of the UML shills that these companies try to offer. I would still advise learning as much SQL as possible and working for a good tech company that implements modern cloud stack formation with AWS.

>>	Anonymous Tue Feb 20 23:36:10 2018 No.7838733 >>7838693 awesome, thank you for the advice. would you mind giving me any more general advice for how i should be progressing my career? money is my main objective

Anonymous Tue Feb 20 23:37:43 2018 No.7838767

>>7838679
>key areas like payroll
They have
>time check ins
How do you think this generally works? The real barrier for entry here is hardware, not software.
>productivity metrics
There are thousands of existing solutions to this type of problem. Re-implementing this by hand is a massive disservice to whoever you're doing it for. Now they're tied to your shitty ass unsupported code for decades.

Anonymous Tue Feb 20 23:40:14 2018 No.7838828

>>7838733
>how i should be progressing my career?
Learn python, ansible or chef, AWS, cloudformation, and jenkins or some shit. Then sell your soul to the devil and become a devops engineer for a big software corporation. It's not hard. I did it without a college degree in about 3 years. Now I make 6 figures.

>>	Anonymous Tue Feb 20 23:41:55 2018 No.7838865 >>7838693 >SQL & Python are a beautiful combination Also this anon is wrong. If you actually write SQL in python then you're doing it wrong. Use SQLalchemy. Never write actual queries.

>>	Anonymous Tue Feb 20 23:42:00 2018 No.7838869 >>7838394 its quite the anomaly

Anonymous Tue Feb 20 23:42:16 2018 No.7838875

>>7838828
I really appreciate your time for this.

do you have any good ideas of projects which will combine knowledge of all of these things together that i could work on and present as part of my portfolio?

or at least for me to draw inspiration from as i were to do work for another company.

thanks again bro

>>	Anonymous Tue Feb 20 23:43:02 2018 No.7838891 >>7838144 I can hire a University educated American for $25 on Upwork and not have to deal with a retard like you face to face. Best of luck!

>>	Anonymous Tue Feb 20 23:44:53 2018 No.7838919 >>7837946 I don't see anything you could do with python + sql that a company couldn't do in house or contract out for cheap, aside from really small businesses.

>>	Satoshinakamoto Tue Feb 20 23:45:30 2018 No.7838932 Instead of selling soul To devil you can make next bitcoin and pre mine it like me.

>>	Anonymous Tue Feb 20 23:47:03 2018 No.7838972 >>7837946 I'm in a committed and loving relationship but God damn I would not pull out, wouldn't cross my mind

Anonymous Tue Feb 20 23:47:04 2018 No.7838974

>>7838875
>do you have any good ideas of projects which will combine knowledge of all of these things together that i could work on and present as part of my portfolio?

You should try setting up some simple python projects with distutils packaging, unit testing, travis CI, etc. Just go way overboard. Maybe implement a website using flask or something.

Then sign up for an AWS account, and practice with free tier stuff. Stand up an elastic beanstalk cluster using AWS CLI and cloudformation templates, and deploy your python app from step one.

Work on open source projects. Pick a random python project like ansible that you wouldn't mind contributing to. Your pull requests will get rejected at first, but stick with it and get better until they start getting accepted.

While you're doing this, go work a shitty tech support job. The single most important step is getting your foot in the door. Once you get a single devops-type job, you're set for the rest of your career.

Anonymous Tue Feb 20 23:47:32 2018 No.7838984

>>7838865
I use jupyter notebook with a magicSQL implementation if im combing them in redshift. Otherwise, I directly query with postgreSQL to redshift. I'm working with a data scientist on an algorithm that combines sql and python in redshift. Idk why that would be wrong. Not sure what you're getting at.

>>	Anonymous Tue Feb 20 23:50:09 2018 No.7839034 >>7838974 thanks for this

>>	Anonymous Tue Feb 20 23:50:15 2018 No.7839035 >>7838733 also OP, my advice is to not do freelance. Get a gig with a tech company that can mentor you. That is invaluable learning while you're getting paid.

>>	Anonymous Tue Feb 20 23:50:34 2018 No.7839038 >>7838984 >I'm working with a data scientist This is why. Academia is stuck in the past. Use SQLalchemy for a side project and you'll feel silly writing actual SQL queries by hand.

>>	Anonymous Tue Feb 20 23:53:24 2018 No.7839093 >>7839035 >Get a gig with a tech company that can mentor you what are the sorts of things i should be getting mentored on? what are the important lessons that i should be paying attention to the most?

>>	Anonymous Tue Feb 20 23:54:48 2018 No.7839118 sauce??

>>	Anonymous Tue Feb 20 23:58:15 2018 No.7839195 >>7839038 >SQLalchemy not suitable for working on production though, t-sql with microsoft enterprise shit is pretty standard

Anonymous Tue Feb 20 23:58:43 2018 No.7839208

>>7839038
I looked up SQLalchemy and now im intrigued. I'm going to give it a shot anon - but my main argument point was that OP needs to not focus on freelancing or making $ atm, but rather getting a good foothold in a tech company that can mentor him further in these languages and how to apply them in real situations.

>>	Anonymous Tue Feb 20 23:59:37 2018 No.7839226 >>7839093 get a cs degree and make sure you have your own projects. There's some good advice here: >>7838974 I have some disagreements with him though

>>	Anonymous Wed Feb 21 00:03:40 2018 No.7839309 >>7839226 >get a CS degree Just like that. For some people just getting that would take years

>>	Anonymous Wed Feb 21 00:04:52 2018 No.7839342 File: 599 KB, 773x1000, brapparticles.jpg [View same] [iqdb] [saucenao] [google] >>7837946

>>	Anonymous Wed Feb 21 00:05:45 2018 No.7839361 >>7839226 >I have some disagreements with him though please share them!

>>	Anonymous Wed Feb 21 00:07:51 2018 No.7839412 >>7837946 booty asians are just fucking ridiculous in how perfect they are. you just know there is a delicious purple vagine and anus tucked behind that golden-skinned brapper

Anonymous Wed Feb 21 00:08:35 2018 No.7839421

>>7839309
i dont have a cs degree but i work in cs. I have a degree in music, which may sound laughable but I attribute my cs knowledge to learning the language of music. I would say that having a friend group/ slack group to ask questions and get better at developing is extremely important. Idk, everyone is different. I would say with the price of what a degree costs at an established univeristy, you're better off putting yourself into a community or job that can teach you first hand.

>>	Anonymous Wed Feb 21 00:08:42 2018 No.7839424 I need some field reporting stuff done, Want a web app - I guess it should be simple, but want to print to small mobile printer and update a spreadsheet on a server Let me know what you might be able to do. prolificpest1@gmail.com

>>	Anonymous Wed Feb 21 00:12:59 2018 No.7839507 >>7838891 No, you can hire a pajeet pretending to be a University educated American. Even good eastern european devs still fetch $30+/hr on upwork.

Anonymous Wed Feb 21 00:36:38 2018 No.7839945

>>7837946
easier than you think. I took a bunch of online classes form coursera and never felt confident because who am I comparing myself too right? I went back to college at 33. Did my first java assignment, Prof asked to see me in email. He says : in class you know everything other profs said same thing. He asks about how much I know in java and I tell him everyhting I completed online. Ask me if I am familiar with java spring boot tell him yes.Asks if I know mysql again yes. why are you here then anon? He introduces me to the co-op company that partners with my school (sunlife financials) get a job and starting pay at 59k. All I have to do is some weekend seminar company pays for, and I have to shadow a team for a few weeks before I can push my code on my own to git. Literally thought I was shit until norman looked at me funny... Just do it. Recommend Coursera, or udacity coursera if you have time and are smart udacity if you have less time and side projects.

Advanced search
Text to find
Subject [?]Search by post subject. Leave empty for any.
Username [?]Search for user name. Leave empty for any user name.
Tripcode [?]Search for tripcode. Leave empty for any.
Email [?]Search by email. Leave empty for any.
Filename [?]Search by image filename. Leave empty for any.
From Date [?]Enter what date to start searching from. Format is YYYY-MM-DD
To Date [?]Enter what date to start searching until. Format is YYYY-MM-DD
Image hash
Search in	All Posts OPs Only
Deleted posts	Show all posts Show only deleted posts Only show non-deleted posts
Internal posts	Show all posts Show only internal posts Show only archived posts
Order	New posts first Old posts first
Capcode	All Posts Only by Users Only by Mods Only by Admins Only by Developers
Results	Posts Threads
Action	[ Simple ]

/biz/ - Business & Finance