Basic SQL

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:

  • 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

Target Audience:
Everyone

Prerequisites:
None

Homework Expectations and Completion Requirements:

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

Technical Requirements:

Session Duration:
This course consists of three 2-hour sessions.

Instructor:  Mike Pullin - learning@amigos.org

Continuing Education Credit:
Contact Hours: 6

July 25 - 29, 2022

10:00 am - 12:00 pm CDT

Online Classroom
United States

Phone: 800-843-8482
Email:

Amigos Member Fee $ 270.00
Non-member Fee $ 540.00