• 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 System

Week 1 – Introduction to Databases

  • Data vs Information
  • File System vs Database System
  • Advantages of DBMS
  • Applications of DBMS
  • Components of DBMS
  • Database Users & Roles
  • Overview of Database Architecture

Outcome: Understand why databases are needed and how DBMS works.

Week 2 – Data Models

  • Concept of Data Models
  • Types of Data Models
    • Hierarchical Model
    • Network Model
    • Relational Model
    • Object-Oriented Model
  • Comparison of Data Models

Outcome: Understand how data can be structured in different models.

Week 3 – Relational Model

  • Concepts of Relation, Tuple, Attribute
  • Domain and Degree
  • Keys
    • Super Key
    • Candidate Key
    • Primary Key
    • Foreign Key
  • Integrity Constraints

Outcome: Understand the structure of relational databases.

Week 4 – Entity Relationship (ER) Model

  • Entities and Attributes
  • Types of Attributes
  • Relationships
  • Cardinality
  • Participation Constraints
  • ER Diagrams
  • Weak Entities

Outcome: Ability to design ER diagrams for real-world systems.

Week 5 – ER to Relational Mapping

  • Converting ER Diagram to Tables
  • Mapping Strong Entities
  • Mapping Weak Entities
  • Mapping Relationships
  • Generalization and Specialization

Outcome: Convert conceptual models into relational schemas.

Week 6 – Structured Query Language (SQL) Basics

  • Introduction to SQL
  • SQL Data Types
  • DDL Commands
    • CREATE
    • ALTER
    • DROP

Lab Practice

  • Creating tables
  • Modifying tables

Outcome: Ability to create database structures.

Week 7 – SQL Data Manipulation

  • DML Commands
    • INSERT
    • UPDATE
    • DELETE
  • SELECT Queries
  • WHERE Clause
  • ORDER BY
  • GROUP BY
  • HAVING

Lab Practice: Writing SQL queries.

Week 8 – Advanced SQL

  • Joins
    • Inner Join
    • Left Join
    • Right Join
    • Full Join
  • Nested Queries
  • Views
  • Indexes

Outcome: Ability to write complex queries.

Week 9 – Normalization

  • Data Redundancy
  • Functional Dependency
  • Normal Forms
    • 1NF
    • 2NF
    • 3NF
    • BCNF

Outcome: Design efficient database structures.

Week 10 – Transaction Management

  • Concept of Transactions
  • ACID Properties
  • Transaction States
  • Concurrent Transactions
  • Serializability

Outcome: Understand database consistency and reliability.

Week 11 – Concurrency Control & Recovery

  • Lock-Based Protocols
  • Deadlocks
  • Timestamp Protocol
  • Database Recovery
  • Log-Based Recovery

Outcome: Learn how databases prevent conflicts and recover from failures.

Week 12 – Database Security & Advanced Topics

  • Database Security Concepts
  • Authorization & Access Control
  • Backup & Recovery
  • Introduction to:
    • Distributed Databases
    • NoSQL Databases
    • Big Data Databases