uCertify

DBMDA/300 Database Fundamentals

(UOP-DBMDA300.AD1)
Lessons
Lab
TestPrep
AI Tutor (Add-on)
Get A Free Trial

Skills You’ll Get

Download Course Outline

1

Competency 1: Database Architecture

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

Competency 2: Database Design

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

Competency 3: Data Organization

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

Appendix A

  • The FullerAckerman Database
  • Schema

1

Competency 1: Database Architecture

  • 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

Competency 2: Database Design

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

Competency 3: Data Organization

  • Saving the Query Results
  • Using the Right Outer Join

Related Courses

All Courses