Video: .mp4 (1280x720, 30 fps(r)) | Audio: aac, 44100 Hz, 2ch | Size: 1.51 GB
Genre: eLearning Video | Duration: 53 lectures (4 hour, 12 mins) | Language: English
Learn Database design ,Write SQLs in R and Python and do Data Analysis. Learn to create ORACLE and MySQL databases.
What you'll learn Homepage: https://www.udemy.com/course/sql-for-data-science/
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
TO MAC USERS: If RAR password doesn't work, use this archive program:
RAR Expander 0.8.5 Beta 4 and extract password protected files without error.
TO WIN USERS: If RAR password doesn't work, use this archive program:
Latest Winrar and extract password protected files without error.