Skip to main content
СУ
You are currently using guest access (
Log in
)
Databases in Finance
Home
Courses
Стопански факултет
Active class Project
Databases in Finance
Topic: Applications in MS Access
Solution
Solution
CommissionAmount
TransactionDate
CustomerStartDay
Last modified: Tuesday, 19 April 2022, 1:49 AM
◄ Exercise: MS Access Queries 3
Jump to...
Jump to...
Introductory video
Course study guide
Formal course description
Link to videoconferencing tool
FB group
Bulletin Board (points & schedule)
Assignments submission form
Request for teacher consultations
Announcements
Video curriculum
Slides Data Science
Exercise: Information theory
Exercise: Types of data
Binary Game
Exercise: Clean & Integrate
Data processing solution
Q&A session
Video curriculum
Slides Databases
C.J. Date - An Introduction to Database Systems-Pearson (2003)
Codd’s Twelve Rules
Exercise: Data normalization
Solution
Solution file
Exercise: Data Normalization 2
Solution
Solution
Exercise: Car Hire Queries
Car Hires solutions 3 - 5
Car Hires solutions 6 -12
Q&A session
Video curriculum
Materials - Introduction into SQL
Materials - SQL Fundamentals
Materials - SQL Intermidiate
Materials - SQL Advanced
Brokerage.DB
SQLite online IDE
SQLite tutorial
Creating DB schema diagrams
Visual JOIN web-page
Assignment 1: SELECT statement
Demo 1
Solution 1
Assignment 2: ORDER BY and LIMIT clauses
Demo2
Solution 2
Assignment 3: WHERE and Logical Operators
Demo 3: WHERE clause
Solution 3
Assignment 4: DISTINCT , CASE
Demo 4 DISTINCT
Demo 4.2 CASE
Demo 4.1 CASE
Solution 4
Assignment 5: GROUP BY
Demo 5 GROUP BY
Solution 5
Assignment 6: DATES
Demo6
Solution 6
SQL Intermediate solutions
Assignment 7: HAVING and Subquery WITH
demo7 HAVING
Demo 7 Chained Query
Demo 7: DROP CREATE TABLE
Solution 7
Exercise: Joins
Assignment 8: JOIN syntax
Demo JOIN syntax
Solution 8
Assignment 9: LEFT JOIN + GROUP BY
DEMO LEFT JOIN + Group BY
Demo LEFT JOIN
Solution 9
Assignment 10 Multiple JOINS
Demo 10 Multiple Joins
Demo 10 Multiple Join 2
Solution 10
Assignment 11 FULL JOIN
Demo FULL OUTER JOIN
Assignment 12: General SQL Recap
Assignment 13: General SQL Recap
SQL Game
sql-murder-mystery-no-sol.db
Q&A session
Install MS Access
Video curriculum
Videos: MS Access Queries applications
Exercise: Create database
Assignment: BrokerageDB
brokerage.accdb
Exercise: MS Access Queries 1
Exercise: MS Access queries 2
Exercise: Data relations
Solutions
stores_clean.accdb
Exercise: MS Access Queries 3
Exercise: Crosstab Query 4
Solution
Exercise: MS Access Queries 5
Solution
Exercise: MS Access Queries 6
Solution
Exercise: Reports in MS Access
Q&A session
Exercise: Crosstab Query 4 ►
