rogerwschmidt/IntroToSQL.md

Created July 24, 2017 14:58

Star (0) You must be signed in to star a gist
Fork (0) You must be signed in to fork a gist

Select an option

Learn more about clone URLs
Clone this repository at <script src="https://gist.github.com/rogerwschmidt/4e197caa413551d3dd81bf3961827ff3.js"></script>
Save rogerwschmidt/4e197caa413551d3dd81bf3961827ff3 to your computer and use it in GitHub Desktop.

Download ZIP

Raw

IntroToSQL.md

Introduction to SQL Instructor Notes

Objectives

Use the PostgreSQL REPL to manage tables in a database.
Describe the common data types in PostgreSQL and their uses
Query a database table with aggregate functions
Query a database table with comparison, logical, and mathematical operators
Query a database table with pattern matching
Query a database table with LIMIT and ORDER BY
Create and use a seed file to create, read, update, and delete tables, columns, and records in a database
Use the PostgreSQL REPL to manage rows in a table.

Use the PostgreSQL REPL to manage tables in a database.

Describe the common data types in PostgreSQL and their uses

Query a database table with aggregate functions

Query a database table with comparison, logical, and mathematical operators

Query a database table with pattern matching

Query a database table with LIMIT and ORDER BY

Create and use a seed file to create, read, update, and delete tables, columns, and records in a database

Use the PostgreSQL REPL to manage rows in a table.

Sign up for free to join this conversation on GitHub. Already have an account? Sign in to comment