Requirement analysis and define entity relationship diagram of the operational database

Create database, data and some procedure, trigger depends on lecture

Depends on business requirement to definite the information package for the system based on the user requirements, hierarchies / categories in this information package and the level of details representing in this information package.

The same lecture 3 but a little harder, and have to rely on database op.

Database OP How to import .bak file to a database in SQL server

Practice init load data warehouse Explain: https://youtu.be/exbiuZnwTBA

Initial load

Practice analysis service

Practice report server