• Welcome to your new Gnomio site

    Now, you are in control!

    Moodle is an open-source Learning Management System (LMS) that provides educators with the tools and features to create and manage online courses. It allows educators to organize course materials, create quizzes and assignments, host discussion forums, and track student progress. Moodle is highly flexible and can be customized to meet the specific needs of different institutions and learning environments.

    Moodle supports both synchronous and asynchronous learning environments, enabling educators to host live webinars, video conferences, and chat sessions, as well as providing a variety of tools that support self-paced learning, including videos, interactive quizzes, and discussion forums. The platform also integrates with other tools and systems, such as Google Apps and plagiarism detection software, to provide a seamless learning experience.

    Moodle is widely used in educational institutions, including universities, K-12 schools, and corporate training programs. It is well-suited to online and blended learning environments and distance education programs. Additionally, Moodle's accessibility features make it a popular choice for learners with disabilities, ensuring that courses are inclusive and accessible to all learners.

    The Moodle community is an active group of users, developers, and educators who contribute to the platform's development and improvement. The community provides support, resources, and documentation for users, as well as a forum for sharing ideas and best practices. Moodle releases regular updates and improvements, ensuring that the platform remains up-to-date with the latest technologies and best practices.

    Links of interest:

    (You can edit or remove this text)

Available courses

DATABASE MANAGEMENT SYSTEMS

DBMS Course Summary

A Database Management System (DBMS) is software that stores, organizes, and manages data efficiently, allowing multiple users to access it securely.

Main Topics:

  1. Introduction to DBMS

    • Manages data, users, and access.

    • Advantages: reduced redundancy, data consistency, security, backup, and recovery.

  2. Database Models

    • Hierarchical: Tree structure.

    • Network: Graph structure.

    • Relational: Tables (most common).

    • Object-Oriented: Stores data as objects.

  3. Relational Model Concepts

    • Table (Relation) = rows (tuples) + columns (attributes).

    • Keys: Primary, Foreign, Candidate, Composite.

  4. Relational Algebra & Calculus

    • Operations: SELECT, PROJECT, JOIN, UNION, etc.

    • Used to query and manipulate data.

  5. SQL (Structured Query Language)

    • DDL: CREATE, ALTER, DROP.

    • DML: SELECT, INSERT, UPDATE, DELETE.

    • DCL: GRANT, REVOKE.

    • TCL: COMMIT, ROLLBACK.

    • Supports filtering, grouping, and joining tables.

  6. Normalization

    • Process to remove redundancy and anomalies.

    • 1NF → Atomic values

    • 2NF → Remove partial dependency

    • 3NF → Remove transitive dependency

    • BCNF → Every determinant is a key

  7. Transactions & Concurrency

    • ACID Properties: Atomicity, Consistency, Isolation, Durability.

    • Prevent issues like lost updates and dirty reads.

    • Techniques: locking, timestamp ordering.

  8. Backup, Recovery & Security

    • Protects data from loss or corruption.

    • Ensures authorized access and encryption.

  9. Database Architecture

    • 3 Levels: External (user view), Conceptual (logical design), Internal (physical storage).

  10. Advanced Topics

    • Distributed Databases – Data across multiple locations.

    • NoSQL – Non-relational databases (e.g., MongoDB).

    • Data Warehousing & Mining – Storage and analysis of large datasets.

    • Big Data – Handling massive unstructured data.