Name
040: SQL for the Absolute Beginner (Limited to 20 Participants)
Date & Time
Thursday, May 9, 2024, 1:00 PM - 5:00 PM
Description

Have you wanted to get started in data analytics, but don’t know where to begin? Is the statement SELECT * FROM Patients; unfamiliar? If you answered “yes” to these questions, then this workshop is for you! Structured query language (SQL) is the language people use to extract data from the databases used in most health information systems today, including electronic health record systems. This hands-on workshop is intended for the person who has no experience with databases or SQL. By the end of the workshop, you will know how to: use DESCRIBE, SELECT, and WHERE to perform simple queries; describe the difference between * and wildcard characters and correctly use them; use pattern matching with LIKE, NOT LIKE, and =; use Boolean operators AND, OR, and NOT; perform basic mathematical functions with SQL, such as averages and counts; and use JOIN to combine data from two tables. Requirements for attendees: You will be requested to install DB Browser for SQLite and will be provided with a simple database with synthetic records. Concepts using didactic lectures will be explained, and those concepts will be reinforced with hands-on activities. You must bring a Windows or Mac laptop. The software will not run on an iPad or Chromebook. You must be able to install software on your laptop from an internet site. If you are using a work-issued laptop, you must confirm with your IT department that you have permission to install DB Browser for SQLite and are able to copy a provided spreadsheet to your computer via download.

Session Type
Preconference
Contact Hours
3.75