eGeoDB - Program - eGEOCampus - The first Earth Science eLearning platform in Spanish lenguage

No registrado

UNIVERSITIES PROJECTS EMPLOYMENT OPPORTUNITIES FEATURES REPOSITORY COLABORATORS MAPPINGINTERACTIVO

What is eGeoDB?
Technical Staff
Course Entry
How to Register
Contact Us
Program
Demonstration
Prices
Sponsorship
eGEOCampus

COURSES

eMasterGIS eGeoDB eGeoGA eGeo.NET eGeoIDE eGeoPhotogram eGeoTLDETEC

Database Techniques for the Geospatial Information Management

	eGeoDB Topic 1 - CONVERTING DATA INTO INFORMATION
		Data and Information. Brief History of data processing. Basic concepts of the Database Related Model.

eGeoDB Topic 2 - INTRODUCTION TO RELATIONAL DESIGN

Designing a SQL Database Server.
Basic elements of related design.
Use of the SQL Server Diagrams.
Practical activity: Design of the mini cadastre CatastroX.

eGeoDB Topic 3 - INTRODUCTION TO MS SQL SERVER

Predominant Characteristics and Architecture of MS SQL Server.
Components of MS SQL Server.
Structure of a BD in SQL Server.
Definition of the scheme of a table, types of data, other properties.
Data integrity.
Security and Control of Access to the data in the SQL Server.
Practical: Representation of the CatastroX designed model in the SQl Server.

eGeoDB Topic 4 - ALPHANUMERIC DATA PROCESSING AND CONSULTATION

SQL language.. Basic operations:
	Consult Add Modify Eliminate
The TRANSACT-SQL dialect of the SQL Server. Access permits. Implementing its business logic: Stored Procedures. Advanced enquiries. Practical: some rules of business Programming for Cadastres.

eGeoDB Topic 5 - PROCESSING FROM A CLIENT. NET

Data Access from a Client on .NET Microsoft technology.
Basic elements of ADO.NET.
SQLClient Supplier.
Consulting and updating of Data.
Practical: Design and implementation of a simple interface for CatastroX: The Alphanumerical Viewfinder.

eGeoDB Topic 6 - GEOSPATIAL DATA AND SQL SERVER

Spatial Data Representation about the types of SQL Server.
Vector Data: Implementation of a simple spaghetti model.
Data Raster: The type of Image and its processing.
Practical: Development of SQLGeoProvider (Supplier of Geospatial Data) and of the Geospatial Viewfinder.

eGeoDB Topic 7 - ADVANCED GEOSPATIAL CONSULTING

Access of Geospatial data using the Internet.
Basic elements of ASP.NET.
Predominant characteristics of a WebService.
Practical: Development of SQLGeoServer, mini spatial data server.

eGeoDB Topic 8 - CONCLUSION

Integration of the developed tools: BD CatastroX, Viewfinder, Alphanumerical, SQLGeoProvider, Geospatial Viewfinder and SQLGeoServer in a minimum prototype of cadastral application.