uCertify

COMI261 - Database Concepts

(MMC-COMI261.AB1)
Lessons
Lab
TestPrep
AI Tutor (Add-on)
Get A Free Trial

Skills You’ll Get

Download Course Outline

1

Introduction

2

Databases and Database Users

  • Introduction
  • An Example
  • Characteristics of the Database Approach
  • Actors on the Scene
  • Workers behind the Scene
  • Advantages of Using the DBMS Approach
  • A Brief History of Database Applications
  • When Not to Use a DBMS
  • Summary
  • Review Questions
  • Exercises
  • Selected Bibliography
3

Database System Concepts and Architecture

  • Data Models, Schemas, and Instances
  • Three-Schema Architecture and Data Independence
  • Database Languages and Interfaces
  • The Database System Environment
  • Centralized and Client/Server Architectures for DBMSs
  • Classification of Database Management Systems
  • Summary
  • Review Questions
  • Exercises
  • Selected Bibliography
4

Data Modeling Using the Entity–Relationship (ER) Model

  • Using High-Level Conceptual Data Models for Database Design
  • A Sample Database Application
  • Entity Types, Entity Sets, Attributes, and Keys
  • Relationship Types, Relationship Sets, Roles, and Structural Constraints
  • Weak Entity Types
  • Refining the ER Design for the COMPANY Database
  • ER Diagrams, Naming Conventions, and Design Issues
  • Example of Other Notation: UML Class Diagrams
  • Relationship Types of Degree Higher than Two
  • Another Example: A UNIVERSITY Database
  • Summary
  • Review Questions
  • Exercises
  • Laboratory Exercises
  • Selected Bibliography
5

The Relational Data Model and Relational Database Constraints

  • Relational Model Concepts
  • Relational Model Constraints and Relational Database Schemas
  • Update Operations, Transactions, and Dealing with Constraint Violations
  • Summary
  • Review Questions
  • Exercises
  • Selected Bibliography
6

SQL Data Definition and Data Types

  • SQL Data Definition and Data Types
  • Specifying Constraints in SQL
  • Basic Retrieval Queries in SQL
  • INSERT, DELETE, and UPDATE Statements in SQL
  • Additional Features of SQL
  • Summary
  • Review Questions
  • Exercises
  • Selected Bibliography
7

The Relational Algebra and Relational Calculus

  • Unary Relational Operations: SELECT and PROJECT
  • Relational Algebra Operations from Set Theory
  • Binary Relational Operations: JOIN and DIVISION
  • Additional Relational Operations
  • Examples of Queries in Relational Algebra
  • The Tuple Relational Calculus
  • The Domain Relational Calculus
  • Summary
  • Review Questions
  • Exercises
  • Laboratory Exercises
  • Selected Bibliography
8

Introduction to SQL Programming Techniques

  • Overview of Database Programming Techniques and Issues
  • Embedded SQL, Dynamic SQL, and SQL J
  • Database Programming with Function Calls and Class Libraries: SQL/CLI and JDBC
  • Database Stored Procedures and SQL/PSM
  • Comparing the Three Approaches
  • Summary
  • Review Questions
  • Exercises
  • Selected Bibliography
9

Web Database Programming Using PHP

  • A Simple PHP Example
  • Overview of Basic Features of PHP
  • Overview of PHP Database Programming
  • Brief Overview of Java Technologies for Database Web Programming
  • Summary
  • Review Questions
  • Exercises
  • Selected Bibliography
10

Object and Object-Relational Databases

  • Overview of Object Database Concepts
  • Object Database Extensions to SQL
  • The ODMG Object Model and the Object Definition Language ODL
  • Object Database Conceptual Design
  • The Object Query Language OQL
  • Overview of the C++ Language Binding in the ODMG Standard
  • Summary
  • Review Questions
  • Exercises
  • Selected Bibliography
11

Basics of Functional Dependencies and Normalization for Relational Databases

  • Informal Design Guidelines for Relation Schemas
  • Functional Dependencies
  • Normal Forms Based on Primary Keys
  • General Definitions of Second and Third Normal Forms
  • Boyce-Codd Normal Form
  • Multivalued Dependency and Fourth Normal Form
  • Join Dependencies and Fifth Normal Form
  • Summary
  • Review Questions
  • Exercise
  • Laboratory Exercises
  • Selected Bibliography
12

Disk Storage, Basic File Structures, Hashing, and Modern Storage Architectures

  • Introduction
  • Secondary Storage Devices
  • Buffering of Blocks
  • Placing File Records on Disk
  • Operations on Files
  • Files of Unordered Records (Heap Files)
  • Files of Ordered Records (Sorted Files)
  • Hashing Techniques
  • Other Primary File Organizations
  • Parallelizing Disk Access Using RAID Technology
  • Modern Storage Architectures
  • Summary
  • Review Questions
  • Exercises
  • Selected Bibliography
13

Strategies for Query Processing

  • Translating SQL Queries into Relational Algebra and Other Operators
  • Algorithms for External Sorting
  • Algorithms for SELECT Operation
  • Implementing the JOIN Operation
  • Algorithms for PROJECT and Set Operations
  • Implementing Aggregate Operations and Different Types of JOINs
  • Combining Operations Using Pipelining
  • Parallel Algorithms for Query Processing
  • Summary
  • Review Questions
  • Exercises
  • Selected Bibliography
14

Introduction to Transaction Processing Concepts and Theory

  • Introduction to Transaction Processing
  • Transaction and System Concepts
  • Desirable Properties of Transactions
  • Characterizing Schedules Based on Recoverability
  • Characterizing Schedules Based on Serializability
  • Transaction Support in SQL
  • Summary
  • Review Questions
  • Exercises
  • Selected Bibliography
15

Distributed Database Concepts

  • Distributed Database Concepts
  • Data Fragmentation, Replication, and Allocation Techniques for Distributed Database Design
  • Overview of Concurrency Control and Recovery in Distributed Databases
  • Overview of Transaction Management in Distributed Databases
  • Query Processing and Optimization in Distributed Databases
  • Types of Distributed Database Systems
  • Distributed Database Architectures
  • Distributed Catalog Management
  • Summary
  • Review Questions
  • Selected Bibliography
16

NOSQL Databases and Big Data Storage Systems

  • Introduction to NOSQL Systems
  • The CAP Theorem
  • Document-Based NOSQL Systems and MongoDB
  • NOSQL Key-Value Stores
  • Column-Based or Wide Column NOSQL Systems
  • NOSQL Graph Databases and Neo4j
  • Summary
  • Review Questions
  • Selected Bibliography
17

Introduction to Information Retrieval and Web Search

  • Information Retrieval (IR) Concepts
  • Retrieval Models
  • Types of Queries in IR Systems
  • Text Preprocessing
  • Inverted Indexing
  • Evaluation Measures of Search Relevance
  • Web Search and Analysis
  • Trends in Information Retrieval
  • Summary
  • Review Questions
  • Selected Bibliography
18

Data Mining Concepts

  • Overview of Data Mining Technology
  • Association Rules
  • Classification
  • Clustering
  • Approaches to Other Data Mining Problems
  • Applications of Data Mining
  • Commercial Data Mining Tools
  • Summary
  • Review Questions
  • Selected Bibliography
19

Overview of Data Warehousing and OLAP

  • Introduction, Definitions, and Terminology
  • Characteristics of Data Warehouses
  • Data Modeling for Data Warehouses
  • Building a Data Warehouse
  • Typical Functionality of a Data Warehouse
  • Data Warehouse versus Views
  • Difficulties of Implementing Data Warehouses
  • Summary
  • Review Questions
  • Selected Bibliography

1

Data Modeling Using the Entity–Relationship (ER) Model

  • Understanding Physical Schema - ER Model
2

SQL Data Definition and Data Types

  • Creating a table
  • Using Referential Integrity constraints in a table
  • Using Check constraints in a table
  • Retrieving the data from the table
  • Using select-project-join query
  • Using alias-naming
  • Retrieving all the attribute values using asterisk
  • Retrieving the data using multiple condition
  • Specifying the cross product of the table
  • Using SELECT DISTINCT statement and UNION operator
  • Using substring pattern matching
  • Using arithmetic operators
  • Retrieving the sorted data using ORDER BY clause
  • Inserting values into a table
  • Inserting values into a table from existing table
  • Deleting the rows from a table
  • Updating the table
3

The Relational Algebra and Relational Calculus

  • Retrieving the distinct rows from the table
  • Using the UNION operator
  • Using the SELECT operator
  • Understanding relational set operator
4

Object and Object-Relational Databases

  • Drag the object database concept to its description.
5

Basics of Functional Dependencies and Normalization for Relational Databases

  • Normalizing the unnormalized model to 1st normal form I
  • Normalizing the unnormalized model to 1st normal form II
  • Normalizing the 1st normal form to 2nd normal form
  • Normalizing the 2nd normal form to 3rd normal form
  • Analyzing the normal forms
  • Normalizing the 3rd normal form to BCNF
6

Disk Storage, Basic File Structures, Hashing, and Modern Storage Architectures

  • Understanding storage device types
  • Identifying the components of disk device
  • Understanding the buffer replacement strategies
  • Understanding program variables
  • Describing the hashing techniques
7

Strategies for Query Processing

  • Identifying the steps of processing a high-level query
  • Counting the number of department from the table
  • Using NOT IN operator
  • Using INTERSECT operator
8

Introduction to Transaction Processing Concepts and Theory

  • Understanding the page replacement method
  • Understanding the transaction states
9

Distributed Database Concepts

  • Click to select the advantages of distributed databases.
10

NOSQL Databases and Big Data Storage Systems

  • Categorizing NOSQL systems
11

Introduction to Information Retrieval and Web Search

  • Identifying the features of databases and IR systems
  • Identifying types of queries
12

Data Mining Concepts

  • Understanding the applications of data mining

Related Courses

All Courses