Topics

47

DBMS Data Models 1 Data Model 2 Entity Relationship Model 3 ER Diagrams 4 Components of ERD 5 Relational Model 6 Hierarchical Model 7 Network Model 8 Object-oriented Data Model

DBMS Relational Databases 1 Introduction 2 Relational Database Design 3 Relational Database Schema 4 Relational Database Instance

Keys in DDMS 1 Primary key 2 Candidate key 3 Composite Key 4 Super Key 5 Foreign key 6 DBMS Keys

Structure Query Language (SQL) 1 Introduction to SQL 2 Database Languages 3 Data definition language (DDL) 4 Data Manipulation Language (DML) 5 Data Control Language (DCL) 6 Transaction Control Language

DBMS Data Storage 1 Introduction Data Storage

DBMS Normalization 1 Normalization Introduction 2 First Normal Form (1NF) 3 Second Normal Form (2NF) 4 Third Normal Form (3NF) 5 Boyce-Codd Normal Form (BCNF) 6 Fourth Normal Form (4NF)

DBMS Transaction Management 1 Introduction

DBMS File organization 1 Introduction

INDEXES 1 Introductions

Concurrency Control 1 Introduction

Relational Algebra 1 Introduction to Relational Algebra

Database Constraints 1 Constraints Introduction

Introduction to DBMS 1 About DBMS Tutorial 2 DBMS Overview 3 Characteristics of DBMS 4 Need of a database 5 File-based vs Database Management System 6 Database Users 7 Architecture of DBMS 8 Data Independenc 9 Two-tier Architecture 10 Three-tier architecture

No topics found for your search.

Table of Contents

An Overview of Database Languages: Types, Functions, and Examples

Rumman Ansari July 19, 2024 6,144 views

An Overview of Database Languages: Types, Functions, and Examples

To provide various facilities to different types of users, a DBMS normally provides one or more specialized programming languages called Database (or DBMS) Languages. The DBMS mainly provides two database languages, namely-

Data Definition Language (DDL)
Data Manipulation Language (DML)
Data Control Language (DCL)
Transaction Control Language(TCL)