Sabio instructor, Hector Arias, takes us on a deep dive of SQL, a querying language used to interpret data. He offers an inside look at a SQL application and shares the different careers that utilize SQL, from Data Analysts and Web Developers to Project Managers and Database Administrators. Hector also shares what stands out about Sabio and offers resources for beginners looking to get their feet wet in SQL.
SQL stands for Structured Query Language. It is a programming language to manage data held in a relational database. A relational database stores data in the form of tables. SQL allows you to make a query with data stored in the database.
SQL has been used for many years to manage data – to take data and apply it in some useful way. At Sabio, SQL is introduced in the basics of the curriculum. It is an easy tool for someone without experience in programming to wrap their head around.
SQL is a tool to interpret data with countless uses. It is not specific to developers; SQL is a useful tool in the world of business and can be applied by Web Developers, Database Administrators, Data Analysts, Quality Assurance Engineers, Project and Program Managers, Business Analysts, and more. It’s up to the individual to determine how they want to utilize SQL.
Let’s say we have a data set of election data – a table that includes columns and rows of data like Gender, Candidate, County, etc.
A web developer would use SQL to draw conclusions about the election results and might use this information to display and monitor progress, show averages or classifications. They could create a simple query, like what the average age of voters is. The developer would take that and build an API to access this information and display it on a website where users could view it.
Do Different Types of Programmers Use SQL Differently?
Nope! At Sabio, we teach Node.JS and .NET; both Node Developers & .NET Developers use SQL in the same way. Using SQL is not dependent on the technology needed to make the query; the way information is managed is the same. Both developers may write an API to use that data, but the language they use to build the API is different.
Developers choose which database querying language to use based on the programming language or the dev environment they’re using. Generally speaking, they are pretty translatable. Most of the differences are architectural decisions, like deciding where to host the server and what is better for their respective technologies.
How a Database Administrator Would Use SQL:
A Database Administrator’s job is to ensure the database is secure; that it can’t be hacked, that people using it are qualified with the right credentials, that the actual architecture of this database is reusable, and more. A Database Administrator developer would use SQL to ensure that the database is secure.
Data Analysts use SQL to assess and analyze the data provided to determine statistics and create projections based on math. In the Election Example, a data analyst working at a news station could determine the percentage of people who already voted to project the winner before all the votes were in. They could then hand those discoveries to their producer or their anchor to read on air!
How a Program Manager Would Use SQL:
A program manager may not want to wait for a report from the analyst team, but as long as they have access to the database, they could query whatever they need and get preliminary information to make decisions and prioritize projects. SQL is not limited to developers; it’s useful in the world of business and at any type of company.
SQL is easy to write and read. It uses functions like “Select” and simple names for queries – it’s simplicity makes SQL easy to learn.
Sabio uses Microsoft’s version of SQL. There are other alternatives; they mainly differ in syntax. The main differences between these SQL databases depend on whether they’re open source or not, what kind of operating system (Windows, Linux etc) they require, etc.
For someone already working with relational databases like Microsoft's SQL version, switching to using other relational databases will be easy, because many features translate.
The language is easy to understand and is supportive for novice developers and people not accustomed to seeing code. Anyone who has used Excel to store information in tables will find SQL familiar and easy to initially transition into.
For beginners getting started with SQL:
All the coding bootcamp news you may have missed in June!
Top 4 Tips for Launching a Cybersecurity Career after Bootcamp!
Find out why bootcamp instructor Lindsey loves teaching data science at Flatiron School!