Intro to Databases

Come to this course to learn about databases and their importance across a multitude of fields. This class will provide students with a basic introduction to what databases are and how to interact with them.

Instructor
Mary Clair Thompson | Office of Information Technology
I am a Data Engineer and Data Scientist on OIT’s Data Analytics team, with previous industry experience working with big data in the cloud.

This class will be hosted via Zoom. You will receive an email with the Zoom link a day before the class. Attendance will be taken and the session will be recorded.

This class will be hosted via Zoom. You will receive an email with the Zoom link a day before the class. Attendance will be taken and the session will be recorded.

  • Databases

About Course

Outline

  • What are data? What is a “database”?
  • Why do we need databases?
  • What are the various “kinds” of databases?
  • Schema (primary keys, indices, etc), data dictionary, SQL (as a generic notion)
  • Architectures (e.g., “NoSQL”), suitability, scalability, ODBC, middleware
  • Data integrity, security, privacy
  • Introduce advanced topics (time permitting)

Objectives

  • Upon completion, participants should be able to identify when a database would be useful, analyze the pros and cons of various platform and configuration options, and feel empowered to begin deploying a database instance for themselves or their workgroup.

This class is part of our Databases Track

See the whole track

This class is part of our Research Computing Track

See the whole track

Suggested Courses

Course Graphic

Intro to mySQL

Take this class to learn more about databases. This course will provide students with a basic introduction to the popular open source Database Management System (DBMS) named “MySQL”.

Learn More