SQL-101-Basics
  • Introduction
  • Part 1: Transact-SQL
    • 1.0: Getting Started with T-SQL
    • 1.1: Create Database
    • 1.2: Drop Database
    • 1.3: Create Table
    • 1.4: Insert
    • 1.5: Update
    • 1.6: Read
    • 1.7: Alter
    • 1.8: Customer Table
    • 1.9: Diagramming Notation
    • 1.10: Foreign Keys
    • 1.11: Join
    • 1.12: Solutions
  • Part 2: PostgreSQL
    • 2.0: Getting Started with PostgreSQL
    • 2.1: Create Database
    • 2.2: Drop Database
    • 2.3: Create Table
    • 2.4: Insert
    • 2.5: Update
    • 2.6: Read
    • 2.7: Alter
    • 2.8: Customer Table
    • 2.9: Diagramming Notation
    • 2.10: Foreign Keys
    • 2.11: Join
    • 2.12: Solutions
  • Part 3: T-SQL Challenges
    • 3.0: Introduction
    • 3.1: Challenge 1
    • 3.2: Challenge 2
    • 3.3: Challenge 3
    • 3.4: Challenge 4
    • 3.5: Solutions
  • Part 4: PostgreSQL Challenges
    • 4.0: Introduction
    • 4.1: Challenge 1
    • 4.2: Challenge 2
    • 4.3: Challenge 3
    • 4.4: Challenge 4
    • 4.5: Solutions
  • Part 5: Resources
    • 5.0: Resources
Powered by GitBook
On this page
  1. Part 2: PostgreSQL

2.1: Create Database

Previous2.0: Getting Started with PostgreSQLNext2.2: Drop Database

Last updated 7 years ago

Start by creating a folder outside of an existing git repository. Name the folder "SQL_Library."

  1. Open pgAdmin.

  2. Click on the plus sign next to "Servers."

  3. Click on the plus sign next to the specific server where you want to create your database.

  4. Enter the password for that server.

  5. Right click on "Databases," hover over "Create," and then click on "Database" when it pops up.

  6. A new window will pop up. Enter "SQL_Library" in the first box of the new window to name your database.

  7. Click on the blue "Save" button at the bottom of the window.

Please continue to .

Part 2.2: Drop Database