class: center, middle # Day 4 ### Postgres --- ## Lightning SQL Review * Databases -- * Tables -- * Columns -- * Constraints -- * SELECT, INSERT, UPDATE, DELETE --- ## Postgresql * Is a Relational Database that uses SQL -- * What does Relational mean? -- * It is free to and open source with thousands of contributors -- * It's going to store our data! -- --- ## Databases AND Schemas * Create Database -- * Create Schemas inside the Database -- * Create Tables inside the Schema -- * Reasons to use Schemas -- * To allow many users to use one database without interfering with each other. * To organize database objects into logical groups to make them more manageable. * Third-party applications can be put into separate schemas so they cannot collide with the names of other objects. --- ## psql CLI * CLI = command line interface -- * Allows you to run postgresql commands on a database -- * You can Create, Modify, Update, Delete anything on a database -- * \h alter - provides help for ALTER command -- * \q - quits psql program --- ## Postgresql Walkthrough * [https://education.launchcode.org/gis-devops/walkthroughs/#Install](https://education.launchcode.org/gis-devops/walkthroughs/#Install)