DATABASE-SYS.AB1
Fundamentals of Database Systems
Discover the fundamentals of database systems, their applications, and the related technology. Get hands-on training from expert instructors.
- Practice in 58 Hands-On Labs — nothing to install
- 34 Interactive Lessons and 324 topics mapped to the official exam objectives
- 231 Practice Test Questions
Intermediate Self-paced · 1 year access
58 Hands-On LiveLabs
Practice real IT tasks in guided environments.
- Real environments
- Auto-graded
- No installation
34Interactive Lessons
324Topics
58LiveLab
231Practice Test Questions
170Flashcards
170Glossary of terms
01 / Skills you'll get
What you will be able to do
Try Free →
No credit card required
From basic to advanced topics, this Fundamentals of Database Systems course covers everything you need to know about database systems and their applications. Start with a comprehensive introduction of the fundamentals including architecture, components, models, schemas, and more. Gradually, learn how to interact with the Database using programming languages like SQL, DML, and DDL. By the end of this database fundamentals course, you’ll be a pro at designing, implementing, and managing efficient database schemas.
- Apply data models like ER, and EER to represent real-world entities and relationships
- Optimize performance with normalized database schemas
- Expertise in SQL query language for data manipulation, retrieval, and analysis
- Understand the components and architecture for storage, indexing, and query processing
- Awareness of transaction concepts, ACID properties, and concurrency control techniques
- Knowledge of data security principles, techniques, and best practices
- Write database applications using programming languages like Java, Python, or PHP
- Ability to work with modern NoSQL databases like MongoDB
- Process large datasets with big data technologies like Hadoop and Spark
- Identify patterns and trends with data mining and machine learning concepts
- Problem-solving and critical-thinking capabilities
Course Highlights
-
34 Structured Lessons Comprehensive coverage of core course objectives
-
58 Hands-On LiveLabs Interactive guided scenarios with instant evaluation
-
231 Practice Questions Assessment tests with detailed answer rationales
-
1 Year Full Access Self-paced learning accessible anytime on all devices
02 / Lessons & labs
See exactly what you will learn and practice
Lessons
34 Interactive Lessons · 324 topics01 Introduction +
02 Databases and Database Users 12 topics · 1 LiveLab +
- 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
1 LiveLab in this lesson — see the labs panel →
03 Database System Concepts and Architecture 10 topics · 1 LiveLab +
- 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
1 LiveLab in this lesson — see the labs panel →
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 Enhanced Entity–Relationship (EER) Model 12 topics +
- Subclasses, Superclasses, and Inheritance
- Specialization and Generalization
- Constraints and Characteristics of Specialization and Generalization Hierarchies
- Modeling of UNION Types Using Categories
- A Sample UNIVERSITY EER Schema, Design Choices, and Formal Definitions
- Example of Other Notation: Representing Specialization and Generalization in UML Class Diagrams
- Data Abstraction, Knowledge Representation, and Ontology Concepts
- Summary
- Review Questions
- Exercises
- Laboratory Exercises
- Selected Bibliography
06 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
07 SQL Data Definition and Data Types 9 topics · 14 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
14 LiveLab in this lesson — see the labs panel →
08 More SQL: Complex Queries, Triggers, Views, and Schema Modification 8 topics · 8 LiveLab +
- More Complex SQL Retrieval Queries
- Specifying Constraints as Assertions and Actions as Triggers
- Views (Virtual Tables) in SQL
- Schema Change Statements in SQL
- Summary
- Review Questions
- Exercises
- Selected Bibliography
8 LiveLab in this lesson — see the labs panel →
09 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 →
10 Relational Database Design by ER- and EER-to-Relational Mapping 7 topics +
- Relational Database Design Using ER-to-Relational Mapping
- Mapping EER Model Constructs to Relations
- Summary
- Review Questions
- Exercises
- Laboratory Exercises
- Selected Bibliography
11 Introduction to SQL Programming Techniques 9 topics · 3 LiveLab +
- 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
3 LiveLab in this lesson — see the labs panel →
12 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
13 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 →
14 XML: Extensible Markup Language 11 topics · 1 LiveLab +
- Structured, Semistructured, and Unstructured Data
- XML Hierarchical (Tree) Data Model
- XML Documents, DTD, and XML Schema
- Storing and Extracting XML Documents from Databases
- XML Languages
- Extracting XML Documents from Relational Databases
- XML/SQL: SQL Functions for Creating XML Data
- Summary
- Review Questions
- Exercises
- Selected Bibliography
1 LiveLab in this lesson — see the labs panel →
15 Basics of Functional Dependencies and Normalization for Relational Databases 12 topics · 5 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
- Exercises
- Laboratory Exercises
- Selected Bibliography
5 LiveLab in this lesson — see the labs panel →
16 Relational Database Design Algorithms and Further Dependencies 11 topics · 2 LiveLab +
- Further Topics in Functional Dependencies: Inference Rules, Equivalence, and Minimal Cover
- Properties of Relational Decompositions
- Algorithms for Relational Database Schema Design
- About Nulls, Dangling Tuples, and Alternative Relational Designs
- Further Discussion of Multivalued Dependencies and 4NF
- Other Dependencies and Normal Forms
- Summary
- Review Questions
- Exercises
- Laboratory Exercises
- Selected Bibliography
2 LiveLab in this lesson — see the labs panel →
17 Disk Storage, Basic File Structures, Hashing, and Modern Storage Architectures 15 topics +
- 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
18 Indexing Structures for Files and Physical Database Design 11 topics · 1 LiveLab +
- Types of Single-Level Ordered Indexes
- Multilevel Indexes
- Dynamic Multilevel Indexes Using B-Trees and B+-Trees
- Indexes on Multiple Keys
- Other Types of Indexes
- Some General Issues Concerning Indexing
- Physical Database Design in Relational Databases
- Summary
- Review Questions
- Exercises
- Selected Bibliography
1 LiveLab in this lesson — see the labs panel →
19 Strategies for Query Processing 12 topics · 1 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
1 LiveLab in this lesson — see the labs panel →
20 Query Optimization 14 topics · 2 LiveLab +
- Query Trees and Heuristics for Query Optimization
- Choice of Query Execution Plans
- Use of Selectivities in Cost-Based Optimization
- Cost Functions for SELECT Operation
- Cost Functions for the JOIN Operation
- Example to Illustrate Cost-Based Query Optimization
- Additional Issues Related to Query Optimization
- An Example of Query Optimization in Data Warehouses
- Overview of Query Optimization in Oracle
- Semantic Query Optimization
- Summary
- Review Questions
- Exercises
- Selected Bibliography
2 LiveLab in this lesson — see the labs panel →
21 Introduction to Transaction Processing Concepts and Theory 10 topics · 1 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
1 LiveLab in this lesson — see the labs panel →
22 Concurrency Control Techniques 11 topics +
- Two-Phase Locking Techniques for Concurrency Control
- Concurrency Control Based on Timestamp Ordering
- Multiversion Concurrency Control Techniques
- Validation (Optimistic) Techniques and Snapshot Isolation Concurrency Control
- Granularity of Data Items and Multiple Granularity Locking
- Using Locks for Concurrency Control in Indexes
- Other Concurrency Control Issues
- Summary
- Review Questions
- Exercises
- Selected Bibliography
23 Database Recovery Techniques 11 topics · 1 LiveLab +
- Recovery Concepts
- NO-UNDO/REDO Recovery Based on Deferred Update
- Recovery Techniques Based on Immediate Update
- Shadow Paging
- The ARIES Recovery Algorithm
- Recovery in Multidatabase Systems
- Database Backup and Recovery from Catastrophic Failures
- Summary
- Review Questions
- Exercises
- Selected Bibliography
1 LiveLab in this lesson — see the labs panel →
24 Distributed Database Concepts 12 topics +
- 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
- Exercises
- Selected Bibliography
25 NOSQL Databases and Big Data Storage Systems 9 topics · 3 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
3 LiveLab in this lesson — see the labs panel →
26 Big Data Technologies Based on MapReduce and Hadoop 9 topics +
- What Is Big Data?
- Introduction to MapReduce and Hadoop
- Hadoop Distributed File System (HDFS)
- MapReduce: Additional Details
- Hadoop v2 alias YARN
- General Discussion
- Summary
- Review Questions
- Selected Bibliography
27 Enhanced Data Models: Introduction to Active, Temporal, Spatial, Multimedia, and Deductive Databases 9 topics · 2 LiveLab +
- Active Database Concepts and Triggers
- Temporal Database Concepts
- Spatial Database Concepts
- Multimedia Database Concepts
- Introduction to Deductive Databases
- Summary
- Review Questions
- Exercises
- Selected Bibliography
2 LiveLab in this lesson — see the labs panel →
28 Introduction to Information Retrieval and Web Search 11 topics +
- 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
29 Data Mining Concepts 11 topics · 3 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
- Exercises
- Selected Bibliography
3 LiveLab in this lesson — see the labs panel →
30 Overview of Data Warehousing and OLAP 10 topics · 2 LiveLab +
- 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
2 LiveLab in this lesson — see the labs panel →
31 Database Security 14 topics · 1 LiveLab +
- Introduction to Database Security Issues
- Discretionary Access Control Based on Granting and Revoking Privileges
- Mandatory Access Control and Role-Based Access Control for Multilevel Security
- SQL Injection
- Introduction to Statistical Database Security
- Introduction to Flow Control
- Encryption and Public Key Infrastructures
- Privacy Issues and Preservation
- Challenges to Maintaining Database Security
- Oracle Label-Based Security
- Summary
- Review Questions
- Exercises
- Selected Bibliography
1 LiveLab in this lesson — see the labs panel →
32 Appendix A: Alternative Diagrammatic Notations for ER Models +
33 Appendix B: Parameters of Disks +
34 Appendix C: Overview of the QBE Language 2 topics +
- C.1 Basic Retrievals in QBE
- C.2 Grouping, Aggregation, and Database Modification in QBE
Hands-On Labs Our edge
58 LiveLabs- Understanding the Basic Database System Environment
- Understanding the Schema Architecture
- Inserting Data into a Table
- Updating Data in a Table
- Creating and Updating a View
- Creating a Table in SQL
- Using the CHECK Constraint
- Using Attribute Constraints
- Using Arithmetic Operations
- Using Asterisk in SQL
- Using the ORDER BY Clause
- Using Aliases
- Using the DISTINCT Keyword
- Using the Substring Pattern Matching
- Enforcing Referential Integrity Constraints
- Deleting a Record from a Table
- Using Aggregate Functions
- Retrieving Data Using WITH and CASE Clauses
- Retrieving Data Using a Nested Query
- Using the EXISTS and NOT EXISTS Operators
- Using GROUP BY and HAVING Clauses
- Using Triggers in SQL
- Modifying a Table
- Using the UNION, INTERSECTION, and EXCEPT Operations
- Using Unary Relational Operations
- Using the CROSS JOIN Operation
- Using the JOIN Operation
- Using the DIVISION Operation
- Using Embedded SQL in C
- Embedding SQL Commands in Java
- Connecting to a Database Using Visual Studio Code
- Creating UDTs
- Generating XML Data Using SQL Functions
- 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
- Normalizing the 3rd Normal Form to BCNF
- Solving the Problems with Dangling Tuples
- Solving the Problems with NULL Values
- Creating Function-Based Indexes
- Retrieving Data Using Semi-join and Anti-join
- Using the View-Merging Operation
- Unnesting a Query
- Understanding Transaction States and Additional Operations
- Creating a Backup and Restoring Data
- Performing CRUD Operations in MongoDB
- Building the Sample Data in MongoDB
- Using Basic Cypher Queries
- Using Triggers in Oracle Notation
- Performing Basic Operations in Oracle
- Creating a Decision-Tree Model
- Performing k-Means Clustering
- Using the Apriori Algorithm
- Understanding the Hive System Architecture
- Understanding the General Architecture of a Data Warehouse
- Granting and Revoking Privileges
Labs run in your browser — nothing to install.
03 / FAQs
Questions before you start
Who should take this course?+
Fundamentals of Database Systems course is designed for all those data enthusiasts wanting to gain insight into how data is stored and managed within organizations. Students and academicians with computer science and data science backgrounds can use this course to solidify their knowledge. Tech professionals involved in software development, data analysis, database administration, and web development will also benefit greatly from this course.
Are there any prerequisites for this course?+
No, there are no formal prerequisites.
What career opportunities are available after this course?+
The potential career paths after completing this course are plenty:
- Database administrator
- Database developer, architect, and engineer
- Data scientist
- Software engineer
- Cloud database specialist
- Cybersecurity analyst
Does this course cover any advanced topics?+
This is a beginner-friendly course focusing on the fundamentals of database systems. Some of the advanced topics covered here include NoSQL databases, distributed databases, cloud database technologies, advanced SQL, and more.
What is the course duration?+
This is a self-paced course that can be completed at your own convenience. The single-user license is valid for 1 year from the date of purchase.
Keep going
You might also like
Learn Database Handling!
Step towards a successful career in data.
- 1 year of full access
- 58 LiveLab included
- Certificate of completion
No credit card required