Python + Data Science Syllabus

Credence IT Professional Training Institute

Tushar Kathalkar/ Yusuf Tamboli
📞+918237916162 📞+917385318590
📞+919766722458 📞+918275219894
[Link]
Address : Indira Heights, Survey no. 34/5, Radhe Sham Building, Mohan
Nagar, Dhankawadi, Pune, Maharashtra 411043
 Python
1: Introduction to Python
➢ Installation and Working with Python
➢ Understanding Python variables
➢ Python basic Operators
➢ Understanding python blocks
➢ Type casting, Unicode etc.
2: Python Data Types
➢ Declaring and using Numeric data types: int, float, complex, bool
➢ Using string data type and string operations
➢ Defining list and list slicing
➢ Use of Tuple data type

2
2
Python
3: Python Program Flow Control
➢ Conditional blocks using if, else and elif
➢ Simple for loops in python
➢ For loop using ranges, string, list and dictionaries
➢ Use of while loops in python
➢ Loop manipulation using: pass, continue, break
➢ Programming using Python conditional and loops block
4: Python String, List, set and Dictionary Manipulations
➢ Building blocks of python programs
➢ Understanding string in build methods
➢ List manipulation using in build methods
➢ Tuple operation
➢ Set manipulation 3
➢ Dictionary manipulation 3
 Python
5: Fundamentals of Object orientation:
➢ Class, Object
➢ Constructor
➢ Types of Variables
➢ Methods and its types
➢ Importing Class
➢ OOP’s Concepts: Inheritance, Encapsulation, Abstraction, Polymorphism
➢ File handling: text, binary, csv
➢ Exception handling: try, except, else, finally

4
4
 Data Science
6. Complete Data Science: 7. Pandas: (Data Analysis)
➢ NumPy: (Numerical Python) ➢ DataFrame and Series
➢ Introduction to Numpy ➢ DataFrame operations
➢ Datatypes of ndarrays ➢ Data Slicing, indexing
➢ Dealing with ndarrays, copies and views ➢ DataFrame functions
➢ Arithmetic operations, ➢ Reading the files- csv, excel
➢ Indexing , Slicing, splitting arrays ➢ Boolean filtering
➢ Shape manipulation ➢ Storing file in various formats
➢ Stacking together different data ➢ Useful DataFrame functions

5
5
 Data Science
Pandas: (Data Analysis) Matplotlib ( Data Visualization)
➢ Stats using pandas ➢ Introduction to Matplotlib
➢ Dealing with missing data ➢ Simple plotting
➢ Operations over the data ➢ Formatting the graph: colors, markers, line style, etc
➢ Customization
➢ Plotting with list, arrays, pandas
➢ Types: scatter plot, bar chart, pie chart, histogram

6
6
Python Advance
▸ Modules
▸ File Handling
▸ Exception Handling
▸ Regular Expression
▸ Python OOPs Concepts
▸ Polymorphism
▸ Multi Threading
▸ Python Database programming

7
7
IDE
▸ Pycharm
▸ Eclips
▸ Atom

8
8
Django

▸ Introduction To Web Development &

▸ MVT vs MVC & Config with IDE(Pycharm & ATOM)
▸ Development of First Web Application
▸ Template & Static Files
▸ Working with Models and database
▸ Working with Django Forms
▸ Working with Django Model Forms
▸ Working with Django Model Forms

9
9
Django
▸ Working with Advance Template Features
▸ Session Management
▸ User Authentication and Authorization
▸ Class Based Views
▸ CRUD operations by using both CBVs and FBVs
▸ Django ORM
▸ Working with Advanced Model Concepts
▸ Woking with Django Middleware
▸ Deployment of our application in LIVE Environment
▸ REAL TIME PROJECT
10
10
Oddo
▸ Introduction Of Odoo
▸ Install odoo particular version in IDE(Eclips)
▸ How to Create Custom module(py with xml)
▸ How to create deferent type fields.
▸ How to define all type of View and act-window
▸ Set access right in odoo
▸ Inherit and add fields to existing views and models in Odoo

11
11
 Oddo
▸ Model in works
a. Websites b. Sales c. Operation
• website builders • Sales ▪ Accounting
• E-Commerce • CRM ▪ HR
• Event • Invoicing ▪ Inventory
• Event management • Point of sale ▪ Purchases
▪ Manufacturing

12
12
SQL
➢ What is Data?
➢ What is Database?
➢ DBMS VS RDBMS?
➢ SQL statements
I. DDL
II. DML
III. DCL
IV. TCL

13
13
 SQL
SQL Operators SQL functions SQL constraints

➢ Arithmetic ➢ Aggregate ➢ Primary key

➢ Character ➢ Unique
➢ Comparison
➢ Date
➢ Check
➢ Logical
➢ Not null
➢ Set ➢ Number
➢ Default
➢ Like ➢ Foreign key
➢ Concatenation ➢ Composite key

14
14
 SQL
SQL joins Pseudo columns SQL clauses
➢ Inner join ➢ Rank() ➢ Where
➢ Left outer ➢ Dense_rank() ➢ Group by
➢ Right outer ➢ Rownum ➢ Having
➢ Full outer ➢ Rowid
➢ Order by
➢ Equi join
➢ Non equi join PLSQL
➢ Cross join ➢ Store procedures
➢ Self join ➢ Triggers
➢ Multiple table joins ➢ Views

15
15
 Data Warehousing – ETL + BI
Data Warehouse Concepts:
➢ Introduction of Analytical system , Data Warehouse and ETL Process
➢ Architecture/technical Flow/Data Flow/High level Design of data warehouse
➢ Differences between OLTP and OLAP.
➢ Normalization and De-Normalization.
➢ Difference between relational and dimensional modelling.
➢ Introduction of Fact table, Dimension table and It’s Types
➢ Surrogate Key
➢ Data Mapping Document

16
16
Data Warehousing - ETL + BI
Data Warehouse Concepts:
➢ Data Models:
a) Conceptual Model
b) Logical Model
c) Physical Model
➢ Star Schema, Snowflake Schema, Galaxy Schema
Business Intelligence :
➢ Introduction of BI tool Tableau
➢ Report Development

17
17
 Tools

1. SQL Developer
2. SQL server management studio
3. Visual studio +SSIS
4. Tableau

18
18
Post Course Completion Operations
➢ Technical interviews + HR interviews
➢ Resume building

19
19
Thanks !

20
20