For 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.
Structured Query Language (SQL) is an American National Standards Institute (ANSI) computer language for accessing and manipulating database systems. It works with database programs such 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. Students also learn how to stream text into a field; retrieve and send results in an email as text or attachment; perform error trapping; and create audit systems, dynamic SQL and pivot tables with hyperlinks.
We use cookies to understand how you use our site and to improve your experience, including personalizing content and to store your content preferences. By continuing to use our site, you accept our use of cookies.
Read our privacy policy.