4.50(2)

Hydro.Data Management (SQLite and Python)

  • Duration 15h
  • Total Enrolled 11
  • Last Update June 28, 2023

Description

Hydrological data management involves collecting, storing, analysing, and visualizing data related to water resources. SQLite is a lightweight, serverless, and self-contained database system that can be used to store hydrological data in a structured manner. Python, on the other hand, is a powerful and popular programming language with many libraries, packages, and tools for data manipulation, analysis, and visualization. Together, SQLite and Python can be used to build an efficient and effective hydrological data management system that can handle large volumes of hydrological data, automate routine tasks, and generate insights for better decision-making.

What Will I Learn?

  • DB Browser for SQLite
  • Python programming
  • Hydrological Data Retrieval using Python
  • Data Management

Topics for this course

10 Lessons15h

Day 1: Introduction?

Introduction to Hydrological Data Management, Need of course.

Day 2: Introduction to SQLite?

Why SQLite? Installation of DB Browser for SQLite, Basic Syntaxes in SQL

Day 3: Working on SQLite?

Writing queries in SQL for data slicing, dicing

Day 4: Introduction to Python?

Python in Water Resource, PyCharm as IDE, Basic Python syntaxes

Day 5: Coding in Python?

Pandas Data Frame, Working on Pandas

Day 6: Retrieving Hydrological Data available in Excel?

How to get hydrological data in Pandas Data Frame?

Day 7: USGS Data Retrieval?

USGS Stations, Retrieving data from USGS NWIS, A comparison with DHM Nepal.

Day 8: Integrating Python and SQLite?

Read and write SQLite database using Python

Day 9: Integrating Python and SQLite and conclusion?

A complete project example

Course materials link

About the instructors

4.77 (35 ratings)

14 Courses

293 students

4.50 (2 ratings)

1 Courses

0 students

Student Feedback

4.5

Total 2 Ratings

5
1 rating
4
1 rating
3
0 rating
2
0 rating
1
0 rating

overall good

It was very wonderful to attend all those training sessions. After completing the training, I have developed high confidence to deal with bulky hydrological data.

2,000

Material Includes

  • Data for learning
  • Software are open source

Enrolment validity: Lifetime

Requirements

  • Individual Laptop
  • Basic coding skills
  • Desire in data science

Target Audience

  • Graduate Engineers interested in Water Resource Engineering

Want to receive push notifications for all major on-site activities?

✕

Price Based Country test mode enabled for testing Nepal. You should do tests on private browsing mode. Browse in private with Firefox, Chrome and Safari