Looking for Code Training

Clm

Hola,

I'm looking to learn to code. In every job i have had i was never required to learn anything except SQL. Now im looking to expand if you know any good sites with solid materials let me know.

Thanks in advance.

NetworkNewb

"code" might be a little too broad. Before learning any language you should have a good idea what your goal of learning that particular language is.

1. Choose what you want to learn to do
2. Then choose the language that can do it
3. Then learn that language


A couple good sites I've played around with are CodeAcademy.com and Teamtreehouse.com though.

Clm

I'm looking to do more with SQL and Im thinking python. Im currently studying for aws and from what i hear python is a great code to know.

yoba222

For learning to program I personally prefer reading a textbook cover to cover initially. Can then use websites afterwards to build on what I learned in the textbook. I feel that going the textbook route is a more well-structured learning approach compared with the online, slew of several hours of 2-10 minute video clips.

Really hard to learn code just for the sake of learning code though. What problems/projects are you looking to accomplish with code?

Clm

I work with a SQL Database daily but im usually only doing where clauses but i want to dig a little deeper in knowledge.

NetworkNewb

Clm wrote: »

from what i hear python is a great code to know.

Yea, it definitely can be as long as you have some use cases or ideas you're planning on use it for already. If I were you (or anyone thinking of learning to program), I'd come up with a problem or project, like yoba222 mentioned, and then figure out to how to create it. It will make things a million times more fun learning it.

Not to mention creating your own code and troubleshooting issues with it will help a ton as well.

DoubleNNs

https://automatetheboringstuff.com/

Start here. You'll learn the basics of the language and some fun use-cases. Might be able to automate a few repeatable tasks you currently do at work. Then move on from there.

Book is free to read online. You can also pay for the print/pdf/kindle version of the book. There is also a video course of the book up on Udemy.

jelevated

Enjoy

https://www.hackerrank.com/domains/python/py-introduction

EnderWiggin

codeacademy.com

It's free, and interactive. Tons of different classes there too, including both python and SQL.

Khohezion

For python...

https://www.coursera.org/learn/python

I learned alot form charles Severance off of Coursera I did the first 4 courses when it was on 2.7 but I think he recently updated it to reflect python 3.6 or whatever one its on now

If you dont want to sign up for Coursera he has a website with the same material here..

Python 2
Python for Everybody: Exploring Data in Python 3

Python 3
https://www.py4e.com/

NotHackingYou

I really liked the head first series of books. They have one on Python and another on SQL.

yoba222

NotHackingYou wrote: »

I really liked the head first series of books. They have one on Python and another on SQL.

+1 on the Head First series' recommendation. I'm slated to read Head First Python by Paul Barry over the next several weeks/months. I particularly like how this book steps the reader through a project that is actually useful--you code up a webapp that has a MySQL database on the backend.

I'm going to tweak that project into a vulnerability management system. I'll upload Nessus scans to a webapp, append/manipulate/keep track of the data, then be able to download the Nessus scans as a custom report.

The only thing is that Paul Barry wrote Head First Python under the assumption that Python was not your first programming language, so it might not be ideal as a first learn to code experience.