This video would help in quick revision of basic database and data warehouse concepts. Feel free to skip and fast-forward the sections to save time.
Data warehouse schema design - dimensional modeling and star schema
