An Overview of Spatial Data and GIS for the DBA

An Overview of Spatial Data and GIS for the DBA, available at $19.99, has an average rating of 3.45, with 11 lectures, 11 quizzes, based on 24 reviews, and has 159 subscribers.

You will learn about Understand where spatial data comes from Learn about coordinate systems used with spatial data Understand how spatial data is being stored Learn about the different geometry types in spatial data Learn 3 methods to approach managing spatial data Understand adding spatial data capability to a table This course is ideal for individuals who are DBAs who are currently or will be managing spatial data in their databases or Database Administrators, or Developers with that knowledge or This is not a beginning database administrator course It is particularly useful for DBAs who are currently or will be managing spatial data in their databases or Database Administrators, or Developers with that knowledge or This is not a beginning database administrator course.

Enroll now: An Overview of Spatial Data and GIS for the DBA

Summary

Title: An Overview of Spatial Data and GIS for the DBA

Price: $19.99

Average Rating: 3.45

Number of Lectures: 11

Number of Quizzes: 11

Number of Published Lectures: 11

Number of Published Quizzes: 11

Number of Curriculum Items: 22

Number of Published Curriculum Objects: 22

Original Price: $22.99

Quality Status: approved

Status: Live

What You Will Learn

Understand where spatial data comes from

Learn about coordinate systems used with spatial data

Understand how spatial data is being stored

Learn about the different geometry types in spatial data

Learn 3 methods to approach managing spatial data

Understand adding spatial data capability to a table

Who Should Attend

DBAs who are currently or will be managing spatial data in their databases

Database Administrators, or Developers with that knowledge

This is not a beginning database administrator course

Target Audiences

DBAs who are currently or will be managing spatial data in their databases

Database Administrators, or Developers with that knowledge

This is not a beginning database administrator course

Managing a spatial database, or as some vendors call it, a geodatabase, requires some insight into spatial data, the collection of the data, different datatypes used to store the data, and the ultimate display of the data. This course is meant to give you more common ground with the GIS Professional, to do the best job of managing spatial data as a DBA, and see some differences in how spatial data is managed. The philosophy that is presented is that if you know something about the data, you will do a much better job of managing it as a DBA. So, in the introduction, a few examples are given about how spatial data is created.

The DBA will have a better understanding why they should have some knowledge of coordinate systems. Some questions are provided to help you pick a coordinate system type to use, or understand why a certain coordinate system is currently being used. Some examples are provided for what different types of coordinate systems are used for in the real world.

Participants are provided enough information to understand the basics of different types of geometries and datatypes that are used to store the spatial data. An introduction is given into the strategy of spatial data sharing in organizations.

A section on operational considerations provides several overview lectures of subjects to think about.

First, a lecture provides insight into how spatial data might be managed by one or all of three scenarios that have been experienced. A high level view of versioned spatial data and editing is then provided to show how ArcSDE operates. Since this class is an overview, only one editing Vendor situation is presented at a high level. The participant is provided some performance considerations that need to be thought about for spatial data operations. Each Vendor’s scenarios might be somewhat different, but these are ones that the instructor has experienced.

The participant is given a few high level examples of integrated GIS systems, to broaden the thinking of where GIS might fit into your overall operation.

A lecture was designed to give participants an introduction into adding spatial capability to their database. Several questions are provided to help the DBA hone in on the requirements for the spatial data operations. Each database Vendor has their own specifics for spatial data, but this specific lecture will give the general path to making this happen.

Participants learn the steps to create a spatially enabled table with a geometry column.

Picking the coordinate system

Defining the spatial metadata

Inserting the metadata

Creating the spatial index

Inserting the data including the spatial data

Running the stats

Course Curriculum

Chapter 1: Overview Questions

Lecture 1: Intro to spatial data and GIS for the DBA

Chapter 2: Coordinate Systems

Lecture 1: Why know about coordinate systems

Lecture 2: Projected vs: Geographic Coordinates

Lecture 3: Open Geospatial Consortium

Chapter 3: Geometry Types, Datatypes

Lecture 1: Geometry Types

Lecture 2: Spatial Datatypes

Chapter 4: Operational Considerations

Lecture 1: Three Scenarios to Consider

Lecture 2: Editing / Versioning of Spatial Data, Types of Editing

Lecture 3: Performance Considerations

Lecture 4: Integrated GIS Systems, Connectivity

Lecture 5: Adding Spatial Data Capability to Your Current Database

Instructors

Gil Scholl
Sr Database Administrator, Tyler Technologies, Inc.

Rating Distribution

1 stars: 2 votes

2 stars: 5 votes

3 stars: 5 votes

4 stars: 6 votes

5 stars: 6 votes

Frequently Asked Questions

How long do I have access to the course materials?

You can view and review the lecture materials indefinitely, like an on-demand channel.

Can I take my courses with me wherever I go?

Definitely! If you have an internet connection, courses on Udemy are available on any device at any time. If you don’t have an internet connection, some instructors also let their students download course lectures. That’s up to the instructor though, so make sure you get on their good side!