This is a free CCIAA training for members. You can register here.

This webinar will build on the query methods overviewed in the 2021 CCIAA SQL for Crime Analysis Class. We will overview the sample queries previously demonstrated for administrative, strategic, and tactical Crime Analysis. Then we will move into more advanced queries involving cross apply, outer apply and pivot functions. Finally we will move into stored procedures that can be used for data cleaning, and transfer between databases. If time remains at the end we can have interactive question and answers to cover attendee questions.