Coding for Finance Summer 2022
Lessons
Class 1 – SQL Setup
Lesson 2: Intro to SQL
Homework File: Coding for Finance 2022 – SQL Homework 1 Database Schema File & Dimension Table Examples: DATA_LAYOUT
Lesson 3: Intermediate SQL
Homework File: Coding for Finance SQL Homework 2 Class 3 Excel File w/SQL Queries: 7_24_2022 Class3
Lesson 4: Advanced SQL
Homework File: Coding for Finance Bootcamp – Homework 3 Class 4 Excel File w/SQL Queries: Class 7_31 notes
Lesson 5: VBA 1
Homework File: VBA_Class1_HW Class 5 Excel File: VBA_CLASS1
Lesson 6: VBA 2
Homework: VBA 2 Homework Class 6 Excel File: Class 6 – VBA 2
Lesson 7: Interpolation
Assignment: Bootcamp Interpolation Class
Lesson 8: Data Cleansing Project
Assignment: Clean Data – Last Issue
Lesson 9: VBA Classes
Assignment & Files from class: Class 9 Files
Lesson 10: SQL Homeworks Review
Assignment & Files from class: None
Lesson 11 – VBA SQL Data Reporting
Assignment & Files from class: To be uploaded Oct 7