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

Recent Submissions

Now showing 1 - 5 of 11
  • 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 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 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 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 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.