+ - 0:00:00
Notes for current slide
Notes for next slide

Day 4

Postgres

1 / 6

Lightning SQL Review

  • Databases
2 / 6

Lightning SQL Review

  • Databases
  • Tables
2 / 6

Lightning SQL Review

  • Databases
  • Tables
  • Columns
2 / 6

Lightning SQL Review

  • Databases
  • Tables
  • Columns
  • Constraints
2 / 6

Lightning SQL Review

  • Databases
  • Tables
  • Columns
  • Constraints
  • SELECT, INSERT, UPDATE, DELETE
2 / 6

Postgresql

  • Is a Relational Database that uses SQL
3 / 6

Postgresql

  • Is a Relational Database that uses SQL
  • What does Relational mean?
3 / 6

Postgresql

  • Is a Relational Database that uses SQL
  • What does Relational mean?
  • It is free to and open source with thousands of contributors
3 / 6

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!
3 / 6

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!
3 / 6

Databases AND Schemas

  • Create Database
4 / 6

Databases AND Schemas

  • Create Database
  • Create Schemas inside the Database
4 / 6

Databases AND Schemas

  • Create Database
  • Create Schemas inside the Database
  • Create Tables inside the Schema
4 / 6

Databases AND Schemas

  • Create Database
  • Create Schemas inside the Database
  • Create Tables inside the Schema
  • Reasons to use Schemas
4 / 6

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.
4 / 6

psql CLI

  • CLI = command line interface
5 / 6

psql CLI

  • CLI = command line interface
  • Allows you to run postgresql commands on a database
5 / 6

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
5 / 6

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
5 / 6

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
5 / 6

Postgresql Walkthrough

6 / 6

Lightning SQL Review

  • Databases
2 / 6
Paused

Help

Keyboard shortcuts

↑, ←, Pg Up, k Go to previous slide
↓, →, Pg Dn, Space, j Go to next slide
Home Go to first slide
End Go to last slide
b / m / f Toggle blackout / mirrored / fullscreen mode
c Clone slideshow
p Toggle presenter mode
t Restart the presentation timer
?, h Toggle this help
Esc Back to slideshow