Interfacing with SQL

  • course details
  • Dates and time: 6 – 8:30 p.m. Mondays and Wednesdays, March 25 - April 10
  • Location: Online, instructor-led live sessions
  • Number of sessions: 6 sessions over 3 weeks
  • Instructional fee: $1,195, reduced fees available (see Cost section below for details)
  • Format: Zoom videoconference

Interested in writing programs to work with databases? Do you need to automatically extract information from files, such as CSV, and insert data into a MySQL database? How about using Python to manipulate data in a database and to create a front end to view the data in a browser? Then, this course is for you!

Along the way, you will also learn some more advanced SQL techniques such as Views, Triggers and Functions. You will add measures to the front end to prevent malicious SQL injection attacks. The course starts near the end of March.

This new course is part of a two-course series. If you don't have basic understanding of SQL, you should first take the Intro to SQL course. Then, take this course. You need to register for each SQL course separately.

Register now

What you will learn

  • Python and how to connect Python to a website and backend database
  • Intermediate SQL statements such Views, Triggers, and Functions
  • Basic HTML and Dynamic webpages

Who should attend

Working professionals, engineers, managers and those moving into a database role or whose role has expanded to include database technologies, including those who wish to utilize relational database technologies in their own area of work.

Course content

A typical course covers the following:

  1. Introduction to Python – variables, loops, methods
  2. File I/O, libraries, connecting Python to MySQL
  3. Intro to HTML, CSS, and GET/POST methods
  4. Connecting the front end website to the backend database, SQL Injection
  5. Advanced SQL topics – Views, Triggers, Functions
  6. Final Presentations

Capstone projects are chosen by you at the beginning of the program (in alignment with the needs of your employer). Combination of the in-class training and the application of course concepts synthesized with real-world capstone project applications will help accelerate and increase your knowledge depth. You will receive one-on-one reviews of your database project with the instructor.

Student materials

Course materials will be provided in PDF format. In addition, you will need:

  • Software available to download for free
    • MySQL Community Server
    • MySQL Workbench
    • Python 3.9 with associated libraries

Instructor

Ben McCamish received his Ph.D. from Oregon State University and is scholarly assistant professor at WSU Vancouver. His research areas include databases and information retrieval using game theory techniques to improve dynamic database effectiveness. Some of the related courses he teaches include Introduction to Databases and Information Retrieval. He also serves on the WSU Data Analytics Curriculum Committee.

Cost

The instructional fee is $1,195. There are limited number of seats available for employees of small businesses with fewer than 150 employees ($598), non-profits and educational institutions ($299), and for current WSU students ($120) and employees ($299). All instructional fees are per person and include a nonrefundable administrative fee of $75. See registration for details.

The registration fee is the same regardless of residence.


Meetings and format

The course is delivered via Zoom videoconference with live instruction. To attend, you need a computer with webcam, microphone and high-speed internet.

Each Zoom session allows for live interactions with the instructor and other students via chat, web conferencing or phone, all in real time. Assignments and other materials will be available online through a web-based learning management system.

Certificate completion

Earning the certificate requires the following:

  • Attending at least six of eight sessions
  • Completion and presentation of capstone project
  • A score of at least 80% on a multiple-choice test (open book and offline). The test will be available at the end of the fifth session.