CSF 112 Database Systems

Permanent URI for this collection

https://erepository.ouk.ac.ke/handle/123456789/82
Database systems is a first year course

Browse

Browsing CSF 112 Database Systems by Author "Chepken K.C"

Now showing 1 - 11 of 11
  • Thumbnail Image
    Item
    Module 10: Database Transactions
    (2023-04-23) Chepken K.C
    The assumption here is that you may have joined this course mid-way or you may have followed a sequential order, by which case you will have completed all the previous modules. Whichever path you took; this module should make sense to you. Just ensure that you are familiar with the database systems basics including the database environment, normalization, SQL queries and database programming languages. In this module you will learn about database transactions and states of transactions, which borrows ideas heavily from SQL and database programming languages.
  • Thumbnail Image
    Item
    Module 11: Introduction to Data Warehousing and Business intelligence
    (2023-04-23) Chepken K.C
    If you have followed this course sequentially from module one, you have made significant progress and by now you should have the necessary basic database skills. If you just jumped into this module, then you are welcome to this course. In this module you will learn about Data warehousing and business intelligence.
  • Thumbnail Image
    Item
    Module Eight: Relational Algebra in SQL and query planning
    (2023-04-23) Chepken K.C
    This module is all about Relational Algebra in SQL and query planning. It describes the theoretical underpinning of query languages such as SQL. Query planning shows you how a query is executed as opposed what it does.
  • Thumbnail Image
    Item
    Module Five: Physical Database Design
    (2023-04-23) Chepken K.C
    The topic for this module is Physical Database Design. The learner is expected to have had knowledge in ER modeling and logical database design.
  • Thumbnail Image
    Item
    Module Four: Entity Relations Models
    (2023-04-23) Chepken K.C
    This is the fourth module of the database systems course which is part of the core courses for cyber security and digital forensics degree programme. It follows from the introduction of relational models from the previous module. You will learn about entity Relational (E-R) Models.
  • Thumbnail Image
    Item
    Module Nine: Database Programming
    (2023-04-23) Chepken K.C
    Module nine of the database systems course? Yes it is. If you have followed this course sequentially from module one, congratulations that you have made good progress. If you just jumped into this module, you are welcome to this course. Just ensure that you are familiar with the database systems basics including the database environment, normalization and SQL queries. In this module you will learn about data processing and specifically Database programming languages, file organization and indexes, query and transaction processing.
  • Thumbnail Image
    Item
    Module One: Introduction to Database Systems
    (2023-04-23) Chepken K.C
    This is the first module of the database systems course which is part of the core courses for cyber security and digital forensics degree programme. You will learn about the basics of database systems.
  • Thumbnail Image
    Item
    Module Seven: SQL Joins and sub queries
    (2023-04-23) Chepken K.C
    This module is a buildup of the Structured query languages (SQL). The general topic is SQL as used in relational databases. SQL joins builds on the DML SELECT query. Sub queries are queries within another SQL query. Here you will study SQL joins and sub queries.
  • Thumbnail Image
    Item
    Module Six: Getting started with SQL
    (2023-04-23) Chepken K.C
    Now that you have a physical design of your relational database, and you have probably implemented the database, you need a way to create and manipulate it. This is done using structured query languages (SQL) and hence this module.
  • Thumbnail Image
    Item
    Module Three: Relational and non-relational Database Models
    (2023-04-23) Chepken K.C
    This is the third module of the database systems course which is part of the core courses for cyber security and digital forensics degree programme. You will learn about Relational and non-relational database Models.
  • Thumbnail Image
    Item
    Module Two: Database Environment
    (2023-04-23) Chepken K.C
    This is the second module of the database systems course which is part of the core courses for cyber security and digital forensics degree programme. You will learn about Components of a database environment and the Database Management Systems (DBMS)