Course Description

This course prepares students to understand basic concepts of databases; normalization and denormalization of data in the context of analytics; structured query language (SQL) to extract, manipulate, and transform data for data mining enabled analytical solutions for business problems; use of cloud resources for data storage and access; and emerging trends in data management.

Course Textbook

The course follows from Data Management: Databases and Analytics Open Ed., by Dr. Richard T. Watson.

Normalization

The following articles talk about data normalization.

Normilization Microsoft

Normalization MariaDB

Other Stuff

The following Powershell and SQL files are examples of inserting a document into powershell, creating a T-SQL script for a cursor, and XML crib sheet for querying an XML document.

Powershell Document Insert

T-SQL Cursor Scaffolding

XML Crib Sheet

Emerging Tech Report

The following is an emerging tech report on blockchain.

Emerging Tech Report

Emerging Tech Presentation