VBA/Python/SQL Online Certificates

The VBA/Python/SQL Online Certificates are a joint project by the Baruch MFE Program and Mark Ross, Baruch MFE instructor. The courses are delivered entirely online by ScriptUni and are part of the Pre-MFE Program. A teaching assistant is provided to each student, and the Baruch MFE Program grants a Certificate of Completion upon successfully completing each course.

Audience: These certificates are designed for people interested in pursuing graduate studies in financial engineering.  With an emphasis on financial applications for quantitative finance, these courses are also useful to professionals interested in learning scripting languages in the realm of finance, giving them a leg-up on their competition.

Certification: Upon successful completion of each course, the Baruch MFE program will issue a Certificate of Completion to students who obtain a 70% or higher final score. A Certificate of Completion with Distinction will be awarded to students with 90% or higher final score.

________________

VBA for Financial Engineering

Course Topics:

  • Excel Functions: Worksheet functions, compounding, interest rates, discount factors, bond pricing in Excel, Offset, pivot tables
  • VBA Syntax: Subs/functions, variables, vectors, loops, conditional statements, cells vs range, bond pricing in VBA, linear interpolation, forward rates
  • Option Pricing in VBA: Option payoff model, Binomial Asset Pricing Model, Black Scholes
  • Classes: Data types, classes, portfolio analysis, value at risk
  • Data Structuring: Formatting/graphing in VBA, file manipulation, userforms, pivot tables in VBA, SQL in VBA, extracting market data using SQL

Format: The VBA online certificate consists of 5 levels, each with video lectures, micro-quizzes, and homeworks. The course concludes with a case-study. Each student is assigned a personal TA (alumni of the Baruch MFE Program). Aside from the TA, student may discuss lectures directly under the course videos via the comments section.

Time Frame: The course must be completed within 8 weeks from the enrollment date.

The Course Syllabus and a Sample Course Video can be found here.

Tuition: $750

Registration: Follow this link to register.

________________

Practical Python with Applications in Finance

Course Topics:

  • Python Syntax 101: Variables, lists, loops, functions, sets, dictionaries, packages
  • Intermediate Python: Object-oriented programming, advanced functions, generators, exception handling, context managers
  • Advanced Python Syntax: I/O, string manipulation, date/time, decorators
  • Monte Carlo in Python: Random number generators, concurrency
  • Asset-Backed Securities: Numerical packages, pricing ABS in Python

Format: The VBA online certificate consists of 6 levels, each with video lectures, micro-quizzes, and homeworks. The course concludes with a case-study. Each student is assigned a personal TA (alumni of the Baruch MFE Program). Aside from the TA, student may discuss lectures directly under the course videos via the comments section.

Time Frame: The course must be completed within 8 weeks from the enrollment date.

The Course Syllabus and a Sample Course Video can be found here

Tuition: $750

Registration: Follow this link to register.

________________

SQL for Finance

Course Topics:

  • Basic Queries: Select, filters, multiple filters, top, aliases
  • Writing Data: Delete, updating data, adding data
  • Joins: inner joins, left/right joins, full outer joins
  • Unions: union, union, all, full outer join workaround

Format: The SQL online certificate consists of 5 levels, each with video lectures, micro-quizzes, and homeworks. Each student is assigned a personal TA (alumni of the Baruch MFE Program). Aside from the TA, student may discuss lectures directly under the course videos via the comments section.

Time Frame: The course must be completed within 4 weeks from the enrollment date.

The Course Syllabus and a Sample Course Video can be found here

Tuition: $275

Registration: Follow this link to register.

________________

 

 

 

 

 

2017-06-08T17:13:06+00:00