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”.

 

 

 

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.

 

  • MySQL
  • Databases

About Course

Outline

  • Creating a Personal Linux VM
  • Access control / User management
  • Adding/modifying tables and indexes
  • Populating database with data
  • Writing queries to retrieve data
  • Useful ancillary information

Objectives

  • The class will cover a variety of tasks (specific to MySQL) including setting up users, creating databases, developing schema, adding/altering tables, writing queries, and evaluating basic security and performance.

Tools

  • Students may get more out of the course by bringing their own laptop, although this is not required. Attendees will have access to their own personal Linux computational server VM (that will persist after leaving the class). Participants using Windows laptops will need to install an SSH client (if they haven’t before); a free one can be downloaded and installed from: https://www.chiark.greenend.org.uk/~sgtatham/putty/latest.html . (Mac users can simply use the Terminal application that comes with MacOS.) Also keep in mind that, in order to access a vm (part of the labs), users who are not on campus will need to be on the Duke campus vpn. They should take care of this ahead of time by contacting the OIT helpdesk.
  • two monitors set up if possible

--

The instructor also recommends running through Lab 0 at https://github.com/LinuxAtDuke/Intro-to-MySQL, if you are interested in doing the units/labs of the class "along" with him during the class session itself.

Files

Prerequisites

Students with a basic understanding of databases and a working knowledge of Linux will get the most out of the class. Suggested prerequisites, given this, are: Introduction to databases, and Linux and the Bash Shell.

--

The instructor also recommends running through Lab 0 at https://github.com/LinuxAtDuke/Intro-to-MySQL, if you are interested in doing the units/labs of the class "along" with him during the class session itself.

This class is part of our Databases Track

See the whole track

This class is part of our Software Development Track

See the whole track

This class is part of our Research Computing Track

See the whole track

Suggested Courses

Course Graphic

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.

Learn More