040 - SQL for the Absolute Beginner and Introduction to R

Structured query language (SQL) is the language used to extract data from databases in most health information systems today, including electronic health record systems. Part 1 of this workshop is intended for the person with no experience with databases or SQL. Learn 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; and lastly, use JOIN to combine data from two tables. R is a free software environment for statistical computing and graphics. It compiles and runs on a wide variety of UNIX platforms, Windows, and MacOS. Part 2 of this workshop is intended for the person with no experience with R or its graphical user interface R studio. Learn how to install R and R studio and different R packages; create a data matrix in R; load a dataset into R; explore a dataset in R; create new calculated variables and recode data; generate a frequency; conduct simple statistical tests; and utilize the R package “ggplot” to generate visualizations.

Continuing Education Instructions and Disclosure Information:

Contact hours available until 4/29/2024.

Requirements for Successful Completion:
Complete the learning activity in its entirety and complete the online nursing continuing professional development (NCPD) evaluation. You will be able to print your NCPD certificate at any time after you complete the evaluation.

Disclosure of relevant financial relationships with ineligible companies (planners, faculty/speakers, reviewers):

Planning Committee and Abstract Reviewer Disclosures:
There are no Planning Committee and Abstract Reviewer disclosures to declare.

Speaker Disclosures:
There are no speaker disclosures to declare.

Commercial Support:
No commercial support declared.

Accreditation Statement:
This educational activity is jointly provided by Anthony J. Jannetti, Inc. (AJJ) and the American Nursing Informatics Association (ANIA).

Anthony J. Jannetti, Inc. is accredited as a provider of nursing continuing professional development by the American Nurses Credentialing Center’s Commission on Accreditation.

Anthony J. Jannetti, Inc. is a provider approved by the California Board of Registered Nursing, provider number CEP 5387.

Learning Outcome:
After completing this learning activity, the participant will be able to demonstrate basic SQL functions and use of R to enhance practice.