SQL for Crime Analysis


$10/non members, FREE for VCAN Members

Not a member? Join VCAN Today

SQL for Crime Analysis

Presenter: Matthew Harris (Crime Analyst, Sonoma County Sheriff's Office)

Presentation Abstract: This webinar will overview the basic principles of connecting to law enforcement database systems and the use of Structured Query Language (SQL) to answer your analytical questions. We will start by discussing the process of connecting to database systems and the possible roadblocks you might face. Then we will cover the process of exploring your data structure to learn and understand how your data is formatted and where it is stored. Next, we will transition into the basic elements of a SQL statement and how you can use them to decide which data to display and how to manipulate it. Lastly, we will cover some sample queries for administrative, strategic, and tactical Crime Analysis. If time remains at the end we can have interactive questions and answers to cover attendee questions.

This presentation will be recorded.

Event is from 1pm - 3pm Eastern Daylight Time. Registration closes at COB on Tuesday, July 12, 2022. Login details will be sent by COB on Wednesday, July 13, 2022.

RSVP to this Webinar:

    I understand that the deadline for cancellations is Wednesday, July 13th, 2022. If I fail to email the VCAN board directly at [email protected] with my cancellation after this time, or fail to attend without notice, I will be responsible for a $10 cancellation fee. I understand that I will not be permitted to register for additional VCAN-sponsored training until this cancellation fee is paid.

    I understand that if I violate the policy on 2 occasions during the same calendar year. I will not be permitted to register for additional VCAN-sponsored training during the same calendar year.

    There are NO EXCEPTIONS to this policy. INITIAL BELOW.

    Payment Details


    $10.00 USD