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

▶

Mar 02, 2024 305 likes •423 views

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

CompSci 316

nline sql tester

SLIDE 2

Just click the link!

http://compsci316-db-server.cs.duke.edu:5050/browser/

SLIDE 3

Click server -> Dashboard -> Add new server

SLIDE 4

Add a name
And then click connection

SLIDE 5

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

SLIDE 6

The list of tables is in
Beers -> schemas
-> public -> tables

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

Click the server you just created

> Databases
> beers
> the lightning

icon To start using select queries

SLIDE 9

Or Goto

Tools -> Query tool To start

SLIDE 10

Query here press to execute result