NSCVCE
  • Computing Courses
  • Sign In
Select Page

Structured Query Language (SQL)

by nsc-admin | Feb 25, 2025

A relational database management system (RDBMS) is a collection of programs and capabilities that enable IT teams and others to create, update, administer and otherwise interact with a relational database. A relational database is a type of database that stores related data points.

RDBMSes store data in the form of tables, with most commercial relational database management systems using Structured Query Language (SQL) to access the database. However, since SQL was invented after the initial development of the relational model, it isn’t necessary for RDBMS use.

The RDBMS is the most popular database system among organisations. It provides a dependable method of storing and retrieving large amounts of data while offering a combination of system performance and ease of implementation. It’s also the basis for modern database systems like MySQL.

Getting Started

1 of 16 FREE
Choosing a Database
Lesson 1 of 16 within section Getting Started.
0
2 of 16 FREE
Where is MySQL mostly used?
Lesson 2 of 16 within section Getting Started.
0
3 of 16 FREE
Setting up a DBMS workspace
Lesson 3 of 16 within section Getting Started.
0
4 of 16 FREE
Create Alter and Drop a DATABASE
Lesson 4 of 16 within section Getting Started.
0
5 of 16 FREE
How to create a TABLE
Lesson 5 of 16 within section Getting Started.
0
6 of 16 FREE
How to INSERT rows into a TABLE
Lesson 6 of 16 within section Getting Started.
1
7 of 16 FREE
How to SELECT data from a TABLE
Lesson 7 of 16 within section Getting Started.
0
8 of 16 FREE
How to UPDATE and DELETE data from a TABLE
Lesson 8 of 16 within section Getting Started.
0
9 of 16 FREE
AUTOCOMMIT, COMMIT, ROLLBACK
Lesson 9 of 16 within section Getting Started.
0
10 of 16 FREE
Current Date and Time
Lesson 10 of 16 within section Getting Started.
0
11 of 16 FREE
MySQL constraints
Lesson 11 of 16 within section Getting Started.
0
12 of 16 FREE
PRIMARY KEYS
Lesson 12 of 16 within section Getting Started.
0
13 of 16 FREE
FOREIGN KEYS
Lesson 13 of 16 within section Getting Started.
0
14 of 16 FREE
JOINS inner, left and right
Lesson 14 of 16 within section Getting Started.
0
15 of 16 FREE
One-To-Many Relationship
Lesson 15 of 16 within section Getting Started.
0
16 of 16 FREE
More complex JOINS – Many-To-Many Relationship
Lesson 16 of 16 within section Getting Started.
0

Course Progress

Key Knowledge

  • Getting Started
    • Choosing a Database
    • Where is MySQL mostly used?
    • Setting up a DBMS workspace
    • Create Alter and Drop a DATABASE
    • How to create a TABLE
    • How to INSERT rows into a TABLE
    • How to SELECT data from a TABLE
    • How to UPDATE and DELETE data from a TABLE
    • AUTOCOMMIT, COMMIT, ROLLBACK
    • Current Date and Time
    • MySQL constraints
    • PRIMARY KEYS
    • FOREIGN KEYS
    • JOINS inner, left and right
    • One-To-Many Relationship
    • More complex JOINS – Many-To-Many Relationship
  • Facebook
  • X
  • Instagram
  • RSS
Site by DWNS - Hosted by iPresence.