fbpx

Certificate in Data Analysis Fundamentals
(With SQL & Python)
Enroll Now Download Brochure

DOWNLOAD BROCHURE ENROLL NOW Certificate in Data Analysis Fundamentals (With SQL & Python) LEARN MORE Learn the fundamentals of data analysis with SQL & Python and how to use it to analyze, visualize and present data in 16 hours.

Limited Offer

Enroll now to enjoy $300 OFF on the Certificate in Data Analysis Fundamentals (SQL & Python) with Promotional Code: PYT300.

First-come-first-serve while stock lasts

Terms and conditions

  1. This promotional code is only applicable to the Certificate in Data Analysis Fundamentals (With SQL & Python) course
  2. This promotional code redemption is available on a first-come-first-serve basis and while stock lasts.
  3. Applicant must fill in the promotional code at the time of enrollment.
  4. Each applicant can redeem the offer once only.
  5. Once signed up the course, cancellation is prohibited under all circumstances.
  6. Kaplan Financial students who already signed up for the course are not entitled to enjoy this promotional code offer.
  7. This promotional code offer is not redeemable for cash and no change will be allowed.
  8. Kaplan reserves the final right to amend these terms and conditions with or without prior notice. All matters and disputes will be subject to the final decision of Kaplan Financial.

Course Features

Focus on SQL & Python specifically for finance professionals

Learn from theoretical methodologies to practical applications

Online livestreaming class

16 hours to complete

What Will You Get

You will learn how to collect, clean and analyze a data set to solve a real-world problem in the finance industry. You will obtain a real-world data set, form a hypothesis about it, clean, parse, and apply modeling techniques and data analysis principles to ultimately create a predictive model using Python and SQL.

SQL

  • Learn the basics of SQL and write your own queries to access and handle huge financial data from databases.
  • Learn about SQL various functions to perform data calculation and apply them to datasets to discover insights.
  • Expand your abilities by joining multiple sources of data and retrieve them from multiple tables.
  • Set up a SQL database on your own computer and practice the commands you’ve learned.

Python

  • Learn the basics of Python and perform financial data analysis to harvest insights and get competitive edges.
  • Write your first Python program by implementing concepts of variables, strings, functions, loops, and conditions
  • Work with practical financial data in Python, including reading and writing files, loading, working, and saving data with Pandas
  • Learn how to interpret data in Python using multi-dimensional arrays in NumPy, manipulate DataFrames in pandas, and embed plots into applications with Matplotlib
  • Perform data analytics using popular Python libraries
  • Gain insights from data visualization libraries in Python with Matplotlib

Practice SQL & Python with Real Financial Data

  • Analyze stock market trends
  • Compare huge amount of statistics
  • Present complicated data in simple charts with precis

Earn a Certificate

At the end of the course, you are optional to work on a final project to implement every techniques you have learnt throughout the course.

When you finish the course with 70% attendance and get a pass in the project*, you will earn a Completion Certificate of the course.

*Please note that the project must be submitted in three weeks from the last lesson.

You will earn the Certificate of Attendance if you achieve 70% attendance without submitting the project.

Who Should Attend?

  • Finance professionals who want to make a move in their career from Finance to FinTech
  • IT professionals from non-finance background
  • IT professionals in banking industry who would like to enhance programming skills
  • People from different industries who would like to switch their career to FinTech

This course is approved by Reindustrialization and Technology Training Program (RTTP), which offers up to 2/3 course fee reimbursement upon successful application. Visit https://rttp.vtc.edu.hk for details

RTTP Training Grant Application

Companies should submit their RTTP training grant application for their employee(s) via https://rttp.vtc.edu.hk/rttp/login at least two weeks before course commencement.

If you wish to apply for RTTP training grant, please enroll in the course and apply for RTTP on or before 14 Oct 2022 (Friday). Click here for more details.

Stay abreast of changes and get ahead of others

Whether you are in banking, risk management, portfolio management, or any other field of finance, your role either already requires or will soon require you to be able to program in at least one programming language. As the industry becomes more automated and technology driven, finance professionals with programming/technical skills are going to be more in demand and these skills can help you stay relevant and competitive for the current job market.

Whether you are in banking, risk management, portfolio management, or any other field of finance, your role either already requires or will soon require you to be able to program in at least one programming language. As the industry becomes more automated and technology driven, finance professionals with programming/technical skills are going to be more in demand and can help you stay relevant and competitive for the current job market.

Why Python?

Course Highlight

The purpose of data analysis is to turn raw data into actionable insights. Much of the world’s raw data, in particular with financial data, exists in collections of tables called relational databases. Thus, in order to be an efficient finance professional, you must know how to extract and clean data from these databases using a programming language called SQL in different occasion like for the changing trend of stock market, comparison of a large amount of statistics and create complicated graph easily for more clear presentation.

Once you got the financial data you need, you would then use Python and various Python-related tools to harvest insights from your data to get a competitive edge, whether it is in creating data-driven financial models for business valuation, business analysis, risk management or simply create beautiful data visualizations to represent your financial data.

Unlike any other Data Analysis courses, this course focuses on SQL & Python specifically for finance professionals, helping you to be familiar with the most in demand tech skills in the 21st century and how you can apply these skills to your areas of expertise, whether it is portfolio analysis, financial trading, risk management or FinTech. You will learn the practical applications of the theoretical methodologies where you will blend technology and finance into construction of a model. This is a challenging course where you are expected to learn quickly.

This course is approved by Reindustraialisation and Technology Training Program (RTTP), which offers up to 2/3 course fee reimbursement upon successful application. Visit https://rttp.vtc.edu.hk for details

RTTP Training Grant Application

Companies should submit their RTTP training grant application for their employee(s) via https://rttp.vtc.edu.hk/rttp/login at least two weeks before course commencement.

If you wish to apply for RTTP training grant, please enroll in the course and apply for RTTP on or before 22 Oct 2021. Click here for more details

Who Should Attend?

  • Finance professionals who want to make a move in their career from Finance to FinTech
  • IT professionals from non-finance background
  • IT professionals in banking industry who would like to enhance programming skills
  • People from different industries who would like to switch their career to FinTech

Key Takeaways From The Course

  • Master the basics of SQL and able to use SQL to perform basic fact finding and statistical computation on database
  • Write your first Python program by implementing concepts of variables, strings, functions, loops, and conditions
  • Work with practical financial data in Python, including reading and writing files, loading, working, and saving data with Pandas
  • Learn how to interpret data in Python using multi-dimensional arrays in NumPy, manipulate DataFrames in pandas, and embed plots into applications with Matplotlib
  • Perform data analytics using popular Python libraries
  • Gain insights on data visualization libraries in Python with Matplotlib

Earn a Certificate

At the end of the course, you are optional to work on a final project to implement every techniques you have learnt throughout the course.

When you finish the course with 70% attendance and get a pass in the project*, you will earn a Completion Certificate of the course.

*Please note that the project must be submitted in three weeks from the last lesson.

You will earn the Certificate of Attendance if you achieve 70% attendance without submitting the project.

Click here to get program information

Get Program Information