SQL to Python for Beginners

An intro Course illustrating SQL equivalents in Python


  • Basic Knowledge of Python



In this course you will learn how to use the Python Pandas library to achieve the core SQL functionality listed below.

If you are ready to make the leap from SQL to Python, this course will help you through your adoption and increased usage of Python for data manipulation, transformation and ultimately data analysis.

Understanding how to achieve SQL data manipulation features in Python will serve as your foundation for using Python for advanced analysts, data science and other machine learning tasks. 


This course is recommended for anyone who is comfortable with SQL and would like to increase their adoption of Python for their day to day. It’s also recommended that you have a base understanding of Python or some familiarity of any programming language in order to get the most of this course. Other prerequisites will be outlined in the Introduction video, but having the following set up on your computer ahead of time will allow you to dive right in.

  • Python 3.7 or above installed
  • pandas library installed (pip install pandas)
  • IDE (e.g. PyCharm, VS Code)
  • Git (optional, for cloning repo with code examples)

Core Concepts taught in this course

Core SQL Concepts translated to Python Pandas code are:

  • SQL Limit
  • SQL Distinct
  • SQL Where
  • SQL WHERE / AND (Multiple Predicates)
  • SQL IN ( )
  • SQL NOT IN ( )
  • SQL Aggregate Functions
    • SQL MIN
    • SQL MAX
  • Mode (Not usually available in most SQL databases)
  • SQL Group by Aggregates
  • SQL Row Number over (partition by / order by)
  • SQL Case Statements
  • SQL Joins

Thank you for enrolling in this course! Enjoy!

Who this course is for:

  • Data Analysts
  • Data Scientists new to Python
  • Business Intelligence Analysts

Course content

3 sections • 20 lectures • 43m total length

Python : Basics you should learn for beginners

Learn the step by step Installation process of Python & Pycharm IDE in detailed


  • Computer with internet connection


Hi and welcome to this course,

Python is one of the most popular programming languages in the world, huge companies like google uses it for google search engines and in mission critical applications.

And python is the No 1 Programming language and a great choice for machine learning, data science and AI. To get high paying jobs and to boost up your career, Python is a good option for you.

In this course you will learn how to get started with Python and how to easily install and setup Python on your laptop irrespective on the operating system you use.

In this course you are going to start with downloading process and learn how to find right python version for your OS.

we not only install python, once we are done installing we are going to test the installation process as well by writing a sample python program.

– Python installation on window

– Testing the installation process on Windows Command prompt

– Python installation on Mac OS

– Testing the installation process on Mac Terminal

Disclaimer : Downloaded Lectures are only for reference do not use them or share them to others or do not use for commercial purposes, any miss-use of Course Data & Lectures is a punishable offence & illegal and would be prosecuted legally.

Who this course is for:

  • Beginners or Freshers to Programming language or Python

Course content

2 sections • 5 lectures • 31m total length

Introduction to Text To Speech With Python

Learn how to install Virtualenv and Virtualenvwrapper

Learn how to install Pycharm (Python IDE)

Learn how to install required libraries and applications

Learn how to convert text to speech using Python


  • Applicants must have a level of Python programming above beginner
  • There is no need for mathematics


We are in the AI and robotics era.

Our mobile phones understand what we say and speak. Also new model computers can talk.
Can we do something also?
What not make our computer speak?

In this course, we will learn the basics of Text-to-Speech (TTS).

We will use Python 3.6. A little better than beginner level of programming skill will be enough.

We will study very simple coding examples. But you can improve the scripts easily.

In the course we will use Pycharm Community IDE. Of course, this is not a must! You can write your scripts in a terminal too.

Our main operating system is Ubuntu Linux, version 18.04 LTS. But, our Python scripts will be also compatible with Windows 10 and  Mac OS X which can run Python 3.6.

At the last section of our course, I will show simply how to install required libraries and applications and run our Python scripts in both Windows and Mac.

After this course, I will publish a more advanced course on Speech-to-Text (STT). This course will be helpful for it.

I hope I can help you to start working on TTS and STT with Python.

Who this course is for:

  • Python programmers who want to write their own Text-to-Speech scripts
  • Python programmers who want to practice AI from the beginning and want to create their own bots

Course content