Jump to content
BinaryChaos.net
Lupes

Learning SQL for fun & profit.

Recommended Posts

So recently, because of things, I have decided to invest some time into learning the solid foundations of basic SQL mostly for fun. Anyone familiar with SQL can tell you it's one of the easiest scripting languages around because the syntax and order makes so much sense.

If anyone wanted to come along on this journey of knowledge and power, a great start is learning the entirety of the W3 Schools SQL tutorials, and then working through the exercises once you've really nailed it down.

Get crackin' nerds!

Get smort.

  • Like 1

Share this post


Link to post
Share on other sites

Simple Query Language... name says it all. Basically you write a script that queries a database to get a spreadsheet like result.

Using this you can do all sorts of things like use php to input search criteria in to a query and output what you are looking for all in a http type format. Can use reporting platforms to make the data more visible for clarification in to what's going on in your business, website, or really anything where you would have a mass amount data stored.

It's being utilized more and more by medium to large sized businesses to create metrics and targets. Super handy if you have stakeholders and you want to give them some insight into how your business is doing besides just handing them a spreadsheet with some numbers. 

I work with it on the daily and have found a passion in it so if anyone has any questions along the way to learning let me know and I'll Google it for ya. 😉

Share this post


Link to post
Share on other sites

What I want to know is how do profit? I'd love to do some side work for a project working with SQL. 

  • Meh 1

Share this post


Link to post
Share on other sites

Where do you get the data you'd go through for your side projects? Sounds like you'd have to be a freelance worker.

Share this post


Link to post
Share on other sites

If you want to make money, I recommend starting with postgres or mariadb. IME, dev shops favor those because they have the desirable characteristics of being free and not terrible. Although, again, IME, as an industry, we've been moving away from classic rdbs. Where I work, we're storing most of our data as JSON in S3 and I'm looking to move what's left in our mysql db into QLDB within the next half decade.

A neat tool to look into for reading JSON data is jq, which I use all the time at work: https://stedolan.github.io/jq/

It basically takes JSON data that your software usually manipulates, and turns it into something that you can pipe into the standard *n*x toolset.

postgres: https://www.postgresql.org/

MariaDB: https://mariadb.org/

S3: https://aws.amazon.com/s3/

JSON: https://www.w3schools.com/js/js_json_intro.asp

QLDB: https://aws.amazon.com/qldb

legal disclaimer: the information offered here is my personal opinion and not the opinion of my employer

  • Like 1

Share this post


Link to post
Share on other sites

Create an account or sign in to comment

You need to be a member in order to leave a comment

Create an account

Sign up for a new account in our community. It's easy!

Register a new account

Sign in

Already have an account? Sign in here.

Sign In Now

×