Last month I have completed the majority of the Complete SQL boot camp. I wanted to learn the details about the SQL language to expand my ability to perform manual ETL functions in python. In my past posts I explained how I was able to run simple ETL scripts using […]
The amount of data that is generated and recorded in the world has been growing exponentially in the past 10 years and will continue to grow in the coming future. In 2010 the amount of data in the world was estimated to be 2 Zettabytes, and by May 2020 this […]
I was recently given a data Challenge to complete, I was tasked to use python to install and configure multiple databases and perform an ETL pipeline between both. To Begin I launched T.2 Micro Linux AMI Instance and installed Mysql along with MongoDB, the CLI commands can be seen below […]
I understand that abstracting action through a CLI can be daunting for some but nothing can match the efficiency and granular control of CLI commands. In my previous attempts to migrate my database, I was having difficulty using MySQL workbench. After some time pondering the issue, I concluded that the […]
Today I explored aurora serverless, I am currently working on migrating a website database to more available architecture. I started off by creating a serverless database and attempting to connect using a local MySQL program. After multiple attempts I realized that it was not working. I troubleshooted this issue over […]
I work as a volunteer for a non-profit organization called the Ahmadiyya Muslim Community, they mainly focus on humanitarian along with religious activities and currently they needed help with their AWS systems. I volunteered my time and was given two tasks Apply SSL certificates to terminate on their locally hosted […]