Course: Databases in Finance

Topic outline

General

Collapse all Expand all
Topic: Data science
This topic would introduce the important concepts from data science to the students so that it is used as a foundation for the more detailed database concepts.
- Video curriculum Page
- Slides Data Science File
  
  6.9 MB PDF документ
- Exercise: Information theory Page
- Exercise: Types of data URL
- Binary Game Page
- Exercise: Clean & Integrate File
  
  17.9 KB Excel 2007 spreadsheet
- Data processing solution Page
- Q&A session URL
Topic: Theoretical concepts in Databases
The topic elaborates on the concepts of DBMS and specifically on relational database systems as a bridge to practical assignments.
- Video curriculum Page
- Slides Databases File
  
  6.6 MB PDF документ
- C.J. Date - An Introduction to Database Systems-Pearson (2003) File
  
  54.6 MB PDF документ
- Codd’s Twelve Rules URL
- Exercise: Data normalization File
  
  24.2 KB Excel 2007 spreadsheet
- Solution Page
- Solution file
  
  52.0 KB Excel 2007 spreadsheet
- Exercise: Data Normalization 2 File
  
  23.5 KB Excel 2007 spreadsheet
- Solution Page
- Solution File
  
  59.1 KB Excel 2007 spreadsheet
- Exercise: Car Hire Queries URL
- Car Hires solutions 3 - 5 File
  
  241.5 KB PDF документ
- Car Hires solutions 6 -12 File
  
  730.4 KB PDF документ
- Q&A session URL
Topic: Applications in SQL
This topic presents practical applications of a SQL database management system
- Video curriculum Page
- Materials - Introduction into SQL File
  
  662.6 KB PDF документ
- Materials - SQL Fundamentals File
  
  253.7 KB PDF документ
- Materials - SQL Intermidiate File
  
  274.1 KB PDF документ
- Materials - SQL Advanced File
  
  634.3 KB PDF документ
- Brokerage.DB File
  
  356.0 KB
- SQLite online IDE URL
- SQLite tutorial URL
- Creating DB schema diagrams Page
- Visual JOIN web-page URL
- Assignment 1: SELECT statement Page
- Demo 1 File
  
  125 bytes текстов файл
- Solution 1 File
  
  150 bytes текстов файл
- Assignment 2: ORDER BY and LIMIT clauses Page
- Demo2 File
  
  189 bytes текстов файл
- Solution 2 File
  
  239 bytes текстов файл
- Assignment 3: WHERE and Logical Operators Page
- Demo 3: WHERE clause File
  
  559 bytes текстов файл
- Solution 3 File
  
  629 bytes текстов файл
- Assignment 4: DISTINCT , CASE Page
- Demo 4 DISTINCT File
  
  67 bytes текстов файл
- Demo 4.2 CASE File
  
  247 bytes текстов файл
- Demo 4.1 CASE File
  
  189 bytes текстов файл
- Solution 4 File
  
  644 bytes текстов файл
- Assignment 5: GROUP BY Page
- Demo 5 GROUP BY File
  
  681 bytes текстов файл
- Solution 5 File
  
  341 bytes текстов файл
- Assignment 6: DATES Page
- Demo6 File
  
  585 bytes текстов файл
- Solution 6 File
  
  786 bytes текстов файл
- SQL Intermediate solutions Page
- Assignment 7: HAVING and Subquery WITH Page
- demo7 HAVING File
  
  381 bytes текстов файл
- Demo 7 Chained Query File
  
  640 bytes текстов файл
- Demo 7: DROP CREATE TABLE File
  
  325 bytes текстов файл
- Solution 7 File
  
  340 bytes текстов файл
- Exercise: Joins File
  
  511.6 KB PDF документ
- Assignment 8: JOIN syntax Page
- Demo JOIN syntax File
  
  262 bytes текстов файл
- Solution 8 File
  
  140 bytes текстов файл
- Assignment 9: LEFT JOIN + GROUP BY Page
- DEMO LEFT JOIN + Group BY File
  
  256 bytes текстов файл
- Demo LEFT JOIN File
  
  296 bytes текстов файл
- Solution 9 File
  
  223 bytes текстов файл
- Assignment 10 Multiple JOINS Page
- Demo 10 Multiple Joins File
  
  902 bytes текстов файл
- Demo 10 Multiple Join 2 File
  
  402 bytes текстов файл
- Solution 10 File
  
  1000 bytes текстов файл
- Assignment 11 FULL JOIN Page
- Demo FULL OUTER JOIN File
  
  360 bytes текстов файл
- Assignment 12: General SQL Recap Page
- Assignment 13: General SQL Recap Page
- SQL Game Page
- sql-murder-mystery-no-sol.db File
  
  2.9 MB
- Q&A session URL
Topic: Applications in MS Access
This topic presents practical applications of MS Access database management system
- Install MS Access Page
- Video curriculum Page
- Videos: MS Access Queries applications Page
- Exercise: Create database Page
- Assignment: BrokerageDB Page
- brokerage.accdb File
  
  1.0 MB application/msaccess
- Exercise: MS Access Queries 1 Page
- Exercise: MS Access queries 2 Page
- Exercise: Data relations Page
- Solutions Page
- stores_clean.accdb File
  
  896.0 KB application/msaccess
- Exercise: MS Access Queries 3 Page
- Solution Page
- Exercise: Crosstab Query 4 Page
- Solution Page
- Exercise: MS Access Queries 5 Page
- Solution Page
- Exercise: MS Access Queries 6 Page
- Solution Page
- Exercise: Reports in MS Access Page
- Q&A session URL