SQL for Data Analysis | شاهد كيف أصبح الفيل والدرفيل أصدقاء

#AhmedSami #AraBigData #SQL

SQL for Data Analysis

Chapters:
----
00:00 Introduction

** Prepare the Environment
1:35 GitHub repo
4:10 Introduction to MySQL
9:45 Installing MySQL
13:00 MySQL Post Installation Tasks
39:35 MySQL Workbench
51:41 VSCode Database Extension

** Relational Databases
56:19 Introduction to Relational Databases
1:10:25 Modeling and Design
1:19:17 Normalization
1:31:15 Entity-Relationship Diagram
1:36:11 Primary and Foreign Keys
2:01:28 RDBMS
2:13:36 Data Roles
2:20:30 OLTP vs OLAP

** Basic SQL
2:32:40 Introduction to SQL Language
2:48:40 SELECT
4:32:24 -- GROUP BY
4:40:49 -- JOIN
5:05:42 - -VIEWS
5:17:12 INSERT
5:26:40 UPDATE
5:32:00 DELETE
5:38:06 Constraints
6:06:35 Indexes
6:27:44 Transactions
7:04:36 Stored Objects
7:30:45 Control Flow

** PostgreSQL
7:42:22 Introduction to PostgreSQL
8:20:55 Restore Databases using PGAdmin

** Using Python using RDBMS
8:30:55 Prerequisites
8:33:15 Using mysql.connector for MySQL
8:45:46 Using SQLAlchemy for MySQL
8:49:40 Using Psycopg2 for PostgreSQL

** Data Analysis using SQL
8:54:45 Prepare Data for Analysis
9:05:10 Role of Data Analyst
9:20:50 Exploration
9:24:22 Profiling
9:28:30 Enriching and Reshaping
9:35:24 Cleanup

** Window Functions
9:39:55 Introduction to Window Functions
9:48:30 OVER()
9:50:30 Partitioning
9:57:30 ROW_NUMBER()
10:03:33 RANK() and DENSE_RANK()
10:11:19 LEAD() and LAG()
10:14:22 NTILE()
---

للدعم عن طريق موقع باتريون
https://www.patreon.com/user?u=43417528
للدعم عن طريق باي بال
https://www.paypal.com/paypalme/ahmed...

My Linkedin Profile
  / ahmed-sami-a173138  

Repo containing material showed in the videos
https://github.com/ahmedsami76/sql