Skip main navigation

New offer! Get 30% off your first 2 months of Unlimited Monthly. Start your subscription for just £29.99 £19.99. New subscribers only. T&Cs apply

Find out more

Welcome to week two

Describes the origins, use and structure of Structured Query Language (SQL).
Hello, and welcome to week 2 of the course. Last week, you learned about what a database is and explored an SQL-like database of computer sales data using a DBMS. This week, you’ll learn about a programming language known as structured query language, or SQL. Imagine that you worked for a company that handles large amounts of data. To analyse this data, you will have to retrieve it from an SQL database. So if you want to learn SQL, you should focus on developing the skills required to solve business problems. You’ll need to understand the software that allows you to search for, extract, and update the data you need from the database. What do you think this SQL statement will return when executed?
Share your answers in the comments below.

In week one of the course, you learnt about what a database is and explored an SQLite database of computer sales data using a DBMS (database management system).

This week will look at using SQL (Structured Query Language) to search and update the data in the computer sales database.

What is SQL?

Structured Query Language is a programming language designed to communicate with a DBMS. If you want to search, edit, or add data to a DBMS, SQL is the language to use. It was initially called ‘Structured English Query Language’ (SEQUEL) and pronounced ‘sequel’; it later had its name shortened to ‘Structured Query Language’ (SQL) for trademark reasons.

Applications of SQL

In the 1970s, IBM created new database software called ‘System R’. To enable the data within System R to be managed efficiently, Structured English Query Language (SEQUEL) was created. You can pronounce this as ‘S-Q-L’ or ‘sequel’; either is acceptable.

SQL has become a database query language standard; it is the basis of a variety of well-established database applications. With advances in database technology, SQL-based databases have become increasingly accessible for the regular user. This is due to the introduction of various open-source SQL DBMSs such as MySQL, PostgreSQL, SQLite, Firebird, and many more with no upfront cost.

Although most relational database systems use SQL, most of them also have their own additional proprietary extensions, which are usually only used on their own systems. However, the standard SQL commands such as SELECT, INSERT, UPDATE, DELETE, and CREATE can be used to accomplish almost everything you need to do with a database.

Why do you need to learn about SQL?

Put yourself in the shoes of an employee or a manager of a company who works with large amounts of data. For example, you could be working in Business Intelligence (BI), data science, database administration, or web development. All of these jobs involve managing huge amounts of data. Therefore, before carrying out any analysis with data, you will have to learn how to interact with it. Learning SQL will help you to extract information from a database efficiently and complete your tasks efficiently.

SQL language elements

The SQL language is based on several elements:

  • Queries: a query will retrieve data based on a given criteria. The example below selects all the data in the name field from the model table:
SELECT name From model;
  • Clauses: a clause is used to filter records and return data that fulfil a specified condition.
  • Predicates: predicates specify conditions, which are used to filter the return of the SQL statements. In the example below, the WHERE clause is used to return the name of the models with four cores. '= '4' is the predicate.
SELECT name FROM model
WHERE cores = '4'
  • Expressions: a combination of one or more values, functions, and operators to return a value when it is executed (run). The example below uses the count() function to return the number of records with four cores from the model table:
SELECT count(*) FROM model
WHERE cores = '4'


Below is an SQL statement that uses a SELECT, *, and FROM.

SELECT * from model;

In the comments section, describe what you think this SQL statement will return when it is executed.

This article is from the free online

Introduction to Databases and SQL

Created by
FutureLearn - Learning For Life

Reach your personal and professional goals

Unlock access to hundreds of expert online courses and degrees from top universities and educators to gain accredited qualifications and professional CV-building certificates.

Join over 18 million learners to launch, switch or build upon your career, all at your own pace, across a wide range of topic areas.

Start Learning now