| 001 Filtering Data with equality filters.en.srt | 14.8 KB | ||
| 001 Filtering Data with equality filters.mp4 | 129.8 MB | ||
| 001 Filtering Data.en.srt | 8 KB | ||
| 001 Filtering Data.mp4 | 45.2 MB | ||
| 001 Introduction.en.srt | 512 B | ||
| 001 Introduction.mp4 | 1.5 MB | ||
| 001 MySQL Download & Installation on Windows.en.srt | 18.2 KB | ||
| 001 MySQL Download & Installation on Windows.mp4 | 69.8 MB | ||
| 001 MySQL INNER Join.en.srt | 12.5 KB | ||
| 001 MySQL INNER Join.mp4 | 59 MB | ||
| 001 PostgreSQL Installation on Windows.en.srt | 10.9 KB | ||
| 001 PostgreSQL Installation on Windows.mp4 | 45.3 MB | ||
| 001 Query Data.en.srt | 9.2 KB | ||
| 001 Query Data.mp4 | 41 MB | ||
| 001 SQL Server Installation Requirements.en.srt | 4.4 KB | ||
| 001 SQL Server Installation Requirements.mp4 | 21.5 MB | ||
| 001 What are Analytic Functions.en.srt | 4.2 KB | ||
| 001 What are Analytic Functions.mp4 | 21.8 MB | ||
| 001 What are aggregate Functions.en.srt | 1.9 KB | ||
| 001 What are aggregate Functions.mp4 | 5.9 MB | ||
| 001 What are ranking functions.en.srt | 921.6 B | ||
| 001 What are ranking functions.mp4 | 3.4 MB | ||
| 002 AVG Aggregate Function.en.srt | 3.8 KB | ||
| 002 AVG Aggregate Function.mp4 | 15.9 MB | ||
| 002 Analysing data with PERCENT_RANK Functions.en.srt | 4 KB | ||
| 002 Analysing data with PERCENT_RANK Functions.mp4 | 25.8 MB | ||
| 002 Analysing data with RANK Functions.en.srt | 4.2 KB | ||
| 002 Analysing data with RANK Functions.mp4 | 21.5 MB | ||
| 002 Creating tables.en.srt | 7.8 KB | ||
| 002 Creating tables.mp4 | 34 MB | ||
| 002 Filtering Data with comparison filters.en.srt | 6.7 KB | ||
| 002 Filtering Data with comparison filters.mp4 | 55.8 MB | ||
| 002 MySQL LEFT Join.en.srt | 6.8 KB | ||
| 002 MySQL LEFT Join.mp4 | 29.7 MB | ||
| 002 MySQL Workbench for windows.en.srt | 7 KB | ||
| 002 MySQL Workbench for windows.mp4 | 34.4 MB | ||
| 002 PostgreSQL Installation on Macs.en.srt | 3.3 KB | ||
| 002 PostgreSQL Installation on Macs.mp4 | 16.9 MB | ||
| 002 SQL Server Editions.en.srt | 5 KB | ||
| 002 SQL Server Editions.mp4 | 28.5 MB | ||
| 002 SUB Queries.en.srt | 4.6 KB | ||
| 002 SUB Queries.mp4 | 21.4 MB | ||
| 002 Sorting Data.en.srt | 10 KB | ||
| 002 Sorting Data.mp4 | 40.4 MB | ||
| 002 What is SQL.en.srt | 3.3 KB | ||
| 002 What is SQL.mp4 | 14.9 MB | ||
| 003 Analysing data with CUME_DIST Functions.en.srt | 4.1 KB | ||
| 003 Analysing data with CUME_DIST Functions.mp4 | 21.1 MB | ||
| 003 Analysing data with NTILE Functions.en.srt | 4.1 KB | ||
| 003 Analysing data with NTILE Functions.mp4 | 20.2 MB | ||
| 003 COUNT Aggregate Function.en.srt | 9.7 KB | ||
| 003 COUNT Aggregate Function.mp4 | 44.7 MB | ||
| 003 Filtering Data with logical filters.en.srt | 16.9 KB | ||
| 003 Filtering Data with logical filters.mp4 | 153.6 MB | ||
| 003 MySQL Installation on Macs.en.srt | 8.8 KB | ||
| 003 MySQL Installation on Macs.mp4 | 39.4 MB | ||
| 003 MySQL RIGHT Join.en.srt | 4.2 KB | ||
| 003 MySQL RIGHT Join.mp4 | 21.2 MB | ||
| 003 Nested Sub queries.en.srt | 3.4 KB | ||
| 003 Nested Sub queries.mp4 | 15.3 MB | ||
| 003 PgAdmin Installation on Macs.en.srt | 6.1 KB | ||
| 003 PgAdmin Installation on Macs.mp4 | 33.3 MB | ||
| 003 SQL Server Downloads.en.srt | 5.7 KB | ||
| 003 SQL Server Downloads.mp4 | 23.2 MB | ||
| 003 SUB Queries.en.srt | 8.9 KB | ||
| 003 SUB Queries.mp4 | 42.5 MB | ||
| 003 Using AVG as Window Function.en.srt | 4.2 KB | ||
| 003 Using AVG as Window Function.mp4 | 22.9 MB | ||
| 003 What is a Data Analyst.html | 2.5 KB | ||
| 004 Analysing data with DENSE_ RANK Functions.en.srt | 5.6 KB | ||
| 004 Analysing data with DENSE_ RANK Functions.mp4 | 9.8 MB | ||
| 004 Analysing data with PERCENTILE_DISC Functions.en.srt | 4.5 KB | ||
| 004 Analysing data with PERCENTILE_DISC Functions.mp4 | 22.2 MB | ||
| 004 Comparison Operators.en.srt | 10.7 KB | ||
| 004 Comparison Operators.mp4 | 19.9 MB | ||
| 004 Connecting to PostgreSQL Database Server.en.srt | 5 KB | ||
| 004 Connecting to PostgreSQL Database Server.mp4 | 15.6 MB | ||
| 004 Derived Tables.en.srt | 4.1 KB | ||
| 004 Derived Tables.mp4 | 21.8 MB | ||
| 004 Filtering Data with string comparison filters.en.srt | 12.4 KB | ||
| 004 Filtering Data with string comparison filters.mp4 | 113.3 MB | ||
| 004 MySQL SELF Join.en.srt | 8.1 KB | ||
| 004 MySQL SELF Join.mp4 | 39.8 MB | ||
| 004 MySQL Workbench Installation on Macs.en.srt | 7.3 KB | ||
| 004 MySQL Workbench Installation on Macs.mp4 | 16.4 MB | ||
| 004 Row Number Functions.en.srt | 9.5 KB | ||
| 004 Row Number Functions.mp4 | 44.6 MB | ||
| 004 SQL Server Installation.en.srt | 12.8 KB | ||
| 004 SQL Server Installation.mp4 | 62.5 MB | ||
| 004 SUM Aggregate Function.en.srt | 4.3 KB | ||
| 004 SUM Aggregate Function.mp4 | 20.2 MB | ||
| 004 What is MySQL.en.srt | 3.4 KB | ||
| 004 What is MySQL.mp4 | 16.7 MB | ||
| 005 Analysing data with PERCENTILE_CONT Functions.en.srt | 3.4 KB | ||
| 005 Analysing data with PERCENTILE_CONT Functions.mp4 | 16.6 MB | ||
| 005 Analysing data with ROW Number Functions.en.srt | 5.4 KB | ||
| 005 Analysing data with ROW Number Functions.mp4 | 20.6 MB | ||
| 005 Creating a new MySQL Connection.en.srt | 6.9 KB | ||
| 005 Creating a new MySQL Connection.mp4 | 30.1 MB | ||
| 005 Download Sample Database.en.srt | 10.5 KB | ||
| 005 Download Sample Database.mp4 | 47 MB | ||
| 005 Insert Data.en.srt | 10.2 KB | ||
| 005 Insert Data.mp4 | 52 MB | ||
| 005 Installing SSMS.en.srt | 6.4 KB | ||
| 005 Installing SSMS.mp4 | 36.8 MB | ||
| 005 MIN Aggregate Function.en.srt | 2.3 KB | ||
| 005 MIN Aggregate Function.mp4 | 10.5 MB | ||
| 005 MySQL VIEWS.en.srt | 5.2 KB | ||
| 005 MySQL VIEWS.mp4 | 14.6 MB | ||
| 005 NOT Operators.en.srt | 6.8 KB | ||
| 005 NOT Operators.mp4 | 31 MB | ||
| 005 Rank Functions.en.srt | 3.1 KB | ||
| 005 Rank Functions.mp4 | 16.4 MB | ||
| 005 Sorting Data with ORDER BY.en.srt | 3 KB | ||
| 005 Sorting Data with ORDER BY.mp4 | 28.3 MB | ||
| 005 What is PostgreSQL.en.srt | 1.6 KB | ||
| 005 What is PostgreSQL.mp4 | 6.5 MB | ||
| 006 Analysing data with EXCEPT SET Operators.en.srt | 6.5 KB | ||
| 006 Analysing data with EXCEPT SET Operators.mp4 | 28.5 MB | ||
| 006 Connecting to SQL Server with SSMS.en.srt | 9.6 KB | ||
| 006 Connecting to SQL Server with SSMS.mp4 | 32.4 MB | ||
| 006 Creating MySQL Views.en.srt | 4.9 KB | ||
| 006 Creating MySQL Views.mp4 | 18.9 MB | ||
| 006 DENSE RANK Functions.en.srt | 3.3 KB | ||
| 006 DENSE RANK Functions.mp4 | 14 MB | ||
| 006 MAX Aggregate Function.en.srt | 2.8 KB | ||
| 006 MAX Aggregate Function.mp4 | 12.6 MB | ||
| 006 Managing Server Connections.en.srt | 7 KB | ||
| 006 Managing Server Connections.mp4 | 27.4 MB | ||
| 006 OR Operators.en.srt | 7.2 KB | ||
| 006 OR Operators.mp4 | 34.9 MB | ||
| 006 Sorting data in ascending order.en.srt | 4.4 KB | ||
| 006 Sorting data in ascending order.mp4 | 38.7 MB | ||
| 006 Update Data.en.srt | 12.6 KB | ||
| 006 Update Data.mp4 | 65.6 MB | ||
| 006 Using Multiple Ranking Functions.en.srt | 4.5 KB | ||
| 006 Using Multiple Ranking Functions.mp4 | 30.1 MB | ||
| 006 What is SQL Server.en.srt | 2.7 KB | ||
| 006 What is SQL Server.mp4 | 11.2 MB | ||
| 007 AND Operators.en.srt | 7.9 KB | ||
| 007 AND Operators.mp4 | 38.7 MB | ||
| 007 Analysing data with INTERSECT SET Operators.en.srt | 3.2 KB | ||
| 007 Analysing data with INTERSECT SET Operators.mp4 | 18 MB | ||
| 007 BETWEEN Operator.en.srt | 7 KB | ||
| 007 BETWEEN Operator.mp4 | 40.4 MB | ||
| 007 Client Connections.en.srt | 6.2 KB | ||
| 007 Client Connections.mp4 | 45.2 MB | ||
| 007 Delete Data.en.srt | 5.9 KB | ||
| 007 Delete Data.mp4 | 27.2 MB | ||
| 007 FIRST Value Function.en.srt | 2.5 KB | ||
| 007 FIRST Value Function.mp4 | 11.9 MB | ||
| 007 Install Sample Database.en.srt | 7.6 KB | ||
| 007 Install Sample Database.mp4 | 32.6 MB | ||
| 007 Query MySQL Views.en.srt | 3.8 KB | ||
| 007 Query MySQL Views.mp4 | 20.2 MB | ||
| 007 Sorting data in descending order.en.srt | 5.3 KB | ||
| 007 Sorting data in descending order.mp4 | 42.1 MB | ||
| 007 What is T-SQL.en.srt | 1.7 KB | ||
| 007 What is T-SQL.mp4 | 7.3 MB | ||
| 008 Analysing data with UNION SET Operators.en.srt | 5.3 KB | ||
| 008 Analysing data with UNION SET Operators.mp4 | 30.2 MB | ||
| 008 Basic Database Concepts.en.srt | 4.5 KB | ||
| 008 Basic Database Concepts.mp4 | 18.9 MB | ||
| 008 Checking MySQL Server Status.en.srt | 5.2 KB | ||
| 008 Checking MySQL Server Status.mp4 | 31.1 MB | ||
| 008 Combining AND _ OR Operators.en.srt | 9.3 KB | ||
| 008 Combining AND _ OR Operators.mp4 | 51.8 MB | ||
| 008 IN Operator.en.srt | 9.2 KB | ||
| 008 IN Operator.mp4 | 68.2 MB | ||
| 008 LAST Value Function.en.srt | 3.4 KB | ||
| 008 LAST Value Function.mp4 | 20.6 MB | ||
| 008 Modify Views.en.srt | 6.7 KB | ||
| 008 Modify Views.mp4 | 33.8 MB | ||
| 008 Removing duplicate records.en.srt | 6.5 KB | ||
| 008 Removing duplicate records.mp4 | 28.7 MB | ||
| 008 Sorting data by multiple columns.en.srt | 4.9 KB | ||
| 008 Sorting data by multiple columns.mp4 | 47.7 MB | ||
| 009 Dropping a View.en.srt | 2.9 KB | ||
| 009 Dropping a View.mp4 | 11.4 MB | ||
| 009 Grouping Data.en.srt | 4.4 KB | ||
| 009 Grouping Data.mp4 | 19.4 MB | ||
| 009 LAG Function.en.srt | 3.3 KB | ||
| 009 LAG Function.mp4 | 14.3 MB | ||
| 009 LIKE Operator.en.srt | 12.3 KB | ||
| 009 LIKE Operator.mp4 | 69.3 MB | ||
| 009 MySQL Data Types.en.srt | 7.4 KB | ||
| 009 MySQL Data Types.mp4 | 24.9 MB | ||
| 009 What is a Schema.en.srt | 2.9 KB | ||
| 009 What is a Schema.mp4 | 9.6 MB | ||
| 010 Creating a database in MySQL.en.srt | 7.1 KB | ||
| 010 Creating a database in MySQL.mp4 | 28.9 MB | ||
| 010 Database Schema.en.srt | 5.4 KB | ||
| 010 Database Schema.mp4 | 22 MB | ||
| 010 LEAD Function.en.srt | 3.4 KB | ||
| 010 LEAD Function.mp4 | 15.8 MB | ||
| 010 Separating Grouped Data.en.srt | 6.9 KB | ||
| 010 Separating Grouped Data.mp4 | 38.9 MB | ||
| 010 UNION Operator.en.srt | 7.4 KB | ||
| 010 UNION Operator.mp4 | 36.8 MB | ||
| 011 Sorting Data.en.srt | 6.8 KB | ||
| 011 Sorting Data.mp4 | 42.3 MB | ||
| 011 Using IF NOT EXIST DROP.en.srt | 4.6 KB | ||
| 011 Using IF NOT EXIST DROP.mp4 | 11.8 MB | ||
| 012 Creating a table in MySQL Database.en.srt | 15.7 KB | ||
| 012 Creating a table in MySQL Database.mp4 | 67.5 MB | ||
| 012 Filtering Data.en.srt | 3.2 KB | ||
| 012 Filtering Data.mp4 | 12.2 MB | ||
| 013 Setting Default MySQL Database.en.srt | 5.6 KB | ||
| 013 Setting Default MySQL Database.mp4 | 20.9 MB | ||
| 014 Using Primary Keys.en.srt | 4.7 KB | ||
| 014 Using Primary Keys.mp4 | 22.5 MB | ||
| 015 Using Foreign Keys.en.srt | 5.9 KB | ||
| 015 Using Foreign Keys.mp4 | 29.5 MB | ||
| 016 SQL Statement and Query.en.srt | 6.5 KB | ||
| 016 SQL Statement and Query.mp4 | 25.7 MB | ||
| Bonus Resources.txt | 307.2 B | ||
| Get Bonus Downloads Here.url | 204.8 B | ||
| ▲ 219 total files | |||
SQL Data Analyst - SQL , Microsoft SQL, PostgreSQL, MySQL
MP4 | Video: h264, 1280x720 | Audio: AAC, 44.1 KHz, 2 Ch
Genre: eLearning | Language: English + srt | Duration: 109 lectures (10h 21m) | Size: 2.77 GB
Hands-On Data Analysis with SQL
What you'll learn:
Analyse and manipulate data
Create Database and Tables
Analyse data using aggregate functions
Analyse data using analytic functions
Analyse data using ranking functions
Analyse data using various operators
Analyse data using sub queries
Analyse data using views
Requirements
Basic knowledge of SQL required
Basic knowledge of database concepts
Description
A SQL data analyst is a data scientist that uses the SQL language to interpret data.
This analysis is used to improve business information and provide new insights to managers.
| torrent name | size | uploader | age | seed | leech |
|---|---|---|---|---|---|
| 274.1 MB | freecoursewb | 1 week | 17 | 1 | |
|
Udemy - Data Analytics for Beginners - Excel, SQL, and AI Dashboards Posted by
freecoursewb in Other
|
2.1 GB | freecoursewb | 4 weeks | 0 | 0 |
|
Udemy - Databricks Spark Streaming, Delta Lake and SQL, AI Analytics Posted by
freecoursewb in Other
|
3.3 GB | freecoursewb | 4 weeks | 1 | 5 |
| 2.5 GB | freecoursewb | 1 month | 26 | 4 | |
| 1.6 GB | freecoursewb | 1 month | 9 | 8 |
All Comments