Tuesday, December 5, 2023

Practical Guide to Database Design : overview of databases, data normalization, database implementation, normalization and physical design exercise, data modeling tool, using Microsoft access, using sql server, using perl to extract and load data, monitor sql server logs, loading data into tables, monitoring windows logs, manual queries and edits, authorized users, backup/recovery, creating views, creating databases, database creation/installation, change management for sql server, the role of pass through queries, generating reports, modifications to the database design, create the university logical data model, the Erwin data modeling tool, logical to physical design, table key and column data types, creating the data model, creating the entity/attribute list.