Database Tutorial

Course Tutorial Site

Site Admin

Articles

without comments

Week 8: Articles

The articles for this week focus on learning how to use the data dictionary, the query dictionary, and write query diagnostics. The data dictionary contains all the information about data types and structures in the database. The query dictionary is a memory area where all the current SQL statements are stored after they are parsed, which prevents re-parsing frequently used queries. Diagnostics queries look up data stored in the data or query dictionaries.

Articles

Written by michaelmclaughlin

August 11th, 2018 at 3:50 pm

Posted in