Complete Python Course: Basics to Full Stack Development

Complete Python Developer Course: From Fundamentals to Full Stack

Master Python with our complete course from basic programming to full stack development. Learn application building, web scraping, and more. Enroll now!

Buy $74.95

Course curriculum

1. Learn Application Development using Python Effectively
1. Introduction to Windows for Python Beginners
2. Configuration of Windows Laptop or Desktop
3. Overview of Windows Control Panel and checking User Status
4. Overview of Installing Programs or Softwares on Windows
5. Uninstall Programs from Windows using Control Panel
6. Managing Windows Apps and Processes using Task Manager
7. Managing Background Processes using Services
8. Manage Taskbar on Windows
9. Important Windows Folders or Directories
10. Overview of Organizing Files View on Windows
11. Overview of Command Prompt and Powershell
12. Managing Sessions on Windows
13. Conclusion to Windows for Python Beginners
1. Setup Python on Mac or Windows
2. Quiz: Setup Python on Mac or Windows
1. Overview of Strings in Python
2. Quiz: Overview of Strings in Python
1. Arithmetic Operations using Python
2. Quiz: Arithmetic Operations using Python
1. Overview of IDEs and Setup VS Code on Mac and Windows
2. Quick Preview of VS Code for Development
3. Usage of VS Code for the lectures
4. Overview of Git integration with VS Code
5. Quiz: Overview of IDEs and Setup VS Code on Mac and Windows
1. Overview of Variables and Constants
2. Quiz: Overview of Variables and Constants
1. Overview of String Manipulation Functions in Python
2. Quiz: Overview of String Manipulation Functions in Python
1. User Defined Functions in Python
2. Solutions for User Defined Functions Exercises
3. Quiz: User Defined Functions in Python
1. Conditionals using Python - Part 1
2. Conditionals using Python - Part 2
3. Impact of Data Types on Conditionals
4. Quiz: Conditionals using Python
1. Solutions for Exercises on Conditionals
2. Develop Functions using Conditionals
1. Looping using for in Python
2. Looping using while in Python
3. Solutions for Exercises on Loop Constructs
4. Quiz: Looping using for and while in Python
1. Exception Handling in Python
2. Solution for Exercise related to Fibonacci Numbers
3. Quiz : Exception Handling in Python
1. Solution for Exercise related to Prime Numbers
2. Solution for Exercise related to Multiplication Table
3. Quiz : Solutions for Basic Programming Constructs
1. Develop First Python Program
2. Run Program with Run Time Arguments
3. Quiz : Develop First Python Program and Run with Run Time Arguments
1. Overview of Python Modules and Standard Libraries
2. Overview of Notebook Environment
3. Quiz : Overview of Python Modules and Standard Libraries
1. Understand the concept of collections
2. Overview of Python Core Collections
3. Solutions for Exercises related to Overview of Core Collections
4. Quiz : Overview of Python Core Collections
1. Common Python List Operations
2. Solutions for Exercises on Lists in Python
3. Quiz : Common Python List Operations
1. Common Python Set Operations
2. Solutions for Exercises on Sets in Python
3. Quiz : Common Python Set Operations
1. Common Python Tuple Operations
2. Solutions for Exercises on Tuples in Python
3. Quiz : Common Python Tuple Operations
1. Common Python Dict Operations
2. Solutions for Exercises on Dicts in Python
3. Quiz: Common Python Dict Operations
1. Python Practice using list of tuples
2. Solutions for Exercises related to list of tuples
3. Quiz: Python Practice using list of tuples
1. Python Practice using list of dicts
2. Solutions for Exercises related to list of dicts
3. Quiz: Python Practice using list of dicts
1. Comprehensions using Python
2. Solutions for Exercises on Python Comprehensions
3. Quiz: Comprehensions using Python
1. Lambda or Anonymous Functions in Python
2. Quiz: Lambda or Anonymous Functions in Python
1. Sorting Iterables or Collections in Python
2. Solutions for Exercies on Sorting in Python
3. Quiz: Sorting Iterables or Collections in Python
1. Additional Details about Python Functions - Part 1
1. Additional Details about Python Functions - Part 2
2. Solutions for Exercises on Python Arbitrary Arguments
3. Quiz: Additional Details about Python Functions
1. Date Manipulation using Python
2. Solutions for Python Date Manipulation Exercises
3. Quiz: Date Manipulation using Python
1. Generating random data using Python
2. Solution for Exercise on Generating random data
3. Quiz: Generating random data using Python
1. Processing list of delimited Strings - Part 1
1. Processing list of delimited Strings - Part 2
2. Solution for Exercise on Processing list of delimited strings
3. Quiz : Processing list of delimited Strings
1. Overview of yield and generators
2. Solution for Exercises on Python generators
3. Quiz : Overview of Yield and generators
1. Overview of Python Decorators
2. Real World Implementation of Python Decorators
3. Solution for Exercise on Python Decorators
4. Quiz : Overview of Python Decorators
1. Setup Required Data Sets in Files
2. Overview of Files and Folders
3. Quiz : Overview of Files as well as Folders
4. Quiz : Setup Required Data Sets in Files
1. Overview of File IO
2. Process Sales Data from files using File I O and Loops
3. Quiz : Process Sales Data from files using File I O and Loops
1. Process Sales Data from files using File I O and Loops - 2
2. Solution for Exercises on File IO using Python
3. Quiz : Process Sales Data from files using File I O and Loops - 2
1. Managing Files and Folders using Python
2. Solutions for exercises on Managing Files and Folders
3. Quiz : Managing Files and Folders using Python
1. Managing Python Libraries using pip
2. Quiz : Managing Python Libraries using pip
1. Key Concepts related to Data in Files and Objects
2. Overview of JSON Data and Files
3. Quiz : Overview of Json Data and Files
1. Processing JSON Files using json module - Part 1
1. Processing JSON Files using json module - Part 2
2. Solutions for Exercises on Processing JSON Data
3. Quiz: Processing JSON Files using Json module
1. Code Versioning and Getting Started with GitHub
2. Quiz: Code Versioning and Getting Started with GitHub
1. Getting Started with REST APIs
2. Quiz: Getting Started with REST APIs
1. Using Postman to Validate REST APIs
2. Quiz: Using Postman to Validate REST APIs
1. Processing REST Payloads using requests - Part 1
1. Processing REST Payloads using requests - Part 2
2. Solutions for Exercises on REST Payloads
3. Quiz: Processing REST Payloads using requests
1. Object Oriented Constructs using Python - Part 1
2. Object Oriented Constructs using Python - Part 2
3. Quiz: Object Oriented Constructs using Python
1. Exercises on Object Oriented Constructs using Python
2. Solutions for Exercises on Object Oriented Constructs
3. Overview of static and class methods
1. Getting Started with Unit Testing using Python
2. Quiz: Overview of Unit Testing using Python
1. Real World Example of Unit Testing using Python
2. Solution for Exercise on Unit Testing using Python
1. Overview of Database Technologies
2. Quiz: Overview of Database Technologies
1. Installing Postgres Database Server on Windows or Mac
2. Setup Postgres Application Database and Tables
3. Quiz: Installing Postgres Database Server on Windows or Mac
1. CRUD Operations using SQL
2. Solution for CRUD or DML Operations using SQL
3. Quiz: CRUD Operations using SQL
1. Database Connectivity using Python
2. Solution for Exercises related to Database Connectivity using Python
3. Quiz: Database Connectivity using Python
1. Overview of Database Programming using Python
2. Solution for Exercises on Database Programming
3. Quiz: Overview of Database Programming using Python
1. Load CSV Data from Files to Database Table
2. Solution for Exercise to Load CSV Data from files to Table
3. Quiz: Load CSV Data from Files to Database Table
1. Introduction to Overview of Python NumPy
2. Getting Started with NumPy
3. Common operations using NumPy
4. Array Creation using NumPy
5. Mathematical Operations using NumPy
6. Data Analysis using NumPy
7. Indexing and Slicing using NumPy
8. Linear Algebra using NumPy
9. Process Sales Data using NumPy
10. Exercise on Processing Data using Python NumPy
11. Solution on Processing Data using Python NumPy
12. Quiz : Overview of Python NumPy
1. Getting Started with Pandas
2. Solution for Exercise on Getting Started with Pandas
3. Quiz - Getting Started with Pandas
1. Process Sales Data from files using Pandas - Part 1
1. Process Sales Data from files using Pandas - Part 2
2. Solution for Exercise on Process Data from files using Pandas
3. Quiz - Process Sales Data from files using Pandas
1. File Format Conversion using Pandas
1. File Format Conversion using Pandas - Part 2
2. Solution for Exercise on File Format Conversion using Pandas
3. Quiz - File Format Conversion using Pandas
1. Process JSON Data using Pandas
2. Solution for Exercise on Processing JSON Data using Pandas
3. Quiz - Process JSON Data using Pandas
1. Database Programming using Pandas
2. Solution for Exercise on Database Programming using Pandas
3. Quiz : Database Programming using Pandas
1. Overview of Performance Tuning
2. Overview of Multiprocessing or Multithreading Concepts
3. Getting Started with Multiprocessing in Python
4. Quiz : Overview of Multi Processing
1. File Format Conversion using Multiprocessing
2. Solutions for Exercise on Multiprocessing for NYSE File Format Conversion
1. Overview of Data Processing using dask
2. Quiz : Overview of Data Processing using dask
1. File Format Conversion using dask
2. Solution for the Exercise on Data Processing using dask
1. Getting Started with Python Applications and Virtual Environments
2. Setting up Project and Integrating with Git
1. Exercise to setup a Python Project
2. Solution for Exercise on Setting up Python Project
1. Overview of Driver Program and Important Git Commands
2. Solution for the Exercise on Adding Driver Program
1. Add Core logic to Driver Program File
2. Solution for Exercise on Driver Program in Python
1. Overview of Environment Variables
2. Application Development using Environment Variables
3. Solution for Exercise on Development using Environment Variables
4. Quiz : Overview of Environment Variables
1. Enhance Application using git branch
2. Solution for Exercise on Enhancing Application using git branch
1. Software Development Life Cycle and Environment Variables
1. Concepts behind application logging
2. Build reliable applications using logging
3. Quiz : Overview of application logging
1. Add logging to Python Applications
2. Solution for the Exercise on Adding logging to Python Application
1. Build Packages and Executables using Setup Tools
1. Build Package and Executable for File Format Converter
2. Solution for Exercise on Executable using setup tools
1. Setup Ubuntu 22 using wsl on Windows 11
2. Develop Shell Script to run File Format Converter
3. Solution for Exercise on Shell Script to run Python Application
1. Overview of Data Visualization using Pandas
2. Quiz : Overview of Data Visualization using Pandas
1. Real time examples of Visualization using Pandas
2. Solution for Exercise on Data Visualization using Pandas
1. Setup MongoDB Community Database Server on Windows
2. Setup MongoDB Community Database Server on Mac
3. Manage MongoDB Community Database Server on Windows
4. Manage MongoDB Community Database Server on Mac
1. Note about Signing up for Sendgrid
2. Getting Started with Sendgrid
3. Overview of Sendgrid review process
4. Quiz : Getting Started with Sendgrid
1. Sending emails using Sendgrid Python Library
2. Solution for Exercise related to Sending Emails using Python
1. Start MongoDB Community Database Server on Mac or Windows
2. Generate Test Data using Faker
3. Solution for Exercise related to Pandas and Mongodb
4. Quiz : Generate Test Data using Faker
1. Sending Emails via Sendgrid using Python
2. Solution for exercise to send emails
3. Quiz : Sending Emails via Sendgrid using Python
1. Overview of the Application and Setup Project
2. Run and Validate Application to send emails
3. Stop MongoDB Community Database Server on Mac or Windows
1. Introduction to Web Scraping using Python Libraries
2. Overview of Web Scraping using Python
3. Getting Started with BeautifulSoup4
4. Overview of HTML
5. Process HTML using BeautifulSoup
6. Extract URLs from HTML
7. Use requests to read HTML Page
8. Parse and Process Web Page using BeautifulSoup
9. Exercise to get Wiki Pages URLs from NFL Wiki Page
10. Solution to get Wiki Pages URLs from NFL Wiki Page
11. Quiz : Web Scraping using Python Libraries
1. Introduction to Analyzing HTML Table Data using Pandas
2. Validate the installation of Pandas
3. Understand NFL Data in HTML
4. Analyze HTML Data using Pandas
5. Limitations of using Pandas HTML APIs
6. Integration of BeautifulSoup and Pandas
7. Integration of BeautifulSoup and Pandas
8. Exercise on Analyzing HTML Data using Pandas
9. Solution on Analyzing HTML Data using Pandas
10. Quiz : Analyze HTML Data using Pandas
1. Introduction to Getting Started with Scrapy
2. Install Scrapy for Web Scraping
3. Review the Code of the first spider
4. Run and Validate the Application
5. Review Website to be Scraped
6. Create Spider to read quotes
7. Update logic to get urls for authors or titles
8. Overview of Writing Data to json
9. Exercise to Get URLs from Wiki Page
10. Solution to Get URLs from Wiki Page
11. Quiz : Getting Started with Scrapy
1. Introduction to Exploring Scrapy using scrapy shell
2. Getting Started with scrapy shell
3. Overview of fetch and response
4. Read blog post titles using scrapy shell
5. Read text and attribute values using scrapy shell
6. Explore Quotes Content using scrapy shell
7. Exercise to get all author or title names using scrapy shell
8. Solution to get all author or title names using scrapy shell
9. Quiz : Exploring Scrapy using scrapy shell
1. Introduction to Building Scraping Pipelines using Scrapy
2. Review Official Documentation of Scrapy
3. Setting up Project using Scrapy CLI
4. Review Scrapy Project Folder Structure
5. Add Spider to the Scrapy Project
6. Update Scrapy Settings to write to json file
7. Run and Validate the Scrapy Project
8. Exercise to Scrape Data to JSON Files
9. Solution to Scrape Data to JSON Files
10. Quiz : Build Scrape Pipelines using Scrapy
1. Introduction to Building Pipelines using Scrapy and Mongodb
2. Validate Mongodb Database Setup
3. Overview of Scrapy Pipelines
4. Overview of using hash code for quote text
5. Update Spider Logic to include hash code
6. Get MongoDB Connectivity Information from settings
7. Methods to manage Mongodb Connectivity
8. Develop logic to insert into Mongo Database
9. Update settings with Scrapy Pipeline details
10. Quiz : Build Scrape Pipelines using Mongodb
1. Run the Scrapy Pipeline to write to Mongodb
2. Validate Data in Mongodb Collection
3. Exercise to include Page urls in Mongo Collection
4. Solution to include Page urls in Mongo Collection
1. Getting Started with Web or Mobile Application Development
2. Create Flask SQL Alchemy Model
3. Overview of sqlite Database
4. Quiz : Web or Mobile Application Development
1. Overview of Flask Shell and Database Operations
2. Setup GitHub Repository for the Application
3. Solution for Exercise to Get Started with Flask
1. Overview of HTML and CSS
2. Quiz : Overview of HTML and Bootstrap
1. Overview of Bootstrap and Java Script
2. Solution for Exercise on HTML and Bootstrap
1. Getting Started with Jinja Templating
2. Quiz : Overview of Jinja Templating and Bootstrap
1. Integration of Jinja Templating with Database Tables
2. Solution for Exercise on Jinja Templating and Bootstrap
1. Setup Postgres 15 Database Server
2. Overview of Database Integration with Flask
3. Integrate Flask Application with Postgres Database
4. Solution for Exercise on Flask and Posgres Integration
5. Push Postgres Integration changes to GitHub
6. Quiz : Integrate with Postgres Database using SQL Alchemy
1. Overview of SDLC and Controlled Environments
2. Provision Virtual Machine using GCP
3. Review Python Version and understand VM States
4. Overview of GCP Billing - Must Watch
5. Quiz : Provision Virtual Machine using GCP
1. Setup Postgres Database using Elephant SQL
2. Solution for Exercise on Postgres Database using Elephant SQL
3. Quiz : Setup Postgres Database using Elephant SQL
1. Overview of Deployment Process and Different Environments
2. Overview of Application Development Process
3. Key Concepts to access applications
4. Reviewing IP Addresses of a given server
5. Overview of Ports
6. Review Ports using Virtual Machine
7. Deployment Process of Applications
1. Setup gunicorn and nginx to deploy the Application
2. Solution for Exercise on Setup gunicorn and nginx
3. Setup Database Tables in Elephant SQL Postgres
4. Quiz : Setup gunicorn and nginx to deploy the Application
1. Introduction to Overview of CICD using GitHub Actions
2. Recap of Software Development Life Cycle
3. Setup Git Repo for CICD Demos
4. Review GCP Virtual Machine to Deploy the Application
5. Review Manual Deployment Process of Python Application
6. Getting Started with GitHub Actions
7. Update GitHub Workflow file to run Python Application
8. Push Changes and Review Action run
9. Exercise for Getting Started with GitHub Actions
10. Solution for Exercise on GitHub Actions
11. Quiz : Overview of CICD using GitHub
1. Runtime Internals and Deployment Process of GitHub Actions
2. Overview of GitHub Repository Variables
3. Create GitHub Repository Secrets
4. Run Commands on VM using SSH
5. Validate GitHub Action and VM Integration
6. Copying files to the Virtual Machine using scp
7. Copying files to the Virtual Machine using rsync
8. Deploy Demo App on to the VM using GitHub Action
9. Exercise on Deploying Applications using GitHub Actions
10. Solution for Deploying Applications using GitHub Actions
11. Quiz : GitHub Repository Variables and Secrets
1. Introduction to CICD Pipelines using GitHub Actions
2. Make Changes to the Application
3. Setup supervisor on GCP VM
4. Create env file on VM with Database Credentials
5. Shell Script to Build and Run the Application
6. Update GitHub Action Workflow File
7. Next Steps for building CICD Pipeline
1. Define Supervisor Configuration File
2. Getting Started with Supervisor and Gunicorn Integration
3. Merge Changes to Main Branch and Validate GitHub Action
4. Cleanup CICD Demo Application
5. Exercise on Building CICD Pipeline for sales app
6. Review current status of Sales App GitHub Repository
7. Make required application changes locally
8. Add env and supervisor config files on Remote VM
9. Update Workflow and Validate Application
10. Quiz : CICD Pipeline using GitHub Actions
1. Introduction to reorganizing the routes in the flask app
2. Overview of Modularizing Flask Code
3. Cleaning up Stale branches from Git Repository
4. Checkout new branch to modularize Flask routes
5. Modularize Flask Routes for Users
6. Validate Modularized Flask App Locally
7. Validate Modularized App on Remote VM
8. Exercise to Modularize Flask Routes for Courses
9. Solution for Modularizing Flask Routes for Courses
10. Quiz : Reorganizing the routes in the flask app
1. Introduction to Managing Code Versions using Git CLI Commands
2. Reviewing Git Commits
3. Overview of Managing Git Commits
4. Overwrite latest main version with past commit
5. Overwrite latest main version with past branch
6. Check Details of specific git commit
7. Move forward to future commits using merge
8. Exercise to reset and redo for git repos
9. Solution to reset and redo for git repos
10. Quiz : Managing Code Versions using Git CLI Commands
1. Introduction to Developing GET API with Database Integration
2. Overview of CRUD Operations
3. Checkout new git branch for changes
4. Update route to get user details
5. Create user detail page using GET
6. Validate user detail page
7. Using Parameters for GET
8. Validate CICD Pipeline using GitHub Actions
9. Exercise to develop GET API with Database Integration
10. Solution to develop GET API with Database Integration
11. Quiz : Develop GET API with Database Integration
1. Introduction to Develop POST API using Flask
2. Develop HTML Form for POST API
3. Update Application to render HTML Form
4. Validate Application with HTML Form
5. Add Functionality to Save form data
6. Validate Application to save form data
7. Validate Application to save form data
8. Exercise to Insert Course Details using POST API
9. Solution to Insert Course Details using POST API
10. Quiz : Insert Data into Database Table using POST API
1. Introduction to Updating Data in Table using POST API
2. Update user detail HTML page
3. Update user form HTML Page
4. Review logic to update data using flask shell
5. Add update user logic to the application
6. Review Changes and Run the Application to validate
7. Validate CICD Pipeline using GitHub Actions
8. Exercise to add Update logic to Flask Application
9. Solution to add Update logic to Flask Application
10. Quiz : Update Data in Database Table using POST API
1. Introduction to Deleting Data using GET API
2. Overview of Implementing Delete logic
3. Update user detail HTML page for Deletion
4. Update Application with Delete user logic
5. Review Changes for User Delete
6. CICD Pipeline with Delete Functionality
7. Exercise to Delete Course Details
8. Solution to Delete Course Details
1. Introduction to Getting Started with Generative AI and Chat GPT
2. Signing up for Chat GPT
3. Understanding Chat GPT Interface
4. Overview of Generative AI
5. Add Nav Bar to the Application
6. Link to User Detail Page from Dashboard
7. Button to User Form Page from Dashboard
8. Exercise to add features using Chat GPT
9. Solution for Adding features using Chat GPT
10. Solution for Adding features using Chat GPT
11. Quiz : Getting Started with Generative AI and Chat GPT
1. Introduction to Adding Search Functionality using Chat GPT
2. Overview of Search Functionality
3. Overview of Filtering using SQL
4. Best Practices to save data in the table
5. Equal Search of user by email id
6. Pattern based search of user by email id
7. Exercise to to add search functionality to courses
8. Solution to add search functionality to courses
9. Fix search bar and button in users dashboard
10. Solution to add search functionality to courses
11. Quiz : Add Search Functionality using Chat GPT
1. Introduction to Troubleshooting Python Flask Applications
2. Overview of Troubleshooting Issues
3. Overview of Generating Logs in Flask Application
4. Review Supervisor and Gunicorn logs on Servers
5. Extract SQL Queries using Flask SQLAlchemy
6. Log Message for User Not Found
7. Exercise to log message for course not found
8. Solution to log message for course not found
9. Fix Issues in the Application based on the review
10. Quiz : Troubleshooting Python Flask Applications
1. Introduction to Validation Application using Flask Shell
2. Validate Database Operations using Flask Shell
3. Overview of Validating REST APIs using Flask Shell
4. Validate Insert Functionality using POST API
5. Validate Update Functionality using POST API
6. Validate Delete Functionality using GET API
7. Exercise to make API Calls using Flask Shell
8. Solution to make API Calls using Flask Shell
9. Quiz : Validate Application using Flask Shell
1. Introduction to Develop REST API Server using Flask
2. Setup Flask Project for REST APIs
3. Install Dependencies and Setup env file
4. Integrate Flask REST Application with Database
5. Flask for REST API Development
6. Core Functionality for users endpoint
7. Develop GET API for users
8. Exercise to Develop API for courses
9. Solution to Develop API for courses
10. Quiz : Develop REST API Server using Flask
1. Introduction to Add new APIs to Flask REST API Server
2. Add GET API for user
3. Add POST API to add new user
4. Add POST API to update existing user
5. Add DELETE API to delete existing user
6. Exercise to Develop REST APIs for Course
7. Solution to Develop REST APIs for Course
8. Quiz : Develop REST API Server using Flask
1. Exercise to setup CICD for Flask Application
2. Setup Git Repo for the project
3. Review GitHub Action and Application Logs
4. Setup Supervisor Configuration File and env
5. Validate REST APIs using curl
6. Setup GitHub Repo with Secrets
7. Add GitHub Action or Workflow
8. Reset Changes for CICD Pipeline
1. Introduction to Validate REST APIs
2. Create Postman Collection with GET API for users
3. Add GET and DELETE requests for user
4. Add POST request for Insert and Update of User
5. Invoke GET and DELETE API using requests
6. Invoke POST API using requests
7. Exercise to Validate REST APIs using Courses
8. Solution to Validate REST APIs using Courses
9. Quiz : Validate REST APIs using Postman and requests
1. Introduction to Generating API Docs for Flask Application using Chat GPT
2. Exploring Python Flask Swagger Libraries
3. Getting Started with flasgger for API docs
4. Generate API Docs using flasgger doc strings
5. Generate API Docs for User Endpoints
6. Exercise to Generate API Docs for Course Endpoints
7. Solution to Generate API Docs for Course Endpoints
1. Introduction to Generate Test Data for users
2. Review User Model and Rest Tables
3. Install Faker in Notebook Environment
4. Validate POST request to add user
5. Generate Test Data for Users using Faker
6. Populate Test Data into Table using POST Requests
7. Exercise to Populate Test Data using Remote Application
8. Solution to Populate Test Data using Remote Application
1. Introduction to Performance Tuning of SQL Queries
2. Order of Execution of SQL Queries
3. Generating Explain Plan for SQL Queries
4. Interpreting Explain Plan for SQL Queries
5. Overview of Indexes on Database Tables
6. Different Index Scans based on Queries
7. Generate Explain Plans for Application Queries
8. Push Changes to GitHub to log SQL Queries
9. Exercise on Generating Explain Plans
10. Solution on Generating Explain Plans
1. Introduction to Indexes on Database Tables
2. Review Data in Database Table
3. Overview of Database Object Metadata
4. Implicit Index for Constraints on Database Tables
5. Purpose of Index for Constraiints
6. Manage Indexes on Database Tables
7. Relationship between Table and Indexes
8. Indexes for Performance Tuning
9. Exercise for Indexes on Database Tables
10. Solution for Indexes on Database Tables
1. Introduction to Performance Testing and Tuning
2. Use case for Performance Testing
3. Create a new API for orders
4. Validate API for orders
5. Performance Testing of the API for orders
6. Performance Testing of the SQL Queries for orders
7. Review Explain Plan and Fix the issue
8. Retest the performance of Order API
1. Exercise on Performance Testing and Tuning of Applications
2. Create Flask SQLAlchemy Model for Order Items
3. Develop Code for Order Item Endpoint
4. Performance Testing of Order Item Endpoint
5. Fix the issue and reevaluate the performance
6. Push Changes to GitHub repository
7. Setup Dataset and Validate the new APIs
1. Introduction to Performance Tuning of POST Requests
2. Review Application Architecture
3. Performance Testing of POST requests
4. Troubleshoot to identify bottleneck
5. Fix the Performance of POST by adding new API
6. Deploy Changes to GCP VM
7. Retest the performance using POST on users
8. Conclusion for Performance Tuning Tasks for POST Requests
1. Exercise for Performance Tuning of POST Requests
1. Introduction to Pagination for REST GET APIs
2. Overview of Pagination
3. Additional Parameters and Attributes for Pagination
4. Develop logic to read page token and page size
5. Implement Core logic for pagination
6. Add logic to return payload with pagination attributes
7. Validate users API with pagination
8. Process all the users data using pagination
9. Deploy Changes to Remote VM using GitHub Action
1. Exercise on pagination for orders
1. Introduction to Getting Started with Streamlit
2. Overview of Reports and Dashboards
3. Getting Started with Streamlit
4. Generate Test Data for basic report
5. Build Streamlit Table using Test Data
6. Build Streamlit Line Chart and Bar Chart using Test Data
7. Exercise to Build Streamlit Line and Bar Charts
8. Solution to Build Streamlit Line and Bar Charts
9. Add Sidebar to the Streamlit App using Chat GPT

About this course

$74.95
610 lessons
73.5 hours of video content

Ready to dive into mastering Python?

Start Mastering Python!

Pre-requisites

Here are the pre-requisites to take this guided program on Python for beginners. You need to meet these pre-requisites for effective learning of the course.

A Computer with at least 8 GB RAM
Passion to learn coding with continuous effort
High speed Internet to access the course content.

FAQ

Why Should I Master Python?

Python is a simple yet powerful programming language used in many different areas. Whether you're interested in making websites, analyzing data, automating tasks, or working with artificial intelligence, Python can help you get started. Learning Python is a great first step toward a fulfilling career in technology.
What Will I Learn in this course?

In this course, you'll start with the basics of Python, learning about different kinds of data, how to store information in variables, and how to make your programs make decisions and repeat actions. Then, you'll move on to more complex topics like working with files, dealing with unexpected events, processing JSON data, connecting to web services, and gathering information from the internet. By working on real projects, you'll apply what you've learned. These projects range from converting file types and sending emails to extracting information from websites to store in a database, creating a complete web application, and setting up a server to handle API requests.
Which Python Libraries are covered in the course?

This course introduces essential Python libraries crucial for application development. You'll explore Pandas and Dask for data analysis and visualization, use requests for REST API interactions, and employ Sendgrid for email dispatch. Additionally, you'll learn to manipulate databases with Psycopg2 and PyMongo, scrape websites using BeautifulSoup and Scrapy, and develop web applications and REST APIs with Flask and SQLAlchemy. The course also covers key Python core modules like json, csv, multiprocessing, logging, and unittest, providing a comprehensive toolkit for your programming endeavors.
What other tools and technologies are covered as part of the course?

In addition to Python, this course delves into various other crucial tools and technologies. You'll learn SQL with Postgres and use MongoDB for NoSQL or document-based databases. The course includes training on Git CLI and GitHub for code versioning and CI/CD pipelines, and introduces Visual Studio Code as the IDE for Python development. You'll also practice exploring REST APIs using Postman and Curl. Beyond these tools, the course extensively addresses performance tuning and troubleshooting methods, equipping you with a well-rounded skill set for tackling diverse challenges in development.
Who Should Take This Course?

This course is ideal for individuals with little or no prior programming experience who want to learn Python from scratch. If you're interested in data manipulation, web development, automation, or just want to understand the world of coding, this course is for you.
How can I get support for the course?

You can get chat-based support anytime or request on-demand live support to address technical issues and clear up any doubts.
What about Placement Assistance?

Boost your career with our placement assistance! We help polish your LinkedIn profile, create a professional resume, offer job search tips, and provide mock interviews with feedback to prepare you for success.

Instructor(s)

Program Director Durga Gadiraju

Durga Gadiraju is a well-known IT Instructor covering a vast array of topics such as Application Programming, Data Engineering, Cloud, etc. He has 20+ years of IT Experience serving several Fortune clients.

Session 001 - Instructor Message

Session 002 - Understanding Windows for Python Beginners

Session 003 - Setup Python on Mac or Windows

Session 004 - Overview of Strings in Python

Session 005 - Arithmetic Operations using Python

Session 006 - Overview of IDEs and Setup VS Code on Mac and Windows

Session 007 - Overview of Variables and Constants

Session 008 - Overview of String Manipulation Functions in Python

Session 009 - User Defined Functions in Python

Session 010 - Conditionals using Python

Session 011 - Solutions for Exercises on Conditionals

Session 012 - Looping using for and while in Python

Session 013 - Exception Handling in Python

Session 014 - Solutions for Basic Programming Constructs

Session 015 - Develop First Python Program and Run with Run Time Arguments

Session 016 - Overview of Python Modules and Standard Libraries

Session 017 - Overview of Python Core Collections

Session 018 - Common Python List Operations

Session 019 - Common Python Set Operations

Session 020 - Common Python Tuple Operations

Session 021 - Common Python Dict Operations

Session 022 - Python Practice using list of tuples

Session 023 - Python Practice using list of dicts

Session 024 - Comprehensions using Python

Session 025 - Lambda or Anonymous Functions in Python

Session 026 - Sorting Iterables or Collections in Python

Session 027 - Additional Details about Python Functions - Part 1

Session 028 - Additional Details about Python Functions - Part 2

Session 029 - Date Manipulation using Python

Session 030 - Generating random data using Python

Session 031 - Processing list of delimited Strings - Part 1

Session 032 - Processing list of delimited Strings - Part 2

Session 033 - Overview of yield and generators

Session 034 - Overview of Python Decorators

Session 035 - Setup Required Data Sets in Files and Overview of Files as well as Folders

Session 036 - Process Sales Data from files using File I O and Loops

Session 037 - Process Sales Data from files using File I O and Loops

Session 038 - Managing Files and Folders using Python

Session 039 - Managing Python Libraries using pip

Session 040 - Overview of JSON Data and Files

Session 041 - Processing JSON Files using json module - Part 1

Session 042 - Processing JSON Files using json module - Part 2

Session 043 - Code Versioning and Getting Started with GitHub

Session 044 - Getting Started with REST APIs

Session 045 - Using Postman to Validate REST APIs

Session 046 - Processing REST Payloads using requests - Part 1

Session 047 - Processing REST Payloads using requests - Part 2

Session 048 - Object Oriented Constructs using Python

Session 049 - Exercises and Solutions on Object Oriented Constructs using Python

Session 050 - Overview of Unit Testing using Python

Session 051 - Real World Example for Unit Testing using Python

Session 052 - Overview of Database Technologies

Session 053 - Installing Postgres Database Server on Windows or Mac

Session 054 - CRUD Operations using SQL

Session 055 - Database Connectivity using Python

Session 056 - Overview of Database Programming using Python

Session 057 - Load CSV Data from Files to Database Table

Session 058 - Overview of Python NumPy

Session 059 - Getting Started with Pandas

Session 060 - Process Sales Data from files using Pandas - Part 1

Session 061 - Process Sales Data from files using Pandas - Part 2

Session 062 - File Format Conversion using Pandas - Part 1

Session 063 - File Format Conversion using Pandas - Part 2

Session 064 - Process JSON Data using Pandas

Session 065 - Database Programming using Pandas

Session 066 - Overview of Multiprocessing

Session 067 - Multiprocessing using real world examples

Session 068 - Overview of Data Processing using dask

Session 069 - Real world examples using dask

Session 070 - Getting Started with Python Applications and Virtual Environments

Session 071 - Exercise and Solution for setting up a Python Project

Session 072 - Overview of Driver Program and Important Git Commands

Session 073 - Add Core Logic to Driver Program File

Session 074 - Overview of Environment Variables

Session 075 - Enhance Application using git branch

Session 076 - Deep Dive into Software Development Life Cycle

Session 077 - Overview of application logging

Session 078 - Add logging to Python Applications

Session 079 - Build Packages and Executables using Setup Tools

Session 080 - Build Package and Executable for File Format Converter