Data Analyst

Want to become a Data Analyst or a Database Manager? Apply to Pakistan’s top data management course today. Available online for now.

12 Weeks

2 days per week

2 hours per day

Online Live

WHAT YOU WILL LEARN

Introduction to MS Excel

Learn the basics of one of the most ubiquitous spreadsheet software used in workplaces around the world.

Advanced MS Excel

Master the skills needed to validate data, prevent errors, create automation, apply advanced formulas, and conditional logic to help make smart business decisions.

Introduction to SQL : Overview of RDBMS and Creating Schemas in Databases

Acquire the basics of querying tables in relational databases such as MySQL, SQL Server, and PostgreSQL.

Data Manipulation and Exporting using SQL

Struggling with managing bulk data? Learn how to clean, transform, and export big data in any format with as little as a single SQL query.

SQL Querying Concepts

SQL is a special-purpose querying language designed for managing data in a relational database, and is used by a large number of apps and organizations.

Advance SQL Concepts

Learn all the advanced functions for processing and transforming data.

Case Study: Testing ETL skills using Talend by doing a hands-on case study conducted by an industry expert

Talend is an ETL tool for Data Integration. It provides software solutions for data preparation, data quality, data integration, application integration, data management, and big data. At the end of your certification, we will do a hands-on case study, led by an industry expert, that will teach you the usage of this tool along with its many benefits.

Inside our Data Analyst Certification Curriculum

Download our program brochure for a more detailed look at our Data Analyst Certification curriculum, course outline, educational philosophy, and the support structures we use throughout your training journey and beyond.

SQL Curriculum

WHO IS IT FOR

Much of the world’s raw data—from electronic medical records to customer transaction data — lives in organized collections of tables called relational databases. Over the next 12 weeks, master the syntax in SQL shared by many types of databases, such as PostgreSQL, MySQL, SQL Server, and Oracle.

  • University students, who are in 7th or 8th semester

  • Industry Professionals, who are performing Data Management-related tasks primarily on MS Excel

  • Industry Professionals, who are working in IT, MIS or related departments

  • Candidates, who are interested in pursuing / interviewing for Data Analyst or Data Engineering career track

DAY IN THE LIFE

Here’s what a typical day is like in the Data Analyst Certification Program at FTI

Day at FTI

2:05 PM - 3:20 PM

Lecture - learn about vocabulary, concepts and tools

3:30 PM - 3:55PM

Small group or independent challenge

2:00 PM - 2:05 PM

Announcements and review of core concepts from the previous class

3:20 PM - 3:30 PM

Break

3:55 PM - 4:00 PM

Review work, lab session, and preview homework or projects

Instructors

Learn from professional MS Excel and SQL experts who bring years of experience and passion for training and mentorship into our classroom.

afzaal ur rehman

Afzaal ur Rehman

MCBAH I University of Karachi

saqib shah

Saqib Shah

Love For Data I University of Karachi

Student Testimonials

Fees And Scholarship

Upon acceptance, your place in the program will only be reserved once we’ve received your fees. Full tuition is due before the start date of your program.

Tuition Total

PKR 20,000

FULL TUITION PAYMENT

Payments can be made either by cash, IBFT, check, or wire-transfer

20% Merit-based Scholarships available to students with CGPA 3.5 or above

Ready to Enroll?

Join the many students who have trusted us.

FAQs

Professional backgrounds vary quite a bit in the SQL Certification, as data management skills are now highly valued across a range of industries, including banking, pharmaceutical, retail, insurance, marketing, FMCG, and more.
From an educational perspective, 60 percent of participants at FTI are either pursuing or have graduated with a Computer Science or related STEM degree, with about 40 percent coming from a completely non-technical background.

MS Excel, SQL, Talend

All participants are required to bring their laptops with them when attending the class.

Yes, if you successfully complete the Data Analyst course, you will earn a FTI Data Analyst Certificate, which can boost your LinkedIn profile and resume, helping you stand out in the job market and when applying for any Data Analyst, Database Manager, or MIS Officer positions.

We do our best to help our participants get a job or an internship, thanks to our strong network of directors, advisors, and corporate partners. In the past, we have observed about 85% of our graduates get placed in their desired domain within 6 months of successfully graduating

We run our cohorts all year round, on a rolling basis. You can see all upcoming start dates when submitting your application!
To apply, simply click the ‘Apply Now’ button and you will be redirected to the application portal.

FTI is proud to be a corporate training partner to a host of national and multi-national organizations within the analytics domain. We offer customized, hands-on training depending on the specific requirements and business needs of our clients. Our training is offered in onsite, offsite, and online capacity.
Some of the organizations we have been working with include Ernst & Young (EY) – Pakistan, MCB Arif Habib Savings and Investments Limited, PharmEvo Private Limited, United Energy Pakistan, and Shield Corporation Limited.
For further details about corporate training or If you need niche technical or development training for your team, please contact Ms. Shirley Alfanso on shirley.alf@frontiertechnologyinstitute.com.

Still have some questions?

Explore through the curriculum and FTI pages or talk to someone
from the team!