Data Analyst Course:
Objective:>Understanding Python Programming & Data Analysis Process
>Working on transforming and modeling data .
Who can attend?
>Freshers seeking career in Python/Data Analytics.
>Proffessions with Programming background.
>Working/experienced who want to explore on Data.
Complete Syllabus:
MODULE1: PYTHON BASICS
Introduction to Python
Variables, keywords and Data types
Operators
Control Statements
Lists
Tuple
Sets
Dictionary
Functions
Strings
Arrays
MODULE2: PYTHON ADVANCED
Modules and Packages
Exception Handling
File Handling
Object Oriented Programming
Multi-Threading
Regular Expressions
GUI Programming-tkinter
MODULE3:SQL
CREATING OF TABLES
CREATING OF TABLES
DROPING & TRUNCATING OF TABLES
RENAMING OF TABLES
DATA MANIPULATION LANGUAGE
SELECT STATEMENS
JOINS
SUB – QUERIES
SINGLE – ROW FUNCTIONS
ADVANCE SUB-QUERIES
DATA CONTROL LANGUAGE
TRANSACTION CONTROL LANGUAGE
CONTSTRAINTS
SET OEPRATORS
MUTLITALE INSERT SELECT STATEMENTS
ENHANCE MENT TO GROUP BY CLAUSE
ANALYTICAL FUNCTIONS
VIEWS
INDEXES
SEQUENCES
SYNONYMS
WITH STATEMENTS
MODULE4: TABLEAU
MODULE5: ADVANCED EXCEL
MODULE6: PROJECT WORK