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.
Month: September 2019
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.
In this video we use the special operators AND, OR and LIKE in our select queries, to achieve some slightly more complicated queries.
In this video you learn about the select query – how to select specific rows / columns from a table. We also talk about using different comparison operators, such as larger than / smaller than or equal to.
So what you’ve created a table but you made a mistake in the data types of columns or you would like to add / delete columns? We show you how in this video.
In this video we cover the Insert Into SQL statement to insert some data into a table. We ran into some problems already – some phone numbers got stripped off a zero at the front, and it accepted some numbers with incorrect number of digits. All these will be fixed in the next tutorial.
In this lesson we run you through how to create a table in SQL. You learn about the syntax for the create table statement and some data types such as Integer, Varchar and float.