2       0

ANIA 2019 Annual Conference


020 - SQL for the Absolute Beginner


Apr 11, 2019 8:00am ‐ Apr 11, 2019 5:00pm


Credits: None available.

Members: $49.00
Standard: $69.00

Description

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.

Speaker(s):

Credits Available


SQL for the Absolute Beginner

You must be logged in and own this session in order to post comments.

Print Certificate
Review Answers
Print Transcript
Completed on: token-completed_on
Review Answers
Please select the appropriate credit type:
/
test_id: 
credits: 
completed on: 
rendered in: 
* - Indicates answer is required.
token-content
token-speaker-name image
token-speaker-name
token-index
token-content
token-index
token-content
token-index
token-content
token-index
token-content
token-index
token-content
token-index
token-content
/
/
token-index
token-content