This course covers advanced coding concepts of a specific DBMS. For example, if the student is studying MS Access, this course covers coding using Visual Basic for Applications (VBA). If the student is studying MS SQL Server, this course introduces advanced concepts using Transact SQL (TSQL). If the student is studying Oracle DBMS, the student will code in PL/SQL. Students will be taught to code programs to perform error handling and create triggers. Students will program stored procedures and custom functions and learn to call those reusable programs. The course may be repeated one time for purposes of preparing the student as an administrator on a sec- ond database platform. Permission of instructor is required.
Prerequisites: CTS 2440