I recently completed Google Project Management Certificate on Coursera. In this post, I am sharing my overall experience of the course and the reason why… Read More »Google Project Management Certificate – my experience
I recently appeared for AWS Certified Data Analytics – Specialty exam and was able to clear it in my first attempt. In this post I… Read More »My experience of AWS Certified Data Analytics – Specialty certificate
CAST function converts one datatype to another datatype in teradata. The value must be compatible with new datatype else it will result in error. CAST… Read More »CAST function in Teradata
There is no sysdate built-in function in Teradata. You can use current_date and current_timestamp function.You can also create custom function named "sysdate" to replicate it… Read More »Sysdate in Teradata
Redshift ORDER BY is used to sort the output rows in the result set. You can sort the output rows in ascending or descending order.… Read More »Redshift ORDER BY
In SQL, ALIAS means another name given to objects like columns & tables. You can use column and table aliases to make sql query more… Read More »Redshift ALIAS – Column & Table
In this post, I will show you how you can use SELECT statements in Redshift to query data from tables. SELECT is used to fetch… Read More »Redshift Select
Teradata Date Functions Date consists of 3 parts – Day , Month & Year. When we combine all 3 parts together we get the output… Read More »Top 20 Teradata Date Examples
For the past few years I have been involved in many projects where the requirement was to migrate the existing on-premises data warehouse to modern… Read More »DataWarehouse Migration Projects – Beginner Guide
Amazon Redshift supports loading columnar file formats like PARQUET, ORC. This extends compatibility and possibility of moving data easily from different environments for your data… Read More »Should you use PARQUET files with Redshift Copy ?
