VADAPALANI
Data Analysis
PYTHON
1. Introduction to python
1. History of python
2. overview of python
3. Applications and Features of Python
2. Identifiers, Variables and Keywords
1 Identifiers and rules of identifiers
2 Keywords and How to fetch keywords
3 Variables
4 Memory management in variable
3. Datatypes
1. individual /single-value
Int
Float
Boolean
Complex
VADAPALANI
2. collection /container
String and all the string methods
List and all the list methods
Tuple and all the tuple methods
Set and all the set methods
Dictionary and all the dictionary
methods
4. Type casting
5. Operators
6. . Input, Print Statements and formatting string
1 Input function
2 print function
3 types of formatting string
7. control statements
1. conditional statements
If
If-else
If-elif
Nested if
VADAPALANI
2. looping statements
While
For
3. Loop control statements (break,
continue and pass)
8. inbuild methods in python
[Link] games by using python libraries
[Link]
1. Return keyword and examples
2. Types of arguments
3. Packing and unpacking
[Link]
11. Iterator and Generators
1 Iterator
2 Generators
3 next()
VADAPALANI
12. Comprehension
1 Comprehension and Types
2 List Comprehension and examples
3 set Comprehension an examples
4 Dictionary Comprehension and examples
13. advance concepts
1 lambda
2 map
3 filter
[Link]
1. class
2. objects
3. inheritance
4. polymorphisam
[Link]
[Link]
15.file_handling
16.exception_handling
17. Multithreading
VADAPALANI
1 Definition
2 Why multithreading
3 Examples.
18. Database
connection
[Link]
1 Pandas
1. Data series
2. Data frames
3. Data cleaning
4. Data aggregation
[Link] engineering
6. Time series data
7. Paralle processing
[Link]
1. Numpy arrays
2. Indexing and slicing on array
3. Array operations
[Link]
[Link]
[Link]-connector
[Link]
VADAPALANI
[Link]
[Link]
[Link]
[Link]
11. Statistics
1. Descriptive statistics
2. Sampling
3. Frequency destributions
4. Mean,Mode,Median
[Link],Standard deviation,Bessel’s
correction
12. Probability theory
1. Estimating probability
2. Addition rule
3. Permutation and combinations
13. Visualization
1. Matplotlib
2. Seaborn
VADAPALANI
SQL
1. Introduction to sql
Sql and features of sql
History of sql
Data
Database
2. Database Management System(DBMS)
1. Advantages s Disadvantages of DBMS
2. Types of DBMS
Hierarchical DBMS
Network DBMS
Object oriented DBMS
Relational DBMS
3. Relational Model
4. Rules of E.F CODD
VADAPALANI
5. Datatypes
1. char
2. varchar/varchar2
[Link]
4. date
5. Large object’s
Character large objects(CLOB)
Binary large objects (BLOB)
6. Constraints
1. unique
2. not null
3. check
4. primary key
5. Foregin key
7. overview of sql statements/languages/subsets
1. Data Query Language(DQL)
2. Data Definition Language(DDL)
3. Data Manupulation Language(DML)
VADAPALANI
4. Transaction Control Language(TCL)
5. Data Control Language(DCL)
8. Data Query Language
[Link]
[Link]
[Link]
Where clause
Group by clause
Having clause
Order by clause
[Link]
1. inbuilt function
o Single row function
Nvl
Substr
Instr
Length
Replace
Mod
Trunc
VADAPALANI
Months_between
Rank
Dense_rank
To_char
o Multi row function
Max
Min
Sum
Avg
count
2. user defined function
[Link]
TYPES OF JOINS
o Cross/cartesian join
o Inner/equi join
o Outer join
Left outer join
Right outer join
Full outer join
o Self join
o Natural join
VADAPALANI
[Link] Definition Language
1. create
o Table
o View
o Index
[Link]
3. Drop
4. Alter
[Link]
10. Data Manipulation Language
[Link]
2. update
[Link]
11. Transaction Control language
1. commit
[Link]
[Link]
VADAPALANI
12. Data Control Language
1. Grant
[Link]
13. pl/sql concepts
Procedure/stored procedure
Trigger
Cursors
Conditional statements
Case statement
POWER BI
EXCEL
Case studies and projects