CompSci 316 online sql tester Just click the link! - - PowerPoint PPT Presentation

compsci 316
SMART_READER_LITE
LIVE PREVIEW

CompSci 316 online sql tester Just click the link! - - PowerPoint PPT Presentation

CompSci 316 online sql tester Just click the link! http://compsci316-db-server.cs.duke.edu:5050/browser/ Click server -> Dashboard -> Add new server Add a name And then click connection Enter as shown Host: compsci316-db-


slide-1
SLIDE 1

CompSci 316

  • nline sql tester
slide-2
SLIDE 2

Just click the link!

  • http://compsci316-db-server.cs.duke.edu:5050/browser/
slide-3
SLIDE 3

Click server -> Dashboard -> Add new server

slide-4
SLIDE 4
  • Add a name
  • And then click connection
slide-5
SLIDE 5

Enter as shown Host: compsci316-db- server.cs.duke.edu The password for user student316 is compsci316 Click save

slide-6
SLIDE 6
  • The list of tables is in
  • Beers -> schemas
  • -> public -> tables
slide-7
SLIDE 7
  • Click on server -> 316TestServer->

Databases-> beers-> Schemas-> public -> tables -> [any table name]

  • And then click on the circled icon to

have a view of data inside table

slide-8
SLIDE 8

Click the server you just created

  • > Databases
  • > beers
  • > the lightning

icon To start using select queries

slide-9
SLIDE 9
  • Or Goto

Tools -> Query tool To start

slide-10
SLIDE 10

Query here press to execute result