SQL in Finance

SQL in Finance

Learn how to code using Structured Query Language (SQL) for data storage, analysis and manipulation with applications in Finance.
AboutTutor(s)BreakdownKey Info

This course teaches students from foundations, with no prior programming knowledge or experience required. The focus is on the most common usage of SQL in the financial industry, providing students with the knowledge required to start writing SQL code from Day One on the job. The course will benefit those looking to gain working knowledge of this powerful and globally-used database programming language, and to develop knowledge of MS SQL Server.

By the end of the course, students will have an essential skill that financial employers need and feel confident in their ability to write SQL programs to perform many of the day to day functions in a Finance job.

During the program, students will develop several SQL programs which will form part of their portfolio. The portfolio is a valuable addition to a student’s CV/resume, and is a real asset that is evidence of the student’s practical experience and knowledge. This is particularly useful during a job search to set the student apart from other applicants.

The SQL in Finance course is not offered on a standalone basis. It is included in our Certificate in Finance Business Analysis (FinBA), and Coding (Python, SQL) in Finance Certificate training programs.

Section 1 – Basics

  • SQL Server Management Studio
  • Commenting code
  • Data import/export
  • Table functions
  • Column operations

Section 2 – Data Analysis and Manipulation

  • Selecting data
  • Data filtering
  • Data update
  • Views
  • Functions

Section 3 – Joins

  • Keys
  • Aliases
  • Left join
  • Inner join
  • Full outer join

Section 4 – Advanced Data Analysis and Manipulation

  • Pattern searching
  • Aggregation
  • Mathematical operations
  • Stored procedures
  • Nested queries