Computers route traffic using IP addresses, but people remember names. DNS bridges that gap. When you type github.com, something has to turn that name into an address like 140.82.121.4 before any packet can be sent. DNS is the system that does the lookup, and it runs every time you open a page, send mail, or load an app.
DNS is not one giant table. It is a distributed database split into a tree of zones, where each part of the internet runs the servers responsible for its own names. Google runs the authoritative servers for google.com, your registrar or DNS provider runs yours, and a small set of root and top-level-domain servers tie the whole tree together.
DNS also stores more than addresses. A records hold IPv4 addresses, AAAA records hold IPv6 addresses, CNAME records point one name at another, MX records say which servers receive a domain's email, TXT records hold verification and SPF strings, and NS records say which name servers are authoritative for a zone. One domain often has dozens of records of different types.