BEGIN:VCALENDAR
VERSION:2.0
METHOD:PUBLISH
BEGIN:VEVENT
DTSTART:20100702T023000Z
DTEND:20100702T060000Z
DTSTAMP:20100421T163100Z
UID:rpatlan@dbwebsite.com
CREATED:20100421T163100Z
DESCRIPTION:Advanced Structured Query Language: This course is designed for those with some knowledge of SQL.
This hands-on course covers advanced SQL statements used in inserting, retrieving, and updating data in a database.Students are shown how to use advance features of SQL commands, including using operators such as IN, AND, OR, BETWEEN, LIKE, DISRINCT, AGGREGATE, CONCAT, SUBSTRING, HAVING and others.
In addition, advanced usage of table joins, sub-queries, if and case statements, and cast and covert statements are covered, as well as stored procedures, triggers, functions, and cursors. For example, the course shows how to stream text into a field, retrieve and send results in email, create search function using full text index, and create pivot table with hyperlinks.
Please review and register for course at UCLA Extension
LOCATION:
SEQUENCE:0
STATUS:CONFIRMED
SUMMARY:Advanced SQL
TRANSP:TRANSPARENT
END:VEVENT
END:VCALENDAR