.jpg){kind=logo}
MMC-COMI261.AB1 ISBN: 979-8-90059-989-2
COMI261 - Database Concepts
Intermediate Self-paced · 1 year access
45 Hands-On LiveLabs
Practice real IT tasks in guided environments.
- Real environments
- Auto-graded
- No installation
01 / Lessons & labs
See exactly what you will learn and practice
Lessons
19 Interactive Lessons · 192 topics01 Introduction +
02 Databases and Database Users 12 topics +
- 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
03 Database System Concepts and Architecture 10 topics +
- 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
04 Data Modeling Using the Entity–Relationship (ER) Model 15 topics · 1 LiveLab +
- 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
1 LiveLab in this lesson — see the labs panel →
05 The Relational Data Model and Relational Database Constraints 7 topics +
- Relational Model Concepts
- Relational Model Constraints and Relational Database Schemas
- Update Operations, Transactions, and Dealing with Constraint Violations
- Summary
- Review Questions
- Exercises
- Selected Bibliography
06 SQL Data Definition and Data Types 9 topics · 17 LiveLab +
- 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
17 LiveLab in this lesson — see the labs panel →
07 The Relational Algebra and Relational Calculus 12 topics · 4 LiveLab +
- 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
4 LiveLab in this lesson — see the labs panel →
08 Introduction to SQL Programming Techniques 9 topics +
- 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
09 Web Database Programming Using PHP 8 topics +
- 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 10 topics · 1 LiveLab +
- 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
1 LiveLab in this lesson — see the labs panel →
11 Basics of Functional Dependencies and Normalization for Relational Databases 12 topics · 6 LiveLab +
- 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
6 LiveLab in this lesson — see the labs panel →
12 Disk Storage, Basic File Structures, Hashing, and Modern Storage Architectures 15 topics · 5 LiveLab +
- 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
5 LiveLab in this lesson — see the labs panel →
13 Strategies for Query Processing 12 topics · 4 LiveLab +
- 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
4 LiveLab in this lesson — see the labs panel →
14 Introduction to Transaction Processing Concepts and Theory 10 topics · 2 LiveLab +
- 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
2 LiveLab in this lesson — see the labs panel →
15 Distributed Database Concepts 11 topics · 1 LiveLab +
- 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
1 LiveLab in this lesson — see the labs panel →
16 NOSQL Databases and Big Data Storage Systems 9 topics · 1 LiveLab +
- 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
1 LiveLab in this lesson — see the labs panel →
17 Introduction to Information Retrieval and Web Search 11 topics · 2 LiveLab +
- 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
2 LiveLab in this lesson — see the labs panel →
18 Data Mining Concepts 10 topics · 1 LiveLab +
- 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
1 LiveLab in this lesson — see the labs panel →
19 Overview of Data Warehousing and OLAP 10 topics +
- 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
Hands-On Labs Our edge
45 LiveLabs- Understanding Physical Schema - ER Model
- 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
- Retrieving the distinct rows from the table
- Using the UNION operator
- Using the SELECT operator
- Understanding relational set operator
- Drag the object database concept to its description.
- 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
- Understanding storage device types
- Identifying the components of disk device
- Understanding the buffer replacement strategies
- Understanding program variables
- Describing the hashing techniques
- Identifying the steps of processing a high-level query
- Counting the number of department from the table
- Using NOT IN operator
- Using INTERSECT operator
- Understanding the page replacement method
- Understanding the transaction states
- Click to select the advantages of distributed databases.
- Categorizing NOSQL systems
- Identifying the features of databases and IR systems
- Identifying types of queries
- Understanding the applications of data mining
Labs run in your browser — nothing to install.
03 / FAQs
Questions before you start
Keep going
You might also like
Prepare for COMI261 - Database Concepts
One-time payment. Full access for 1 year. Start with a free trial if you want to look around first.
- 1 year of full access
- 45 LiveLab included
- Certificate of completion
No credit card required