Course: Databases in Finance

Section outline

Select section General

Collapse Expand
General

Collapse all Expand all
- Select activity Introductory video
  
  Introductory video Page
- Select activity Course study guide
  
  Course study guide Page
- Select activity Formal course description
  
  Formal course description Page
- Select activity Link to videoconferencing tool
  
  Link to videoconferencing tool URL
- Select activity FB group
  
  FB group URL
- Select activity Bulletin Board (points & schedule)
  
  Bulletin Board (points & schedule) URL
- Select activity Assignments submission form
  
  Assignments submission form URL
- Select activity Request for teacher consultations
  
  Request for teacher consultations Scheduler
- Select activity Announcements
  
  Announcements Forum
- Select activity 16560-Fund-42809
  
  16560-Fund-42809
Select section Topic: Data science

Collapse Expand
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.
- Select activity Video curriculum
  
  Video curriculum Page
- Select activity Slides Data Science
  
  Slides Data Science File PDF
  
  6.9 MB
- Select activity Exercise: Information theory
  
  Exercise: Information theory Page
- Select activity Exercise: Types of data
  
  Exercise: Types of data URL
- Select activity Binary Game
  
  Binary Game Page
- Select activity Exercise: Clean & Integrate
  
  Exercise: Clean & Integrate File XLSX
  
  17.9 KB
- Select activity Data processing solution
  
  Data processing solution Page
- Select activity Q&A session
  
  Q&A session URL
Select section Topic: Theoretical concepts in Databases

Collapse Expand
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.
- Select activity Video curriculum
  
  Video curriculum Page
- Select activity Slides Databases
  
  Slides Databases File PDF
  
  6.6 MB
- Select activity C.J. Date - An Introduction to Database Systems-Pearson (2003)
  
  C.J. Date - An Introduction to Database Systems-Pearson (2003) File PDF
  
  54.6 MB
- Select activity Codd’s Twelve Rules
  
  Codd’s Twelve Rules URL
- Select activity Exercise: Data normalization
  
  Exercise: Data normalization File XLSX
  
  24.2 KB
- Select activity Solution
  
  Solution Page
- Select activity Solution file
  
  Solution file XLSX
  
  52.0 KB
- Select activity Exercise: Data Normalization 2
  
  Exercise: Data Normalization 2 File XLSX
  
  23.5 KB
- Select activity Solution
  
  Solution Page
- Select activity Solution
  
  Solution File XLSX
  
  59.1 KB
- Select activity Exercise: Car Hire Queries
  
  Exercise: Car Hire Queries URL
- Select activity Car Hires solutions 3 - 5
  
  Car Hires solutions 3 - 5 File PDF
  
  241.5 KB
- Select activity Car Hires solutions 6 -12
  
  Car Hires solutions 6 -12 File PDF
  
  730.4 KB
- Select activity Q&A session
  
  Q&A session URL
Select section Topic: Applications in SQL

Collapse Expand
Topic: Applications in SQL
This topic presents practical applications of a SQL database management system
- Select activity Video curriculum
  
  Video curriculum Page
- Select activity Materials - Introduction into SQL
  
  Materials - Introduction into SQL File PDF
  
  662.6 KB
- Select activity Materials - SQL Fundamentals
  
  Materials - SQL Fundamentals File PDF
  
  253.7 KB
- Select activity Materials - SQL Intermidiate
  
  Materials - SQL Intermidiate File PDF
  
  274.1 KB
- Select activity Materials - SQL Advanced
  
  Materials - SQL Advanced File PDF
  
  634.3 KB
- Select activity Brokerage.DB
  
  Brokerage.DB File
  
  356.0 KB
- Select activity SQLite online IDE
  
  SQLite online IDE URL
- Select activity SQLite tutorial
  
  SQLite tutorial URL
- Select activity Creating DB schema diagrams
  
  Creating DB schema diagrams Page
- Select activity Visual JOIN web-page
  
  Visual JOIN web-page URL
- Select activity Assignment 1: SELECT statement
  
  Assignment 1: SELECT statement Page
- Select activity Demo 1
  
  Demo 1 File SQL
  
  125 bytes
- Select activity Solution 1
  
  Solution 1 File SQL
  
  150 bytes
- Select activity Assignment 2: ORDER BY and LIMIT clauses
  
  Assignment 2: ORDER BY and LIMIT clauses Page
- Select activity Demo2
  
  Demo2 File SQL
  
  189 bytes
- Select activity Solution 2
  
  Solution 2 File SQL
  
  239 bytes
- Select activity Assignment 3: WHERE and Logical Operators
  
  Assignment 3: WHERE and Logical Operators Page
- Select activity Demo 3: WHERE clause
  
  Demo 3: WHERE clause File SQL
  
  559 bytes
- Select activity Solution 3
  
  Solution 3 File SQL
  
  629 bytes
- Select activity Assignment 4: DISTINCT , CASE
  
  Assignment 4: DISTINCT , CASE Page
- Select activity Demo 4 DISTINCT
  
  Demo 4 DISTINCT File SQL
  
  67 bytes
- Select activity Demo 4.2 CASE
  
  Demo 4.2 CASE File SQL
  
  247 bytes
- Select activity Demo 4.1 CASE
  
  Demo 4.1 CASE File SQL
  
  189 bytes
- Select activity Solution 4
  
  Solution 4 File SQL
  
  644 bytes
- Select activity Assignment 5: GROUP BY
  
  Assignment 5: GROUP BY Page
- Select activity Demo 5 GROUP BY
  
  Demo 5 GROUP BY File SQL
  
  681 bytes
- Select activity Solution 5
  
  Solution 5 File SQL
  
  341 bytes
- Select activity Assignment 6: DATES
  
  Assignment 6: DATES Page
- Select activity Demo6
  
  Demo6 File SQL
  
  585 bytes
- Select activity Solution 6
  
  Solution 6 File SQL
  
  786 bytes
- Select activity SQL Intermediate solutions
  
  SQL Intermediate solutions Page
- Select activity Assignment 7: HAVING and Subquery WITH
  
  Assignment 7: HAVING and Subquery WITH Page
- Select activity demo7 HAVING
  
  demo7 HAVING File SQL
  
  381 bytes
- Select activity Demo 7 Chained Query
  
  Demo 7 Chained Query File SQL
  
  640 bytes
- Select activity Demo 7: DROP CREATE TABLE
  
  Demo 7: DROP CREATE TABLE File SQL
  
  325 bytes
- Select activity Solution 7
  
  Solution 7 File SQL
  
  340 bytes
- Select activity Exercise: Joins
  
  Exercise: Joins File PDF
  
  511.6 KB
- Select activity Assignment 8: JOIN syntax
  
  Assignment 8: JOIN syntax Page
- Select activity Demo JOIN syntax
  
  Demo JOIN syntax File SQL
  
  262 bytes
- Select activity Solution 8
  
  Solution 8 File SQL
  
  140 bytes
- Select activity Assignment 9: LEFT JOIN + GROUP BY
  
  Assignment 9: LEFT JOIN + GROUP BY Page
- Select activity DEMO LEFT JOIN + Group BY
  
  DEMO LEFT JOIN + Group BY File SQL
  
  256 bytes
- Select activity Demo LEFT JOIN
  
  Demo LEFT JOIN File SQL
  
  296 bytes
- Select activity Solution 9
  
  Solution 9 File SQL
  
  223 bytes
- Select activity Assignment 10 Multiple JOINS
  
  Assignment 10 Multiple JOINS Page
- Select activity Demo 10 Multiple Joins
  
  Demo 10 Multiple Joins File SQL
  
  902 bytes
- Select activity Demo 10 Multiple Join 2
  
  Demo 10 Multiple Join 2 File SQL
  
  402 bytes
- Select activity Solution 10
  
  Solution 10 File SQL
  
  1000 bytes
- Select activity Assignment 11 FULL JOIN
  
  Assignment 11 FULL JOIN Page
- Select activity Demo FULL OUTER JOIN
  
  Demo FULL OUTER JOIN File SQL
  
  360 bytes
- Select activity Assignment 12: General SQL Recap
  
  Assignment 12: General SQL Recap Page
- Select activity Assignment 13: General SQL Recap
  
  Assignment 13: General SQL Recap Page
- Select activity SQL Game
  
  SQL Game Page
- Select activity sql-murder-mystery-no-sol.db
  
  sql-murder-mystery-no-sol.db File
  
  2.9 MB
- Select activity Q&A session
  
  Q&A session URL
Select section Topic: Applications in MS Access

Collapse Expand
Topic: Applications in MS Access
This topic presents practical applications of MS Access database management system
- Select activity Install MS Access
  
  Install MS Access Page
- Select activity Video curriculum
  
  Video curriculum Page
- Select activity Videos: MS Access Queries applications
  
  Videos: MS Access Queries applications Page
- Select activity Exercise: Create database
  
  Exercise: Create database Page
- Select activity Assignment: BrokerageDB
  
  Assignment: BrokerageDB Page
- Select activity brokerage.accdb
  
  brokerage.accdb File ACCDB
  
  1.0 MB
- Select activity Exercise: MS Access Queries 1
  
  Exercise: MS Access Queries 1 Page
- Select activity Exercise: MS Access queries 2
  
  Exercise: MS Access queries 2 Page
- Select activity Exercise: Data relations
  
  Exercise: Data relations Page
- Select activity Solutions
  
  Solutions Page
- Select activity stores_clean.accdb
  
  stores_clean.accdb File ACCDB
  
  896.0 KB
- Select activity Exercise: MS Access Queries 3
  
  Exercise: MS Access Queries 3 Page
- Select activity Solution
  
  Solution Page
- Select activity Exercise: Crosstab Query 4
  
  Exercise: Crosstab Query 4 Page
- Select activity Solution
  
  Solution Page
- Select activity Exercise: MS Access Queries 5
  
  Exercise: MS Access Queries 5 Page
- Select activity Solution
  
  Solution Page
- Select activity Exercise: MS Access Queries 6
  
  Exercise: MS Access Queries 6 Page
- Select activity Solution
  
  Solution Page
- Select activity Exercise: Reports in MS Access
  
  Exercise: Reports in MS Access Page
- Select activity Q&A session
  
  Q&A session URL

Section outline

General

Topic: Data science

Topic: Theoretical concepts in Databases

Topic: Applications in SQL

Topic: Applications in MS Access