Preview Python Certification Course in English

Back

Introduction to Python

Introduction to Coding and Programming Languages

Compilers and Interpreters

Introduction on Python and its advantages

Python Installation in Windows

Python IDE (Pycharm)

Basics of Python

First Program in Python

How to add Comments in Python

Creating variables in Python

Datatypes, User-Inputs - int(), float(), eval()

TypeCasting and subtypes

Problem Solving

Python Operators

Operators and Operands

Arithmetic Operators

Comparisional Operators

Logical Operators

Assignment Operators

Identity Operators

Bitwise Operators

Membership Operators

Conditional Statements

Introduction to Conditional Statements

Using if the Statement

Using if-else conditional Statement

Using if-elif-else conditional Statements

Nested if Statement

Short Hand if Statement

Short Hand if-else Statement

Problem Solving

Loops

Introduction to Loops and types

For Loop

For Loop with Conditional Statements

While Loop

While True

Nested Loops

Break and Continue Statement

Problem Solving (Part- 1)

Problem Solving (Part- 2)

Problem Solving (Part- 3)

Strings

String Functions 1

String Functions 2

String Functions 3

Slicing in Strings

Problem Solving 1

Problem Solving 2

Problem Solving 3

Lists

Introduction to Lists

List slicing

List iteration

List functions Part 1

List functions Part 2

Problem Solving

Tuples

Introduction to Tuples

Tuples slicing and iteration

Conversion of tuples to lists, and tuple functions

Problem Solving

Dictionaries

Introduction to Dictionaries

Iteration in Dictionaries

Dictionary functions (1)

Dictionary functions (2)

Nested Dictionaries

Problem Solving

Probem Solving Part 2

Sets

Introduction to Sets

set methods (1)

set methods (2)

set methods (3)

Problem Solving

Functions

Introduction to Functions

Parameters and Arguments

Return Statement and Recusrion in Functions

Lambda Function in Python

Local and Global Variables

Problem Solving

Modules

Introduction to Modules

In-built Modules

Creation of Modules

File Handling

Introduction to File handling

Read Files

Write Files

Append Files

Pickle Library in Python

Problem Solving

Mini Project (Hangman)

Mini Project (RPS Game)

Object Oriented Programming(OOP)

Introduction to Classes and Objects

Methods and Contructors in OOP

Inheritance in Python

Encapsulation in OOP

Getter and Setter in OOP

Polymorphism in Python

Problem Solving

JSON

JSON data in Python

Converting JSON to Python Objects

Converting Python Objects to JSON

Writing and Reading JSON file

Problem Solving

Python Exceptions

Python errors and Built-In Exceptions

Handling Exceptions in Python

Problem Solving

Python SQLite Database

DB creation and connection and Creation of a Table

DB browser for SQLite Installation

Storing Data in Database

Select Query, Order By and Limit

Deleting a Query

Updating a Query

Where Clause

Pyhton SQLite Join

Python MySQL

Installation of MySQL Connector

DB Creation and Connection

Datatypes in MySQL

Creation of a Table

Inserting a Query

Selecting a Query

Deleting a Query

Updating a Query

Order By and Limit in MySQL

MySQL Searching and Filtering

MySQL joins introduction

MySQL Inner Join

MySQL Left Join

MySQL Right Join

MySQL Equi Join

MySQL Self Join

Between Operator in MySQL

MIN() and MAX() Functions

MySQL Group By Statements

MySQL Distinct Keyword

MySQL SUM() Function

MySQL AVG() Function

MySQL COUNT() Function

MySQL IN or Not IN

Mini Project

Stack and Queue in Python

Regex in Python

Introduction to RegEx

Metacharacters in RegEx

Special Sequences in RegEx

Set in RegEx

RegEx Functions

Match Object in RegEx

Phone Number and Email Verification and Web Scrapping Using RegEx

Python CSV

Working with CSV files in Python

Reading CSV files in Python

Writing CSV files in Python

Mongo DB

Introduction to Mongo DB with python

Guide to Installation with Python

Creating a DataBase Using Mongo DB Python

MongoDB - insert_one and insert_many query Query

Python Mongo DB - Find

Python Mongo DB - Query

Python mongoDB - Sort

Delete Data and Drop Collection

Update-one and Update_many

Limit Query

Create_index Query

Drop Index query

Preview - Python Certification Course in English