SQL Wildcard Characters | How to use SQL wildcards
SQL wildcard characters are one of those simple tools that quietly make you far more effective as a data analyst. Used well, they turn rigid equality filters into flexible pattern…
How To Open Large CSV File (2GB, 4GB, 8GB, 12GB, 50GB)
Handling multi‑gigabyte CSV's - 2 GB, 4 GB, 12 GB, even 50 GB is a classic data engineering pain point. As file sizes increase, the tools and habits that work…
Difference between a Data Scientist and a Data Engineer
In a data centered world, we find a lot of job opportunities as a Data Scientist or Data Engineer for most data-driven organizations. Both career paths are data-driven, analytical and…
How To Get Last Day Of Previous Month In SQL
How to get last day of previous month in SQL SQL has become a powerful tool for data analysis and manipulation of data. The EOMONTH() function returns the last day of…