Under the Jacaranda
  • Communities
  • Create Post
  • Create Community
  • heart
    Support Lemmy
  • search
    Search
  • Login
  • Sign Up
testeronious@lemmy.world to Programming@programming.dev · 1 year ago

Why most developers stop learning SQL at subqueries - a 5-minute guide for PARTITION BY and CTEs

zaidesanton.substack.com

external-link
message-square
14
fedilink
122
external-link

Why most developers stop learning SQL at subqueries - a 5-minute guide for PARTITION BY and CTEs

zaidesanton.substack.com

testeronious@lemmy.world to Programming@programming.dev · 1 year ago
message-square
14
fedilink
Improve your SQL skills X2 in 5 minutes
zaidesanton.substack.com
external-link
SQL for managers is an underrated skill
  • fmstrat@lemmy.nowsci.com
    link
    fedilink
    English
    arrow-up
    13
    ·
    1 year ago

    Huh? How do you write an efficient query and not take into account joins? A single table query? Are you a Prisma fan?

    • FooBarrington@lemmy.world
      link
      fedilink
      arrow-up
      8
      ·
      1 year ago

      Are you a Prisma fan?

      Ooooh, that’s a good burn

Programming@programming.dev

programming@programming.dev

Subscribe from Remote Instance

Create a post
You are not logged in. However you can subscribe from another Fediverse account, for example Lemmy or Mastodon. To do this, paste the following into the search field of your instance: [email protected]

Welcome to the main community in programming.dev! Feel free to post anything relating to programming here!

Cross posting is strongly encouraged in the instance. If you feel your post or another person’s post makes sense in another community cross post into it.

Hope you enjoy the instance!

Rules

Rules

  • Follow the programming.dev instance rules
  • Keep content related to programming in some way
  • If you’re posting long videos try to add in some form of tldr for those who don’t want to watch videos

Wormhole

Follow the wormhole through a path of communities [email protected]



Visibility: Public
globe

This community can be federated to other instances and be posted/commented in by their users.

  • 139 users / day
  • 1.07K users / week
  • 2.95K users / month
  • 7.14K users / 6 months
  • 1 local subscriber
  • 20.1K subscribers
  • 2.2K Posts
  • 34.6K Comments
  • Modlog
  • mods:
  • snowe@programming.dev
  • Ategon@programming.dev
  • MaungaHikoi@lemmy.nz
  • BE: 0.19.7
  • Modlog
  • Instances
  • Docs
  • Code
  • join-lemmy.org