[ FreeCourseWeb ] Udemy - SQL for Data Science ,Oracle , MySQL, R and Python [2020]

seeders: 5
leechers: 10
updated:
Download torrent
Added by freecoursewb in Other > Tutorials
Download Fast Safe Anonymous
movies, software, shows...
  • Downloads: 99
  • Language: English

Files

[ FreeCourseWeb.com ] Udemy - SQL for Data Science ,Oracle , MySQL, R and Python [2020]
  • Get Bonus Downloads Here.url (0.2 KB)
    • ~Get Your Files Here ! 1. Introduction
    • 1. Why SQL for Data Science.mp4 (14.4 MB)
    • 2. Course Outline.mp4 (9.7 MB)
    • 3. Database Concept.mp4 (13.4 MB)
    • 4. SQL Concept.mp4 (36.4 MB)
    10. SQL in R and Data Visualizations
    • 1. Introduction to R.mp4 (3.5 MB)
    • 2. Upload CSV files in R and SQL Queries.mp4 (31.1 MB)
    • 3. Data Visualizations in R using ggplot.mp4 (104.4 MB)
    • 4. Connecting MySQL with R and DML operations.mp4 (32.0 MB)
    • 5. Connecting MySQL with R and DDL operations.mp4 (18.9 MB)
    11. ImportExport Files into Database - Oracle and MySQL
    • 1. Import CSV file in Oracle Database - 1.mp4 (37.2 MB)
    • 2. Import CSV file in Oracle Database - 2.mp4 (37.0 MB)
    • 3. Import CSV file in MySQL - 1.mp4 (63.9 MB)
    12. Case Study - Market Data
    • 1. DML and DDL commands for Market Data.mp4 (46.1 MB)
    • 2. Select Clauses for Market Data in MySQL.mp4 (41.6 MB)
    • 3. Export Files - MySQL.mp4 (13.0 MB)
    • 4. Select Clauses for Market Data in Oracle.mp4 (45.1 MB)
    • 5. Complex SQL - Assignment.mp4 (5.8 MB)
    • 6. Assignment Solutions-1.mp4 (24.7 MB)
    • 7. Assignment Solutions-2.mp4 (88.6 MB)
    13. Bonus Lectures on Machine Learning
    • 1. What is machine learning .mp4 (17.4 MB)
    • 2. Concept of Linear Regression The 1st machine learning Technique.mp4 (18.7 MB)
    • 3. CSV file Upload and Data Analysis.mp4 (16.6 MB)
    • 4. Data Visualisations.mp4 (30.7 MB)
    • 5. Model Building.mp4 (29.1 MB)
    • 6. Assumptions of Linear Regression.mp4 (17.4 MB)
    • 7. Model Fitness and Validation - 1.mp4 (20.9 MB)
    • 8. Model Fitness and Validation - 2.mp4 (17.9 MB)
    3. Database Installation - Oracle and MySQL
    • 1. Oracle vs MySQL.mp4 (27.8 MB)
    • 2. Understand Company Schema.mp4 (19.6 MB)
    • 3. Installation of MySQL Database.mp4 (40.4 MB)
    • 4. Play with MySQL Workbench.mp4 (21.0 MB)
    • 5. Installation of Oracle Database (optional).mp4 (48.9 MB)
    • 6. Understanding Select and Where Clause.mp4 (16.8 MB)
    • 7. Create Company DB ( MySQL).mp4 (34.6 MB)
    • 8. Create Company DB in Oracle ( optional).mp4 (20.8 MB)
    5. Basics of SQL - Write your 1st SQL
    • 1. Write your 1st SQL.mp4 (67.3 MB)
    • 2. IN,NOT IN,BETWEEN Clause.mp4 (58.6 MB)
    • 3. Null ,Not Null , Order by Clause.mp4 (48.4 MB)
    6. Advance SQL
    • 1. Advance SQL - Aggregators.mp4 (20.4 MB)
    • 2. Basic Aggregators.mp4 (26.6 MB)
    • 3. Group by Clause 1.mp4 (15.3 MB)
    • 4. Group by Clause 2.mp4 (17.2 MB)
    • 5. Having Clause.mp4 (31.0 MB)
    7. Nested SQL and Joins
    • 1. Introduction to Nested SQL.mp4 (7.5 MB)
    • 2. Nested SQL 1.mp4 (37.9 MB)
    • 3. Nested SQL 2.mp4 (22.0 MB)
    • 4. Introduction to Joins.mp4 (12.2 MB)
    • 5. Inner Join.mp4 (14.4 MB)
    • 6. Outer Join.mp4 (44.9 MB)
    9. SQL in Python and Data Visualizations
    • 1. Introduction to SQL with Python and R.mp4 (11.5 MB)
    • 2. Installation of Python Developer Environment -Anaconda & Jupyter.mp4 (32.2 MB)
    • 3. SQL Python-Upload Market Data.mp4 (60.7 MB)
    • 4. Write SQL in Python.mp4 (36.6 MB)
    • 5. Visualizations in Python- Seaborn and Pandas.mp4 (41.1 MB)
    • 6. MySQL Database Connection with Python.mp4 (43.3 MB)
    • Bonus Resources.txt (0.3 KB)
    • Readme.txt (0.1 KB)
      • resources
      • company_handout (1).pdf (3.7 MB)
      • company_handout.pdf (3.7 MB)
        • market_Data
        • cust_dimen.csv (113.1 KB)
        • market_fact.csv (605.3 KB)
        • orders_dimen.csv (211.7 KB)
        • prod_dimen.csv (0.8 KB)
        • shipping_dimen.csv (331.8 KB)
      • mysql_create_insert_command.sql (4.0 KB)
      • oracle_create_insert_command.sql (6.5 KB)
      • select_commands_schema_company.sql (6.6 KB)
      • smartphone_ads.csv (4.4 KB)
      • world_mysql-200410-132403.sql (389.3 KB)
      • world_oracle-200410-132303.sql (380.7 KB)

Description

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



Download torrent
1.7 GB
seeders:5
leechers:10
[ FreeCourseWeb ] Udemy - SQL for Data Science ,Oracle , MySQL, R and Python [2020]
Loading...