Topics to Cover in SQL

892o...qf72
10 Oct 2022
20


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/>

Write & Read to Earn with BULB

Learn More

Enjoy this blog? Subscribe to Orthodox 🔶

0 Comments

B
No comments yet.