| 1. Advance SQL - Aggregators.mp4 | 20.4 MB | ||
| 1. DML and DDL commands for Market Data.mp4 | 46.1 MB | ||
| 1. Import CSV file in Oracle Database - 1.mp4 | 37.2 MB | ||
| 1. Introduction to Nested SQL.mp4 | 7.5 MB | ||
| 1. Introduction to R.mp4 | 3.5 MB | ||
| 1. Introduction to SQL with Python and R.mp4 | 11.5 MB | ||
| 1. Oracle vs MySQL.mp4 | 27.8 MB | ||
| 1. What is machine learning .mp4 | 17.4 MB | ||
| 1. Why SQL for Data Science.mp4 | 14.4 MB | ||
| 1. Write your 1st SQL.mp4 | 67.3 MB | ||
| 2. Basic Aggregators.mp4 | 26.6 MB | ||
| 2. Concept of Linear Regression The 1st machine learning Technique.mp4 | 18.7 MB | ||
| 2. Course Outline.mp4 | 9.7 MB | ||
| 2. IN,NOT IN,BETWEEN Clause.mp4 | 58.6 MB | ||
| 2. Import CSV file in Oracle Database - 2.mp4 | 37 MB | ||
| 2. Installation of Python Developer Environment -Anaconda & Jupyter.mp4 | 32.2 MB | ||
| 2. Nested SQL 1.mp4 | 37.9 MB | ||
| 2. Select Clauses for Market Data in MySQL.mp4 | 41.6 MB | ||
| 2. Understand Company Schema.mp4 | 19.6 MB | ||
| 2. Upload CSV files in R and SQL Queries.mp4 | 31.1 MB | ||
| 3. CSV file Upload and Data Analysis.mp4 | 16.6 MB | ||
| 3. Data Visualizations in R using ggplot.mp4 | 104.4 MB | ||
| 3. Database Concept.mp4 | 13.4 MB | ||
| 3. Export Files - MySQL.mp4 | 13 MB | ||
| 3. Group by Clause 1.mp4 | 15.3 MB | ||
| 3. Import CSV file in MySQL - 1.mp4 | 63.9 MB | ||
| 3. Installation of MySQL Database.mp4 | 40.4 MB | ||
| 3. Nested SQL 2.mp4 | 22 MB | ||
| 3. Null ,Not Null , Order by Clause.mp4 | 48.4 MB | ||
| 3. SQL Python-Upload Market Data.mp4 | 60.7 MB | ||
| 4. Connecting MySQL with R and DML operations.mp4 | 32 MB | ||
| 4. Data Visualisations.mp4 | 30.7 MB | ||
| 4. Group by Clause 2.mp4 | 17.2 MB | ||
| 4. Introduction to Joins.mp4 | 12.2 MB | ||
| 4. Play with MySQL Workbench.mp4 | 21 MB | ||
| 4. SQL Concept.mp4 | 36.4 MB | ||
| 4. Select Clauses for Market Data in Oracle.mp4 | 45.1 MB | ||
| 4. Write SQL in Python.mp4 | 36.6 MB | ||
| 5. Complex SQL - Assignment.mp4 | 5.8 MB | ||
| 5. Connecting MySQL with R and DDL operations.mp4 | 18.9 MB | ||
| 5. Having Clause.mp4 | 31 MB | ||
| 5. Inner Join.mp4 | 14.4 MB | ||
| 5. Installation of Oracle Database (optional).mp4 | 48.9 MB | ||
| 5. Model Building.mp4 | 29.1 MB | ||
| 5. Visualizations in Python- Seaborn and Pandas.mp4 | 41.1 MB | ||
| 6. Assignment Solutions-1.mp4 | 24.7 MB | ||
| 6. Assumptions of Linear Regression.mp4 | 17.4 MB | ||
| 6. MySQL Database Connection with Python.mp4 | 43.3 MB | ||
| 6. Outer Join.mp4 | 44.9 MB | ||
| 6. Understanding Select and Where Clause.mp4 | 16.8 MB | ||
| 7. Assignment Solutions-2.mp4 | 88.6 MB | ||
| 7. Create Company DB ( MySQL).mp4 | 34.6 MB | ||
| 7. Model Fitness and Validation - 1.mp4 | 20.9 MB | ||
| 8. Create Company DB in Oracle ( optional).mp4 | 20.8 MB | ||
| 8. Model Fitness and Validation - 2.mp4 | 17.9 MB | ||
| Bonus Resources.txt | 307.2 B | ||
| Get Bonus Downloads Here.url | 204.8 B | ||
| Readme.txt | 102.4 B | ||
| company_handout (1).pdf | 3.7 MB | ||
| company_handout.pdf | 3.7 MB | ||
| cust_dimen.csv | 113.1 KB | ||
| market_fact.csv | 605.3 KB | ||
| mysql_create_insert_command.sql | 4 KB | ||
| oracle_create_insert_command.sql | 6.5 KB | ||
| orders_dimen.csv | 211.7 KB | ||
| prod_dimen.csv | 819.2 B | ||
| select_commands_schema_company.sql | 6.6 KB | ||
| shipping_dimen.csv | 331.8 KB | ||
| smartphone_ads.csv | 4.4 KB | ||
| world_mysql-200410-132403.sql | 389.3 KB | ||
| world_oracle-200410-132303.sql | 380.7 KB | ||
| ▲ 71 total files | |||
SQL for Data Science ,Oracle , MySQL, R and Python [2020]
Last updated 6/2021
Duration: 4h 43m | Video: .MP4, 1280x720 30 fps | Audio: AAC, 44.1 kHz, 2ch | Size: 1.67 GB
Genre: eLearning | 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
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
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."
Download More Courses Visit and Support Us -->> https://FreeCourseWeb.com
| torrent name | size | uploader | age | seed | leech |
|---|---|---|---|---|---|
| 958.9 MB | freecoursewb | 4 years | 0 | 0 | |
|
[ FreeCourseWeb ] Udemy - Web Scraping for Data Science - Python & Selenium - Basics Posted by
freecoursewb in Other
|
1.5 GB | freecoursewb | 4 years | 0 | 2 |
|
[ FreeCourseWeb ] Udemy - Ultimate JavaScript Arrays plus One To-Do List Project Posted by
freecoursewb in Other
|
506 MB | freecoursewb | 4 years | 0 | 0 |
| 615 MB | freecoursewb | 4 years | 0 | 1 | |
|
[ FreeCourseWeb ] Udemy - The Complete Google Docs Course - Google Docs Tricks & Tips Posted by
freecoursewb in Other
|
1.8 GB | freecoursewb | 4 years | 0 | 1 |
All Comments