uCertify

Fundamentals of Database Systems

(DATABASE-SYSTEM.AB1.0L0)
Lab
AI Tutor (Add-on)
Instructor-Led (Add-on)
Get A Free Trial

Skills You’ll Get

Get the support you need. Enroll in our Instructor-Led Course.

Download Course Outline

1

Data Modeling Using the Entity–Relationship (ER) Model

  • Understanding Physical Schema - ER Model
2

The Enhanced Entity–Relationship (EER) Model

  • Understanding generalization
3

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
4

More SQL: Complex Queries, Triggers, Views, and Schema Modification

  • 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
5

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
6

Object and Object-Relational Databases

  • Drag the object database concept to its description.
7

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
8

Relational Database Design Algorithms and Further Dependencies

  • Identifying inference rules
9

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
10

Indexing Structures for Files and Physical Database Design

  • Creating a function-based index
  • Using a function-based index
11

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
12

Query Optimization

  • Unnesting query
13

Introduction to Transaction Processing Concepts and Theory

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

Concurrency Control Techniques

  • Identifying deadlock dealing techniques
15

Database Recovery Techniques

  • Creating a backup
16

Distributed Database Concepts

  • Click to select the advantages of distributed databases.
17

NOSQL Databases and Big Data Storage Systems

  • Categorizing NOSQL systems
18

Enhanced Data Models: Introduction to Active, Temporal, Spatial, Multimedia, and Deductive Databases

  • Classifying spatial operators
19

Introduction to Information Retrieval and Web Search

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

Data Mining Concepts

  • Understanding the applications of data mining
21

Database Security

  • Identifying database attacks

Related Courses

All Courses