This intermediate course is for experienced SQL end users, application programmers, database administrators, and user support staff who need more advanced knowledge of SQL.
Extend your knowledge of scalar functions which: Manipulate arithmetic data, Manipulate date values, and Manipulate character data. Examples of scalar functions that are addressed in this course:SUBSTRPOSSTRCOALESCE/VALUEDECIMALROUNDDIGITSCHARDATE/TIMETable Expressions and Recursive SQL Identify reasons for using table expressions and recursive SQLUse nested and common table expressionsIdentify the difference between views and table expressionsCode recursive SQLControl the depth of recursion when coding recursive SQLUDTs/UDFs and Performance Describe the concepts behind User-Defined Types, User-Defined Functions and Stored ProceduresPredict when queries will use indexes to get better performanceIdentify concepts of predicate processingState introductory concepts about index structureState general best practices advice
You should have experience with coding and executing basic SQL statements. These skills can be developed by attending SQL Workshop (CE120), or having equivalent experience.