Oracle PL/SQL Fundamentals vol. I & II course FINISHED
24 October 2019
In a way, this course was fun. Tim, the instructor, has a peculiar way to teach, but I have to admit, it kept me awake and wanting to learn more the whole time. This course is mainly focused on practicalities and practical use of PL/SQL, which helped me a lot to remove many uncertainties and questions while crashing into PL/SQL code. After this course, it all feels MUCH easier, and I feel like I can do a lot of efficient work in PL/SQL now.
Highlights of the course:
- Packages explained in detail - different ways of defining a package and its body, maintenance of packages.
- Triggers and how to work with them. This is explained in great detail in the course.
- Explicit pointers - I can’t say I’m entirely sure I got it all, but if not, I’m sure I can use these lessons to get the work done whenever I need to use them. Tim took quite a lot of time to explain pointers, which is great because this topic has always been a bit hazy for me.
- I’m very happy that Tim also included maintenance topics in this course. It made me much more aware of invalidating objects, how to validate them again, and what options are here to do so.