A i Using Python
A i Using Python
Python
Python Duration: 6 Months
Introduction To Python
l Why Python
l Application areas of python
l Python implementations
l Cpython
l Jython
l Ironpython
l Pypy
l Python versions
l Installing python
l Python interpreter architecture
l Python byte code compiler
l
String Handling
l What is string
l String representations
l Unicode string
l String functions, methods
l String indexing and slicing
l String formatting
Python List
l Creating and accessing lists
l Indexing and slicing lists
l List methods
l Nested lists
l List comprehension
Python Tuple
l Creating tuple
l Accessing tuple
l Immutability of tuple
Python Set
l How to create a set
l Iteration over sets
l Python set methods
l Python frozenset
Python Dictionary
l Creating a dictionary
l Dictionary methods
l Accessing values from dictionary
l Updating dictionary
l Iterating dictionary
l Dictionary comprehension
Python Functions
l Defining a function
l Calling a function
l Types of functions
l Function arguments
l Positional arguments, keyword arguments
GUI Programming
l Introduction to Tkinter Programming
l Tkinter Widgets
l Layout Managers
l Event handling
l Displaying image
Multi-Threading Programming
l Multi-processing v/s Multi-threading
l Need of threads
l Creating child threads
l Functions /methods related to threads
l Thread synchronization and locking
SQL Basic
l DDL: Create, Alter, Drop, etc.
l DML: Insert, Update, Delete ,etc.
l DQL : Select
l Autoincrement field
l SQL Comments
l SQL Aliases
Savepoint & rollback
SQL Constraints
Not NULL, Unique key
Primary key, Check
Default, Foreign key
SQL Operators
Arithmetic operators
Logical operators
Conditional operators
Like, between, in operators
SQL Clauses
Order by
Where
Limit/top
Group by
having
SQL Joins
Inner Join
Left Join
Right Join
Full Join
SQL View
creating view
updating view
fetching data from view
SQL Functions
String functions
Aggregate functions
Date & time functions
Stored Procedures & Functions
Understanding stored procedures and their key benefits
Working with stored procedures
Studying user-defined functions
Working with CSV Files:
How to write result to csv file
How to read csv file
Python Database Connectivity
Database Drivers and connectors
Creating connection object
Understanding cursor object
Executing SQL statements using cursor
Fetching records from cursor
Storing and retrieving Date and Time
MONGODB
Introduction To MongoDB
Understanding NoSQL DB
NoSQL vs. SQL DB
Understanding Mongo DB
Downloading & Installation
Introduction of MongoDB shell and Compass
Understanding database, collection & document
Crud Operations
Insert Document
Delete Document
Update Document
Query Document
Operators In MongoDB
Query and Projection operators
Update operator
Aggregation Pipeline operators
Methods In MongoDB
limit and sort
bulk methods
other methods
Indexing And Relationships
Types of Indexes
Creating an Indexes
Dropping an Indexes
Defining Relationships between Documents
Python Connectivity With MongoDB
Introduction to pymongo
Installing pymongo module
MongoClient
Getting database and collection
CRUD operations
Range Queries
l Harmonic mean
l
Geometric mean
l Mode
l Quartile
l
First quartile
l
Second quartile(median)
l
Third quartile
l Standard deviation
Probability Distributions
l Introduction to probability
l Conditional probability
l Normal distribution
l Uniform distribution
l Exponential distribution
l Right & left skewed distribution
l Random distribution
l Central limit theorem
l
Hypothesis Testing
l
l Normality test
l Mean test
l T-test
l Z-test
l
ANOVA test
l Chi square test
l Correlation and covariance
Numpy Package
l Difference between list and numpy array
l Vector and matrix operations
l Array indexing and slicing
Pandas Package
Introduction to pandas
l Labeled and structured data
l Series and dataframe objects
How to load datasets
l From excel
l From csv
l From html table
Accessing data from Data Frame
l at & iat
l loc & iloc
l head() & tail()
Exploratory Data Analysis (EDA)
l describe()
l groupby()
l crosstab()
l boolean slicing / query()
Data Manipulation & Cleaning
l Map(), apply()
l Combining data frames
l Adding/removing rows & columns
l Sorting data
l Handling missing values
l Handling duplicacy
l Handling data error
Handling Date and Time
Data Visualization using matplotlib and seaborn packages
l Scatter plot, lineplot, bar plot
l Histogram, pie chart,
l Jointplot, pairplot, heatmap
l Outlier detection using boxplot
Machine Learning
Introduction To Machine Learning
l Traditional v/s Machine Learning Programming
l Real life examples based on ML
l Steps of ML Programming
l Data Preprocessing revised
l Terminology related to ML
Supervised Learning
l Classification
l Regression
Unsupervised Learning
l Clustering
KNN Classification
l Math behind KNN
l KNN implementation
l Understanding hyper parameters
Performance metrics
l Math behind KNN
l KNN implementation
l Understanding hyper parameters
Regression
l Math behind regression
l Simple linear regression
l Multiple linear regression
l
l Polynomial regression
l Boston price prediction
l Cost or loss functions
l Mean absolute error
l
Least square error
l Regularization
Logistic Regression for classification
l Theory of logistic regression
l Binary and multiclass classification
l Implementing titanic dataset
l Implementing iris dataset
l Sigmoid and softmax functions
Open CV
l Reading images
l Understanding gray scale image
l Resizing image
l
l Understanding haar classifiers
l Face, eyes classification
l How to use webcam in open cv
l Building image data set
l Capturing video
l Face classification in video
l Creating model for gender prediction
l AlexNet
l VGG16
l ResNet50
l Yolo algorithm
Word Embedding
l What is word embedding?
l Word2vec embedding
l CBOW
l Skipgram
l
l Number Plate Recognition
l Gender Classification
l My Assistant for Desktop
l Cat v/s Dog Image Classification
+91 7042175774
+91 9810851363