The second week at Industry Connect we are focusing on Data warehouse, I soon realise in order to get a good understanding of Data Warehouse, I need to dive in and get a solid foundation on SQL to fully appreciate both operational and relational database.
If I want to access databases then I need to know SQL.
In fact, SQL is the building block of designing, developing and maintaining the database and it’s a third most popular programming language among all the languages.
The most popular languages. Source: Stack OverFlow Developer Survey Results 2019
Big databases used by NZ big names like NZME, Trademe, local councils, DHB, big four banks and big four accounting firms plus international giants like Facebook, Netflix, Uber, Airbnb and more all use SQL-driven databases.
Essentially SQL is integrated with Generation Y lives when we log in to pretty much any web or mobile app, the data is retrieved from a database using SQL queries.
We all live in a database driven society where data is the most valuable asset and SQL is the powerhouse support every decision-making process.
Despite of rising popularity of NoSQL in recent years, SQL is still making its way back to become the universal interface for BI developers and analysts.
SQL is highly effective at data manipulation and I can exact data and the way it works then data testing and manipulating will be done faster.
Due to the data is held in a relational database management system (RDBMS), which means it is dynamics, can be queried, modified, and manipulated easily with some basic SQL queries.
In fact, SQL is a query language, not a programming language. It’s also a plain English language so anyone who can use English at a basic level can write SQL query easily.
The good news is that most DB engines are compatible with all SQL code. So once you learn SQL it should be similar to work across any relational databases regardless it’s MySQL, Microsoft SQL Server, SQLite, Oracle or others.
It’s easy to understand as all companies no matter which industry they are in, they all rely on data and need to organize and understand the information in a relevant way.
Chances are, they are going to encounter SQL databases, a lot. So they are always going to need a database professional. Whether I am going to be a back-end BI developer or front end BI Analyst, I devise a plan and routine to learn SQL inside-out.
I found a list of resources are very helpful when it comes to learning SQL
if you want to fast-track into high-income skills via an alternative education provider Industry Connect. You can reach out to me to talk about high-income skills, Business Intelligence journey and life design in New Zealand/Australia.
Feel free to connect with me through Linkedin and see if I can answer your question.