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
Section 2 – Data Analysis and Manipulation
Section 3 – Joins
- Full outer join
Section 4 – Advanced Data Analysis and Manipulation
SQL Server with LocalDB version, and SQL Server Management Studio must be installed on your computer for this course:
SQL Server 2017 Express – LocalDB version (free of charge) (Click here to go to the Microsoft website. Ensure you install the LocalDB version)
After the step above, install SQL Server Management Studio (SSMS) 17.9.1 (free of charge) – download link on the Microsoft website
Note: This course is taught using SQL Server 2017 Express – LocalDB version in a Windows environment. The course is designed for specialised professionals in finance. It is not intended for IT specialists, computer scientists, or professional developers in finance. Software installation/application support is not provided by the program. Students are advised to contact the vendors or search online for information if support is required.
Our Alumni Get Great Jobs
Graduates of our training programs secure employment with some of the most prestigious financial employers in locations across the globe. Many financial institutions sponsor their employees. More...
Go from Job Search to Job Success
We provide access to a wide variety of career services and support to help you land your dream job.
CV/resume help (FinBA program only)
You will be assigned a dedicated professional investment banking recruiter, specialising in Risk & Quant Finance, who will work 1-1 with you to tailor your existing CV/resume.
Leverage our network (FinBA program only)
We foster personal introductions to our network of potential hiring managers and recruiters, to help our students based in London, Toronto, NY/Boston/Chicago/Dallas, and Sydney/Melbourne get connected to the right people.
Job search support
You will receive invaluable guidance on how to navigate the complex recruitment landscape and conduct a smart search for your first or next role in investment banking.
You will be provided a comprehensive set of common interview questions and framework for how to answer them. In addition, we will train you on the mindset and approach needed to ace interviews at any investment bank.
Our Taught Courses
“Your Python training materials are easy for anyone to follow even if you have zero programming experience. You are very good at explaining things in a simple manner.”
“The material you are covering is excellent and very relevant for those wanting to work in finance.”
“The CV/resume building and interview preparation tips I received were instrumental. I was offered a new job at TD Bank within weeks of completing the program.”
“The practical approach of the course will help anyone just starting out in investment banking or looking to transition.”
“I truly recommend the program. I secured a new role in Traded Risk shortly after completing the Coding (Python, SQL) in Finance Certificate program.”
“The program is provided in a practical context which helps to immediately ready anyone successful in completing the course for employment in investment banking.”
“I had no prior knowledge of finance. This hands-on program encouraged me to apply for BA roles in IBs, and it gave me a real confidence boost in job interviews. I now work as a Senior Business Analyst.”
“I started applying my new Python skills at work while still in the program. The project-based work helped build my confidence at writing code to solve problems.”
“The competitively priced FinBA program is a highly relevant, practical augmentation to any mathematical finance program. Consider it a must-have.”
“I cannot fully express how great Ola is and the overall content of the training program. Whoever wants to gain practical derivatives, SQL, and Python coding experience this is the right program for you.”
“The program is a crisp recipe for anyone interested in launching a career into FO/Risk Management. The course content is recent, relevant, practical and hands-on.”
“The online recordings and the live teaching sessions were amazing. The course material was really good and in a nutshell. Ola did a great job.”
“Ola was very generous in connecting me with those in his network, which has helped me start my career in a technical data role. I would highly recommend the program to anyone interested in pursuing a career in financial services.”
“This is a great course providing the essentials of market risk & coding in investment banking in a clear manner. It also includes guest speakers covering career progression and new developments in the financial world. It's given me the knowledge I needed to advance my career.”
“Participants of this program will benefit from Ola's wealth of knowledge. They are sure to acquire the hands-on skillset required to excel in the industry.”
“Knowing Ola Alawiye as a seasoned professional, I am confident this sound program will produce the kind of professionals required in solution delivery teams at banks.”
“There is certainly a need in the market - from our investment banking clients - for professionals with the specialised skillset that this program offers.”