.jpg){kind=logo}
UOP-DBMDA300.AD1
DBMDA/300 Database Fundamentals
Intermediate Self-paced · 1 year access
25 Hands-On LiveLabs
Practice real IT tasks in guided environments.
- Real environments
- Auto-graded
- No installation
01 / Lessons & labs
See exactly what you will learn and practice
Lessons
4 Interactive Lessons · 31 topics01 Competency 1: Database Architecture 4 topics · 8 LiveLab +
- Understanding Database Management System
- Understanding Database Architecture
- Understanding Database Query Methods
- Understanding Distributed Database
8 LiveLab in this lesson — see the labs panel →
02 Competency 2: Database Design 21 topics · 15 LiveLab +
- Lesson Objectives
- Lesson Introduction
- TOPIC A: Connect to the SQL Database
- TOPIC B: Query a Database
- TOPIC C: Save a Query
- TOPIC D: Modify and Execute a Saved Query
- TOPIC E: Search Using One or More Conditions
- TOPIC F: Search for a Range of Values and NULL Values
- TOPIC G: Search Data Based on Patterns
- TOPIC H: Perform Date Calculations
- TOPIC I: Calculate Data Using Aggregate Functions
- TOPIC J: Manipulate String Values
- TOPIC K: Sort Data
- TOPIC L: Rank Data
- TOPIC M: Group Data
- TOPIC N: Filter Grouped Data
- TOPIC O: Summarize Grouped Data
- TOPIC P: Use PIVOT and UNPIVOT Operators
- TOPIC Q: Combine the Results of Two Queries
- TOPIC R: Compare the Results of Two Queries
- TOPIC S: Retrieve Data by Joining Tables
15 LiveLab in this lesson — see the labs panel →
03 Competency 3: Data Organization 4 topics · 2 LiveLab +
- Lesson Objectives
- Lesson Introduction
- TOPIC A: Generate a Text File
- TOPIC B: Generate an XML File
2 LiveLab in this lesson — see the labs panel →
04 Appendix A 2 topics +
- The FullerAckerman Database
- Schema
Hands-On Labs Our edge
25 LiveLabs- Creating the Table
- Inserting Values in a Table
- Updating the Value
- Retrieving Data from the Table
- Deleting the Record
- Creating an Index
- Deleting the Index
- Deleting the Table
- Using the HAVING Clause
- Using the WHERE Clause
- Using the Logical Operator
- Using the Arithmetic Operator
- Using the Comparison Operator
- Using the IN operator
- Retrieving the Unique Grades
- Calculating the Average
- Using the Concatenation Operator
- Retrieving Data in Descending Order
- Using the GROUP BY Clause
- Using the UNION Operator
- Using the Cross Join
- Using the Inner Join
- Using the Left Outer Join
- Saving the Query Results
- Using the Right Outer Join
Labs run in your browser — nothing to install.
Keep going
You might also like
Prepare for DBMDA/300 Database Fundamentals
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
- 25 LiveLab included
- Certificate of completion
No credit card required