An ETL pipeline is a fundamental type of workflow in data engineering. The goal is to take data which might be unstructured or difficult to use and serve a source of clean, structured data. It is very easy to build a simple data pipeline as a python script. In this article, we tell you about
Different sub-languages of SQL.
When we talk about databases. One of the biggest types that exists is SQL. SQL or Structured Query Language is used where you have to keep data that is relational in nature. Mysql, Postgres, DB2 are the different software that implements it. SQL comprises of many sub-languages that provide different capabilities to SQL. The capabilities
Want to know how to optimize MySQL database. Read here.
Every software engineer must have heard the name Mysql as it is one the most used and popular databases in world. When it comes to engineering there are whole lot of people who don’t even bother to think about database and focus only on code. This comes back and bite them bad when the system
Five mysql tricks to save your time while migrating huge data.
Hey there, when it comes to data archiving or migrating some of data from mysql to say csv of any other format. If the amount of data is huge it becomes really difficult to do so. Follow the following tips if you are working with great data. So lets see five mysql tricks to save