I want to learn Relational Algebra and calculus in SQL? Can anybody ping me on my comment section for teaching me?

Answer 1

well. Question 1: in which DBMS do you want to conduct this training. This choice affects the applied Sql standard, language constructs, and possibly the database engine.

Answer 2

Okay. Then let's build some database model, on which we will study all situations. Are you familiar with the Create Table, Create Index commands?

Answer 3

Maybe this will help you: https://en.m.wikipedia.org/wiki/Relational_algebra

Answer 4

yes here well done agree.
Very handy for exploring this issue.
I can help you deal with a specific example of a complex JOIN or CTE multi-level query, and for the theoretical part of the question and basic examples - everything is in these articles (answer from Brian , answer from me).

Answer 5

I can try to help you ... but I don't have much time to teach you Sql. Come on like this: you probably already got acquainted with the basics on this topic, and there are probably questions that you do not completely understand. Just ask these questions and I will answer them if I can.

Answer 6

The diagram in this article makes a handy shortcut to translating relational algebra into SQL statements.

https://www.codeproject.com/Articles/33052/Visual-Representation-of-SQL-Joins

Answer 7

I know the basics of SQL but I don't know relational algebra and calculus to frame queries. This is my only problem. I searched Google to find pratice questions with answers but they are vain. If you give me some pratice questions, it will easy for me to frame query.

Answer 8

Sorry sir, if you don't bother, I asked QUERIES practice questions sir...I'm not in expert level. But I want to learn from basic level. Sorry sir for my interruption. This is my obligation

Answer 9

Ya, I know creating tables

Answer 10

Thank you sir, I refer it