ATLE PLN Scheduling SQL Intermediate Course

Select the Use button to add a tag to the body of your email. You may also use tags in the subject of your email by copying and pasting them directly in.

{FIRST_NAME}	Adds the recipients First Name.	Use
{LAST_NAME}	Adds the recipients Last Name.	Use
{COMPANY_NAME}	Adds the Company Name.	Use
{PORTAL_NAME}	Adds the application portals name.	Use
{MEMBER_NAME}	Adds the Recipients Membership name.	Use
{SIGNATURE_OPT_IN}	Adds the Opt-in link.	Use
{SIGNATURE_OPT_OUT}	Add the opt-out link.	Use
%signature%	Adds your preferred signature block.	Use
{Event_Start_Date}	Adds the Event's Start Date.(Events Only)	Use
{Event_End_Date}	Adds the Event's End Date.(Events Only)	Use
{Event_Name}	Adds the Event's Name.(Events Only)	Use
{Event_Description}	Adds the Event's Description.(Events Only)	Use
{Online_Training_Description}	Adds the Online Training Description.(Online Training Only)	Use
{Event_Specific_Dates}	Adds the Event's specific dates.(Events Only)	Use
{member_number}	Adds the Membership Number.	Use
{MemberSince}	Adds the Member Since Date.	Use
{CONTACTEMAIL}	Adds the Contact's Email Address.	Use
{CERTIFICATE_NUMBER}	Adds the Contact's Certificate Number	Use
{EVENTLOCATION}	Adds the Event's Location.	Use
{TOTALEVENTCREDITS}	The total number of credits that the contact has earned through the event tickets and workshops.	Use
{ASAPPEARSONBADGE}	Display the text of as appears field in the event setup.	Use
{contact_organization}	Displays the organization name of the contact.	Use
{RENEWALDATE}	Adds the Member Renewal Date in (yyyy-mm-dd).	Use
{MEMBERSHIP_YEAR}	Adds the Member's Membership Year	Use
{RENEWALDATE_MM-DD-YYYY}	Adds the Member Renewal Date in (mm-dd-yyyy).	Use
{LMS_CREDIT}	The number of credits the LMS course is worth for Continuing Education	Use
{COLLECTION_PERIOD_END-DATE_YYYY_MM_DD}	The end date of the CE collection period end date	Use
{LMS_COURSE_COMPLETION_DATE}	The completion date of the LMS course	Use
{INCEPTION_DATE}	Adds the Member Inception Date in (yyyy-mm-dd).	Use
{EVENT_END-DATE_MONTH_YYYY}	Adds Event End Date in Full Month Name and Year Format.(Events Only)	Use
{EVENT_END-DATE_MONTH_YYYY_ADD3}	Adds Event End Date in Full Month Name and Year Format Plus 3 Years.(Events Only)	Use
{WORKSHOP_NAME}	Adds the workshop name (if applicable)	Use
{WORKSHOP_DESCRIPTION}	Adds the workshop description (if applicable)	Use

In this course session, we will build upon concepts introduced in the foundational session by doing the following:

1) Continue adding power to our basic table queries with advanced sorting, distinct row returns and table unions

2) Exploring additional aggregate functions, such as listagg

3) Exploring more complicated table joins using keywords such as having, exists, etc.

Please join us for this 2 hour session on March 13th at 1:30pm.

Free for ATLE members; $25 per meetup for non-ATLE members.

[When you click the green "Register Now" button and enter your email address, the price associated with your current member status will automatically appear. Questions? Contact us.]

Thank you for taking part in ATLE ProLearn PLN events. We are happy to have you participate.

If you are enjoying being a part of individual sessions you may find it valuable to become a member of ATLE to participate in all of these events for free!

Please note that ATLE ProLearn PLN events are designed for ATLE members and non-member educational authority staff only. Vendors may attend ProLearn PLN events only under specially arranged sponsorship scenarios, negotiated in advance with ATLE. For more information, please contact ProLearn@atle.ca.

ATLE PLN Scheduling SQL Intermediate Course

Thursday Mar 13 2025, 1:30 PM - 3:30 PM
ONLINE - Watch your email for the link!

Upcoming Events

HACK ALBERTA II March 12
Banff, Alberta

ATLE Emerge Spring S... April 24, April 25
Edmonton, Alberta

ATLE 2025 Administra... October 23, October 24
Edmonton, Alberta