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/ahmedsami1976 My Linkedin Profile https://www.linkedin.com/in/ahmed-sami-a173138/ Repo containing material showed in the videos https://github.com/ahmedsami76/sql