TRN-INF503.AB1
Advanced Database
- Practice in 64 Hands-On Labs — nothing to install
- 35 Interactive Lessons and 323 topics mapped to the official exam objectives
- 220 Practice Test Questions
Intermediate Self-paced · 1 year access
64 Hands-On LiveLabs
Practice real IT tasks in guided environments.
- Real environments
- Auto-graded
- No installation
35Interactive Lessons
323Topics
64LiveLab
220Practice Test Questions
170Flashcards
170Glossary of terms
01 / Lessons & labs
See exactly what you will learn and practice
Lessons
35 Interactive Lessons · 323 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 Enhanced Entity–Relationship (EER) Model 12 topics · 1 LiveLab +
- 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
1 LiveLab in this lesson — see the labs panel →
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 · 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 →
08 More SQL: Complex Queries, Triggers, Views, and Schema Modification 8 topics · 10 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
10 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 +
- 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
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 +
- 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
15 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 →
16 Relational Database Design Algorithms and Further Dependencies 11 topics · 1 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
1 LiveLab in this lesson — see the labs panel →
17 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 →
18 Indexing Structures for Files and Physical Database Design 11 topics · 2 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
2 LiveLab in this lesson — see the labs panel →
19 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 →
20 Query Optimization 14 topics · 1 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
1 LiveLab in this lesson — see the labs panel →
21 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 →
22 Concurrency Control Techniques 11 topics · 1 LiveLab +
- 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
1 LiveLab in this lesson — see the labs panel →
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 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 →
25 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 →
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 · 1 LiveLab +
- Active Database Concepts and Triggers
- Temporal Database Concepts
- Spatial Database Concepts
- Multimedia Database Concepts
- Introduction to Deductive Databases
- Summary
- Review Questions
- Exercise
- Selected Bibliography
1 LiveLab in this lesson — see the labs panel →
28 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 →
29 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 →
30 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
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
35 Appendix D: Project 1 topics +
- STUDENT RECORD-KEEPING SYSTEM DATABASE PROJECT
Hands-On Labs Our edge
64 LiveLabs- Understanding Physical Schema - ER Model
- Understanding generalization
- 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 values of a table using nested queries I
- Retrieving values of a table using nested queries II
- Retrieving values of a table using JOIN operator
- Using Aggregate functions
- Counting all the rows of a table
- Using the GROUP BY and HAVING clauses
- Using the CASE clause
- Specifying general constraints as Assertions
- Creating view
- Modifying the table definition
- 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
- Identifying inference rules
- Understanding storage device types
- Identifying the components of disk device
- Understanding the buffer replacement strategies
- Understanding program variables
- Describing the hashing techniques
- Creating a function-based index
- Using a function-based index
- Identifying the steps of processing a high-level query
- Counting the number of department from the table
- Using NOT IN operator
- Using INTERSECT operator
- Unnesting query
- Understanding the page replacement method
- Understanding the transaction states
- Identifying deadlock dealing techniques
- Creating a backup
- Click to select the advantages of distributed databases.
- Categorizing NOSQL systems
- Classifying spatial operators
- Identifying the features of databases and IR systems
- Identifying types of queries
- Understanding the applications of data mining
- Identifying database attacks
Labs run in your browser — nothing to install.
02 / FAQs
Questions before you start
Keep going
You might also like
Prepare for Advanced Database
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
- 64 LiveLab included
- Certificate of completion
No credit card required