Updating search results...

Search Resources

2 Results

View
Selected filters:
  • sql-server
Business Intelligence Integration Services Project: Creation and Deployment
Conditional Remix & Share Permitted
CC BY-NC-SA
Rating
0.0 stars

This module covers the creation, execution and deployment of an ETL project using the SQL Server Integration Services (SSIS). Several examples were provided to show how data from different sources can be Extracted from the source, Transformed into meaningful forms and Loaded to the data warehouse.

Subject:
Applied Science
Education
Higher Education
Information Science
Material Type:
Activity/Lab
Module
Unit of Study
Date Added:
09/12/2018
Spatial Database Management
Conditional Remix & Share Permitted
CC BY-NC-SA
Rating
0.0 stars

A spatial database is the backbone of a successful organization or website that depends upon maintaining and using data pertinent to locations on Earth. In GEOG 868, Spatial Database Management, capabilities specific to Relational Database Management Systems (RDBMS) and Geographic Information Systems (GIS) are combined to teach students to create, maintain, and query spatial databases in both desktop and enterprise environments. Learn the basics of Standard Query Language (SQL) and database design/normalization, the specifics of managing spatial data in an open-source technologies context (Postgres/PostGIS) and in the context of the Esri geodatabase. Along the way, you will become familiar with spatial functions and versioning, the latter in a server environment hosted by Amazon Web Services.

Subject:
Applied Science
Atmospheric Science
Business and Communication
Career and Technical Education
Engineering
Environmental Science
Environmental Studies
Finance
Physical Science
Material Type:
Full Course
Provider:
Penn State College of Earth and Mineral Sciences
Author:
Jim Detwiler
Jim Sloan
Date Added:
10/07/2019