Jump to content
Supermalt

Learning To Code

Recommended Posts

6 hours ago, Drift said:

If you can, jump on SQL.

I use it as part of my job, it's a gateway to a lot of niche hidden fields you can move into.

What do you do fam

Share this post


Link to post
Share on other sites
1 hour ago, i5_PRODUCER said:

What do you do fam

I work in Finance Systems

Share this post


Link to post
Share on other sites

I keep getting sidetracked with learning a trade. 

Electrician and carpentry were high on my list. 

Share this post


Link to post
Share on other sites

I looked at machine learning for about a month and moon walked out of it.

Still doing python but paused that while I do post GCSE maths on Khan academy

Share this post


Link to post
Share on other sites

 

11 hours ago, Drift said:

If you can, jump on SQL.

I use it as part of my job, it's a gateway to a lot of niche hidden fields you can move into.

 I can't c/s this enough, currently employed as a sql database developer for a company that makes scouting software. Such a long way from where I started.

The  demand for sql professionals right now is so healthy. Way may demand than supply imo.

Share this post


Link to post
Share on other sites

Inspirational topic still

 

big up those pushing themselves big up those making the first steps

and those of you who are reading this want to do it but can not be asked stop being a lazy shit and push yourself. Rest when you are dead.

Share this post


Link to post
Share on other sites
On 16/03/2017 at 6:19 PM, Wavant said:

I keep getting sidetracked with learning a trade. 

Electrician and carpentry were high on my list. 

Electronician definitely 

Share this post


Link to post
Share on other sites
21 hours ago, Heero Yuy said:

 

 I can't c/s this enough, currently employed as a sql database developer for a company that makes scouting software. Such a long way from where I started.

The  demand for sql professionals right now is so healthy. Way may demand than supply imo.

Without baiting anything personal you dont want to...what sort of coin can you rake in??

When ive finished this part time degree im looking to either learn spanish properly or do something computer based

Share this post


Link to post
Share on other sites
22 hours ago, Heero Yuy said:

 

 I can't c/s this enough, currently employed as a sql database developer for a company that makes scouting software. Such a long way from where I started.

The  demand for sql professionals right now is so healthy. Way may demand than supply imo.

I done Sql and data warehouse as a degree, so I know the basics but I don't have work experience in it, so I'm doing my Oracle and Microsoft certification in summer.... But your right Sql is so healthy right now even as a entry level position... Your looking at 30k to 45k calm doing simple querys... Once your in the database industry you should be looking at data warehousing that's when u get the serious bucks 60k upwards..

 

Don't sleep on Sql trust me.. But it will be hard understand the diagrams ERD etc

 

This time next year I should be doing databases 

Share this post


Link to post
Share on other sites
On 3/16/2017 at 9:50 AM, Drift said:

If you can, jump on SQL.

I use it as part of my job, it's a gateway to a lot of niche hidden fields you can move into.

i'm sold, where do i start?

off for the next two weeks & looking to be productive as fuck

Share this post


Link to post
Share on other sites
1 minute ago, Guest28 said:

I done Sql and data warehouse as a degree, so I know the basics but I don't have work experience in it, so I'm doing my Oracle and Microsoft certification in summer.... But your right Sql is so healthy right now even as a entry level position... Your looking at 30k to 45k calm doing simple querys... Once your in the database industry you should be looking at data warehousing that's when u get the serious bucks 60k upwards..

 

Don't sleep on Sql trust me.. But it will be hard understand the diagrams ERD etc

 

This time next year I should be doing databases 

i'm sold, where do i start?

off for the next two weeks & looking to be productive as fuck

Share this post


Link to post
Share on other sites

Been learning C# since last summer on and off and Javascript solidly for the past 3 months, started messing around with node + react and all that stuff recently.. When you learn one language, learning another is not even long, the fundamentals are all the same.  

When you think you got the basics down just start jumping in at the deep end trying to make stuff thats a bit beyond your skill level. 

Trying to get my foot stuck in this year

Share this post


Link to post
Share on other sites

yes, please guys, just try to make something

i hear too many people who talk about how they started learning then just stopped

actually make something, it doesn't have to be something amazing, but if you're just learning and not actually using it you'll stop caring

Share this post


Link to post
Share on other sites

I agree ..doing a project or two makes a world of difference 

Also at some point consider contributing to open source projects on github 

Share this post


Link to post
Share on other sites
22 hours ago, QPR Dee said:

i thought SQL was being superseded by NoSQL databases for big data etc?

NoSQL is good for storing large data but doesn't hold up to sql for complicated powerful queries. Also SQL is much better dealing with heavy duty transactions. Like operations updating hundreds of thousands to millions of rows of data at a time etc.

 

14 hours ago, Anderson said:

Without baiting anything personal you dont want to...what sort of coin can you rake in??

When ive finished this part time degree im looking to either learn spanish properly or do something computer based

Not sure what London rates are but for me in Brum 30-35k is average and 60k is top end.  If you move into business intelligence and data warehousing then you can hit 70k top end.

 

14 hours ago, Guest28 said:

I done Sql and data warehouse as a degree, so I know the basics but I don't have work experience in it, so I'm doing my Oracle and Microsoft certification in summer.... But your right Sql is so healthy right now even as a entry level position... Your looking at 30k to 45k calm doing simple querys... Once your in the database industry you should be looking at data warehousing that's when u get the serious bucks 60k upwards..

 

Don't sleep on Sql trust me.. But it will be hard understand the diagrams ERD etc

 

This time next year I should be doing databases 

This is what i'm doing now. My company has a DW in place but it's shit and will need redesigning in the near future. I should be a massive part of that which is going to give me invaluable experience, and  It's literally the only part of my lacking on my CV.

Diagrams as a concept are difficult, but once you start relating them to the design of your database schema it becomes piss easy.

Share this post


Link to post
Share on other sites
2 hours ago, Heero Yuy said:

NoSQL is good for storing large data but doesn't hold up to sql for complicated powerful queries. Also SQL is much better dealing with heavy duty transactions. Like operations updating hundreds of thousands to millions of rows of data at a time etc.

 

Not sure what London rates are but for me in Brum 30-35k is average and 60k is top end.  If you move into business intelligence and data warehousing then you can hit 70k top end.

 

This is what i'm doing now. My company has a DW in place but it's shit and will need redesigning in the near future. I should be a massive part of that which is going to give me invaluable experience, and  It's literally the only part of my lacking on my CV.

Diagrams as a concept are difficult, but once you start relating them to the design of your database schema it becomes piss easy.

Very interesting

Share this post


Link to post
Share on other sites

One thing I always struggle with and still do, is wanting to build new things, or waiting for amazing ideas to come before building something. But that's bullshit when the goals are to improve your skills. Just build anything. Clone your favourite apps, just build something! 

Share this post


Link to post
Share on other sites
17 hours ago, Incumbent said:

i'm sold, where do i start?

off for the next two weeks & looking to be productive as fuck

googled it but it's a mind field

Share this post


Link to post
Share on other sites

get an idea of what you want to make, something that sounds small, then me or one of the others in the know here can advise you on a starting point

Share this post


Link to post
Share on other sites

inspiring thread 

like most learning the basics of coding but also  learning woodwork something to do with my hands and away from a computer screen 

Share this post


Link to post
Share on other sites
On 18/03/2017 at 1:39 PM, Incumbent said:

googled it but it's a mind field

https://www.microsoft.com/en-gb/learning/mcsa-sql-certification.aspx

this is where im starting with SQL, look at the learning materials and the content that is tested for each exam

https://mva.microsoft.com/en-US/training-courses/sql-database-fundamentals-16944

https://mva.microsoft.com/training-topics/database-development#!jobf=Developer&lang=1033

start with these handy videos and complete the free courses on MVA. get the training book for the exam and see if you need to complete a paid course or if you reckon you can learn from these other resources.

For Oracle, there is MySQL certification and ordinary Oracle certification. At this time I will leave out Oracle because the exam definitely requires classroom time. Looking at job ads, lots ask for you to know about MySQL as a part of a list of other things concerning web development. For SQL/database development jobs I found that they wanted experience in either Oracle or SQL Server (microsoft one). 

 

https://www.mysql.com/certification/

http://education.oracle.com/pls/web_prod-plq-dad/db_pages.getpage?page_id=786#

 

apparently mysql has a different syntax to sql server

Share this post


Link to post
Share on other sites
On 18/03/2017 at 7:29 PM, tino said:

inspiring thread 

like most learning the basics of coding but also  learning woodwork something to do with my hands and away from a computer screen 

its a new dawn

Share this post


Link to post
Share on other sites

Create an account or sign in to comment

You need to be a member in order to leave a comment

Create an account

Sign up for a new account in our community. It's easy!

Register a new account

Sign in

Already have an account? Sign in here.

Sign In Now


×