13 docs tagged with "dbms"

In this tutorial, you will learn about Database Management Systems (DBMS), their architecture, data models, applications, and importance in modern computing.

Learn about the concepts of Generalization and Aggregation in DBMS, which allow expressing database entities in a conceptual hierarchical manner.

Learn about the SQL Aggregate Functions.

Learn about the Structured Query language (SQL), its basic concepts, data types, operators, and commands that form the foundation of database manipulation.

Learn about the SQL clauses and operators.

Learn with an example.

Learn about the architecture of Database Management Systems (DBMS) including single-tier, two-tier, and three-tier architectures.

Understand data independence in DBMS, including logical and physical data independence, and their importance in maintaining flexibility and scalability.

Learn about different data models in DBMS, including flat data models, Entity-Relationship models, and relational models, and understand how data is structured, processed, and stored.

Learn about database schemas, including physical and logical schemas, and understand their role in defining the structure and constraints of a database.

Learn how to represent the Entity-Relationship (ER) Model using ER diagrams, including entities, attributes, relationships, and cardinality.

Learn about the Entity-Relationship (ER) model, its basic concepts, entities, attributes, and relationships that form the foundation of database design.

In this tutorial, you will learn about Database Management Systems (DBMS), their architecture, data models, applications, and importance in modern computing.