Gr12 – SQL. Random numbers

Random numbers with predictable starting and ending values eg 1 – 10, 1 – 100, 1 -1000In SQL we use the RND( ) function. Inside the round brackets goes the seed value (an integer value) Generating a random number requires a few steps. A) Generating a...

Gr 12 – SQL Adv

In grade 12 you need to be familiar with composite SQL statements (embedded / nested SQL statements). This means that two statements are joined together – the result set on one query is passed to the other. Therefore there are two SELECT / FROM statements joined...

Gr 12 – OOP Theory

In Java OOP we need to understand the terminology and the design concepts behind OOP. Here are two handouts, quite similar but one is a teaching document and the other is a study document. Click here for OOP theory handout Click here for OOP theory study notes One of...