Running a marathon is a monumental undertaking. Even though I had been preparing for 1.8 years, it wasn’t until a few weeks ago that I truly grasped the significance of this feat. The turning point came when I made the decision to run for a charity organization in Brazil, specifically Casa da Crianca Paralítica de Campinas (https://www.ccp.org.br/web/). This organization provides vital medical, dental, and pedagogical support to children with physical and mental disabilities in Campinas, Sao Paulo State, Brazil. Moreover, during my preparations, I delved into the origin of the…
Category: Amazon
EXAM PREPARATION – AWS Certified Machine Learning – Specialty
I have been studying not only for this certification of Machine Learning but for other in Data Engineering since I started my master’s studies in Data Science a few years ago. And the reason behind that is that I was already working with the AWS console and was overwhelmed with the changing data management I saw while a database administrator. I still remember everyone talking about this Machine Learning thing, and I had no clue back then what it was. I was seen many database administrators mistakenly changing their role…
Transforming .CSV format file in Apache Parquet format via Amazon Glue
I had the task of storing a .CSV format file in an Amazon S3 storage, but the pre-requisite was converting this .CSV format file to Apache Parquet format. Thinking from this perspective, I assume that one of the reasons for this conversion is to reduce costs, and for that, the tool Amazon Glue is the perfect tool to accomplish this task. I thought to describe and show my implementation here, but I realized that there are many how-tos that I followed, and their link is shared below as a source:…
EXAM PREPARATION – AWS Certified Database – Specialty (DBS-C01)
The AWS Certified Database – Specialty (DBS-C01) y exam has been on my bucket list for a few months. I tried it for the first time on Aug 09, 2022, and I failed. Although I considered that I was not that bad at all, I scored 681, where the minimum passing score is 750: The approach that I took for my first attempt was to buy some courses about the certification at Udemy, which I will no longer share the courses here not to do free merchandising 🙂 , and…
If you ever need clarification about the functionality of the content delivery network (CDN) service Amazon CloudFront …
It has been some years since I graduated in Computer Science. Then, out of curiosity, I checked the college website to see the new courses and everything else that was new. However, after many attempts, I could still be blocked by the configuration in the Amazon CloudFront established as below: I understand that Amazon Cloud Front has many advantages, such as communication encryption while handling certificates and default protection against DDoS attacks by covering the majority of attacks on the 3 and 4 layers of the OSI model provided by…
Exam Preparation – AWS Certified Data Analytics – Specialty
Many people don’t know that the idea of learning from data is not something from the current decade. It was pointed out over 50 years ago by John Tukey in “The Future of Data Analysis” (Donoho, D. (2017)). More and more companies have a Data Warehouse (Data Lake or both – Data Lakehouse) that can handle a massive amount of data, such as 900 TB, and has data imported constantly with SQL-like queries and operators accessing it over the day. What is the reason behind it? Identifying and visualizing patterns…
CDC Oracle is not CDC Amazon
I have done some migrations from Oracle On-premise to Oracle AWS RDS using the AWS DMS (Data Migration Services) . However, while I was giving a lecture in Sweden I found out that the CDC is not supported in Oracle 12 and onward. Mathias Magnusson, one of the Oracle Aces (Oracle Ace Program) in Sweden asked me if the Amazon CDC mentioned in my presentation was the same CDC in the Oracle Database. At that moment I didn’t have the information but after the presentation and some research I found…
ORACLE AND AWS RDS FOR ORACLE TIP 4: DMS limitation and my experience (Pros X Cons) to migrate your Oracle database On-prem to AWS RDS
So this is the fourth and final article about how to migrate your Oracle database On-Prem to AWS. You can check the previous articles here : 1- ORACLE AND AWS RDS FOR ORACLE TIP 1: HOW TO CONFIGURE YOUR ORACLE ON-PREM TO BE MIGRATED TO AWS RDS ORACLE? A guide to use Amazon Data Migration Service (DMS). 2- ORACLE AND AWS RDS FOR ORACLE TIP 2: HOW TO CONFIGURE YOUR ORACLE AWS RDS TO RECEIVE DATA FROM AN ORACLE ON-PREM? A guide to use Amazon Data Migration Service (DMS). 3-ORACLE…
ORACLE AND AWS RDS FOR ORACLE TIP 3: HOW TO CREATE A TASK AT DMS AND START YOUR MIGRATION
This post is part of the first post “ORACLE AND AWS RDS FOR ORACLE TIP: HOW TO CONFIGURE YOUR ORACLE ON-PREM TO BE MIGRATED TO AWS RDS ORACLE? A GUIDE TO USE AMAZON DATA MIGRATION SERVICE (DMS)” where I briefly explained how to configure your Oracle database On-Prem to be migrated to an AWS RDS Oracle and second post “ORACLE AND AWS RDS FOR ORACLE TIP: HOW TO CONFIGURE YOUR ORACLE AWS RDS TO RECEIVE DATA FROM AN ORACLE ON-PREM? A GUIDE TO USE AMAZON DATA MIGRATION SERVICE (DMS)” where…
ORACLE AND AWS RDS FOR ORACLE TIP 2: HOW TO CONFIGURE YOUR ORACLE AWS RDS TO RECEIVE DATA FROM AN ORACLE ON-PREM? A guide to use Amazon Data Migration Service (DMS).
On my last article, I wrote about how to configure your Oracle On-Prem database to be migrated to an AWS RDS Amazon (If you didn’t see this post check it out : https://www.techdatabasket.com/oracle-and-aws-rds-for-oracle-tip-how-to-configure-your-oracle-on-prem-to-be-migrated-to-aws-rds-oracle-a-guide-do-use-amazon-data-migration-service-dms/). Some people may ask the version of my Oracle On-Prem or even the class or version of my AWS RDS instance but the fact is if you are going to perform a Homogeneous migration as it is in this example (From Oracle to AWS Oracle RDS) the steps are the same. However, as it is in all…