Course Hive
Search

Welcome

Sign in or create your account

Continue with Google
or
How to Extract JSON Data using Excel vs SQL vs Python vs ChatGPT
Play lesson

SQL Tips - How to Extract JSON Data using Excel vs SQL vs Python vs ChatGPT

4.0 (2)
17 learners

What you'll learn

This course includes

  • 9 hours of video
  • Certificate of completion
  • Access on mobile and TV

Summary

Keywords

Full Transcript

Save up to 50% off Maven Pro Plans! ➡️ https://bit.ly/4cXXTHo Maven instructors Enrique Ruiz, Alice Zhao, and Chris Bruehl demonstrate how to flatten a column of nested JSON data into individual rows in a table using Excel, SQL, and Python. Then, we see how ChatGPT approaches the same task. Try this Data Drill out yourself! 👉 https://bit.ly/3YZXb6f 🎉 UP TO 50% OFF SPRING SAVINGS 🎉 The LOWEST PRICING of the season starts NOW! AI is reshaping every industry, and the professionals who will thrive aren’t waiting to figure it out. They’re building real skills right now. You can, too! For Spring Savings, you can choose from 3 great offers through May 6th: 👉 Monthly plan: 25% off your first 3 months ($36.75/mo) 👉 Annual plan: 50% off your first year ($199.50/yr) 👉 Lifetime access: 50% off, forever ($849.50) All Maven Pro memberships include: ✓ Unlimited access to ALL courses & learning paths ✓ Customized learning plans ✓ Guided projects ✓ Skills assessments ✓ Showcase portfolio builder ✓ Free practice data sets ✓ Private student dashboard ✓ Live instructor chat support Plus something brand NEW, launching soon...👀 Build job-ready AI + data skills, all in one membership. SAVE NOW 👉 https://bit.ly/4cXXTHo 🔗 Helpful Resources 👉 Build Data Skills with Maven Analytics: https://bit.ly/4jEPZot 👉 Follow us on LinkedIn: Maven Analytics: https://www.linkedin.com/company/maven-analytics Enrique: https://www.linkedin.com/in/enrique-ruiz-tapia/ Alice: https://www.linkedin.com/in/alicexzhao/ Chris: https://www.linkedin.com/in/chrisbruehl/ ⏱️ Timestamps: 00:00 - Intro 00:15 - Data Drill Objective 00:37 - Excel Solution Walkthrough 04:29 - SQL Solution Walkthrough 11:16 - Python Solution Walkthrough 18:47 - ChatGPT Solution Walkthrough 20:53 - Validation Question 21:30 - Outro/Resources Maven Analytics is an award-winning online platform for data professionals to learn new skills, showcase their work, and connect with peers around the world. We've helped more than 1,000,000 students build job-ready data & AI skills, master tools like Excel, SQL, Power BI, Tableau and Python, and build the foundations for successful careers. Start learning and build your FREE portfolio at www.MavenAnalytics.io

Course Hive

Continue this lesson in the app

Install CourseHive on Android or iOS to keep learning while you move.

Related Courses

FAQs

Course Hive
Download CourseHive
Keep learning anywhere