SQL BASICS — The Data Analysis Journey Begins with SQL
What is SQL, Why is it important to learn and what are OLTP and OLAP? This question marks the starting point of our journey with SQL.
As we all know, if we want to communicate with anyone in the world, we need to know how to speak in ENGLISH the globally recognized common language of communication. Similarly, when it comes to storing our data in database (OLTP/OLAP, well, we discussed later), we must understand to communicate with them using SQL.
SQL (Structured Query Language ) serves as the means to interact with various database such as MYSQL,SQL Server, Oracle, DB2, BigQuery and others available in the market,whether they operate on OLTP (Online Transaction Processing) or OLAP(Online Analysis Processing) principles.
Remember when we used to use pendrive to store data, we opted different brands like Transcend,SanDisk each with varying storage capacities like 2GB, 4GB, and beyond? Similarly, we store our data in database such as MYSQL, SQL Server,DB2, BigQuery based on the size of data they can accommodate.
In essence, regardless of the company providing the database or the size of database, our means of communication with it remains SQL.So, that’s why SQL is as important to lean as English.
Moving further, first, let’s discuss-What is OLTP and OLAP ?
In the whole world we have only two type of database. OLTP(Online Transaction Processing) and OLAP(Online Analytical Processing).
Conclusion:
In simple terms, we can say OLTP is like a cheetah that runs fast, while OLAP is like a cat that runs slowly. Depending on our needs, we can choose between OLTP and OLAP, and we can use SQL to communicate with both of them.
Happy Learning….!!!!
