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:
- PuTTY (or another SSH client) installed - https://www.putty.org/
- Visit BigBlueButton's detailed minimum requirements page
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
United States
| Amigos Member Fee | $270.00 |
| Non-member Fee | $540.00 |