Using Subquery and Derived Tables I had difficult time understanding the world x and world y concept from the yet completed post “SELECT Quiz”. I found this one small hidden hyperlink “SELECT from...

I was learning SQL through SQLZOO, and at first, it looks easy. The deeper I got into it, and I realized that it can become all gibberish. I figured it might have to do with me not understanding th...

UPDATE (06/19/17) Please review Using Derived Tables and Nested SELECT to understand more about world x and world y in “Alias” paragraph New Keywords to learn: MAX Returns the largest value worl...

SELECT within SELECT exercise in SQLZOO teaches how to perform complex queries with one table. I am still new to SQL and yet have to learn how to work with two different tables or more. New Keywor...

The ArrayList Data Structure From Exercise #61 to Exercise #69 focus on ArrayList<Integer>(). I am going to start with Exercise #64 which covers on how to use (ArrayList<Integer> list)...

Continuing OOP Java Week 3 In last week, we learned how to use methods and calling arguments from a method into another method. Exercise #47 to Exercise #60 focuses on how to manipulate a string o...

UPDATE In MOOC’s Week 1 and Week 2 exercises, I did not capitalize classes. I learned that classes should always be capitalized. I don’t want to change all Week 1 & 2 classes, too much of work....

This post covers SQLZOO’s Exercise #3 Quiz. In previous post “SELECT from Nobel”, few new tricks like how to arrange data in order was discussed. It is also pointed out that SQL like things to be w...

This is the third exercise from SQLZOO. First half of the third exercise is just a review on previous exercises. I don’t plan to repeat them. Second half is where it gets harder, and even harder in...

I was going to continue on Eclipse with this last exercise of the Week 2, but realize it has many components and methods of its own. I decided to use NetBeans, because I want to start Week 3 alread...