Data Analysis

Duration : 2 Months

Category :Data Analysis, SQL Analysis

Course Objective
Curriculum

The objective of the Data Analysis Training program is to equip learners with the essential analytical, technical, and problem-solving skills required to interpret data and support informed business decisions. This course provides a strong foundation in data handling, statistical analysis, data visualization, and reporting using industry-standard tools and techniques.

Learners will gain hands-on experience working with Excel, SQL, Python (or other analytical tools), and visualization platforms to clean, transform, analyze, and present data effectively. The training emphasizes understanding data patterns, generating actionable insights, creating dashboards, and applying analytical methodologies used in real business environments.

By the end of the course, learners will be able to work confidently with structured and unstructured data, perform exploratory data analysis, build meaningful visual reports, and contribute to data-driven decision-making—preparing them for roles such as Data Analyst, Business Analyst, Reporting Analyst, and Analytics Professional across multiple industries.

Python

Python Basics (Data Types, Variables, Loops, Conditions)
File Handling
Exception Handling
Object-Oriented Programming (OOP)
Working with Libraries
Decorators and Generators
Regular Expressions
Python Comprehensions
Multithreading and Multiprocessing
Functions and Modules

NumPy

NumPy Arrays and Array Operations
Data Types and Attributes
Mathematical Functions and Operations
Broadcasting and Vectorization
Array Manipulation (Reshaping, Joining, Splitting)
Statistical and Random Functions
Linear Algebra with NumPy
NumPy I/O
Indexing, Slicing, and Iterating

Pandas

Pandas Data Structures (Series, Data Frame)
Data Cleaning and Preprocessing
Handling Missing Data
Data Aggregation and Grouping
Merging and Joining Data Frames
Pivot Tables and Cross-tabulation
Time Series Analysis
Data Visualization with Pandas
Indexing, Slicing, and Subsetting Data

Matplotlib

Basic Plotting (Line, Bar, Scatter Plots)
Subplots and Grids
Working with Colours and Styles
Plot Annotations
Advanced Plot Types (Histograms, Pie Charts, 3D Plots)
Interactive Plots
Exporting Plots to Files
Customizing Plots (Labels, Titles, Legends)

MySQL

Basic SQL Queries (SELECT, INSERT, UPDATE, DELETE)
Aggregate Functions (SUM, AVG, COUNT)
Indexing and Query Optimization
Stored Procedures and Triggers
Transaction Management
Backup and Restore
Connecting MySQL with Python
Joins (INNER, LEFT, RIGHT, FULL)

MongoDB

MongoDB Basics (Databases, Collections, Documents)
Indexes and Aggregation Framework
Working with Embedded Documents
Schema Design and Data Modelling
Querying and Filtering Data
Connecting MongoDB with Python
CRUD Operations in MongoDB

DATA DEFINITION using SQL

Manage Databases
MySQL Data Types
MySQL CREATE TABLE
MySQL Primary Key
MySQL Foreign Key
MySQL Sequence
MySQL INT Data Type
MySQL DECIMAL Data Type
MySQL DATE Data Type
MySQL TIME Data Type
MySQL DATETIME Data Type
MySQL ALTER TABLE
MySQL RENAME TABLE
MySQL ADD COLUMN
MySQL DROP TABLE
MySQL Temporary Table
MySQL Table Types

Basic Data Manipulation using SQL

SQL Functions

SQL Avg()
SQL First()
SQL Last()
SQL Max()
SQL Min()
SQL Sum()
SQL Group By
SQL Having
SQL Ucase()
SQL Lcase()
SQL Mid()
SQL Len()
SQL Round()
SQL Now()
SQL Format()
SQL Count()

MYSQL STORED PROCEDURES

MySQL Stored Procedures Introduction
MySQL Stored Procedure Variables
MySQL Stored Procedure Parameters
MySQL Stored Procedures – Return Multiple Values
MySQL IF Statement
MySQL CASE Statement
IF vs. CASE
MySQL Loop Statements
MySQL Cursor
MySQL Stored Procedures Listing
MySQL Error Handling
MySQL Stored Procedures – Raising Error Conditions
MySQL Stored Function
MySQL Stored Procedures Getting Started

Introduction to SQL Trigger

MySQL Triggers Implementation
Managing Triggers in MySQL
Create Multiple Triggers For The Same Trigger Event And Action Time
Working with MySQL Scheduled Event
Modifying MySQL Events
Create Trigger in MySQL

MYSQL VIEWS

Introduction to Database View
MySQL CREATE VIEW
MySQL Views & WITH CHECK OPTION
Creating MySQL Updatable Views
Views in MySQL

Alexzender Alex

CSE Teacher

Sed ut perspiciatis unde omnis iste natus error sit voluptatem accusa dolore mque laudantium totam rem aperiam eaqipsa quae ab illo inventore veritatvolup tatem quia voluptas sit aspernatur aut odit aut fugit sed quia conseque.

Nathaniel Bustos

Manager

Latanya Kinard

Web Designer

Where Our Alumini Works