Back to marketplace

Chapter 18 - Introduction to SQL

No description yet. This curated deck is ready for daily study.

Total cards: 24•Content version: v4•Public deck•Updated: 8/1/2026

Card preview (24)

#1
Front (Question)

What is SQL?

Back (Answer)

» SQL is a declarative language used to query and update tables in a relational database

#2
Front (Question)

What does the SELECT command do?

Back (Answer)

» Used to extract a collection of fields from a given table

#3
Front (Question)

What does the FROM command do?

Back (Answer)

» Specifies from which table the data will come from

#4
Front (Question)

What does the WHERE command do?

Back (Answer)

» Lists the search criteria

#5
Front (Question)

What does the ORDER BY command do?

Back (Answer)

» List the fields that the results are to be sorted on

#6
Front (Question)

What is one key feature to remember about the ORDER BY command?

Back (Answer)

» Default order is always ASC

#7
Front (Question)

What are the 2 types of commands in the ORDER BY statement?

Back (Answer)

» ASC » DESC

#8
Front (Question)

What does the = command mean?

Back (Answer)

» Equal to » Such as Title = “Death note”

#9
Front (Question)

What does the != command mean?

Back (Answer)

» Not equal to

#10
Front (Question)

What does the >= command mean?

Back (Answer)

» Greater than or equal to

#11
Front (Question)

What does the <= command mean?

Back (Answer)

» Less than or equal to

#12
Front (Question)

What does the IN command do?

Back (Answer)

» Equal to a value within a set of values

#13
Front (Question)

What is the LIKE command?

Back (Answer)

» Similiar to

#14
Front (Question)

What does the BETWEEN..AND command mean?

Back (Answer)

» Within a range » Such as Datepublish BETWEEN 01 AND 31

#15
Front (Question)

What is the IS NULL operator?

Back (Answer)

» Field does not contain a value

#16
Front (Question)

What is the standard structure of a SQL query?

Back (Answer)

» SELECT » FROM » WHERE » ORDER BY

#17
Front (Question)

What is the * operator?

Back (Answer)

» A wild card, selects all the fields of records

#18
Front (Question)

What are the commands to combine data from two or more tables, by only specifying which table the data is held in?

Back (Answer)

» Using the syntax: » tablename.fieldname » Then use multiple instances of this syntax to combine the tables

#19
Front (Question)

What is one thing to remember when joining data from two or more table?

Back (Answer)

» The table name is optional unless the field name appears in more than one table

#20
Front (Question)

How can you provide a link between tables in SQL?

Back (Answer)

» Using a condintion in the WHERE clause, such as eg.. » WHERE song.artistID = Artist.ArtistID

#21
Front (Question)

What is an alternative method of combining rows from two or more tables?

Back (Answer)

» Using the SQL JOIN command

#22
Front (Question)

When can the JOIN command be used?

Back (Answer)

» Can be used to combine data from two or more tables by specifying a common field between them

#23
Front (Question)

What is the main command of the JOIN operator?

Back (Answer)

» JOIN tablename » ON tablename.field = tablename.field » Note the table name is the other table which is not in the FROM statement

#24
Front (Question)

What is one key thing to remeber after using the JOIN command?

Back (Answer)

» Remember to specify the table where the field is coming from » Usually just do the table in which it is in the FROM statement then dot the record which links the 2 tables