A SQL to your database desire.

When you hear about SQL or perhaps you read my SQL on a Mac blog post you are probably curious about how to accomplish this nebulous task that according to stack overflow (link here) is about as likely as growing wings because you want to fly.

You don’t need to grow wings, you can, however, learn that most tutorials and I mean well over 80% of the tutorials online are missing steps.

I’ve often thought about doing a blog post for every bad tutorial out there and create a shame list of the worst tutorials in the home we can get them taken down.

Ahhh, yes, rant ending now.

So you want to learn SQL and you have a mac?

The first thing to do is go to Microsoft SQL… shocker!!!

While I will give you some help, there is going to be a countless number of potential issues and I recommend a number of books as required… or not optional learning that I will reference in any email you do send me.

These books contain an invaluable amount of info, they can be taken in any order but I recommend you start on one today… yes you are capable of learning to code.

Learn Python the Hard Way

Learn SQL the Hard Way

SQL for Mere Mortals

Googles Python Class

Tableau’s Tuesday Dashboard classes

Cracking the Coding Interview

I also recommend you start listening to Talk Python to Me, and Python Bytes podcasts, they are awesome and your Netflix account will miss you but you can always catch up on tv once you have a phat tech job.

So once you have found the MSFT link you might want to go to this page MSFT Github this page links to the variety of source code that you need to download, install and start learning how to use.

SQL is a program that requires you to set up a “server” which is a fancy word for a program that needs to be running like your Gmail tab when you browse the internet.

In the books I’ve mentioned they talk about setting up SQL and saving passwords, which is a very good idea.

More in the future on naming conventions and tips on setting up your first mac based SQL server.

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.

Advertisements

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.

Big Data for Small Business

Firehose_dataThe world is filling up with data so fast and its not a matter of if you should do something but what are you using to manage the three V’s.

  1. Volume
    This is the amount of data that is flowing in, on and around your company location, about your company’s intellectual property, via social media or intranet. These sources of data run 24/7 365 and if you are only able to check them once a week or once a day… its a full-time job for most companies marketing or sales department.
  2. Variety
    This is the number of sources that can generate the work, how many social media accounts do you have where you have instant access to all of the data analyzed for ad-hoc use right now… your competitors are developing this, why aren’t you?
  3. Velocity
    Data is increasing in speed like a Tsunami coming to the mainland, the amount of data in Terrabytes is increasing every month, as of June 2018 we currently are able to track over 80 individual points of data on our own customers. Sometimes the insights and new sources of business value are not where you expect them.

Your Data Talking is an end to end boutique data service for small to mid-sized companies, usually companies with less than 100 employees are an excellent fit for the service and scale we offer.

The small business association has found that 99.7% of all businesses in the country are small businesses.

Companies that have more than 100 employees up to 500 already have two departments collaborating with key stakeholders or the board to analyze the data, that is assisted by an outsourced 3rd party as the skills and talent to work on the data is in limited supply.

Your Data Talking has people ready to listen to your questions and we will look to identify new sources of business value, then expand your data ecosystem, building models to process the data and that’s just the first three steps.

You can reach us at info@yourdatatalking.com give us a call.

Seattle office: 425-463-5034

New York office: 347-991-9106