Basic SQL

Scheduled Dates

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

Course Details
Course Type: 
Target Audience: 
Everyone
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
Prerequisites

None

Homework Expectations
  • In-class exercises will be provided in each class, to be completed before the next meeting. Assignments build on previous assignments, so each one must be completed. In addition, a final assignment must be completed.
  • It is designed for individual participation; each individual must register.
Session Information
Session Duration: 
This course consists of three 2-hour sessions.
Contact Hours: 
6
Instructor