For internal use only. Do not redistribute.
This lecture serves as an introduction to databases and SQL, outlining the fundamental concepts necessary for understanding how databases store, organize, and retrieve data. Participants will learn about different types of databases, with a focus on relational databases and their management through SQL. We will code basic SQL commands for demostration purposes. By the end of this lecture, participants will possess a clear understanding of database systems and be equipped to begin using learning SQL .
Slides Video DataThis lecture introduces the essentials of accessing and retrieving data using SQL queries. Participants will learn how to construct SELECT statements, use WHERE clauses to filter data, and employ various operators to refine their search criteria. Through practical examples, participants will gain the skills needed to efficiently query databases and extract valuable information. In addition, we will cover the some of the best practices for writing SQL code; such as, commenting code for documentation, clarity, and communication.
Slides Video DataThis lecture covers SQL capabilities for aggregating and grouping data to extract insights and generate reports. Participants will learn how to use aggregation functions to perform calculations on dataset subsets. We will cover the GROUP BY clause to segment data into groups and apply aggregate functions to each group, along with the HAVING clause for filtering groups based on specific conditions. By the end of the lecture, participants will be equipped with the skills needed to perform complex data aggregation.
Slides Video DataThis lecture will explore the fundamental SQL concepts and techniques for combining data from multiple tables using joins. Through practical hands-on examples, participants will learn how to use different types of joins including inner joins, left joins, right joins, and full outer joins, and when to use each to achieve the desired data set. By the end of this lecture, participants will have a solid understanding of how and when to utilize SQL joins to manipulate and extract meaningful information from their relational databases.
Slides Video DataThis brief course was developed by CSG Justice Center to train staff members internally. Namely, the analysts in the Research Division working with correctional agencies to help them build up their data analysis capabilities.
Please note that this course and all materials presented are not meant, not designed, for external use. As such, we ask that you do not redistribute without asking. To do so, please send an email request to Christopher Callaghan (ccallaghan@csg.org) who maintains these materials.