Skip to main content
Penn State College of Earth and Mineral Sciences Logo Penn State shield logo with links to Penn State homepage and College of Earth and Mineral Sciences

Department of Geography

Department of

Geography

GEOG 868: Spatial Database Management for the Geospatial Professional

User account menu

  • Log in
  1. Home
  2. Welcome to GEOG 868 - Spatial Database Management
  3. Lesson 1: Retrieving Data From a Relational Database

Checklist

Lesson 1 is one week in length (see the Canvas Calendar for specific due dates). To finish this lesson, you must complete the activities listed below:

  1. Download the baseball stats.accdb (right-click and Save As) Access database that will be referenced during the lesson.
  2. Work through Lesson 1.
  3. Complete Project 1 and upload its deliverables to the Project 1 Dropbox.
  4. Complete the Lesson 1 Quiz.

Book traversal links for Checklist

  • ‹ Overview
  • Up
  • SELECT Query Basics ›
Printer-friendly version

Search

Lessons

  • Welcome to GEOG 868 - Spatial Database Management
    • Lesson 1: Retrieving Data From a Relational Database
      • Overview
      • Checklist
      • SELECT Query Basics
      • Joining Data From Multiple Tables
      • Aggregating Data
      • SELECT Query Syntax
      • Differences Between MS-Access and Standard SQL
      • Subqueries
      • Project 1: Writing SQL SELECT Queries
    • Lesson 2: Relational Database Concepts and Theory
    • Lesson 3: Building a Postgres/PostGIS Database
    • Lesson 4: Advanced Postgres/PostGIS Topics
    • Lesson 5: Working with Esri's Desktop Geodatabases
    • Lesson 6: Introduction to the Enterprise Geodatabase
    • Lesson 7: Data Management in an Enterprise Geodatabase
    • Lesson 8: Versioned Editing
    • Final Project

Course materials prepared by Jim Detwiler and Jim Sloan, College of Earth and Mineral Sciences, The Pennsylvania State University

Unless otherwise noted, this site is licensed under a Creative Commons Attribution-NonCommercial-ShareAlike 4.0 International License(opens in a new tab), part of Penn State's College of Earth and Mineral Sciences' OER Initiative and the Libraries’ Repository of Open and Affordable Materials (ROAM(opens in a new tab)).

The College of Earth and Mineral Sciences is committed to making its websites accessible to all users, and welcomes comments or suggestions on access improvements. Please send comments or suggestions on accessibility to the site editor. (opens email client).

The John A. Dutton Institute for Teaching and Learning Excellence is the learning design unit of the College of Earth and Mineral Sciences at The Pennsylvania State University. About the Institute | Contact Us | Email the Site Editor. (opens email client)

© The Pennsylvania State University | Privacy | Non Discrimination | Accessibility | Equal Opportunity | Copyright