Simple Advice for the Programmer Wannabe (please share this)

By Rick Delpo, former Senior Data Engineer at General Electric, now retired


Audience:

This advice is best for those who did not learn programming in school and are looking for a lucrative career or career change or just want to program for the fun of it. Also perhaps, a need to know by managers of data people.

How to begin, what is it all about:

There is much debate over which programming language to learn. At the high level we have Microsoft based versus open source. For example, do we learn Visual Basic or do we learn Java? Then there is the question of scripting versus the actual language itself. For purposes of learning data, scripting such as Javascript is used mostly for the front end application. So we need some connectivity to the back end which is the data repository. Therefore we need something like the java programming language. The reason I choose java for beginners is because of the java API, application programming interface. It is the basis for creating a java class which we will then execute and connect to the data. Java is also universal and other languages actually stem from java. We write up a class following a recipe in an API and then we compile and execute the class in a Java environment. Ideally we want to connect to a data source, iterate through some data and perform some kind of function on the data. Then we publish our application on the Cloud for others to see and use, or share and extend if they want to.

But we also need to consider, while researching, that it can get confusing quite fast as to where one’s entry point should be and at what level one should start. For the beginner, he or she will be unable to discern if there are prerequisites needed before just diving into any programming endeavor. This is probably the most confusing part for the beginner wondering where exactly do I start. Also, forget about reading technical articles as you will instantly find yourself over your head. Google research is great but I refer to it as “research hell” because it takes so long and there are many black holes to fall in to.

So the purpose of this writing is to provide my recommendation of an entry point and a path to follow. Then after that you will gain enough experience to do your own research and build upon what you know as a beginner. Then perhaps you will not stay with java or maybe you would prefer front end development instead.

My methodology comes from the way I learned my first programming language and it was very painstaking because I made all the common mistakes by doing it by myself. My recommendations are designed to quicken the process to avoid giving up. I get you to the shortcuts immediately and then we fill in the blanks later. This is my teaching methodology and I do it this way because I gave up many times along the way and it literally took me 10 years to finally land a lucrative position in the field. This is hardly what one wants, thus the shortcuts.

 

Notes on Entry Point:

  • Start with basic Java and SQL
  • Learn the shortcuts
  • Cut drastically the time it takes to get off the ground
  • Hand-holding is available through free tutoring

 

Barriers to Entry:

  • Too hard to learn alone
  • Many unanswered questions
  • Confusing conventions
  • Time consuming
  • Can give up easily

 

My curriculum:

  • It all starts with columns and rows in a spreadsheet
  • A spreadsheet with an API? What is an API anyway?
  • Why not learn a valuable programming language while playing with data on a spreadsheet
  • Learn JDBC first – connecting to the data
  • Set up data test in SQLITE
  • Query the data – learn SQL basics
  • Write a WebApp
  • Publish WebApp on the Cloud

Advanced level

  • Introduction to the data model – entity relationship diagram

   In the beginning we work on only one table but here we have multiple relational tables

  • A data warehouse environment to store and manipulate data and relationships
  • MySQL, Postgres

 

 

 

Tools used (all free):

  • JDK
  • Google sheets (free) or Excel (not free)
  • Eclipse
  • Tomcat
  • Sqlite
  • Talend
  • Data modeling tool

 

Why do this in the first place?

Quick answer is for the money.  It is a lucrative career choice. I did it and have no regrets. In fact, I was 42 years old at the time and made a career change from the field of finance to data management.

While Java and SQL is not new, creating and managing Cloud is still in its infancy.

Many large companies are just beginning to enhance their cloud experience and over next 10 years will need many new programmers. I know this first hand from working at GE. Consider that these large companies have a hybrid cloud so some of their cloud content is out their publicly and some is on a private cloud network. They need people to manage all of this. I encourage you to research this topic and you will be surprised.

Just look at the AI field for example. Wouldn’t you think that this is a growing field?

 

Conclusion:

I provide the basic nuts and bolts to get started and most of my services are free, then you determine the value and if you want to pursue fee based services do so only when ready.

First try all this on your own, then as questions arise call for free direction, I have an open door policy.

The best of luck to you!

Find me at cloudwithasilverlining.com

 

 

About the Author:

Rick Delpo has been involved in All things Data for 20 years in both a self employed capacity and on a real job with 2 of the largest companies in the country, both on the S&P 100. Now retired, Rick  offers free consulting just because of his passion for the subject matter. “I love what I do and got rich doing it so I don’t need the money anymore and want to share with others just for fun” says Rick on a recent blog post.

Rick Delpo grew up in rural Connecticut, son of a successful entrepreneur,  was prep school educated and a graduate from Georgetown University with a BS in Business Administration, class of 1976