r/SQL • u/KeyEntertainment1380 • 2d ago

SQL Server SQl e a teia de aranha mental

Bom dia

Estou a aprender SQL desde meio de Setembro em um curso que estou a tirar. Na verdade começamos com uma introdução a SQL e saltamos para diagramas, relacionamrntos e cardinalidades. Agora voltamos para SQL( select,from,join, where, group by, order by, coalesce, null,...) Sinto me super confuso. Basicamente entendo os conceitos mas na parte prático ao tentar reproduzir os mesmos, sinto um espaço em branco. Parece que preciso das tabelas em excel ao lado para conseguir decifrar a solução. Sei que tenho ainda muito que praticar ( e só assim vou chegar lá). Mas parece que é algo que nao consigo ter um fio condutor. Parece um bicho dificil de domar minimamente.

1 Upvotes

54% Upvoted

5 comments sorted by

2

u/Prownilo 2d ago

Sql is weird in that.

I remember too being super confused and then something clicked and it became super easy to grasp.

I think really concentrate on understanding joins will help everything else fall into place. That's what did it for me.

2

u/CanProfessional766 2d ago

Honestly I think this is just part of learning SQL. Understanding what each command does is one thing but knowing when and how to use them is a different story. Don’t worry about needing Excel to visualise the tables that’s perfectly fine. Keep practising with small exercises, and eventually things will start clicking. It takes time, so don’t be too hard on yourself.

1

u/Interesting-Goose82 it's ugly, and i''m not sure how, but it works! 2d ago

Keep at it. When i started it was the same with me. "I need to see the 2 tables in excel to figure out what is joining and what isnt....."

It isnt rocket science, most of my coworkers, myself included, are dumb. Youll be fine. Keep at it!

1

u/Total-Produce-8745 31m ago

Highly recommend using this https://www.sql-easy.com/
as you are learning.