UOP-DBM300: Database Fundamentals

• Understanding Database Management System
• Understanding Database Architecture
• Understanding Database Query Methods
• Understanding Distributed Database

8 LiveLab in this lesson — see the labs panel →

• 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

6 LiveLab in this lesson — see the labs panel →

• Lesson Objectives
• Lesson Introduction
• TOPIC A: Perform Date Calculations
• TOPIC B: Calculate Data Using Aggregate Functions
• TOPIC C: Manipulate String Values

3 LiveLab in this lesson — see the labs panel →

• Lesson Objectives
• Lesson Introduction
• TOPIC A: Sort Data
• TOPIC B: Rank Data
• TOPIC C: Group Data
• TOPIC D: Filter Grouped Data
• TOPIC E: Summarize Grouped Data
• TOPIC F: Use PIVOT and UNPIVOT Operators
• TOPIC G: Combine the Results of Two Queries
• TOPIC H: Compare the Results of Two Queries
• TOPIC I: Retrieve Data by Joining Tables

6 LiveLab in this lesson — see the labs panel →

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