Topics to Cover in SQL

10 Oct 2022

SQL is a database computer language designed for the retrieval and management of data in a relational database. SQL( Structured Query Language). Topics to cover for a basic understanding of SQL and required to get a job.

SQL is a computer language for storing, manipulating, and retrieving data stored in a relational database.
SQL is the standard language for Relational Database Systems. All the Relational Database Management Systems (RDMS) like MySQL, MS Access, Oracle, Sybase, Informix, Postgres.

But for learning purposes, I'd suggest going with MySQL, because of the reasons that it is secure, free & open source and the support is excellent. Later you can switch to other databases easily.

Topics To Learn

  1. DDL 
  2. DML 
  3. DCL 
  4. TCL 
  5. Databases 
  6. Schemas 
  7. Relationships

  1. Creating Databases
  2. Creating Tables
  3. Data Types 
  4. Data Insertion
  5. Data Updation 
  6. Data Deletion

Keys & Constraints 
  1. Primary Key
  2. Candidate Key
  3. Super Key 
  4. Foreign Key 
  5. Default 
  6. Unique •
  7. Not null


[1] BULB, 'Write to Earn. Read to Earn' (online, 2022) <>

Write & Read to Earn with BULB

Learn More

Enjoy this blog? Subscribe to Orthodox 🔶


No comments yet.