Database Developer - SQL Server/T-SQL/Database Migration


Event Title: “Database Developer - SQL Server/T-SQL/Database Migration”


I. Details of the event/activity


I started May 29 and finished May 30, 2024, I completed an online course on Udemy about database migration using Oracle SQL Developer. The course covered how to move a database from Microsoft SQL Server to Oracle. It included topics like setting up a migration repository, connecting to the old database, checking the current database state, converting the database to Oracle, translating SQL objects, creating scripts for the new database, and moving data to Oracle.


II. Reflections on the webinar/activity give rise to (learnings):


As a student, the course for me is informative but challenging. I also learned the importance of checking the current state of the database before starting the migration process, this is to avoid affecting what's in the live database. I also started to understand how to convert database models and translate T-SQL objects to Oracle SQL. While I didn’t grasp all the details, I got a sense of how these steps help keep the database working properly after the migration. This course gave me a basic idea of the key steps involved in database migration, which is important for backend development.


III. Reflections on possibilities on implementing some of the webinar input on a

practical level (practical application of learning)


Even though I’m still learning, I can see some practical applications of what I’ve learned. For instance, I can try setting up a migration repository and connecting to different databases in my practice projects. Attempting to capture and convert database models will be a good exercise for when I upgrade or migrate databases in the future. The basics of generating scripts and moving data will be useful skills to develop further, helping me understand how to handle database migrations more smoothly in the future.


IV. Positive feedback (on the event organization)


The course was well organized and easy to follow. The instructor did a good job of explaining each step and provided practical examples that were helpful, it’s just i have hard time following some of the instructions, especially the technica part. The content was arranged in a logical order, making it easier to follow along. I appreciated the hands-on approach, which allowed me to practice some of the concepts as I learned them.


V. Suggestions for improvements to be made/consider for future activities


While the course was very helpful, it could be improved by offering more details on troubleshooting common issues during database migration. Including more real-world examples would also help in understanding how to apply these principles in different situations. Additionally, providing downloadable resources or quick-reference guides would be beneficial for students like me who are still getting a grasp on these concepts.


VI. Photo


VII. Certificate

Comments

Post a Comment

Popular posts from this blog

PIONEERING THE FUTURE: STUDENTS DELVE INTO THE IT INDUSTRY

Image
        PIONEERING THE FUTURE: STUDENTS DELVE INTO THE IT INDUSTRY January 15, 2024   Event Title: “PIONEERING THE FUTURE: STUDENTS DELVE INTO THE IT INDUSTRY” Details of the event/activity: Our recent visit to iPhiTech, a leading IT company, was an enlightening experience for the group of students from Gordon College. The visit encompassed a tour of the company's satellite office, discussions with key figures in the organization, and an exploration of iFiTech, a technology company in the Dau HQ. Reflections on the webinar/activity give rise to (learnings): The visit provided a unique opportunity to witness the inner workings of a prominent IT company. The engagement with Ms. Lear Dacanay, the HR Director, offered insights into the company's culture and values. Interacting with various departments and employees allowed us to understand the intricate hierarchy and the diverse roles contributing to the company's success.  The conversation with Mr. Benjamin Y...
Read more

Cloudstaff ROAR 2023

Image
     Cloudstaff ROAR 2023 December 09, 2023   Event Title:"“Cloudstaff ROAR 2023” " Details of the event/activity: Cloudstaff ROAR 2023 was a spectacular event held in Sta. Maria, Bulacan, featuring captivating performances by the Manila Philharmonic Orchestra, Lola Amour, and renowned singer Ely Buendia. The event was a celebration of excellence, marked by awards ceremonies and a diverse range of performances. Hosted by the charismatic Sam YG, the atmosphere was filled with joy and excitement. Reflections on the webinar/activity give rise to (learnings): Participating in Cloudstaff ROAR 2023 provided valuable insights into the synergy of diverse talents and the power of collaboration in creating a memorable event. The performances showcased the impact of live music and entertainment in fostering a sense of unity and celebration. Additionally, the awards ceremonies underscored the significance of recognizing and celebrating achievements in various fields. Reflec...
Read more