Softecks

A database management system (DBMS) is system software for creating and managing databases. The DBMS provides sers and programmers with a systematic way to create, retrieve, update and manage data.

A DBMS makes it possible for end users to create, read, update and delete data in a database. The DBMS essentially serves as an interface between the database and end users or application programs, ensuring that data is consistently organized and remains easily accessible.

Topics Covered in this App are Listed Below

Overview

Architecture

Data Models

Data Schemas

Data Independence

ER Model – Basic Concepts

ER Diagram Representation

Generalization Aggregation

Codd’s 12 Rules

Relation Data Model

Relational Algebra

ER Model to Relational Model

SQL Overview

Normalization

Joins

Storage System

File Structure

Indexing

Hashing

Transaction

Concurrency Control

Deadlock

Data Backup

Data Recovery

What is a Database Management System?

Who Interacts with a DBMS?

Components of a Database System

Basic Set Concepts

DBMS Database Models

Database Keys

What is First Normal Form 1NF ?

What is Second Normal Form?

Third Normal Form 3NF

Boyce-Codd Normal Form BCNF

Fourth Normal Form 4NF

create command

ALTER command

Truncate, Drop or Rename a Table

INSERT SQL command

UPDATE SQL command

DELETE SQL command

Commit, Rollback and Savepoint SQL commands

GRANT and REVOKE

SELECT SQL Query

WHERE SQL clause

SQL LIKE clause

ORDER BY Clause

Group By Clause

HAVING Clause

DISTINCT keyword

AND & OR operator

Division Operator in SQL

SQL Constraints

What are SQL Functions?

Scalar Functions

SQL Alias – AS Keyword

SET Operations in SQL

What is an SQL Sequence?

SQL VIEW

Available on Google Play Store for Android