SQL Interview Challenge! Reverse Engineering a Database Schema with ChatGPT!

In this video, we take a look at a fantastic question posted on Reddit. The user states they were given a set of queries and asked to generate a schematic or ERD (entity relationship diagram) of the database without being given any table information.

Well we took the challenge on using ChatGPT to give us some sample queries, and ended up with an elaborate and detailed ERD.

In this video, I show you my thought process step by step, including fields, relationships, and even data types!

Lots of fun, and I think we’ll make it a regular topic!

--------------------------------------------------

Tools used:

https://chat.bing.com

https://LucidChart.com

   / @lucidchart  
--------------------------------------------------

If you want to check out some report demos or blog posts, have a look at https://SQLDevDBA.com

Shout out to    / @lascurry   for his tutorials and how to videos on OBS and Streaming strategies, this was the first stream since implementing those and I’m quite happy with the results.

Catch me on Twitch!   / sqldevdba  

-----------------------------------------
Data Sources
https://kaggle.com
https://data.gov
https://statista.com
https://www.microsoft.com/en-us/resea...
/ datasets
https://datos.estadisticas.pr
-----------------------------------------
Resources:
Notepad ++: https://notepad-plus-plus.org/downloads
Power BI Visual Vocabulary: https://community.fabric.microsoft.co...
https://dbatools.io/commands
https://liveSQL.oracle.com
-----------------------------------------
Favorite PBI Channels:
/ @howtopowerbi
/ @datapears
/ @guyinacube
/ @powerbipark
-----------------------------------------

--------------------------------------------------

Tags:
#sql #powerbi #datavisualization #data #dataanalysis #lyft #portfolio #tutorial #powerbitutorial #sqltutorial #sqlserver #databases