Careertail
About UsCoursesCareer PathsBlogOpportunities
Log In
Courses>Database Design & Development>SQL to Python for Beginners
DevelopmentSQL to Python for Beginners
Price:Free
Length:44 mins
Content type:video
level:beginner
Updated:19 February 2024
Published:21 August 2022
Similar courses
Opportunities
Courses>Database Design & Development>SQL to Python for Beginners
SQL to Python for Beginners
4.5 (5.9k)
44 mins
5932 students
What you will learn
1Learn Python by Example
2Learn to translate SQL into Python
3Manipulate data in Python like you would with SQL
4Become familiar with the Pandas library in Python
Target audiences
1Data Analysts
2Data Scientists new to Python
3Business Intelligence Analysts
Requirements
1Basic Knowledge of Python
FAQ
You can view and review the lecture materials indefinitely, like an on-demand channel.
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!
Description

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!

Similar courses
Opportunities
Make the most out of your online education
Careertail
Copyright © 2021 Careertail.
All rights reserved
Quick Links
Get StartedLog InAbout UsCourses
Company
BlogContactsPrivacy PolicyCookie PolicyTerms and Conditions
Stay up to date
Trustpilot
Careertail
Courses>Database Design & Development>SQL to Python for Beginners
DevelopmentSQL to Python for Beginners
Price:Free
Length:44 mins
Content type:video
level:beginner
Updated:19 February 2024
Published:21 August 2022
Similar courses
Opportunities
Courses>Database Design & Development>SQL to Python for Beginners
SQL to Python for Beginners
4.5 (5.9k)
44 mins
5932 students
What you will learn
1Learn Python by Example
2Learn to translate SQL into Python
3Manipulate data in Python like you would with SQL
4Become familiar with the Pandas library in Python
Target audiences
1Data Analysts
2Data Scientists new to Python
3Business Intelligence Analysts
Requirements
1Basic Knowledge of Python
FAQ
You can view and review the lecture materials indefinitely, like an on-demand channel.
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!
Description

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!

Similar courses
Opportunities
Make the most out of your online education
Careertail
Copyright © 2021 Careertail.
All rights reserved
Quick Links
Get StartedLog InAbout UsCourses
Company
BlogContactsPrivacy PolicyCookie PolicyTerms and Conditions
Stay up to date
Trustpilot