SQL to Python for Beginners

Overview

On this course you’ll discover ways to use the Python Pandas library to realize the core SQL performance listed beneath.

If you’re able to make the leap from SQL to Python, this course will aid you by means of your adoption and elevated utilization of Python for knowledge manipulation, transformation and in the end knowledge evaluation.

Understanding learn how to obtain SQL knowledge manipulation options in Python will function your basis for utilizing Python for superior analysts, knowledge science and different machine studying duties.

Stipulations

This course is beneficial for anybody who’s comfy with SQL and wish to improve their adoption of Python for his or her everyday. It’s additionally beneficial that you’ve got a base understanding of Python or some familiarity of any programming language as a way to get essentially the most of this course. Different stipulations will probably be outlined within the Introduction video, however having the next arrange in your laptop forward of time will assist you to dive proper in.

• Python 3.7 or above put in
• pandas library put in (pip set up pandas)
• IDE (e.g. PyCharm, VS Code)
• Git (optionally available, for cloning repo with code examples)

Core Ideas taught on this course

Core SQL Ideas translated to Python Pandas code are:

• SQL Restrict
• SQL Distinct
• SQL The place
• SQL WHERE / AND (A number of Predicates)
• SQL IN ( )
• SQL NOT IN ( )
• SQL Mixture Capabilities
  • SQL MIN
  • SQL MAX
  • SQL COUNT
  • SQL COUNT DISTINCT
  • SQL AVERAGE / MEAN
• Mode (Not often out there in most SQL databases)
• SQL Group by Aggregates
• SQL Row Quantity over (partition by / order by)
• SQL Case Statements
• SQL Joins

Thanks for enrolling on this course! Get pleasure from!