In this tutorial we learn how to generate a random decimal number between 0 and 1, we then learn how to convert it to a random integer between 1 and 6, similar to rolling a die.
In this lesson we declare an integer variable, assign a value to it, then use an If/else statement to decide what to output to the screen based on evaluating the contents of the variable using a comparison operator.
In this lesson we learn about why we need variables. We declare a string variable, assign value to the variable, output the variable to the screen and also find out how many characters are in the variable.
In this tutorial you learn how to install the Eclipse IDE for programming Java. We also write, compile and execute our first program in Java to print a message to the screen.
In this tutorial we show you how to download and install the latest Java Development Kit (JDK) and also set the system environment variables in Windows to make it work.
In this lesson we talk about what the HAVING clause means (adding a condition for the output of the aggregate function when the GROUP BY clause is used), and we also talk about how to update particular values in a row using the UPDATE clause.
In this tutorial we talk about how to join tables together. It is important to remember with joins to always set in the Where clause which field is equal in both tables, otherwise you will get a very big table.
In this tutorial we learn to put our rows into groups, count the number of rows in each group, and find the maximum, minimum, or average value of each group.
In this tutorial we learn to use functions such as DATE(), MAX(), INT() with arithmetical operators such as minus and divide.
In this video we learn to sort our results from a query using the order by clause.