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.
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.