Udemy

SQL for Data Science Oracle , MySQL, R and Python [2025]

Enroll Now
  • 3,204 Students
  • Updated 1/2025
4.1
(103 Ratings)
CTgoodjobs selects quality courses to enhance professionals' competitiveness. By purchasing courses through links on our site, we may receive an affiliate commission.

Course Information

Registration period
Year-round Recruitment
Course Level
Study Mode
Duration
4 Hour(s) 43 Minute(s)
Language
English
Taught by
Piyush S | insightEdge100.com
Rating
4.1
(103 Ratings)

Course Overview

SQL for Data Science Oracle , MySQL, R and Python [2025]

Learn Database design ,Write SQLs in R and Python and become Data Literate.Learn to create ORACLE and MySQL databases.

Recent Reviews:

Yes definitely this is the course what I was looking for . Kudos to instructor who clearly explains the basics . Quizzes are really helpful

This course was very helpful to me. Each and every topic has detailed explanation and easy to learn the concepts.


Taught by Data Scientist with over 15+ years of Industry Experience

Lifetime access to course materials . 100% money back guarantee

  • Start writing simple to the most advanced SQL queries.

  • Start using SQL queries in Oracle , MySQL

  • Integrate R and Python with Database and execute SQL command on them for data analysis and Visualizations.

  • Start using filter , having clause , joins with multiple tables ,aggregators etc.

  • Create DDL commands and modify the schema objects.

  • Create own database in your laptop/Desktop - Oracle and MySQL

  • Import and export data from and to external files.

  • Write and understand complex SQL - Group by , nested SQL ,inner join, outer join.

  • Write SQL on python and R .

  • Connect database to python and R .

  • Do the visualizations on data stored in oracle/mysql using R studio.

  • Do the visualizations on data stored in oracle/mysql using Python.

  • Install R and python in your system.

  • Understand basic concept of machine learning and write your 1st machine learning program.

  • We will be using real world data sets for Market data and Company .

  • Become Data Literate.

Course Content

  • 10 section(s)
  • 61 lecture(s)
  • Section 1 Introduction
  • Section 2 Before we began the next Sections Download the following files
  • Section 3 Database Installation - Oracle and MySQL
  • Section 4 Oracle vs MySQL Resources
  • Section 5 Basics of SQL - Write your 1st SQL
  • Section 6 Advance SQL
  • Section 7 Nested SQL and Joins
  • Section 8 SQL Practise Questions
  • Section 9 SQL in Python and Data Visualizations
  • Section 10 SQL in R and Data Visualizations

What You’ll Learn

  • Start writing simple to the most advanced SQL queries in Oracle and MySQL
  • Start using SQL queries on powerful R and Python console and plots graph for visualizations and data analysis
  • Create your own database in your laptop - Oracle and MySQL
  • Start using filters , group by & having clause , joins with multiple tables ,aggregators etc.
  • Create DDL commands and modify the schema objects.
  • Import & Export files from and to database


Reviews

  • D
    Dariusz Pszenny
    3.0

    Not enough excercises and tests. Little to fast curve of learning

  • N
    Negru Irena
    5.0

    Cursul este foarte bine structurat si usor de inteles.

  • E
    Esther Ndunge
    4.5

    It was a good match for me. I have been able to understand SQL functions in details

  • M
    M D
    1.5

    I think it lacks more theory. Sometimes the program the teacher is using is not the same one he suggested and that makes it slightly different to use (SQL v. MySQL). When He suggest downloading a program he didn't explain how to install the necessary library in R f.ex. A bit confusing as a course and the thick accent makes it harder to follow and understand.

Start FollowingSee all

We use cookies to enhance your experience on our website. Please read and confirm your agreement to our Privacy Policy and Terms and Conditions before continue to browse our website.

Read and Agreed