Data Analyst

Want to become a Data Analyst or a Database Manager? Apply to our data management course today. Available for online and onsite.

Course Overview

12 weeks
2 days per week
2 hours per day
Online classes

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.
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.

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.
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.
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.
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.

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,
-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

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.

Testimonials

Well organized and structured, covering all the necessary skills. The assignment, exams and capstone project really helped give us hands-on practical experience.

Sarah Ameen

ERNST & YOUNG

Classes are interesting, interactive and very thorough. The course has been designed to accomodate beginners to programming; and ignites an interest in the field making of Data Science.

Khoulah Afzal

DATA LADDER

As a beginner in Data Science, I would say it's a great course that helps you in understanding concepts and tools used in DS.

Farhan Siddiqui

PAF-KIET

The lectures, exams, assignments and hands on experience including all the sessions proved to be very helpful to me.

Mahnoor Afridi

MCB- ARIF HABIB

Course Fees

Enquire Now!

Ready to Enroll?

Join many students who have trusted us.

Get In Touch

info@maglytic.com
Monday to Friday: 09.00 - 19.00