Course Information
Course Overview
Learn Database design ,Write SQLs in R and Python and become Data Literate.Learn to create ORACLE and MySQL databases.
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.
Course Content
- 10 section(s)
- 61 lecture(s)
- Section 1 Introduction
- Section 2 Before we began the next Sections Download the following files
- Section 3 Database Installation - Oracle and MySQL
- Section 4 Oracle vs MySQL Resources
- Section 5 Basics of SQL - Write your 1st SQL
- Section 6 Advance SQL
- Section 7 Nested SQL and Joins
- Section 8 SQL Practise Questions
- Section 9 SQL in Python and Data Visualizations
- Section 10 SQL in R and Data Visualizations
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
Skills covered in this course
Reviews
-
DDariusz Pszenny
Not enough excercises and tests. Little to fast curve of learning
-
NNegru Irena
Cursul este foarte bine structurat si usor de inteles.
-
EEsther Ndunge
It was a good match for me. I have been able to understand SQL functions in details
-
MM D
I think it lacks more theory. Sometimes the program the teacher is using is not the same one he suggested and that makes it slightly different to use (SQL v. MySQL). When He suggest downloading a program he didn't explain how to install the necessary library in R f.ex. A bit confusing as a course and the thick accent makes it harder to follow and understand.