SQL on a Mac… we have the technology

At some point, you get tired of being told “You can’t do that”

Unless you are breaking a law or somehow being hurtful, success in life is really about the successful realization of a worthy ideal that positively contributes to society.

When you are told to sit down and shut up enough times you stop standing up and speaking but if you do stand up and speak against the vapid arrogance that flows out of the mouth of most Computer Science graduates… well you find they know actually know about 1/n as much as they say. (see what I did there)

The following phrases flow freely from the mouths of newly minted college grad computer science developers and more than a few advanced developers, who unfortunately don’t have a solid tech foundation.

“Hmmm, that’s weird” then walks away.

“Works on my machine” puts headphones back on.

“Sucks for you” seriously… who would say this?

These phrases should be banned and begin to gather gravity, thus forming as a series of red flags for IT and HR to be aware of with new (bad) hires, who are better at talking big about everything they know more than writing code that would identify them as a 10x developer.

More on 10x code in the future.

This behavior is essentially IT bullying and the startup society is finding this less and less acceptable behavior as found with the growing number of “no jerks” policy being listed on a number of startups (list here).

That being said there are skills that one must learn if you plan on getting any number of “tech jobs”

  1. Software Developer
  2. Software Engineer
  3. IT Analyst
  4. Data Analyst
  5. Data Engineer
  6. Data Scientist

While I’m sure the comments section will fill up quickly with people saying that these are not the only jobs in IT that people will want but the walls of Stack Overflow are covered in flame wars and hateful comments directed at people who are new and don’t know how to ask a question while they learn an industry that seems to be working hard to keep new people out.

This is called elitism and while it would be overly ambitious and an intractable challenge in snuffing it out, I plan on a series of blog posts teaching a few of the 100 level courses of which you will need to study while you work to learn the skills for each of these six positions.

We will also cover how other industries that have been around for at least 500 years have used a drastically different model for teaching, how those methods survive today and should be something you aspire to hold yourself accountable to for the quality of your work, be known for high quality code.

I will start with a Data Analyst since that is an essentially low hanging fruit of jobs that would be in my mindset since my focus long term is to be a Data Scientist.

In my next blog post, I’m going to begin to show someone with a Mac, how they can install and begin SQL, Python and AWS products.

Yes you can run SQL on the mac, no its not slower than a PC and if you’ve ever been in an actual data science boot camp or a major software development conference with the lights out… you will notice hundreds of white Apple logo.

If you use a PC, then I bid you good luck but while my firm doesn’t exclude PC’s we do highly recommend the use of Macs when asked, in the future I will provide a link to a good source for a MacBook pro laptop for beginner coders.

So this whole site, from the early stages of brainstorming, planning, design, implementation, and publishing was all done… on… my 7-year-old mac.

Yes, it has a bit more Ram at 16gig and a 2tb SSHD hard drive but other than that its stock, how is that for laptop lifestyle. (future link here)

Soon I will remove the CD-Rom and replace it with another SSHD just because I want the storage space and as a challenge to see how long I squeeze functionality out of “Markov” which is my MacBook Pro’s name.

Then we will work on some Tableau, PowerBI and if I am feeling brave some Jupyter-Notebooks scientific computing with Anaconda.

All this will be quite a project to complete in addition to my current workload as a Data Science undergrad but you know what they say “The best way to learn something is to teach it”

So onto SQL (I pronounce it as sequel), SQL which has multiple ways of being said, for clarity I will refer to it as “a sequel”, as in the Empire Strikes Back was an amazing sequel to the 1970’s Starwars movie A New Hope.

Normally SQL is referred to as the “database” and is essentially a small or large group of drawers in the .sql file which organizes data for a computer program.

If you have questions after reading this email I encourage you to buy the book “SQL for Mere Mortals” or “SQL for Dummies” and in future blog posts I will find a copy online for you to buy and this will help support my site, thus allow more people to learn data science tools so we can shore up the massive talent gap we are experiencing.

I am not a professional blogger but this is my blog and most of these are my ideas, that being said I read constantly from many, many different sources. So if you recognize a phrase or concept that should be attributed to someone, mention it in comments below and I’ll look into updating my blog.