Tutorialspoint

FREEDOM SALE IS LIVE! Use: FREEDOM10

Master Python MySQL from Scratch and Develop Crypto Alert

person icon Gianluca Mottola

4.3

Master Python MySQL from Scratch and Develop Crypto Alert

Python, MySql , Opencv, Selenium Webdriver libraries: image recognition to shift a slider on a puzzle window , web scraping , regular expressions

updated on icon Updated on Jun, 2025

language icon Language - English

person icon Gianluca Mottola

English [CC]

category icon Development ,Software Testing,Selenium WebDriver

Lectures -67

Resources -6

Duration -6.5 hours

Lifetime Access

4.3

price-loader

Lifetime Access

30-days Money-Back Guarantee

Training 5 or more people ?

Get your team access to 10000+ top Tutorials Point courses anytime, anywhere.

Course Description

Basic Python Language features explained from the beginning:

  • Installation of the Visual Studio Code editor and the Python relevant packages

  • Basic Types in Python

  • Python Lists

  • Python dictionaries

  • Python tuples

  • Python sets

  • Python - if-else conditional statement

  • Python while loops

  • Python for loops

  • Python Functions

  • Python lambda functions


OOP Concepts - Classes and objects explained with real-life examples:

  • OOP concepts

  • Python classes definition and object instantiation

  • Python Inheritance  

Selenium WebDriver framework explained in detail:

  • Fill in the input fields

  • ActionChains to move a slider

  • More Web element detection strategies for a better web scraping strategy

  • Explicit WebWait strategy to wait for the Web elements without losing performance

MySQL - PostgreSQL DB interaction:

  • All queries needed for the project are explained in detail

  • cancellation of the oldest rows in case the remote DB is full

OpenCV2 for detailed image pixel analysis:

  • Filter out the relevant pixels of a given image

  • Detect the edges and the x-y coordinates of the edges 

  • Detect the distance between two edges to shift a slider of the correct amount

  • Numpy arrays management

Python App development on Heroku Remote Host Provider:

  • Installation of the relevant packages to make the Linux remote host run properly

  • Deployment of the Python App directly from the GitHub environment

  • Take a screenshot on the remote host machine to analyse in real time the flow of the applications, and save that screenshot to a cloud provider

Build a Real crypto alert Python application to scrape the crypto stocks market:

  • Get in real time all crypto-value pairs

  • Store those values in a database (MySQL, Postgres)

  • Pull all the values from the past

  • Decide, for each crypt,o whether it's the moment to invest or not, according to a completely customizable strategy

  • Send the crypto alert notification on a Telegram Account

Trade automatically a crypto without human intervention:

  • Log in to Pionex

    • by overriding the puzzle shifting authorisation check window

    • by overriding the email verification code window (Google Restful APIs)

  • Click the crypto for which the algorithm decides to invest

  • Invest money in that crypto with 0.05% fees!

Typical recruiters' questions to apply to Python and web testing positions

Final developing challenge for you

The entire source code is provided

Who this course is for:

  • Beginner Python developers who want to discover the power of this language!
  • People who want to understand the image recognition mechanism
  • People who wish to apply for a web testing position
  • People who want to understand how MySQL and PostgreSQL databases work
  • Professional traders who want to understand the trend of crypto and, stock market in real time
  • Professional traders who want to trade with the lowest fees in the market
  • Professional traders who want to develop an app that trades automatically after the decision tree is met

Goals

  • Selenium Web testing learners

  • Beginner and advanced Python learners

  • People who want to automate boring tasks on web applications

  • People who want to dive into web scraping

  • People who want to create their trading strategy without paying thousands of dollars in fees to trading crypto platforms

  • Improve your crypto-stock investment strategy by studying old data trends

  • Make the login automatically in a crypto platform and invest immediately in crypto without making the login manually

  • People who want to learn how image recognition works

  • People who want to create professional trading crypto alerts

  • People who want to create professional item pricing alerts

  • People who want to create professional stock alerts

  • Create and maintain a MySQL DB

  • Create, edit and maintain a remote Postgres DB, check when you overload the max allowed capacity and cancel eventually some rows

  • Override the check of the image check puzzle window by moving the slider, with the package opencv2

  • Override an email verification check window by checking the content of your email inbox and looking for the current verification code

  • Deploy a Python application to a remote server through GitHub

Prerequisites

  • No prerequisites are required; I will explain everything you need from scratch!
Master Python MySQL from Scratch and Develop Crypto Alert

Curriculum

Check out the detailed breakdown of what’s inside the course

Introduction

1 Lectures
  • play icon Introduction to the course 05:49 05:49

Introduction to python language - installation of the relevant packages

12 Lectures
Tutorialspoint

OOP Concepts - classes and objects

4 Lectures
Tutorialspoint

Python - Selenium Crypto alert project developing - Local Host

31 Lectures
Tutorialspoint

Python - Selenium Crypto alert project developing - Remote Host

16 Lectures
Tutorialspoint

Typical Python - Selenium interview questions from recruiters

3 Lectures
Tutorialspoint

Instructor Details

Gianluca Mottola

Gianluca Mottola

HEllo guys


I am a senior testing engineer,

my passion is programming


my preferred programming languages are c , python , java


I am on this platform for sharing my experience with all of you, I will do the best to simplify the theory and make as transparent as possible every kind of programming topic

Course Certificate

Use your certificate to make a career change or to advance in your current career.

sample Tutorialspoint certificate

Our students work
with the Best

Related Video Courses

View More

Annual Membership

Become a valued member of Tutorials Point and enjoy unlimited access to our vast library of top-rated Video Courses

Subscribe now
Annual Membership

Online Certifications

Master prominent technologies at full length and become a valued certified professional.

Explore Now
Online Certifications

Talk to us

1800-202-0515