SQL Roadmap for Fullstack Developer

•

SQL Roadmap for Fullstack/Backend Developer a thread...

Often as Fullstack/BE Developer, we don't know how much SQL to learn. Due to this, few people waste time learning advanced concepts, while few ignore SQL totally. As Fullstack/BE Developer, you're not expected to have mastery in SQL. Because every organisation has DBA Team.

Let's see how much SQL Knowledge is required, to have a successful career as Fullstack/BE Developer. First come basics, afterwards you can straight dive into below-mentioned topics.

1. Normalisation and Relationships You should know how to normalise a table. How to add relationships between them using primary, foreign key. Learn about different types of keys and constraints which help with data redundancy and validation.

2. Be Good with Queries Learn DQL and DML, because most of the time you will be searching and managing data in DB, from your application. Learn DDL, as it will help in defining and restructuring your DB objects like SP, View, Triggers, Functions, Tables, etc.

Have a good knowledge of: - Joins(INNER, LEFT, RIGHT Joins, etc) - Operators(AND, OR, etc) - Datatypes - Clause(Group by, Having, etc) - Wildcards - Aggregate functions(avg, count, etc) - Different ways to filter/sort records twitter.com/vikasrajputin/status/1517330102400344065

3. Store Procedure, Functions, Triggers, Views Sometimes, business logic needs to be put on DB side. Having good knowledge of these topics can easily helps you write complex business logic on DB. You should know - how to use it, when to use it, and what problems they solve.

4. Basics of Indexing No need to have advanced knowledge of Indexing. But you should know how to apply it, and the problem it solves. To know more about Indexing, check out this thread: twitter.com/vikasrajputin/status/1535072762288410624

5. Improving Query Performance This will help you in fixing critical performance issues in the production environment. It is one of the common problems, and knowing about it can add extra stars to your profile. Check out the below thread: twitter.com/vikasrajputin/status/1538691104169525249?s=20&t=V8zixMyQJh7n_AjVKV3uVw

Conclusion: Idea behind the thread is to make you aware of important area you should be focusing more on as Fullstack/BE Dev. This much knowledge is more than enough to have successful career as Fullstack Dev. Other imp concepts can be learnt as and when required.

Note: In the exceptional cases, it might differ because few small organisations do not have a DBA team so you might need to learn other advanced concepts as and when required. Don't follow this Roadmap, if you're DBA or any other Database professional.

That's it for now, hope you learned something new! Every Mon, Wed & Fri - I write a thread on Fullstack Development. Follow @vikasrajputin to read all my future threads.