Database Management System and Spatial Analysis
Learn how you can store data, how to retrieve data, and the different types of databases in this free online course.
Take this certificate on your own.
Start now and learn at your own pace.
CertificationView course modules
This course will begin by introducing you to the meaning of a database and database management system. You will learn how you can store data, how to retrieve data, and most importantly, the different ways of storing data in the various databases that are available. You will also learn about the languages that are being used in order to manage this database or query data from the database.
Next, you will be familiar with the different types of keys; including technical key, parent key, child key, and composite key. This will lead you to normalization in database management systems, data integrity constraints, and the reasons for normalization. You will further be introduced to the different models of the database management system, where you will be brought up to speed with the different aspects of how the database management system is handled. You will also learn about the types of databases, the pros, and cons of each database type.
Lastly, you will further your knowledge on how to create, maintain, and edit a database. You will assimilate the different types of databases, how the querying can be done, and how to address certain issues when creating a database. This will then enable you to grasp structured query language, spatial analysis, and basic editing in geographic information system. You will then gain an understanding of the procedures involved in integrated data analysis, and how to maintain logical consistency in creating a vector database.Start Course Now
Introduction to Database and Database Management System
Introduction to Database and Database Management System - Learning Outcomes
Introduction to Database
Components of a Database Management System
Database Keys and Normalization
Introduction to Database and Database Management System- Lesson Summary
Database Query and Spatial Analysis
Database Query and Spatial Analysis - Learning Outcomes
Creating and Maintaining a database
Spatial Query using SQL - Introduction
Database Design and Spatial Analysis
Basic Editing of Data
Database Query and Spatial Analysis- Lesson Summary
By the end of this course, you should be able to:
- Explain the concept of data and information in a geographic information system
- Describe the major database features available
- Explain in details the GIS database system
- List the benefits of a database system in relation to GIS
- Describe the components of a database management system
- Explain entity relations and database management system architecture
- Discuss how Microsoft Access is used in relational database management
- Describe how to plan and design a database
- Explain the operations required in maintaining a database which includes: compacting, repairing, encrypting, and securing
- Describe the concept of the structured query language (SQL)
- Describe positioning, indexing, and hashing in the spatial query using SQL
- Explain the concept of database design and spatial analysis
All Alison courses are free to enrol, study and complete. To successfully complete this Certificate course and become an Alison Graduate, you need to achieve 80% or higher in each course assessment. Once you have completed this Certificate course, you have the option to acquire an official Certificate, which is a great way to share your achievement with the world. Your Alison Certificate is:
Ideal for sharing with potential employers - include it in your CV, professional social media profiles and job applications
An indication of your commitment to continuously learn, upskill and achieve high results
An incentive for you to continue empowering yourself through lifelong learning
Alison offers 3 types of Certificates for completed Certificate courses:
Digital Certificate - a downloadable Certificate in PDF format, immediately available to you when you complete your purchase
Certificate - a physical version of your officially branded and security-marked Certificate, posted to you with FREE shipping
Framed Certificate - a physical version of your officially branded and security-marked Certificate in a stylish frame, posted to you with FREE shipping
All Certificates are available to purchase through the Alison Shop. For more information on purchasing Alison Certificates, please visit our FAQs. If you decide not to purchase your Alison Certificate, you can still demonstrate your achievement by sharing your Learner Record or Learner Achievement Verification, both of which are accessible from your Dashboard. For more details on our Certificate pricing, please visit our Pricing Page.