Skip to content
DataDeconstructedLogo
  • PostsExpand
    • Most Popular Posts
    • Latest Posts
  • TopicsExpand
    • Data Science
    • SQL
    • LLMsExpand
      • ChatGPT
      • Image Models
    • Business Intelligence
    • Resources
  • ResourcesExpand
    • Free Open Source Books
    • Essential Links for a Data Scientist
  • About
Twitter Linkedin
DataDeconstructedLogo

SQL

SQL (Structured Query Language) underpins nearly every technology in the world and is the most effective way of pulling and transforming data. These posts will span from beginner SQL to Advanced SQL querying strategies and tips

Data Scientist looks at computer
ChatGPT | Data Science | Resources | SQL

Essential Links for a Data Scientist

ByMatt July 16, 2023August 29, 2023

A curated list of essential resources and links for any Data Scientist, covering Machine Learning, AI, ChatGPT & other LLMs like Bard and Claude

Read More Essential Links for a Data ScientistContinue

SQL Server Cross apply
SQL

SQL Tip #1: APPLY and why you should be using it

ByMatt June 11, 2023February 19, 2024

Write a lot of SQL joins? Learn the magic of the Apply operator to make more efficient and performant joins between tables and datasets. Using Apply can often outperform joins or subqueries and makes your code much cleaner and easier to read.

Read More SQL Tip #1: APPLY and why you should be using itContinue

SQL Shortcuts keyboard
SQL

5 Game-Changing SQL Server Shortcuts

ByMatt May 22, 2023August 8, 2023

In this article we’ll show you five little-known SQL Server Management Studio tips and tricks that even veteran SQL coders may not be aware of. By learning these shortcuts you can massively improve your SQL speed and efficiency, and its a fun way to impress your coworkers. (If you’re new or just want to try…

Read More 5 Game-Changing SQL Server ShortcutsContinue

Categories

  • ChatGPT
  • Data Science
  • Image Models
  • LLMs
  • Resources
  • SQL

Trending

  • Improve ChatGPT Results with Expert Prompting
  • The Ultimate ChatGPT Custom Instructions Guide
  • SQL Tip #1: APPLY and why you should be using it
  • Create AI images with Midjourney in 5 Simple Steps

© 2025 DataDeconstructed     |

Contact

Scroll to top
  • Posts
    • Most Popular Posts
    • Latest Posts
  • Topics
    • Data Science
    • SQL
    • LLMs
      • ChatGPT
      • Image Models
    • Business Intelligence
    • Resources
  • Resources
    • Free Open Source Books
    • Essential Links for a Data Scientist
  • About