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

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

Tags:

Tutorial Bar
Logo