Data Analyst Portfolio Project - Synthetic Financial Datasets For Fraud Detection

Take your SQL data analysis skills to the next level with this full portfolio project. In just 1 hour, you'll dive into an end-to-end SQL project that will showcase your practical skills in data analysis. Perfect for beginners and experienced data analysts alike!

Dataset - https://www.kaggle.com/datasets/ealax...

GIT HUB Download Data : https://github.com/shubhamringole/SQL...

Questions and Solution :   / sql-data-analyst-project  


Playlist Name: Learn SQL Complete Guide • Learn SQL: Complete Guide

Medium Blog -   / sql-data-analyst-project  

Description for Playlist:
Welcome to the "SQL Mastery: From Basics to Advanced" playlist! This series is designed to take you from a complete beginner to a proficient SQL user. Whether you're looking to learn SQL for data analysis, database management, or enhancing your development skills, this playlist has you covered.

🎓 What You Will Learn:

The fundamentals of SQL and relational databases
Essential SQL commands for data manipulation and querying
Advanced SQL techniques for filtering, sorting, and joining tables
Practical applications of SQL in various industries
Step-by-step tutorials on using SQL tools and software

🔗 Videos in this Playlist:

1. Introduction to SQL Learn to Query Databases Like a Pro
• Introduction to SQL Learn to Query Da...
2.How to Install MySQL Workbench - A step-by-step guide on downloading, installing, and setting up MySQL Workbench.
• How to Install MYSQL Work Bench | Les...
3.SQL Fundamentals: Data Types, Keys, and Constraints
• SQL Essentials: Understanding Data Ty...
4.SQL Table Operations : Create, Delete, Drop, Truncate, and Alter | Lesson 4 | Introduction to SQL
• SQL Table Operations : Create, Delete...
5.SELECT Statement | WHERE Clause with Examples and Operators in SQL |Lesson 5 | Introduction to SQL
• SELECT Statement | WHERE Clause with ...
6.How to Import an Excel CSV File into MySQL A Step by Step Guide| Lesson 4 | Introduction to SQL
• How to Import an Excel CSV File into ...
7.Mastering SQL GROUP BY and HAVING Clauses Explained
• Mastering GROUP BY and HAVING Clauses...
8.Mastering SQL JOINs: Complete Guide with Examples | INNER & LEFT JOIN Lesson 8 | Introduction to SQL
• SQL JOIN | INNER & LEFT JOIN Lesson ...
9. Right Join, Cross Join, and Outer Join Explained | Lesson 9 | Introduction to SQL
• SQL Join Tutorial: Right, Cross, Oute...
10.SQL Subqueries Explained: Unlock Advanced Querying Techniques
• Master SQL with Secret Subquery Tips

Timecodes
00:00 Intro
01:33 Channel Intro
01:42 Understanding Data Set
06:20 Importing Data Set
14:37 Detecting Recursive Fraudulent Transactions
26:31 Analyzing Fraudulent Activity over Time
33:20 Complex Fraud Detection Using Multiple CTEs
44:55 Query that checks new_updated_Balance equal to actual newbalanceDest
50:07 Practice Question
51:56 Upload to GitHub