Lesson 3: Retrieving Data Result-Set

Question 1

Keywords

Answer 1

A word that is considered a reserved SQL word that is used in a database operation.

Question 2

SELECT

Answer 2

A SQL keyword that is used in a query statement to retrieve data rows from database tables (this tells you what rows of data you want pulled example FirstName LastName, City

Question 3

FROM

Answer 3

A SQL keyword that is used in a query statement before the table name that identifies the table. Example Where Customer will pull all the info from the customers table

Question 4

WHERE Clause

Answer 4

The WHERE clause is used to filter rows and only retrieve those that meet a specified condition. The specified conditon will use math operator symbols Example Where City = ‘Roswell’, Where amount > ‘100’

Question 5

Column Names

Answer 5

The column names that were defined when the table was created. Example FirstName LastName

Question 6

Filter Rows

Answer 6

Uses the WHERE clause to retrieve only the rows that meet a specified condition instead of all the data rows.

Question 7

Limit Columns

Answer 7

A list of column names to retrieve in the SQL query instead of retrieving all the columns in a table.

Question 8

Execute

Answer 8

Running a query statement to retrieve a result-set

Question 9

SQL Syntax

Answer 9

SQL syntax refers to the rules and guidelines that must be followed as SQL queries are written. The punctuation, spaces, mathematical operators, and special characters have a special meaning when used inside of SQL query statements. Different database systems will use different syntax rules, but the majority of SQL query statements are standard, which means that, as you learn SQL in this course, it can be applied to other database systems.

Question 10

Result-set

Answer 10

The data columns and rows retrieved when a SQL query is executed.

Question 11

Example of SQL Syntax Structure

Answer 11

Select FirstName, LastName, Email

From Customers