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

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

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 own database in your laptop - Oracle and MySQL
Start using filter , 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

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.


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

Who this course is for:

Beginners who are looking to enhance their data science skills