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

Any questions?
Check out the FAQs

Still have unanswered questions and need to get in touch?

Contact Us Now

Related Courses

All Courses
We use cookies for improving site experience and analytics. Learn More