Search Results (2)

View
Selected filters:
  • Sql Server
Business Intelligence Integration Services Project: Creation and Deployment
Conditions of Use:
Remix and Share
Rating

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:
Information Science
Higher Education
Material Type:
Activity/Lab
Module
Unit of Study
Provider:
Higher College of Technology, Muscat, Oman
Author:
Gregorio dela Cruz, Jr.
HCT IT-Database
Date Added:
09/25/2018
Spatial Database Management
Conditions of Use:
Remix and Share
Rating

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:
Engineering
Environmental Science
Finance
Environmental Studies
Atmospheric Science
Material Type:
Full Course
Provider:
Penn State University
Provider Set:
Penn State's College of Earth and Mineral Sciences (http:// e-education.psu.edu/oer/)
Author:
Jim Detwiler
Jim Sloan
Date Added:
09/18/2018