uCertify

UOP-DBM300: Database Fundamentals

(UOP-DBM300.AA1)
Lessons
Lab
TestPrep
Get A Free Trial

Skills You’ll Get

Download Course Outline

1

Understanding Database

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

Executing Query and Performing Conditional Search

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

Working with Functions

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

Organizing and Retrieving Data

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

Exporting Query Results

  • Lesson Objectives
  • Lesson Introduction
  • TOPIC A: Generate a Text File
  • TOPIC B: Generate an XML File
A

Appendix A

  • The FullerAckerman Database
  • Schema

1

Understanding Database

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

Executing Query and Performing Conditional Search

  • Using the HAVING Clause
  • Using the WHERE Clause
  • Using the Logical Operator
  • Using the Arithmetic Operator
  • Using the Comparison Operator
  • Using the IN operator
3

Working with Functions

  • Retrieving the Unique Grades
  • Calculating the Average
  • Using the Concatenation Operator
4

Organizing and Retrieving Data

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

Exporting Query Results

  • Saving the Query Results
  • Using the Right Outer Join
6

Appendix A

  • Sandbox

Related Courses

All Courses