Free Performance Labs : Fundamentals of Database Systems en-uCertify

Advance Search

Chapters

Actions

Types

All
Part 1
1
2
Part 2
3
4
Part 3
5
6
7
8
9
Part 4
10
11
Part 5
12
13
Part 6
14
15
Part 7
16
17
Part 8
18
19
Part 9
20
21
22
Part 10
23
24
25
Part 11
26
27
28
29
Part 12
30

No item found.

Title
no bookmarked, confident, or note marked 1.2.1 Understanding the Basic Database System Environment	Beginner Unattempted
no bookmarked, confident, or note marked 2.2.1 Understanding the Schema Architecture	Beginner Unattempted
no bookmarked, confident, or note marked 3.7.1 Understanding Physical Schema - ER Model	Beginner Unattempted
no bookmarked, confident, or note marked 6.1.1 Inserting Data into a Table	Beginner Unattempted
no bookmarked, confident, or note marked 6.1.2 Updating Data in a Table	Beginner Unattempted
no bookmarked, confident, or note marked 6.1.3 Creating and Updating a View	Beginner Unattempted
no bookmarked, confident, or note marked 6.1.4 Creating a Table in SQL	Beginner Unattempted
no bookmarked, confident, or note marked 6.2.1 Using the CHECK Constraint	Beginner Unattempted
no bookmarked, confident, or note marked 6.2.2 Using Attribute Constraints	Beginner Unattempted
no bookmarked, confident, or note marked 6.3.1 Using Arithmetic Operations	Beginner Unattempted
no bookmarked, confident, or note marked 6.3.2 Using Asterisk in SQL	Beginner Unattempted
no bookmarked, confident, or note marked 6.3.3 Using the ORDER BY Clause	Beginner Unattempted
no bookmarked, confident, or note marked 6.3.4 Using Aliases	Beginner Unattempted
no bookmarked, confident, or note marked 6.3.5 Using the DISTINCT Keyword	Beginner Unattempted
no bookmarked, confident, or note marked 6.3.6 Using the Substring Pattern Matching	Beginner Unattempted
no bookmarked, confident, or note marked 6.3.7 Enforcing Referential Integrity Constraints	Beginner Unattempted
no bookmarked, confident, or note marked 6.4.1 Deleting a Record from a Table	Beginner Unattempted
no bookmarked, confident, or note marked 7.1.1 Using Aggregate Functions	Beginner Unattempted
no bookmarked, confident, or note marked 7.1.2 Retrieving Data Using WITH and CASE Clauses	Beginner Unattempted
no bookmarked, confident, or note marked 7.1.3 Retrieving Data Using a Nested Query	Beginner Unattempted
no bookmarked, confident, or note marked 7.1.4 Using the EXISTS and NOT EXISTS Operators	Beginner Unattempted
no bookmarked, confident, or note marked 7.1.5 Using GROUP BY and HAVING Clauses	Beginner Unattempted
no bookmarked, confident, or note marked 7.2.1 Using Triggers in SQL	Beginner Unattempted
no bookmarked, confident, or note marked 7.4.1 Modifying a Table	Beginner Unattempted
no bookmarked, confident, or note marked 7.4.2 Using the UNION, INTERSECTION, and EXCEPT Operations	Beginner Unattempted
no bookmarked, confident, or note marked 8.1.1 Using Unary Relational Operations	Beginner Unattempted
no bookmarked, confident, or note marked 8.2.1 Using the CROSS JOIN Operation	Beginner Unattempted
no bookmarked, confident, or note marked 8.3.1 Using the JOIN Operation	Beginner Unattempted
no bookmarked, confident, or note marked 8.3.2 Using the DIVISION Operation	Beginner Unattempted
no bookmarked, confident, or note marked 10.2.1 Using Embedded SQL in C	Intermediate Unattempted
no bookmarked, confident, or note marked 10.2.2 Embedding SQL Commands in Java	Intermediate Unattempted
no bookmarked, confident, or note marked 10.2.3 Connecting to a Database Using Visual Studio Code	Intermediate Unattempted
no bookmarked, confident, or note marked 12.2.1 Creating UDTs	Intermediate Unattempted
no bookmarked, confident, or note marked 13.7.1 Generating XML Data Using SQL Functions	Intermediate Unattempted
no bookmarked, confident, or note marked 14.3.1 Normalizing the Unnormalized Model to 1st Normal Form I	Intermediate Unattempted
no bookmarked, confident, or note marked 14.3.2 Normalizing the Unnormalized Model to 1st Normal Form II	Intermediate Unattempted
no bookmarked, confident, or note marked 14.3.3 Normalizing the 1st Normal Form to 2nd Normal Form	Intermediate Unattempted
no bookmarked, confident, or note marked 14.3.4 Normalizing the 2nd Normal Form to 3rd Normal Form	Intermediate Unattempted
no bookmarked, confident, or note marked 14.5.1 Normalizing the 3rd Normal Form to BCNF	Intermediate Unattempted
no bookmarked, confident, or note marked 15.4.1 Solving the Problems with NULL Values	Intermediate Unattempted
no bookmarked, confident, or note marked 15.4.2 Solving the Problems with Dangling Tuples	Intermediate Unattempted
no bookmarked, confident, or note marked 17.5.1 Creating Function-Based Indexes	Intermediate Unattempted
no bookmarked, confident, or note marked 18.1.1 Retrieving Data Using Semi-join and Anti-join	Intermediate Unattempted
no bookmarked, confident, or note marked 19.2.1 Using the View-Merging Operation	Intermediate Unattempted
no bookmarked, confident, or note marked 19.2.2 Unnesting a Query	Intermediate Unattempted
no bookmarked, confident, or note marked 20.2.1 Understanding Transaction States and Additional Operations	Intermediate Unattempted
no bookmarked, confident, or note marked 22.7.1 Creating a Backup and Restoring Data	Intermediate Unattempted
no bookmarked, confident, or note marked 24.3.1 Performing CRUD Operations in MongoDB	Intermediate Unattempted
no bookmarked, confident, or note marked 24.3.2 Building the Sample Data in MongoDB	Intermediate Unattempted
no bookmarked, confident, or note marked 24.6.1 Using Basic Cypher Queries	Intermediate Unattempted
no bookmarked, confident, or note marked 25.4.1 Understanding the Hive System Architecture	Intermediate Unattempted
no bookmarked, confident, or note marked 26.1.1 Using Triggers in Oracle Notation	Advanced Unattempted
no bookmarked, confident, or note marked 26.1.2 Performing Basic Operations in Oracle	Advanced Unattempted
no bookmarked, confident, or note marked 28.3.1 Creating a Decision-Tree Model	Advanced Unattempted
no bookmarked, confident, or note marked 28.4.1 Performing k-Means Clustering	Advanced Unattempted
no bookmarked, confident, or note marked 28.4.2 Using the Apriori Algorithm	Advanced Unattempted
no bookmarked, confident, or note marked 29.2.1 Understanding the General Architecture of a Data Warehouse	Advanced Unattempted
no bookmarked, confident, or note marked 30.2.1 Granting and Revoking Privileges	Advanced Unattempted

1.2.1. Understanding the Basic Database System Environment

Understanding the Basic Database System Environment

Beginner

Unattempted

2.2.1. Understanding the Schema Architecture

Understanding the Schema Architecture

Beginner

Unattempted

3.7.1. Understanding Physical Schema - ER Model

Understanding Physical Schema - ER Model

Beginner

Unattempted

6.1.1. Inserting Data into a Table

Inserting Data into a Table

Beginner

Unattempted

6.1.2. Updating Data in a Table

Updating Data in a Table

Beginner

Unattempted

6.1.3. Creating and Updating a View

Creating and Updating a View

Beginner

Unattempted

6.1.4. Creating a Table in SQL

Creating a Table in SQL

Beginner

Unattempted

6.2.1. Using the CHECK Constraint

Using the CHECK Constraint

Beginner

Unattempted

6.2.2. Using Attribute Constraints

Using Attribute Constraints

Beginner

Unattempted

6.3.1. Using Arithmetic Operations

Using Arithmetic Operations

Beginner

Unattempted

6.3.2. Using Asterisk in SQL

Using Asterisk in SQL

Beginner

Unattempted

6.3.3. Using the ORDER BY Clause

Using the ORDER BY Clause

Beginner

Unattempted

6.3.4. Using Aliases

Using Aliases

Beginner

Unattempted

6.3.5. Using the DISTINCT Keyword

Using the DISTINCT Keyword

Beginner

Unattempted

6.3.6. Using the Substring Pattern Matching

Using the Substring Pattern Matching

Beginner

Unattempted

6.3.7. Enforcing Referential Integrity Constraints

Enforcing Referential Integrity Constraints

Beginner

Unattempted

6.4.1. Deleting a Record from a Table

Deleting a Record from a Table

Beginner

Unattempted

7.1.1. Using Aggregate Functions

Using Aggregate Functions

Beginner

Unattempted

7.1.2. Retrieving Data Using WITH and CASE Clauses

Retrieving Data Using WITH and CASE Clauses

Beginner

Unattempted

7.1.3. Retrieving Data Using a Nested Query

Retrieving Data Using a Nested Query

Beginner

Unattempted

7.1.4. Using the EXISTS and NOT EXISTS Operators

Using the EXISTS and NOT EXISTS Operators

Beginner

Unattempted

7.1.5. Using GROUP BY and HAVING Clauses

Using GROUP BY and HAVING Clauses

Beginner

Unattempted

7.2.1. Using Triggers in SQL

Using Triggers in SQL

Beginner

Unattempted

7.4.1. Modifying a Table

Modifying a Table

Beginner

Unattempted

7.4.2. Using the UNION, INTERSECTION, and EXCEPT Operations

Using the UNION, INTERSECTION, and EXCEPT Operations

Beginner

Unattempted

8.1.1. Using Unary Relational Operations

Using Unary Relational Operations

Beginner

Unattempted

8.2.1. Using the CROSS JOIN Operation

Using the CROSS JOIN Operation

Beginner

Unattempted

8.3.1. Using the JOIN Operation

Using the JOIN Operation

Beginner

Unattempted

8.3.2. Using the DIVISION Operation

Using the DIVISION Operation

Beginner

Unattempted

10.2.1. Using Embedded SQL in C

Using Embedded SQL in C

Intermediate

Unattempted

10.2.2. Embedding SQL Commands in Java

Embedding SQL Commands in Java

Intermediate

Unattempted

10.2.3. Connecting to a Database Using Visual Studio Code

Connecting to a Database Using Visual Studio Code

Intermediate

Unattempted

12.2.1. Creating UDTs

Creating UDTs

Intermediate

Unattempted

13.7.1. Generating XML Data Using SQL Functions

Generating XML Data Using SQL Functions

Intermediate

Unattempted

14.3.1. Normalizing the Unnormalized Model to 1st Normal Form I

Normalizing the Unnormalized Model to 1st Normal Form I

Intermediate

Unattempted

14.3.2. Normalizing the Unnormalized Model to 1st Normal Form II

Normalizing the Unnormalized Model to 1st Normal Form II

Intermediate

Unattempted

14.3.3. Normalizing the 1st Normal Form to 2nd Normal Form

Normalizing the 1st Normal Form to 2nd Normal Form

Intermediate

Unattempted

14.3.4. Normalizing the 2nd Normal Form to 3rd Normal Form

Normalizing the 2nd Normal Form to 3rd Normal Form

Intermediate

Unattempted

14.5.1. Normalizing the 3rd Normal Form to BCNF

Normalizing the 3rd Normal Form to BCNF

Intermediate

Unattempted

15.4.1. Solving the Problems with NULL Values

Solving the Problems with NULL Values

Intermediate

Unattempted

15.4.2. Solving the Problems with Dangling Tuples

Solving the Problems with Dangling Tuples

Intermediate

Unattempted

17.5.1. Creating Function-Based Indexes

Creating Function-Based Indexes

Intermediate

Unattempted

18.1.1. Retrieving Data Using Semi-join and Anti-join

Retrieving Data Using Semi-join and Anti-join

Intermediate

Unattempted

19.2.1. Using the View-Merging Operation

Using the View-Merging Operation

Intermediate

Unattempted

19.2.2. Unnesting a Query

Unnesting a Query

Intermediate

Unattempted

20.2.1. Understanding Transaction States and Additional Operations

Understanding Transaction States and Additional Operations

Intermediate

Unattempted

22.7.1. Creating a Backup and Restoring Data

Creating a Backup and Restoring Data

Intermediate

Unattempted

24.3.1. Performing CRUD Operations in MongoDB

Performing CRUD Operations in MongoDB

Intermediate

Unattempted

24.3.2. Building the Sample Data in MongoDB

Building the Sample Data in MongoDB

Intermediate

Unattempted

24.6.1. Using Basic Cypher Queries

Using Basic Cypher Queries

Intermediate

Unattempted

25.4.1. Understanding the Hive System Architecture

Understanding the Hive System Architecture

Intermediate

Unattempted

26.1.1. Using Triggers in Oracle Notation

Using Triggers in Oracle Notation

Advanced

Unattempted

26.1.2. Performing Basic Operations in Oracle

Performing Basic Operations in Oracle

Advanced

Unattempted

28.3.1. Creating a Decision-Tree Model

Creating a Decision-Tree Model

Advanced

Unattempted

28.4.1. Performing k-Means Clustering

Performing k-Means Clustering

Advanced

Unattempted

28.4.2. Using the Apriori Algorithm

Using the Apriori Algorithm

Advanced

Unattempted

29.2.1. Understanding the General Architecture of a Data Warehouse

Understanding the General Architecture of a Data Warehouse

Advanced

Unattempted

30.2.1. Granting and Revoking Privileges

Granting and Revoking Privileges

Advanced

Unattempted