Course Goal: To equip oceanography students with a robust and practical command of SQL for structuring, querying, and managing scientific data. Using the universal database tool DBeaver, the course will focus on the principles of relational databases, with PostgreSQL as the primary example, to build skills applicable throughout their scientific careers.
Course Instructor: Dr. GAH-MUTI Salvanus YEVALLA
Course Outline:
PART I: DATABASE FUNDAMENTS & THE DBMS LANDSCAPE (Weeks 1-4)
Week 1: From Data Chaos to Structured Data
Week 2: A Tour of the Database World
Week 3: The Building Blocks: Tables, Keys, and Relationships
Week 4: Blueprint for Your Data: Visual Database Design
PART II: THE SQL BOOTCAMP (Weeks 5-8)
Week 5: SQL Foundations: Retrieving Data
Week 6: SQL Filtering: Mastering the WHERE Clause
Week 7: SQL Summaries: Aggregation and Grouping
Week 8: SQL Power Move: Connecting Tables with JOIN
PART III: DATA MANAGEMENT & REVIEW (Weeks 9-10)
Week 9: Managing Your Data
Week 10: Course Review and Capstone Challenge
- Teacher: System Administrator