SQL for Data Science Oracle , MySQL, R and Python [2024]
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
Requirements
- Passion for Data
- Desktop/Laptop
Description
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.
Who this course is for:
- Beginners who are looking to enhance their data science skills
Instructor
- 3.9 Instructor Rating
- 323 Reviews
- 9,977 Students
- 6 Courses
"PG in Data Science ( IIIT Bangalore) , PMP ( Project Management Institute,USA), CAPM , B.Tech ( Electronics)"
I have over 12+ years of industry experience in Python , R and SQL .
Have worked across various international finance companies including Insurance & Banking. I been instrumental in implementing the various software products .
I am passionate about data and the insights which it gives. I am looking forward to share my experiences with you . I will guide you step by step so that you can make a leap in your career . The Data Engineers and Data Science experts have the highest demand in the world.