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.
In this lesson we talk about subqueries – using the result from one query as part of the condition of another query.
More SQL operators – Between – where we want to select rows with values between a certain range, or In, where we want the values to be in a set of specific values. We also talk about linking conditions together using brackets.