Course DescriptionStructured Query Language (SQL) is an American National Standards Institute (ANSI) computer language for accessing and manipulating database systems. It works with such database programs as MS Access, DB2, Informix, MS SQL Server, Oracle, and Sybase. 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 learn how to use advanced features of SQL commands, including operators such as IN, AND, OR, BETWEEN, LIKE, DISTINCT, AGGREGATE, CONCATENATE, SUBSTRING, HAVING, and others. In addition, instruction covers advanced topics using table joins, sub-queries, if and case statements, and cast and convert statements, as well as stored procedures, triggers, functions, and cursors. You'll also learn how to stream text into a field, retrieve and send results in email as text or attachment, error trapping, create audit system, dynamic SQL, and create pivot tables with hyperlinks.
Course OutlineFor those with SQL knowledge, this course covers advanced SQL statements used in inserting, retrieving, and updating a database. Students learn how to use advanced features of SQL commands and other advanced topics.