Udemy - SQL Data Analyst - SQL , Microsoft SQL, PostgreSQL, MySQL

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

Files

[ FreeCourseWeb.com ] Udemy - SQL Data Analyst - SQL , Microsoft SQL, PostgreSQL, MySQL
  • Get Bonus Downloads Here.url (0.2 KB)
    • ~Get Your Files Here ! 01 Introduction
    • 001 Introduction.en.srt (0.5 KB)
    • 001 Introduction.mp4 (1.5 MB)
    • 002 What is SQL.en.srt (3.3 KB)
    • 002 What is SQL.mp4 (14.9 MB)
    • 003 What is a Data Analyst.html (2.5 KB)
    • 004 What is MySQL.en.srt (3.4 KB)
    • 004 What is MySQL.mp4 (16.7 MB)
    • 005 What is PostgreSQL.en.srt (1.6 KB)
    • 005 What is PostgreSQL.mp4 (6.5 MB)
    • 006 What is SQL Server.en.srt (2.7 KB)
    • 006 What is SQL Server.mp4 (11.2 MB)
    • 007 What is T-SQL.en.srt (1.7 KB)
    • 007 What is T-SQL.mp4 (7.3 MB)
    • 008 Basic Database Concepts.en.srt (4.5 KB)
    • 008 Basic Database Concepts.mp4 (18.9 MB)
    • 009 What is a Schema.en.srt (2.9 KB)
    • 009 What is a Schema.mp4 (9.6 MB)
    • 010 Database Schema.en.srt (5.4 KB)
    • 010 Database Schema.mp4 (22.0 MB)
    02 MySQL Database Server Setup
    • 001 MySQL Download & Installation on Windows.en.srt (18.2 KB)
    • 001 MySQL Download & Installation on Windows.mp4 (69.8 MB)
    • 002 MySQL Workbench for windows.en.srt (7.0 KB)
    • 002 MySQL Workbench for windows.mp4 (34.4 MB)
    • 003 MySQL Installation on Macs.en.srt (8.8 KB)
    • 003 MySQL Installation on Macs.mp4 (39.4 MB)
    • 004 MySQL Workbench Installation on Macs.en.srt (7.3 KB)
    • 004 MySQL Workbench Installation on Macs.mp4 (16.4 MB)
    • 005 Creating a new MySQL Connection.en.srt (6.9 KB)
    • 005 Creating a new MySQL Connection.mp4 (30.1 MB)
    • 006 Managing Server Connections.en.srt (7.0 KB)
    • 006 Managing Server Connections.mp4 (27.4 MB)
    • 007 Client Connections.en.srt (6.2 KB)
    • 007 Client Connections.mp4 (45.2 MB)
    • 008 Checking MySQL Server Status.en.srt (5.2 KB)
    • 008 Checking MySQL Server Status.mp4 (31.1 MB)
    • 009 MySQL Data Types.en.srt (7.4 KB)
    • 009 MySQL Data Types.mp4 (24.9 MB)
    • 010 Creating a database in MySQL.en.srt (7.1 KB)
    • 010 Creating a database in MySQL.mp4 (28.9 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)
    • 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)
    03 Data Analysis & Manipulation with MySQL
    • 001 Query Data.en.srt (9.2 KB)
    • 001 Query Data.mp4 (41.0 MB)
    • 002 SUB Queries.en.srt (4.6 KB)
    • 002 SUB Queries.mp4 (21.4 MB)
    • 003 Nested Sub queries.en.srt (3.4 KB)
    • 003 Nested Sub queries.mp4 (15.3 MB)
    • 004 Derived Tables.en.srt (4.1 KB)
    • 004 Derived Tables.mp4 (21.8 MB)
    • 005 Insert Data.en.srt (10.2 KB)
    • 005 Insert Data.mp4 (52.0 MB)
    • 006 Update Data.en.srt (12.6 KB)
    • 006 Update Data.mp4 (65.6 MB)
    • 007 Delete Data.en.srt (5.9 KB)
    • 007 Delete Data.mp4 (27.2 MB)
    • 008 Removing duplicate records.en.srt (6.5 KB)
    • 008 Removing duplicate records.mp4 (28.7 MB)
    • 009 Grouping Data.en.srt (4.4 KB)
    • 009 Grouping Data.mp4 (19.4 MB)
    • 010 Separating Grouped Data.en.srt (6.9 KB)
    • 010 Separating Grouped Data.mp4 (38.9 MB)
    • 011 Sorting Data.en.srt (6.8 KB)
    • 011 Sorting Data.mp4 (42.3 MB)
    • 012 Filtering Data.en.srt (3.2 KB)
    • 012 Filtering Data.mp4 (12.2 MB)
    04 MySQL Data Analysis using Table Joins & Views
    • 001 MySQL INNER Join.en.srt (12.5 KB)
    • 001 MySQL INNER Join.mp4 (59.0 MB)
    • 002 MySQL LEFT Join.en.srt (6.8 KB)
    • 002 MySQL LEFT Join.mp4 (29.7 MB)
    • 003 MySQL RIGHT Join.en.srt (4.2 KB)
    • 003 MySQL RIGHT Join.mp4 (21.2 MB)
    • 004 MySQL SELF Join.en.srt (8.1 KB)
    • 004 MySQL SELF Join.mp4 (39.8 MB)
    • 005 MySQL VIEWS.en.srt (5.2 KB)
    • 005 MySQL VIEWS.mp4 (14.6 MB)
    • 006 Creating MySQL Views.en.srt (4.9 KB)
    • 006 Creating MySQL Views.mp4 (18.9 MB)
    • 007 Query MySQL Views.en.srt (3.8 KB)
    • 007 Query MySQL Views.mp4 (20.2 MB)
    • 008 Modify Views.en.srt (6.7 KB)
    • 008 Modify Views.mp4 (33.8 MB)
    • 009 Dropping a View.en.srt (2.9 KB)
    • 009 Dropping a View.mp4 (11.4 MB)
    05 MySQL Data Analysis using Aggregate Functions & Operators
    • 001 What are aggregate Functions.en.srt (1.9 KB)
    • 001 What are aggregate Functions.mp4 (5.9 MB)
    • 002 AVG Aggregate Function.en.srt (3.8 KB)
    • 002 AVG Aggregate Function.mp4 (15.9 MB)
    • 003 COUNT Aggregate Function.en.srt (9.7 KB)
    • 003 COUNT Aggregate Function.mp4 (44.7 MB)
    • 004 SUM Aggregate Function.en.srt (4.3 KB)
    • 004 SUM Aggregate Function.mp4 (20.2 MB)
    • 005 MIN Aggregate Function.en.srt (2.3 KB)
    • 005 MIN Aggregate Function.mp4 (10.5 MB)
    • 006 MAX Aggregate Function.en.srt (2.8 KB)
    • 006 MAX Aggregate Function.mp4 (12.6 MB)
    • 007 BETWEEN Operator.en.srt (7.0 KB)
    • 007 BETWEEN Operator.mp4 (40.4 MB)
    • 008 IN Operator.en.srt (9.2 KB)
    • 008 IN Operator.mp4 (68.2 MB)
    • 009 LIKE Operator.en.srt (12.3 KB)
    • 009 LIKE Operator.mp4 (69.3 MB)
    • 010 UNION Operator.en.srt (7.4 KB)
    • 010 UNION Operator.mp4 (36.8 MB)
    06 PostgreSQL Setup <

Description

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.



Download torrent
3.3 GB
seeders:27
leechers:13
Udemy - SQL Data Analyst - SQL , Microsoft SQL, PostgreSQL, MySQL
Loading...