01cWhy

Database Management

Mick McQuaid

University of Texas at Austin

28 Apr 2026

Why do you need to learn about databases?

most organizations store data in databases

  • Since the 1970s, governments and businesses have realized that there are naturally inconsistencies in the way they store data
  • They’ve chosen enterprise-wide database management systems to solve this problem
  • Most of these enterprise-wide systems are based on SQL (Structured Query Language) and relational databases
  • They are mostly client-server systems so that many people can access the same database at the same time

you will need data that is already in databases in the workplace

  • Most of the data about customers, employees, products, and sales that organizations collect is stored in databases
  • Even if you work in a non-profit organization, they will have information about services in databases
  • The most common way to get data from a database is to write SQL queries
  • It used to be the province of specialists
  • Now, with LLMs (large language models), it is becoming more accessible to everyone

you may need to create databases in the workplace

  • Your activities are very likely to generate data that you will want to store in databases
  • You may need to create databases for projects or to support applications
  • You may need to create databases for data analysis or reporting
  • You may need to create databases to support web applications or mobile applications
  • You may need to create databases to support data science projects or machine learning projects or data warehousing projects or data integration projects or data migration projects

END

Colophon

This slideshow was produced using quarto

Fonts are Roboto, Roboto Light, and Victor Mono Nerd Font