14 Data 4

D191 Advanced Data Management

  • Write complex SQL statements in order to implement functions, stored procedures, and triggers to prepare data sets for data analysis and manipulation.
  • Configure data extraction, transformation, and loading tasks in order to automate data integration.
  • Provide original SQL code in a text format that creates the detailed and summary tables to hold your report table sections.
  • Provide an original SQL query in a text format that will extract the raw data needed for the detailed section of your report from the source database.
  • Provide original SQL code in a text format that creates a trigger on the detailed table of the report that will continually update the summary table as data is added to the detailed table.