Explore Courses Blog Tutorials Interview Questions
0 votes
in SQL by (9k points)
What are the key features of SQL and where can I learn SQL basics for beginners?

1 Answer

0 votes
by (45.3k points)

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’:

Browse Categories