SQL to Python for Beginners

SQL to Python for Beginners, available at Free, has an average rating of 4.15, with 20 lectures, based on 140 reviews, and has 10577 subscribers.

Free Enroll Now

You will learn about Learn Python by Example Learn to translate SQL into Python Manipulate data in Python like you would with SQL Become familiar with the Pandas library in Python This course is ideal for individuals who are Data Analysts or Data Scientists new to Python or Business Intelligence Analysts It is particularly useful for Data Analysts or Data Scientists new to Python or Business Intelligence Analysts.

Enroll now: SQL to Python for Beginners

Summary

Title: SQL to Python for Beginners

Price: Free

Average Rating: 4.15

Number of Lectures: 20

Number of Published Lectures: 20

Number of Curriculum Items: 20

Number of Published Curriculum Objects: 20

Original Price: Free

Quality Status: approved

Status: Live

What You Will Learn

Learn Python by Example

Learn to translate SQL into Python

Manipulate data in Python like you would with SQL

Become familiar with the Pandas library in Python

Who Should Attend

Data Analysts

Data Scientists new to Python

Business Intelligence Analysts

Target Audiences

Data Analysts

Data Scientists new to Python

Business Intelligence Analysts

Overview

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. 

Prerequisites

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

SQL COUNT

SQL COUNT DISTINCT

SQL AVERAGE / MEAN

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!

Course Curriculum

Chapter 1: Introduction

Lecture 1: Introduction

Chapter 2: SQL to Python using Python Pandas

Lecture 1: SQL Limit Records

Lecture 2: SQL Distinct

Lecture 3: SQL Select Columns

Lecture 4: SQL Where Clause

Lecture 5: SQL Multiple Where Clause

Lecture 6: SQL IN ( )

Lecture 7: SQL NOT IN ( )

Lecture 8: SQL Average

Lecture 9: SQL Max

Lecture 10: SQL Min

Lecture 11: Computing the Mode

Lecture 12: SQL Group by Sum

Lecture 13: SQL Group by Avg

Lecture 14: SQL Group by Count

Lecture 15: SQL Group with Multiple Aggregates

Lecture 16: SQL Row Number Function

Lecture 17: SQL Case Statement

Lecture 18: SQL Joins

Chapter 3: Outro

Lecture 1: Thank you and Final Exercise

Instructors

Oscar Valles
Analytics and Business Intelligence Professional

Rating Distribution

1 stars: 6 votes

2 stars: 3 votes

3 stars: 15 votes

4 stars: 46 votes

5 stars: 70 votes

Frequently Asked Questions

How long do I have access to the course materials?

You can view and review the lecture materials indefinitely, like an on-demand channel.

Can I take my courses with me wherever I go?

Definitely! If you have an internet connection, courses on Udemy are available on any device at any time. If you don’t have an internet connection, some instructors also let their students download course lectures. That’s up to the instructor though, so make sure you get on their good side!