SQL Roadmap for the Backend (or Fullstack) Developer:
Often as Fullstack/BE Developers, we don't know how much SQL to learn.
Few waste time learning advanced concepts, while few ignore SQL totally.
Let's see how much SQL Knowledge is required.
First, come basics, afterwards, you can straight dive into the below-mentioned topics.
Few waste time learning advanced concepts, while few ignore SQL totally.
Let's see how much SQL Knowledge is required.
First, come basics, afterwards, you can straight dive into the below-mentioned topics.
1. Normalisation and Relationships
You should know how to normalise a table.
How to add relationships between them using primary, and foreign key.
Learn about different types of keys and constraints which help with data redundancy and validation.
You should know how to normalise a table.
How to add relationships between them using primary, and 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.
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
- 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
3. Stored Procedures, 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.
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.
No need to have advanced knowledge of Indexing.
But you should know how to apply it, and the problem it solves.
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.
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.
6. Note
The idea behind the thread is to make you aware of the important area you should be focusing more on as Fullstack/BE Dev.
This much knowledge is more than enough to have a successful career as Fullstack Dev.
Other imp concepts can be learnt as and when required.
The idea behind the thread is to make you aware of the important area you should be focusing more on as Fullstack/BE Dev.
This much knowledge is more than enough to have a successful career as Fullstack Dev.
Other imp concepts can be learnt as and when required.
That's a wrap!
I help people get started with Backend Development.
Follow me @vikasrajputin for more.
If you find this thread helpful then Like/Retweet the first tweet below:
I help people get started with Backend Development.
Follow me @vikasrajputin for more.
If you find this thread helpful then Like/Retweet the first tweet below:
This Saturday (3rd Dec, 2022), I'll be talking to Treblle API about how to get started with Backend engineering.
If you've any questions on Backend development then this space is for you!
See you at 8 PM Indian Time. Do Join!
If you've any questions on Backend development then this space is for you!
See you at 8 PM Indian Time. Do Join!
جاري تحميل الاقتراحات...