This course introduces the design, development, and management of geospatial databases, including multi-user enterprise geodatabases. In addition to learning about relational database design, students will construct and maintain spatial databases.
Fundamental concepts and management of geospatial databases
Construct and maintain spatially enabled relational databases
Enterprise database systems that support large datasets
Learn free and open source PostgreSQL/PostGIS database management system
About this course:
This course introduces concepts and techniques associated with the design, development, and management of geospatial databases, including databases used in shared and scalable enterprise GIS platforms. In addition to learning about relational database theory and design, students construct and maintain spatially enabled relational databases using the free and open source PostgreSQL/PostGIS database management system. Database performance and user access considerations are introduced, and students learn to develop and work with enterprise database systems that support large datasets and simultaneous access by many users. Enterprise GIS systems and techniques facilitating concurrent editing of shared spatial databases are introduced. The courses practical assignments involving enterprise databases are contextualized with a focus upon GIS project management best practices.
Students will be earning transferable UCLA course credit for all courses in the certificate program. This course is accredited and approved by the UCLA Academic Senate as a credit-bearing course. It carries upper-division undergraduate credit. Weekly activities include reviewing video lectures, technical screencasts, and readings. Completing practical assignments involve the use of GIS methods to address real-world scenarios; Self-assessment using automated non-graded quizzes; and more.
Required course in the GIS & Geospatial Technology Certificate program.
This is an online course, wherein all course content is delivered online and all interaction among the instructor and the participants will take place online; additional requirements include microphone, headphones/speakers, and webcam.
Technical requirements: Students are responsible for providing a personal computer with a minimum of 4GB of RAM that is capable of running Windows 10. Apple hardware running macOS can be used provided that Windows 10 is installed either using Boot Camp or virtualization (VirtualBox, Parallels, etc.) with at least 4GB of RAM allocated to Windows. Hardware specifications in excess of these minimum requirements will offer better performance and a better student experience. Students will be provided with a student license for ArcGIS as long as they are enrolled in program courses for which ArcGIS is required.
Enrollment limited to 50 students; early enrollment advised. Visitors not permitted. Internet access required. Materials required.
No refunds after July 10, 2023
Our team members are here to help. Hours: Mon-Fri, 8am-5pm.