(With SQL & Python)
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
- This promotional code is only applicable to the Certificate in Data Analysis Fundamentals (With SQL & Python) course
- This promotional code redemption is available on a first-come-first-serve basis and while stock lasts.
- Applicant must fill in the promotional code at the time of enrollment.
- Each applicant can redeem the offer once only.
- Once signed up the course, cancellation is prohibited under all circumstances.
- Kaplan Financial students who already signed up for the course are not entitled to enjoy this promotional code offer.
- This promotional code offer is not redeemable for cash and no change will be allowed.
- 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.
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 2 Jun 2023 (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?
In Demand Worldwide
Popular
Easy
Versatile & Productive
Course Highlight
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.