Udemy - Learn MySQL from scratch for Data Science and Analytics

seeders: 7
leechers: 9
updated:

Download Fast Safe Anonymous
movies, software, shows...

Files

[ CourseWikia.com ] Udemy - Learn MySQL from scratch for Data Science and Analytics
  • Get Bonus Downloads Here.url (0.2 KB)
  • ~Get Your Files Here ! 1. Introduction
    • 1. Introduction.mp4 (22.2 MB)
    • 1. Introduction.srt (2.2 KB)
    • 2. How to get course requirements.mp4 (8.9 MB)
    • 2. How to get course requirements.srt (1.6 KB)
    • 3. Getting started on Windows, Linux or Mac.mp4 (6.8 MB)
    • 3. Getting started on Windows, Linux or Mac.srt (0.8 KB)
    • 4. How to ask great questions.mp4 (10.5 MB)
    • 4. How to ask great questions.srt (1.5 KB)
    • 5. FAQ’s.mp4 (7.9 MB)
    • 5. FAQ’s.srt (1.2 KB)
    10. SQL Data Analytic statements
    • 1. Order By statement.mp4 (43.3 MB)
    • 1. Order By statement.srt (6.4 KB)
    • 2. SELECT TOP 3 records.mp4 (15.7 MB)
    • 2. SELECT TOP 3 records.srt (1.9 KB)
    • 3. BETWEEN command.mp4 (49.8 MB)
    • 3. BETWEEN command.srt (7.0 KB)
    • 4. IN operator.mp4 (27.1 MB)
    • 4. IN operator.srt (3.9 KB)
    • 5. Search Data using LIKE cards.mp4 (40.5 MB)
    • 5. Search Data using LIKE cards.srt (5.6 KB)
    11. SQL Group by statement
    • 1. Section Introduction.mp4 (7.1 MB)
    • 1. Section Introduction.srt (0.8 KB)
    • 2. Group by – theory.mp4 (18.2 MB)
    • 2. Group by – theory.srt (4.4 KB)
    • 3. Data Analytics with Group By.mp4 (29.4 MB)
    • 3. Data Analytics with Group By.srt (5.1 KB)
    • 4. HAVING statement.mp4 (22.7 MB)
    • 4. HAVING statement.srt (4.1 KB)
    12. JOINS
    • 1. Overview of Joins.mp4 (10.7 MB)
    • 1. Overview of Joins.srt (2.2 KB)
    • 2. What are Joins.mp4 (11.9 MB)
    • 2. What are Joins.srt (3.0 KB)
    • 3. Inner join.mp4 (55.9 MB)
    • 3. Inner join.srt (8.9 KB)
    • 4. Left outer join.mp4 (20.4 MB)
    • 4. Left outer join.srt (2.9 KB)
    • 5. Right outer join.mp4 (18.9 MB)
    • 5. Right outer join.srt (2.6 KB)
    • 6. Union.mp4 (23.2 MB)
    • 6. Union.srt (3.7 KB)
    • 7. CERTESIAN Product or Cross Join.mp4 (25.3 MB)
    • 7. CERTESIAN Product or Cross Join.srt (3.9 KB)
    • 8. Query Exercise.mp4 (10.7 MB)
    • 8. Query Exercise.srt (1.5 KB)
    • 9. Solution for Query Exercise.mp4 (8.7 MB)
    • 9. Solution for Query Exercise.srt (1.1 KB)
    13. SQL Constraints
    • 1. Section introduction.mp4 (10.6 MB)
    • 1. Section introduction.srt (1.5 KB)
    • 2. Check constraint.mp4 (58.7 MB)
    • 2. Check constraint.srt (8.5 KB)
    • 3. NOT NULL constraint.mp4 (23.5 MB)
    • 3. NOT NULL constraint.srt (3.6 KB)
    • 4. UNIQUE constraint.mp4 (49.6 MB)
    • 4. UNIQUE constraint.srt (7.0 KB)
    14. Views
    • 1. Creating Views.mp4 (28.3 MB)
    • 1. Creating Views.srt (4.2 KB)
    • 2. Data Analytic Views from multiple tables.mp4 (31.9 MB)
    • 2. Data Analytic Views from multiple tables.srt (4.1 KB)
    15. Advanced SQL Functions
    • 1. Section Introduction.mp4 (8.8 MB)
    • 1. Section Introduction.srt (0.9 KB)
    • 2. Timestamp.mp4 (25.6 MB)
    • 2. Timestamp.srt (3.9 KB)
    • 3. Extract from timestamp.mp4 (24.1 MB)
    • 3. Extract from timestamp.srt (3.1 KB)
    • 4. Mathematical scalar functions.mp4 (18.7 MB)
    • 4. Mathematical scalar functions.srt (3.0 KB)
    • 5. String functions.mp4 (53.2 MB)
    • 5. String functions.srt (9.3 KB)
    • 6. Advanced functions.mp4 (28.9 MB)
    • 6. Advanced functions.srt (5.0 KB)
    • 7. Sub Queries.mp4 (24.9 MB)
    • 7. Sub Queries.srt (3.8 KB)
    • 8. SELECT with calculations.mp4 (43.1 MB)
    • 8. SELECT with calculations.srt (5.2 KB)
    16. SQL Stored procedures
    • 1. Create stored procedure.mp4 (47.2 MB)
    • 1. Create stored procedure.srt (6.7 KB)
    • 2. Stored procedure with parameter.mp4 (31.1 MB)
    • 2. Stored procedure with parameter.srt (4.4 KB)
    • 3. Drop Procedure.mp4 (13.5 MB)
    • 3. Drop Procedure.srt (1.6 KB)
    17. Import & Export data
    • 1. Section Introduction.mp4 (9.4 MB)
    • 1. Section Introduction.srt (1.4 KB)
    • 2. Import .csv file.mp4 (34.2 MB)
    • 2. Import .csv file.srt (5.5 KB)
    • 3. Export Data to .csv file.mp4 (19.3 MB)
    • 3. Export Data to .csv file.srt (2.7 KB)
    18. Backup and Restore Database
    • 1. Section Introduction.mp4 (6.7 MB)
    • 1. Section Introduction.srt (0.8 KB)
    • 2. Creating Database backup.mp4 (20.5 MB)
    • 2. Creating Database backup.srt (2.8 KB)
    • 3. Restoring Database backup.mp4 (20.8 MB)
    • 3. Restoring Database backup.srt (2.7 KB)
    2. SQL Server setting up
    • 1. Section Introduction.mp4 (9.2 MB)
    • 1. Section Introduction.srt (1.1 KB)
    • 2. MySQL Server Installation.mp4 (93.1 MB)
    • 2. MySQL Server Installation.srt (18.3 KB)
    • 3. Connect MySQL Server Instance.mp4 (37.1 MB)
    • 3. Connect MySQL Server Instance.srt (8.0 KB)
    • 4. MySQL Workbench overview.mp4 (64.4 MB)
    • 4. MySQL Workbench overview.srt (14.8 KB)
    • 5. Download and Restore Sample Database.mp4 (59.7 MB)
    • 5. Download and Restore Sample Database.srt (8.9 KB)
    3. SQL Database basics
    • 1. Section Introduction.mp4 (9.1 MB)
    • 1. Section Introduction.srt (1.2 KB)
    • 10. Creating Temporary tables.mp4 (74.2 MB)
    • 10. Creating Temporary tables.srt (15.9 KB)
    • 11. EER – Enhanced Entity Relationship Diagrams.mp4 (38.7 MB)
    • 11. EER – Enhanced Entity Relationship Diagrams.srt (5.6 KB)
    • Description

      Learn MySQL from scratch for Data Science and Analytics



      https://CourseWikia.com

      Published 07/2022
      MP4 | Video: h264, 1280x720 | Audio: AAC, 44.1 KHz, 2 Ch
      Genre: eLearning | Language: English + srt | Duration: 87 lectures (5h 40m) | Size: 2.5 GB

      Using MySQL Server RDBMS with Workbench to Become a SQL Expert on Queries for your Business Logic on real world problems

      What you'll learn
      What you'll learn
      Use SQL to query a data for reports
      Get a job as a junior Data Analytics developer
      Advanced SQL statements
      Use Workbench to prepare Database schema structure
      Be comfortable putting SQL and MySQL on their resume
      Learn to perform GROUP BY statements for Business Intelligence reports
      Replicate real-world situations and query reports
      Complete basic SELECT statements querying against a single table
      Filter data using the WHERE clause to identify required data
      Apply SQL for Data Science
      Using JOINS, return data from multiple tables in the same query
      Complete Analysis statements that use aggregate functions
      Import and Export .CSV, Excel to SQL Database
      Performing Secure Backup and Restore Full SQL Database

      Requirements
      No prior technical experience is required! All you need a computer!
      No SQL experience needed. You will learn everything you need to know
      No software is required in advance of the course (all software used in the course is free)



Download torrent
2.4 GB
seeders:7
leechers:9
Udemy - Learn MySQL from scratch for Data Science and Analytics


Trackers

tracker name
udp://tracker.torrent.eu.org:451/announce
udp://tracker.tiny-vps.com:6969/announce
http://tracker.foreverpirates.co:80/announce
udp://tracker.cyberia.is:6969/announce
udp://exodus.desync.com:6969/announce
udp://explodie.org:6969/announce
udp://tracker.opentrackr.org:1337/announce
udp://9.rarbg.to:2780/announce
udp://tracker.internetwarriors.net:1337/announce
udp://ipv4.tracker.harry.lu:80/announce
udp://open.stealth.si:80/announce
udp://9.rarbg.to:2900/announce
udp://9.rarbg.me:2720/announce
udp://opentor.org:2710/announce
µTorrent compatible trackers list

Download torrent
2.4 GB
seeders:7
leechers:9
Udemy - Learn MySQL from scratch for Data Science and Analytics


Torrent hash: 66241200B6BCC549F84E7EFC75B0A560F294DDCA