Basic SQL

Scheduled Dates

July 25, 27 & 29, 2022 10 am - 12 pm CDT (Register Now)

Course Details
Course Type: 
Topic Area: 
Course Description

Structured Query Language, or SQL (sometimes pronounced “sequel”), is a powerful language used to query and manipulate data held in relational databases. Many librarians go through mediated queries to find needed information e.g. conducting a search via a library catalogue. With SQL, you can directly construct your database queries without the constraints (e.g. field name or search limitations) imposed by a mediated search interface. This course is an introduction to the basics of SQL including terminology, design, working with databases, and working with the PHP scripting language.

Learning objectives for this session include
  • Understanding the terminology and relational (linked) databases (tables)
  • Designing a small database and writing SQL statements
  • Demonstrating the ability to add/delete data from the database
  • Understanding how PHP works with MySQ
Session Information
Session Duration: 
This course consists of three 2-hour sessions.
Contact Hours: