SQLite (3) Practical Vocabulary

My first 'MEMCODE' deck. Learning SQLite vocabulary, focused mostly on common statements. Primary References: https://sqlite.org/ https://www.sqlitetutorial.net/ and others.

11 flashcards · Programming Languages · by antonmylcd

1. A "VIEW" is composed of a

   SELECT statement

2. A "VIEW" is a logical table

   Not physically stored

3. Name four notable features of SQLite:

   Four notable features of SQLite: server-less, self-contained, transactional, zero-configuration

4. SQLite is a software library.

   Written in C.

5. SQLite is a software library. It implements a database engine.

   Another common term for RDMS

6. Using sqlite3.exe, commands are entered into the command line.

   CLI

7. In clause with a SELECT statement and a WHERE statement, Which statemen is a query and which is most like a filter?

   A SELECT statement with a WHERE clause is commonly referred to as a query, but to differentiate SELECT from WHERE the following is helpful: SELECT is a query, WHERE is more analogous to a 'filter'

8. The ORDER BY clause is used to sort rows in sequence in the results.

   A place for everything and everything in its place. All is in ______.

9. SELECT DISTINCT column_list FROM table_list JOIN table ON join_condition WHERE row_filter ORDER BY column LIMIT count OFFSET offset GROUP BY column HAVING group_filter;

   The syntax of the SELECT statement. This one is hard

10. We use the JOIN statement to query data from multiple tables

    Can't think of a good hint for this one, sorry.

11. Punctuation: The comma seperates values in a list. The semicolon terminates a clause.