Add unit 6, 7, 8

3 files changed, 52 insertions, 1 deletions

diff --git a/doc/unit-5.md b/doc/unit-5.md
index 38df362..05f34b4 100644
--- a/doc/unit-5.md
+++ b/doc/unit-5.md
@@ -138,7 +138,7 @@ Terms:
 * dynamic view
 * materialized view
 
-## Section 3: Advanced SQL and Data Control Commands
+on 3: Advanced SQL and Data Control Commands
 
 Read Chapter 7: Advanced SQL
 * all sections
diff --git a/doc/unit-7.md b/doc/unit-7.md
new file mode 100644
index 0000000..f6c1d3a
--- /dev/null
+++ b/doc/unit-7.md
@@ -0,0 +1,24 @@
+# Unit 7: Introduction to Data Warehousing
+
+## Section 1 - Basic Concepts of Data Warehousing
+
+* Read "Chapter 9: Basic concepts of data warehousing"
+
+## Section 2 - Data Warehouse Architectures and OLAP Tools
+
+Read the Chapter 9 sections:
+
+* "Data warehouse architectures," 
+* "Some characteristics of data warehouse data," 
+* "The derived data layer," 
+* "Column databases: A new alternative for data warehouses,"
+* "The user interface"
+* "SQL OLAP querying," and 
+* "Data visualization"
+
+* describe the main architectures used to build data warehouse systems;
+* list and explain the basic characteristics and types of data in data warehousing systems;
+* explain the main concepts involved in the design of data marts;
+* describe the process used to generate derived data;
+* describe the star schema, as used in data marts;
+* present a variety of tools and techniques that are used to query, analyze, and visualize the data stored in data warehouses and data marts.
diff --git a/doc/unit-8.md b/doc/unit-8.md
new file mode 100644
index 0000000..ce9eb25
--- /dev/null
+++ b/doc/unit-8.md
@@ -0,0 +1,27 @@
+# Unit 8: Data Quality and Database Administration
+
+## Section 1: Data Quality and Integration
+
+Read all section in Chapter 10.
+
+* define the characteristics of data quality;
+* identify situations of poor data quality, and measures for improving them;
+* describe the following data integration approaches: data consolidation, data federation, and data propagation;
+* discuss, in detail, the ETL process for data integration used in the reconciled data layer of data warehousing;
+* discuss the data transformation functions.
+
+## Section 2: Data Administration and Database Administration
+
+Read all sections of Chapter 11: "Data and Database Administration."
+
+When you have completed this section, you should be able to
+
+* discuss the need for organizations to have both data administrator(s) and database administrator(s);
+* list and discuss the roles of data administrators and database administrators;
+* describe the threats addressed by data security;
+* discuss the characteristics of most data security plans;
+* discuss the Sarbanes-Oxley Act (SOX) for the control and security of databases and applications;
+* list and discuss the backup and recovery facilities provided by database management systems;
+* discuss the types of database failures and the process for disaster recovery;
+* outline different mechanisms used for concurrency control;
+* list and discuss the core functions supported by repository engines.