Basic SQL

Scheduled Dates

This course is currently not scheduled.

Also available on request

Course Details
Course Type: 
Live-Online
Topic Area: 
Cataloging
Metadata
Technology
Course Description

Structured Query Language, or SQL, queries and manipulates data held in relational databases. Many librarians go through mediated queries to find needed information, for example searching via a library catalog. With SQL, directly construct database queries without a mediated search interface’s constraint, such as field name or search limitations. Gain 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 MySQL
Session Information
Session Duration: 
This course consists of three 2-hour sessions.
Contact Hours: 
6
Questions
Contact: 

learning@amigos.org