SQL for the Absolute Beginner

Note that handout provided does not include tutorial referenced by speaker.

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 in a SQL query; use pattern matching with LIKE, NOT LIKE, and =, 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.

Continuing Education Instructions and Disclosure Information

Contact hours available until 4/13/2021.

Requirements for Successful Completion:
Complete the learning activity in its entirety and complete the online CNE evaluation. You will be able to print your CNE certificate at any time after you complete the evaluation.

Faculty and Planners Conflict of Interest Disclosure:

Planning Committee: 
No planning committee declares any actual or potential conflict of interest.

Speakers: There are no conflicts to disclose.

Commercial Support and Sponsorship:
No commercial support or sponsorship declared.

Accreditation Statement:
This educational activity offering is jointly provided by Anthony J. Jannetti, Inc. (AJJ) and ANIA.

Anthony J. Jannetti, Inc. is accredited as a provider of continuing nursing education 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 CEP5387.

Learning Outcome:
After completing this learning activity, the participant will use DESCRIBE, SELECT, and WHERE to perform simple queries; describe the difference between * and wildcard characters and correctly use them in an SQL query; use pattern matching with LIKE, NOT LIKE, and = and use Boolean operators AND, OR, and NOT; perform basic mathematical functions with SQL, such as averages and counts; and JOIN to combine data from two tables.