Topics to Cover in SQL

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

Theory 

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

Basics 

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

References 

[1] BULB, 'Write to Earn. Read to Earn' (online, 2022) <https://www.bulbapp.io/>