SQL Basics Flashcards
To be able to recall basic terminology of SQL so you don't look like a dumbass talking to the smart people.
SQL stands for ?
Structured Query Language
What is a relational database ?
Is a database that organizes information into one or more tables.
What is a table ?
A collection of data organized into rows and columns
What is a column ?
A set of data values of a particular type
What is a row ?
A single record in a table
What is a statement ?
Is typed text that a database recognizes as a command;
Statements always end in a semicolon ;
Statements vary but will usually contain a clause, a table name (the specific database set) and parameters.
What is a clause ?
Clauses preform specific tasks when read by the database.Clauses are always written in CAPITAL LETTERS !!! Clauses can also be referred to as commands.
What is a parameter ?
A parameter is a list of columns, data types, or values, that are part of a command aka clause. Parameters in conjunction with a command form an argument !!!
