It is known that Oracle has two types of partitioned Indexes: Local and Global Partitioned Index. I will only cover some of the specifications that explain their differences. However, according to the VLDB and Partitioning Guide release 21c, “Partitioning is possible on both regular (heap organized) tables and index-organized tables, except for those containing LONG or LONG RAW columns. You can create nonpartitioned global indexes, range or hash partitioned global indexes, and local indexes on partitioned tables.”. Furthermore, while creating a local index, the database constructs the index, which is…
Year: 2023
Oracle Certified Master Exam Updates – March 2023
It has been a while since I aimed to be an Oracle Certified Master (OCM). For those unfamiliar with this exam, it is (or was) an Oracle practical exam that consisted of two days somewhere in the world. It would test your Oracle skills to achieve the master’s and top certification from Oracle. It is a certification that gives prestige and recognization because a minority number of database administrators have this credential, and all because of all the value invested in the courses as prerequisites and other expenses. From the…
Exam preparation – Exam AZ-305: Designing Microsoft Azure Infrastructure Solutions
It has been a while since I got nervous about taking a certification exam, and this was the big surprise about the “Exam AZ-305: Designing Microsoft Azure Infrastructure Solutions” for me. This year is all about Infrastructure and cloud, and for those who read something on my blog is a new approach after nearly a decade of writing mainly about databases, especially my favorite RDBMS, Oracle. I wish I had much to say about this exam. Still, everything about my preparation was everything that I covered in the book “Book…
Book Review: Exam Ref AZ-305 Designing Microsoft Azure Infrastructure Solutions
This post is about my thoughts about the book “Exam Ref AZ-305 Designing Microsoft Azure Infrastructure Solutions” written by Ashish Agrawal, Gurvinder Singh, Mohammad Sabir Sopariwala, and Avinash Bhavsar. Some specifications of this book are below: Language English Publisher Pearson Education Author Ashish Agrawal, Gurvinder Singh, Mohammad Sabir Sopariwala, Avinash Bhavsar Title Exam Ref Az-305 Designing Microsoft Azure Infrastructure Solutions ISBN-13 9780137878789 Publication Date November 2022 ISBN-10 0137878788 I decided to read this book to increase my skills in designing…
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 – Google Cloud Certified – Associate Cloud Engineer
First of all, check out my GitHub to keep up-to-date about my programming https://github.com/brunorsreis and find some projects, scripts, or use cases about my studies. This exam is one of those that I most enjoy taking. The approach here was setting up some weeks with my twin brother where we were located on two different continents, making it work to have a meeting and study together with each other, real teamwork. I am grateful to have a brother like my twin. On top of that, I have been working on…
Exam Preparation – Google Cloud Certified – Professional Data Engineer
Google Professional Data Engineer is one of the most exciting and interesting exams I was aiming to pass. Over my career, I have worked mainly with database management until I realized something had happened – The RDBMS databases were no longer the inevitable choice for data management. As a Data Engineer, one is expected to work still with databases and streaming technologies, microservices, third-party APIs, data pipelines, big data technologies, etc. And back then, I had no idea what was happening. Therefore, what does one do when do not know…
Exam Preparation – Google Cloud Certified – Professional Cloud Database Engineer
I have aimed to take a Google certification since starting my career. However, I only had the opportunity to work with Google’s products in the last 3 years, when I began working with GCP Cloud. Therefore, I started my preparation in the segment that is my domain: databases. And, mainly because I wanted to go deeper into a product that as Athena for AWS and Oracle as RDBMS, it became one of my favorite products to work with, which is Google’s fully managed, serverless data warehouse named BigQuery. To my…