Webinar 2018 Introduction to MySQL on Graham

From SHARCNETHelp
Jump to navigationJump to search

Structured Query Language (SQL) is a popular standard for performing operations on relational databases such as: MariaDB/MySQL, SQL Server, MS Access, Postgres, and many others. It is long lived standard that sees use in a wide range of applications from web app development to bioinformatics.

The Graham and Cedar clusters now have their own MySQL and Postgres servers. This webinar will show you how to connect to these servers, as well as introducing SQL programming. We will be using the open source MariaDB (MySQL) database management system (DBMS) to cover basic table creation, data manipulation, and data retrieval. This is an introductory level webinar and assumes that the viewer has no previous knowledge of MySQL. The webinar will only cover command line manipulation of the database requiring basic Linux command line knowledge.