r/learnSQL • u/Sorry_Data_IT • 2d ago

Sql expert?

How to become sql expert as data analyst as 7 years of experience as im tableau developer but I know sql basic.

What things to learn to show as 7 years expert in sql or for role of sql developer or data analyst with sql.

Please list down things like

Topics

Types of questions and knowledge to have etc

6 Upvotes

67% Upvoted

11 comments sorted by

2

u/Owen-Isaac-2022 1d ago

Give yourself 2 hours a day to study & practice SQL for at least 2 months. It'll require personal sacrifice.

2

u/Jobsnotdone1724 1d ago

I always forced myself to study before, every after shift.

1

u/91ws6ta 1d ago

Basic:

Views, filtering data using WHERE clauses, primary / foreign keys, data types

Intermediate/advanced:

CTEs, join types, aggregations, procedures, triggers, cursors, Query Optimization, indexing, replication, ETL

1

u/Sorry_Data_IT 1d ago

Thanks bro

2

u/Abalone2496 1d ago

LearnSQL has some great courses if you're looking for some structure.

Otherwise start with W3Schools to understand the syntax and how things work. Then build from there with more in depth courses.

1

u/Ginger-Dumpling 21h ago

The same way you get to Carnegie Hall!