icon picker
Sample databases


checked-checkbox

Practice with a sample database.

If you haven’t yet watched it, in a new tab. Then, follow the steps below to put that learning into action. Once you’ve completed the tasks, you can check your work by expanding the example dropdown.
Select all the data in this .
Copy and paste it in the space below (and see how Coda imports this data as a table automatically!).
Consider the ways this data could be improved, then implement some of those changes.
If you’re stuck, here are some ideas:
Make sure all of the currencies are formatted correctly.
Group your rows by County.
Sort your table by the What is your annual salary? column.

Expand to reveal example.

Country
How old are you?
What industry do you work in?
Job title
What is your annual salary?
Please indicate the currency
City
State
How many years of post-college professional work experience do you have?
If your job title needs additional context, please clarify here:
United States
22
35-44
Pet care
Pet sitter
$15,000.00
USD
Pittsburgh
Pennsylvania
5-7 years
18-24
Market Research
Market Research Assistant
$36,330.00
USD
Las Vegas
Nevada
2 - 4 years
25-34
Publishing
Assistant Media Editor
$41,000.00
USD
New York
New York
2 - 4 years
25-34
Information Management
Associate Consultant
$45,000.00
USD
Seattle.
Washington
8 - 10 years
35-44
Libraries
Director
$45,000.00
USD
Bridgeport
Michigan
8 - 10 years
25-34
Mental Health
HR and Administrative Coordinator
$50,000.00
USD
Baltimore
Maryland
5-7 years
one-man HR department and oversee administrative support for regional offices, staff events and trainings for a nonprofit
25-34
academic library
Public Services Coordinator
$50,000.00
USD
Unknown
Massachusetts
11 - 20 years
I manage the circulation desk and student shelvers
25-34
Nonprofit
Development Manager
$51,000.00
USD
Dallas
Texas
2 - 4 years
I manage our fundraising department, primarily overseeing our direct mail, planned giving, and grant writing programs.
25-34
Higher Ed
Associate Professor
$52,000.00
USD
Pittsburgh
PA
8 - 10 years
Community College
25-34
Education
Teacher
$54,000.00
USD
Unknown
Georgia
8 - 10 years
25-34
Higher Education
Student Records Coordinator
$54,371.00
USD
Philadelphia
Pennsylvania
8 - 10 years
equivalent to Assistant Registrar
35-44
Higher education
Instructional Consultant
$58,000.00
USD
Unknown
Wisconsin
5-7 years
25-34
state government - business mgmt/facilities
Associate Governmental Program Analyst
$60,000.00
USD
Sacramento
California
5-7 years
catch all title for higher level admin/analyst work. 1 step below management level. pay negotiated by union, set raises at fiscal year (COL/varies) and anniversary (5%), non-negotiable pay, set ranges for pay for each job title where everyone starts at base and can max out after a couple of years.
25-34
Environmental nonprofit
Operations Director
$65,000.00
USD
Madison
Wisconsin
8 - 10 years
25-34
Non-profit
Assistant Director of Development Research
$67,500.00
USD
Boston
Massachusetts
5-7 years
25-34
Events
Event Producer
$70,000.00
USD
Berkeley
California
5-7 years
25-34
IT
Support QA Lead
$71,000.00
USD
Baltimore
Maryland
5-7 years
35-44
construction fastener sales
office manager
$72,000.00
USD
Brick
New Jersey
21 - 30 years
I do sales and stock management as well - small office only 4 people
35-44
Government
Talent Management Asst. Director
$75,000.00
USD
Nashville
Tennessee
11 - 20 years
35-44
Business Consulting
Senior Consultant
$75,000.00
USD
Newark
New Jersey
11 - 20 years
Technical Writer
25-34
Business Services
Copywriter
$80,000.00
USD
DC
DC
11 - 20 years
25-34
media
senior marketing manager
$90,000.00
USD
DC
DC
8 - 10 years
Canada
4
35-44
Film & Television
Visual Effects Compositor
$50,000.00
CAD
Toronto
ON
2 - 4 years
25-34
Healthcare
Social worker (embedded in primary care)
$55,000.00
USD
Detroit
Michigan
5-7 years
35-44
communications
communiity investment officer
$68,000.00
CAD
Ottawa
Ontario
8 - 10 years
25-34
Telecommunications
Marketing Manager
$73,000.00
CAD
Montreal
Quebec
8 - 10 years
United Kingdom
2
25-34
Market research
Senior research executive
$30,000.00
GBP
London
England
5-7 years
25-34
Biotechnology
Senior Scientist
$34,600.00
GBP
Cardiff
Wales
5-7 years
Unknown
1
35-44
not for profit
convention coordinator
$63,000.00
CAD
Unknown
Unknown
11 - 20 years

Up next:



Want to print your doc?
This is not the way.
Try clicking the ⋯ next to your doc name or using a keyboard shortcut (
CtrlP
) instead.