Advance Search

  • 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
  • *
  • *
  • *
1
1.2.1 Understanding the Basic Database System Environment
Beginner Unattempted
2
2.2.1 Understanding the Schema Architecture
Beginner Unattempted
3
3.7.1 Understanding Physical Schema - ER Model
Beginner Unattempted
4
6.1.1 Inserting Data into a Table
Beginner Unattempted
5
6.1.2 Updating Data in a Table
Beginner Unattempted
6
6.1.3 Creating and Updating a View
Beginner Unattempted
7
6.1.4 Creating a Table in SQL
Beginner Unattempted
8
6.2.1 Using the CHECK Constraint
Beginner Unattempted
9
6.2.2 Using Attribute Constraints
Beginner Unattempted
10
6.3.1 Using Arithmetic Operations
Beginner Unattempted
11
6.3.2 Using Asterisk in SQL
Beginner Unattempted
12
6.3.3 Using the ORDER BY Clause
Beginner Unattempted
13
6.3.4 Using Aliases
Beginner Unattempted
14
6.3.5 Using the DISTINCT Keyword
Beginner Unattempted
15
6.3.6 Using the Substring Pattern Matching
Beginner Unattempted
16
6.3.7 Enforcing Referential Integrity Constraints
Beginner Unattempted
17
6.4.1 Deleting a Record from a Table
Beginner Unattempted
18
7.1.1 Using Aggregate Functions
Beginner Unattempted
19
7.1.2 Retrieving Data Using WITH and CASE Clauses
Beginner Unattempted
20
7.1.3 Retrieving Data Using a Nested Query
Beginner Unattempted
21
7.1.4 Using the EXISTS and NOT EXISTS Operators
Beginner Unattempted
22
7.1.5 Using GROUP BY and HAVING Clauses
Beginner Unattempted
23
7.2.1 Using Triggers in SQL
Beginner Unattempted
24
7.4.1 Modifying a Table
Beginner Unattempted
25
7.4.2 Using the UNION, INTERSECTION, and EXCEPT Operations
Beginner Unattempted
26
8.1.1 Using Unary Relational Operations
Beginner Unattempted
27
8.2.1 Using the CROSS JOIN Operation
Beginner Unattempted
28
8.3.1 Using the JOIN Operation
Beginner Unattempted
29
8.3.2 Using the DIVISION Operation
Beginner Unattempted
30
10.2.1 Using Embedded SQL in C
Intermediate Unattempted
31
10.2.2 Embedding SQL Commands in Java
Intermediate Unattempted
32
10.2.3 Connecting to a Database Using Visual Studio Code
Intermediate Unattempted
33
12.2.1 Creating UDTs
Intermediate Unattempted
34
13.7.1 Generating XML Data Using SQL Functions
Intermediate Unattempted
35
14.3.1 Normalizing the Unnormalized Model to 1st Normal Form I
Intermediate Unattempted
36
14.3.2 Normalizing the Unnormalized Model to 1st Normal Form II
Intermediate Unattempted
37
14.3.3 Normalizing the 1st Normal Form to 2nd Normal Form
Intermediate Unattempted
38
14.3.4 Normalizing the 2nd Normal Form to 3rd Normal Form
Intermediate Unattempted
39
14.5.1 Normalizing the 3rd Normal Form to BCNF
Intermediate Unattempted
40
15.4.1 Solving the Problems with NULL Values
Intermediate Unattempted
41
15.4.2 Solving the Problems with Dangling Tuples
Intermediate Unattempted
42
17.5.1 Creating Function-Based Indexes
Intermediate Unattempted
43
18.1.1 Retrieving Data Using Semi-join and Anti-join
Intermediate Unattempted
44
19.2.1 Using the View-Merging Operation
Intermediate Unattempted
45
19.2.2 Unnesting a Query
Intermediate Unattempted
46
20.2.1 Understanding Transaction States and Additional Operations
Intermediate Unattempted
47
22.7.1 Creating a Backup and Restoring Data
Intermediate Unattempted
48
24.3.1 Performing CRUD Operations in MongoDB
Intermediate Unattempted
49
24.3.2 Building the Sample Data in MongoDB
Intermediate Unattempted
50
24.6.1 Using Basic Cypher Queries
Intermediate Unattempted
51
25.4.1 Understanding the Hive System Architecture
Intermediate Unattempted
52
26.1.1 Using Triggers in Oracle Notation
Advanced Unattempted
53
26.1.2 Performing Basic Operations in Oracle
Advanced Unattempted
54
28.3.1 Creating a Decision-Tree Model
Advanced Unattempted
55
28.4.1 Performing k-Means Clustering
Advanced Unattempted
56
28.4.2 Using the Apriori Algorithm
Advanced Unattempted
57
29.2.1 Understanding the General Architecture of a Data Warehouse
Advanced Unattempted
58
30.2.1 Granting and Revoking Privileges
Advanced Unattempted
1.2.1. Understanding the Basic Database System...
Understanding the Basic Database System Environment
Beginner
2.2.1. Understanding the Schema Architecture
Understanding the Schema Architecture
Beginner
3.7.1. Understanding Physical Schema - ER Model
Understanding Physical Schema - ER Model
Beginner
6.1.1. Inserting Data into a Table
Inserting Data into a Table
Beginner
6.1.2. Updating Data in a Table
Updating Data in a Table
Beginner
6.1.3. Creating and Updating a View
Creating and Updating a View
Beginner
6.1.4. Creating a Table in SQL
Creating a Table in SQL
Beginner
6.2.1. Using the CHECK Constraint
Using the CHECK Constraint
Beginner
6.2.2. Using Attribute Constraints
Using Attribute Constraints
Beginner
6.3.1. Using Arithmetic Operations
Using Arithmetic Operations
Beginner
6.3.2. Using Asterisk in SQL
Using Asterisk in SQL
Beginner
6.3.3. Using the ORDER BY Clause
Using the ORDER BY Clause
Beginner
6.3.4. Using Aliases
Using Aliases
Beginner
6.3.5. Using the DISTINCT Keyword
Using the DISTINCT Keyword
Beginner
6.3.6. Using the Substring Pattern Matching
Using the Substring Pattern Matching
Beginner
6.3.7. Enforcing Referential Integrity Constraints
Enforcing Referential Integrity Constraints
Beginner
6.4.1. Deleting a Record from a Table
Deleting a Record from a Table
Beginner
7.1.1. Using Aggregate Functions
Using Aggregate Functions
Beginner
7.1.2. Retrieving Data Using WITH and CASE Clauses
Retrieving Data Using WITH and CASE Clauses
Beginner
7.1.3. Retrieving Data Using a Nested Query
Retrieving Data Using a Nested Query
Beginner
7.1.4. Using the EXISTS and NOT EXISTS Operators
Using the EXISTS and NOT EXISTS Operators
Beginner
7.1.5. Using GROUP BY and HAVING Clauses
Using GROUP BY and HAVING Clauses
Beginner
7.2.1. Using Triggers in SQL
Using Triggers in SQL
Beginner
7.4.1. Modifying a Table
Modifying a Table
Beginner
7.4.2. Using the UNION, INTERSECTION, and EXCEPT...
Using the UNION, INTERSECTION, and EXCEPT Operations
Beginner
8.1.1. Using Unary Relational Operations
Using Unary Relational Operations
Beginner
8.2.1. Using the CROSS JOIN Operation
Using the CROSS JOIN Operation
Beginner
8.3.1. Using the JOIN Operation
Using the JOIN Operation
Beginner
8.3.2. Using the DIVISION Operation
Using the DIVISION Operation
Beginner
10.2.1. Using Embedded SQL in C
Using Embedded SQL in C
Intermediate
10.2.2. Embedding SQL Commands in Java
Embedding SQL Commands in Java
Intermediate
10.2.3. Connecting to a Database Using Visual Studio Code
Connecting to a Database Using Visual Studio Code
Intermediate
12.2.1. Creating UDTs
Creating UDTs
Intermediate
13.7.1. Generating XML Data Using SQL Functions
Generating XML Data Using SQL Functions
Intermediate
14.3.1. Normalizing the Unnormalized Model to 1st...
Normalizing the Unnormalized Model to 1st Normal Form I
Intermediate
14.3.2. Normalizing the Unnormalized Model to 1st...
Normalizing the Unnormalized Model to 1st Normal Form II
Intermediate
14.3.3. Normalizing the 1st Normal Form to 2nd Normal Form
Normalizing the 1st Normal Form to 2nd Normal Form
Intermediate
14.3.4. Normalizing the 2nd Normal Form to 3rd Normal Form
Normalizing the 2nd Normal Form to 3rd Normal Form
Intermediate
14.5.1. Normalizing the 3rd Normal Form to BCNF
Normalizing the 3rd Normal Form to BCNF
Intermediate
15.4.1. Solving the Problems with NULL Values
Solving the Problems with NULL Values
Intermediate
15.4.2. Solving the Problems with Dangling Tuples
Solving the Problems with Dangling Tuples
Intermediate
17.5.1. Creating Function-Based Indexes
Creating Function-Based Indexes
Intermediate
18.1.1. Retrieving Data Using Semi-join and Anti-join
Retrieving Data Using Semi-join and Anti-join
Intermediate
19.2.1. Using the View-Merging Operation
Using the View-Merging Operation
Intermediate
19.2.2. Unnesting a Query
Unnesting a Query
Intermediate
20.2.1. Understanding Transaction States and Additional...
Understanding Transaction States and Additional Operations
Intermediate
22.7.1. Creating a Backup and Restoring Data
Creating a Backup and Restoring Data
Intermediate
24.3.1. Performing CRUD Operations in MongoDB
Performing CRUD Operations in MongoDB
Intermediate
24.3.2. Building the Sample Data in MongoDB
Building the Sample Data in MongoDB
Intermediate
24.6.1. Using Basic Cypher Queries
Using Basic Cypher Queries
Intermediate
25.4.1. Understanding the Hive System Architecture
Understanding the Hive System Architecture
Intermediate
26.1.1. Using Triggers in Oracle Notation
Using Triggers in Oracle Notation
Advanced
26.1.2. Performing Basic Operations in Oracle
Performing Basic Operations in Oracle
Advanced
28.3.1. Creating a Decision-Tree Model
Creating a Decision-Tree Model
Advanced
28.4.1. Performing k-Means Clustering
Performing k-Means Clustering
Advanced
28.4.2. Using the Apriori Algorithm
Using the Apriori Algorithm
Advanced
29.2.1. Understanding the General Architecture of a...
Understanding the General Architecture of a Data Warehouse
Advanced
30.2.1. Granting and Revoking Privileges
Granting and Revoking Privileges
Advanced
We use cookies to enhance your experience. By continuing to visit this site you agree to our use of cookies. More information
Accept