- Development Environment
-
- Use a unix command line interface (CLI) to manage files and
directories.
- Log-on to a remote server and move files between the remote and local
machine using
ssh and scp.
- Edit text files with vi.
- SQLite Command Line Interface
-
- Be able to start and stop the SQLite CLI and use .help to list CLI
commands.
- Correctly differenciate between an SQLite database file (binary) and
an SQLite script (text).
- Create SQLite scripts and execute them from the sqlite3 command shell
using the
.read command.
- Create SQLite scripts use unix redirect (<) to run them from the
unix command line.
- SQL Data Definition Language (DDL)
-
- Use the CREATE TABLE command to design data tables.
- Use the ALTER TABLE command to modify a table.
- Use the DROP TABLE command to delete a table.
- Use appropriate data types for numeric and text data.
- Use primary keys to manage table data.
- Use foreign keys to establish table joins.
- Use Unique constraint to manage table data.
- Use NOT NULL constraint to manage table data.
- Use VIEW to create a permanent virtual table.
- SQL Data Manipulation Language (DML)
-
- Use INSERT sql command to add data to tables.
- Use UPDATE sql command to modify current table data.
- Use DELETE sql command to remove current table data.
- Demonstrate constraint behavior against INSERT, UPDATE, and DELETE
commands.
- Use SELECT sql command to query one and multiple tables.
- Use SELECT sql command with WHERE clauses to filter and refine queries.
- Use SELECT sql command with WHERE clauses and boolean operators (AND,
OR, NOT, LIKE, IN, BETWEEN) to filter and refine queries.
- Use JOIN sql command and understant variants (INNER, OUTER) to create
table relationships.
- Use aggregate functions (SUM, MIN, MAX, AVG) to restrict returned data
set.
- Use HAVING clause to restrict returned data set.
- Use GROUP BY clause to organize returned data set.
- Understand string and formatting functions, and how to use a special
purpose table (such as dual) to test their usage.
- USE string, date, and time functions to build columns on the fly.
- Mathematics
-
- Calculate the Cartesian product of two sets.
- Evaluate ternary logical expressions.
