Question

What are the key features of SQL and where can I learn SQL basics for beginners?

Answer 1

The key features of SQL include:

• Tables: Every table has a primary key column that is used to identify the row uniquely.
• Relationships: When you join two tables in SQL, one becomes the parent and the other becomes the child. The primary key column of the parent table becomes a foreign key column in the child table.
• Ordinality: It helps in indicating whether the relation between the parent table and the child table is optional.
• Cardinality: It states whether the relation between the tables is one-to-one, one-to-many, or many-to-many.

To learn SQL basics for beginners and gain a better knowledge of the concept, read SQL Tutorial and watch ‘How to learn SQL’: