Overview
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 ****
- Start writing simple to the most advanced SQL queries.
- Start using SQL queries in Oracle, MySQL
- 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.
Testimonials
- 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
- 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
- Good concept of sql and database. Instructor explains the concepts in details and covers basic, good for beginners ~ Kuldeep S
- This course is well detailed. Some of the excercises are interesting and challenging. Recommended for beginners ~ J Asmah
- Exactly what I was looking for, value for money and recommend for beginners looking to start data analysis career ~ Douglas J
- It is a great course and I'm learning lot, the course is very well presented, thanks ~ A Ingino
- This course was very helpful to me. Each and every topic has detailed explaination and easy to learn the concepts ~ Priyanka A
- 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
- Start writing simple to the most advanced SQL queries in Oracle and MySQL
- Create own database in your laptop - Oracle and MySQL
- Start using SQL queries on powerful R and Python console and plots graph for visualizations and data analysis
- 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
- Integrate R and Python with Database and execute SQL command on them for data analysis and Visualizations.
Requirements
- Passion for Data
- Beginners who are looking to enhance their data science skills
- Desktop/Laptop