Coding resources and Hacktober!

This week has been light on the person projects, but not light in the learning. Yesterday I spent the more relaxed end of my work day studying some SQL. It's some basic things, but I still think going over the basics again is useful. We use a lot of pre-written queries at work and despite my project using SQL I find that I struggle when actually writing my own queries. It is getting better and I am glad that I feel comfortable looking things up while I am at work. In the past I struggled much more with reaching out for help. I guess it was a bit of a pride thing, but more so it was a fear of not being perfect. I still strive to be as perfect at things I do as possible even though intellectually I know that that striving is futile.

Below I is a list of resources I use for learning SQL and everything else. This is a list I maintain in a document and send out to people if they express interest in learning how to code. This has been especially helpful at work, since I have been able to share a ton of free education resources to coworkers.

Teamtreehouse.com - Free with my local library card and many other libraries in the United States or $25/$50 a month depending on if you want access to their tech degrees and a few other things.

Udemy.com - Relatively cheap since there are frequent site-wide sales. As a general rule I don't buy any course over $10. Buyer beware though, there are a lot of courses on there and not all are good. Reviews are your friend.

Microsoft.com - specifically search for their learning material. There are a lot of free courses, a lot of them focusing on Azure but there are also some .NET courses too.

Freecodecamp.org - is a wonderful resource to get your feet wet with web development. They have over 1k coding challenges, 6 certifications, and 30 projects you can work on.

YouTube.com - There is a plethora of free learning material on YouTube. Use it to your advantage!

Javascript30.com - This is an excellent 30 day course of 30 vanilla JavaScript coding challenges.

Leetcode.com - coding challenges

Hackerrank.com - coding challenges

100daysofcode.com - Code a minimum of an hour everyday and post your progress

codewars.com - coding challenges

theodinproject.com - Full stack JavaScript, front end only, and a full stack ruby on rails course

codecombat.com - gameified coding challenges

coderbyte.com - coding challenges

codier.io - coding challenges

Lynda.com - free with a library card for me, might be for you as well

Those are the resources I can think of right now, but I am sure I missed so many. Next week I am going to list online reference resources that you can go to for explanations and examples of code so you can apply it to your own projects.

Hacktoberfest and Confidence

It's the most wonderful time of the year? Maybe, haha! Time again for Hacktoberfest and at the same time for me Preptober for Nanowrimo, which is next month. Oh boy, do I love projects. For Hacktoberfest though, I'm not quite sure what kind of projects I want to contribute to. I know I want to go to my local Open Source meetup and go to their Hacktoberfest presentation. It's fun to see the possibilities that are there for contributions.

This year will be my second Hacktoberfest and I couldn't be more excited. I'm of course listening to podcasts and watching YouTube videos for inspiration and guidance, but like last year I am apprehensive about actually participating. I think that comes down to me only working on my own things throughout the year. And not really committing to GitHub on top of that. (I have to get better at that!)

On top of the Open Source meetup I also want to go to more meetups in general. I know there are awesome people there that love to help out people who need a little guidance, but too often than not I let my shyness get the best of me. I have this nagging need to not be a bother to anyone, but I know to get anywhere with code I MUST ask questions. There a ton of resources available to me, one being the awesome Slack channel from my boot camp that I am still a part of and well, as mentioned before, the wonderful people at meetups who want to help those who need help.

I think I get stuck on wanting to do coding challenges rather than actually building something, so the prospect of adding to an existing project feels daunting. I desperately don't want to break anything! But then I remind myself, that's why these are pull requests. If I put in a pull request and they choose to put it in their project and it breaks something...well it is their project. That, however, doesn’t mean I won't try my hardest not to break something!

I still need to research if this is a thing, but I would love it if I could do a pull request involving Postgres since that's what we use at work. I want to get better at it! We have pre-built scripts that we can run to get the information we need, but whenever I need to write something myself I freeze. Here’s to more learning and applying my knowledge this month!