Career Coach
Additional Resources
Career Tips
LinkedIn
YouTube
FAQs
Select Page
Cart
Contact us
Login
Lesson 10: SQL Homeworks Review
Assignment & Files from class: None
Lesson 10: SQL Homeworks Review
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
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: