Hey Gophers I need your help! I'm lost..

[summer creek]

Lost 2 years bcz of some health issues which makes it difficult.

Have been learning Go for few months. I have build simple web server, movies CRUD, simple Calculator, Quiz.

I'm jumping from one thing to another thinking I'm not learning it the right way. Going from reading cs books, sometimes Go books wasted lot of time on tutorials etc etc.

I want to get skilled in Go, PostgresSQL and Docker, Git, Github, Jira, Postman, Testing, Debugging and if anything I miss that I need to be the best Go developer.

● Help me make a strict detailed step by step study plan along with specific resources in a way that I can get skilled at all these and get a job asap.

● Help me learn DSA and PostgresSQL in an organized way and how to approach this ?

● Have no techie friends to ask or give a guidance to me. Im from a small village. So pls help. It would be helpful it anyone can dm or be my friend or mentor ?

[clever geode]

I do have some health issues too
Life's hard with them, I know
I'm from a small city, nobody around me knows what programming is
But it doesn't stop me, don't let it stop you. You can do it
Unfortunate, but there is no "strict detailed step by step guide", because it depends on the situation, heavily
I like to do projects that I like when I got basic syntax knowledge, as it boosts motivation, it teaches me a lot of things.
If you're got stuck in any part of your project, do ask. Even a little question, ask. We're willing to answer

[summer creek]

Thanks a lot for replying.. Can u tell me how you approached learning database ? What db are you skilled at ?

[summer creek]

Also same situation here. Learning from home and sitting infront of computer is not something people here see as normal.

I just want to get best skilled at these so that I can make it to my fav company.

[clever geode]

As you mentioned dsa (I assume data structure & algorithms), I recommend not copying tutorials if you're doing that and actually reading and writing code
Knowledge of dsa comes for free while doing that
Ok, a specific example: I like modifying the standard libraries to improve them
It gives a lot of information of internals, algorithms

[summer creek]

Like you contribute to Golang source code? !!

[clever geode]

I know the feeling when people around you are looking at you like

[summer creek]

Yeah 😅

[summer creek]

I'm learning normalization in db now.

[clever geode]

I'm a wrong person to ask about dbs btw

[summer creek]

Oh ok np. Thanks

What I'm confused is everything is so vast. So I need to know how much do I need to learn. What specific book to learn.

In college and all we can just learn the textbooks we want and get everything and if we want more we can refer more.

But learning from home and not knowing what to refer when u have tons of resource on internet and nobody in tech sector to actually ask means horrible.

[unique igloo]

@summer creek I don't have great advice for you.
Mostly relax a bit, programming isn't about learning a checklist of things.

For example if you learn postgres your goal shouldn't be to check off all the items in the documentation, but to be able to translate usecases into SQL queries and to predict what kind of performance you would get.

There isn't a specific book to learn or anything.
I think practice is the best solution, generate 10m row (or whatever creates 10s queries) then try your best to optimize it using more efficient queries and or indexes.

This will give you a deep understanding.
Like for example you could optimize the query and see it goes from 10s to 5s, but you could also try adding an index and see it move from 10s to 20ms.
(I'm making up numbers.)

[summer creek]

Yeah I get it. But like there would be minimum stuff people learn in the beginning and then they learn along the way when doing projects right ?

Idk how people approach this. I'm not used to learn in this way. It feels I'm learning random things incompletely from random sources.

[unique igloo]

And the point is that getting a feel for this give you invaluable knowledge about the kind of things indexes do in general, this would also apply to mysql, mongodb.

[unique igloo]

I'm a project extremist

I find documentation / books, to be mostly useless before you built a strong mental model.

If you aren't able to quickly correct picture your problem in your head and make predictions that are mostly correct I think you should try more stuff (that means write more code).

[fluid kettle]

same

[summer creek]

I'm very new to this and don't really know how to optimize and all what u said.

I have gone through PostgresSQL docs in which I read SELECT, FROM, WHERE, IN, BETWEEN etc statements and when to use.

Like what resources should I learn first in the order like ?

But then I lost and I want to know how people approach this.

[unique igloo]

Ok let's say you want to learn SELECT.
Go right now in your favorite way to interact postgresql.
Generate 10m rows of some data (in the process you will also need to learn how to use INSERT).
Then try selecting things from it.

Like create a plain boring table with email address, age and favorite pet.
Then try selecting all the users between 20 and 30 that love cats.

See it runs in a couple of seconds and try making that faster.

The point is that you are creating problems for yourself and working through solving them.

[summer creek]

Okay. I still don't know how to connect db or create this. But let me figure it out.

Thanks

[unique igloo]

great that already your first problem

this is a go server so you could search how to run queries in postgresql from go

[summer creek]

Do I need to know theory stuff in db to work on this like normalization, etc etc ?

[unique igloo]

Tell me how will you apply your normalization knowledge if you don't even know how to connect to the database ?