SQL
record (aka row)
A ____________ is each individual horizontal entry that exists in a table.
column
A ______________ is a vertical entity in a table that contains all information associated with a specific field in a table.
semicolon
A __________________ is the standard way to separate each SQL statement in database systems that allow more than one SQL statement to be executed in the same call to the server.
SELECT column1, column2, ... FROM table_name WHERE condition1 OR condition2 OR condition3 ...;
OR Syntax
fields
Every table is broken up into smaller entities called ______________; which is a column in a table that is designed to maintain specific information about every record in the table.
SELECT column1, column2, ... FROM table_name WHERE NOT condition;
NOT Syntax
SELECT DISTINCT column1, column2, ... FROM table_name;
Syntax for SELECT DISTINCT
SELECT column1, column2, ... FROM table_name WHERE condition;
Syntax for WHERE when using SELECT
SELECT COUNT (DISTINCT column_name) FROM table_name;
Syntax for returning the actual count of different/distinct values
SELECT * FROM table_name;
Syntax to select all records in a table?
SELECT column1, column2, ... FROM table_name;
Syntax to select specific records in a table?
relational database management system
What does RDBMS stand for?
Structured Query Language (SQL)
What does SQL stand for?
Standard language that lets you access and manipulate databases
What is SQL?
SELECT column1, column2, ... FROM table_name WHERE condition1 AND condition2 AND condition3 ...;
AND Syntax
No
Are SQL keywords case sensitive?
= Equal <> Not Equal > Greater than < Less than >= Greater than or equal <= Less than or equal
Basic Operators in the WHERE clause:
table
The data in RDBMS is stored in database objects called ______________; which is a collection of related data entries and it consists of columns and rows.
result-set
The data returned from a SQL Statement is stored in a result table, called the __________________.
WHERE
This clause is used to filter records and extracts only those records that fulfill a specified condition.
SELECT DISTINCT
This statement is used to return only distinct (different) values
SELECT
This statement is used to select data from a database.
NOT
Typically using in conjunction with the WHERE clause, the _________ operator displays a record if the condition(s) is NOT TRUE.
AND
Typically using in conjunction with the WHERE clause, the ___________ operator displays a record if all the conditions separated by "AND" are TRUE.
OR
Typically using in conjunction with the WHERE clause, the ___________ operator displays a record if all the conditions separated by "OR" are TRUE.