image

SQL for Data Science

134 views
Last updated 5/2022 English
Overview

SQL for Data Science, Oracle and MySQL

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

**** Taught by Data Scientist with over 13++ years of Industry Experience ****

**** Lifetime access to course materials  ****

  1. Start writing simple to the most advanced SQL queries.
  2. Start using SQL queries in Oracle, MySQL
  3. Start using filter, having clause, joins with multiple tables, aggregators etc.
  4. Create DDL commands and modify the schema objects.
  5. Create own database in your laptop/Desktop - Oracle and MySQL
  6. Import and export data from and to external files.

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

Testimonials
  1. So far I liked the course and is as per expectations. Recommended for beginners who want to get started with database and sql ~ Avinash R
  2. As expected. Recommended for beginners and who are preparing for interviews. Instructor covers basic to complex SQL. I liked the visualisation and integration with R & Python ~ Cesar Y
  3. Good concept of sql and database. Instructor explains the concepts in details and covers basic, good for beginners ~ Kuldeep S
  4. This course is well detailed. Some of the excercises are interesting and challenging. Recommended for beginners ~ J Asmah
  5. Exactly what I was looking for, value for money and recommend for beginners looking to start data analysis career ~ Douglas J
  6. It is a great course and I'm learning lot, the course is very well presented, thanks ~ A Ingino
  7. This course was very helpful to me. Each and every topic has detailed explaination and easy to learn the concepts ~ Priyanka A
  8. Yes definitely this is the course what I was looking for. Kudos to instructor who clearly explains the basics. Quizzes are really helpful ~ Felipe S
What you'll learn
  1. Start writing simple to the most advanced SQL queries in Oracle and MySQL
  2. Create own database in your laptop - Oracle and MySQL
  3. Start using SQL queries on powerful R and Python console and plots graph for visualizations and data analysis
  4. Start using filter, having clause, joins with multiple tables, aggregators etc.
  5. Create DDL commands and modify the schema objects.
  6. Import / Export files from and to database
  7. Integrate R and Python with Database and execute SQL command on them for data analysis and Visualizations.
Requirements
  1. Passion for Data
  2. Beginners who are looking to enhance their data science skills
  3. Desktop/Laptop
Course Content
10 Sections 53 Lectures 3h 48m total length