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.
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.
A typical course covers the following:
- Introduction to Python – variables, loops, methods
- File I/O, libraries, connecting Python to MySQL
- Intro to HTML, CSS, and GET/POST methods
- Connecting the front end website to the backend database, SQL Injection
- Advanced SQL topics – Views, Triggers, Functions
- 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.
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
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.
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.
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.