Career Coach
Additional Resources
Career Tips
LinkedIn
YouTube
FAQs
Select Page
Cart
Contact us
Login
Lesson 3: Intermediate SQL
Homework File:
Coding for Finance SQL Homework 2
Class 3 Excel File w/SQL Queries:
7_24_2022 Class3
Lesson 3: Intermediate SQL
VBA 01 - Advanced Excel Features
1 – Intro to VBA
2 – Excel Functions 1
3 – Excel Functions II
4 – Compounding
5 – Compounding Rates
6 – Discount Factors
7 – Bond Pricing
8 – Offset
9 – Pivot Tables
10 – Homework Prep
11 – Homework Tips and Tricks
VBA 02 - VBA Basics
1 – Subs and Functions
2 – Variables
3 – Vectors
4 – Loops
5 – Bond Pricing
6 – Conditional Statements
7 – Linear Interpolation
8 – Linear Interpolation Code
9 – Forward Rates Curve
10 – Forward Rates Code
11 – Homework Prep
12 – VBA Tips and Tricks – HW2
13 – Debugging Your Code
VBA 03 - Option Pricing
1 – Intro to Options
2 – Binomial Asset Pricing Model
3 – Binomial Asset Pricing Model Code
4 – Black Scholes
5 – Homework Prep
VBA 04 - Classes
1 – Cell vs Range
2 – User Data Types
3 – Collections
4 – Classes
5 – Portfolio Analysis
6 – Value At Risk
7 – Homework Prep
VBA 05 - Data Structuring
1 – Selection
2 – Charts
3 – File Manipulation
4 – User Forms
5 – Pivot Tables
6 – SQL
7 – The Interview
8 – Case Study
SQL 01 - Basic Queries
1 – Introduction
2 – Understanding the Data
3 – Select
4 – Filters
5 – Multiple Filters
6 – SQL Homework Guidelines
SQL 02 - Writing Data
1 – Delete
2 – Update
3 – Insert
Python 00 - Introduction
1 – IDE
2 – Python Language
3 – Student Submission Guidelines
Python 01 - Python Syntax 101
1 – Variables and Types
2 – IO
3 – Conditionals
4 – Loops
5 – Lists
6 – List Comprehensions
7 – Functions
8 – Built In Functions
9 – Sets
10 – Dictionaries
11 – Loan Functions
12 – Packages
Python 02 - OOP
1 – Object Oriented Programming
2 – Class and Static Methods
3 – Loan
4 – Composition
5 – Inheritance
6 – Multiple Inheritance
Python 03 - Intermediate Python Syntax
1 – Callables
2 – Partials
3 – Iterators
4 – Generators
5 – Context Managers
6 – Exceptions
Python 04 - I/O and String Manipulation
1 – String Manipulation
2 – String Formatting
3 – Logging
4 – File I/O
5 – File Functions
Python 05 - Advanced Python Syntax
1 – Dates and Times
2 – Decorators
Python 06 - Monte Carlo in Python
1 – Random Number Generators
2 – Concurrency
Python 07 - Case Study
1 – Numerical Packages
2 – Project Background
SQL 03 - Advanced SQL Syntax
1 – Order By
2 – Aliases
3 – Case When
4 – Coalesce
5 – Functions
SQL 04 - Joins
1 – Intro to Joins
2 – Inner Join
3 – Left Join
4 – Full Outer Join
SQL 05 - Unions
1 – Intro to Unions
2 – Union Example
3 – Union All
4 – Full Outer Join Workaround
SQL 06 - Closing
1 – Subqueries
2 – Stored Procedures
3 – With As
Career Coach - The Resume
01 – Cover Letter & Resume
02 – Networking & Interviewing
Python 08 - All Python2.0 Videos
Legacy – Python 2 Lectures
Choosing a Career
01 – Intro to CareerJump
02 – Understand Your Life Plan
03 – Do You Love to Code?
Resume Design
01 – What is This Thing Anyways?
02 – Header Bar
03 – Summary Section
1: Basic Queries
Intro to SQL
Select
Select Star
Select Distinct
Select Where
Select Like
Where In
Dates
Between
Multiple Filters
Order By
Limit
Multiple Filters Or
MySQL Setup – Loading Tables
3: Tables 101
Intro to Tables
Map
Dimension
Fact
Database Schema
Primary Key
Foreign Key
Primary Key – Foreign Key Relationship
Table Index
Column Constraints
2: Intermediate SQL Syntax
Case When
Aliases
Is Null
Coalesce
Sum
Average
Decimal Precision
4: Tables Syntax
Create Table
Add Column
Update Column
Rename Column
Row Oriented vs Column Oriented
Views
Create View
5: Modifying Data
Delete
Orphaned Records
Updating Data
Updating From an External Table
Adding From an External Table
Adding New Data
6: Join & Union
Intro to Joins
Join Types
Inner Join
Left and Right Joins
Full Outer Join
Self Join
Union
Full Join Workaround
7: Advanced Topics in SQL
Subqueries
Common Table Expressions
Deterministic Functions
Temporary Tables
Order of Execution
Stored Procedures
Back to:
