We’re constantly interacting with data in our lives, which means that, behind the scenes, SQL is probably helping to deliver that information to us. Here are a few examples:
At its most basic, SQL is about accessing data locked away in databases. Think about the last time you received a report about how your company or team is performing. This probably had some key metrics like sales figures, conversion rates, or profit margins based on data stored in a system like a customer relationship management (CRM) or eCommerce platform.
A developer or analyst, or maybe even you, used SQL in order to access the data needed to produce that report.
Think about the last time you looked up the name of a movie on IMDb, the Internet Movie Database. Perhaps you quickly noticed an actress in the cast list and thought something like, “I didn’t realize she was in that,” then clicked a link to read her bio.
As you were navigating through that site, SQL may have been responsible for returning the information you “requested” each time you clicked a link.
Synthesizing Data to Make Business Decisions
With SQL, you can combine and synthesize data from different sources, then use it to influence business choices.
For example, if you work at a real estate investment firm and are trying to find the next up-and-coming neighborhood, you could use SQL to combine city permit, business, and census data to identify areas that are undergoing a lot of construction, have high populations, and contain a relatively low number of businesses. This might present a great opportunity to purchase property in a soon-to-be thriving neighborhood!