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.
In this lesson we talk about how to map our conceptual schema to relational database tables in the optimal normal form.
In this lesson we talk about some other constraints you can include in your CS diagram.
In this lesson we talk about how to add unique constraints (many to one, one to many, many to many, one to one)