Buy Now AED 239.99 + VAT

Monthly Subscription Starting at AED 99 + VAT

Database Management Essentials
  • Level Professional
  • Duration 123 hours
  • Course by University of Colorado System
  • Offered by

About

Database Management Essentials provides the foundation you need for a career in database development, data warehousing, or business intelligence, as well as for the entire Data Warehousing for Business Intelligence specialization. In this course, you will create relational databases, write SQL statements to extract information to satisfy business reporting requests, create entity relationship diagrams (ERDs) to design databases, and analyze table designs for excessive redundancy. As you develop these skills, you will use either Oracle, MySQL, or PostgreSQL to execute SQL statements and a database diagramming tool such as the ER Assistant or Visual Paradigm to create ERDs. We've designed this course to ensure a common foundation for specialization learners. Everyone taking the course can jump right in with writing SQL statements in Oracle, MySQL, or PostgreSQL.

Modules

Specialization Introduction

    • 1 Videos
    • 1 Readings
Show info about module content

1 Videos

  • Specialization Introduction video lesson

1 Readings

  • Get help and meet other learners in this course. Join your discussion forums!

Course Introduction

    • 1 Videos
Show info about module content

1 Videos

  • Course introduction video lecture

Course objectives

    • 1 Videos
    • 1 Readings
Show info about module content

1 Videos

  • Course objectives video lecture

1 Readings

  • Powerpoint lecture notes for lesson 1

Topics, assignments, and DBMS software

    • 1 Videos
    • 3 Readings
Show info about module content

1 Videos

  • Topics and assignments video lecture

3 Readings

  • Powerpoint lecture notes for lesson 2
  • Optional textbook
  • Database management software requirements

Database characteristics

    • 1 Videos
    • 1 Readings
    • 1 Assignment
Show info about module content

1 Assignment

  • Learning check-in

1 Videos

  • Database characteristics video lecture

1 Readings

  • Powerpoint lecture notes for lesson 1

Organizational roles

    • 1 Videos
    • 1 Readings
Show info about module content

1 Videos

  • Organizational Roles video lecture

1 Readings

  • Powerpoint lecture notes for lesson 2

DBMS overview and database definition feature

    • 1 Videos
    • 1 Readings
Show info about module content

1 Videos

  • DBMS overview and database definition feature video lecture

1 Readings

  • Powerpoint lecture notes for lesson 3

Non-procedural access

    • 1 Videos
    • 1 Readings
Show info about module content

1 Videos

  • Non-procedural access video lecture

1 Readings

  • Powerpoint lecture notes for lesson 4

Transaction processing overview

    • 1 Videos
    • 1 Readings
Show info about module content

1 Videos

  • Transaction processing overview video lecture

1 Readings

  • Powerpoint lecture notes for lesson 5

Data warehouse processing overview

    • 1 Videos
    • 1 Readings
Show info about module content

1 Videos

  • Data warehouse processing overview video lecture

1 Readings

  • Powerpoint lecture notes for lesson 6

DBMS technology evolution

    • 1 Videos
    • 1 Readings
Show info about module content

1 Videos

  • DBMS technology evolution video lecture

1 Readings

  • Powerpoint lecture notes for lesson 7

Concept Quiz and Review

    • 1 Readings
    • 1 Assignment
Show info about module content

1 Assignment

  • Concept Quiz for Module 2

1 Readings

  • Optional textbook reading

Basics of relational databases

    • 1 Videos
    • 1 Readings
Show info about module content

1 Videos

  • Basics of relational databases video lecture

1 Readings

  • Powerpoint lecture notes for lesson 1

Integrity rules

    • 1 Videos
    • 1 Readings
Show info about module content

1 Videos

  • Integrity rules video lecture

1 Readings

  • Powerpoint lecture notes for lesson 2

Basic SQL CREATE TABLE statement

    • 1 Videos
    • 2 Readings
Show info about module content

1 Videos

  • Basic SQL CREATE TABLE statement video lecture

2 Readings

  • Powerpoint lecture notes for lesson 3
  • University database SQL statements for Oracle and PostgreSQL

Integrity constraint syntax

    • 1 Videos
    • 1 Readings
Show info about module content

1 Videos

  • Integrity constraint syntax video lecture

1 Readings

  • Powerpoint lecture notes for lesson 4

Assignment 1 Notes

    • 1 Videos
    • 1 Readings
Show info about module content

1 Videos

  • Assignment 1 notes video lecture

1 Readings

  • Powerpoint lecture notes for lesson 5

Concept Quiz, Practice Problems, and Assignment

    • 6 Readings
    • 3 Assignment
Show info about module content

3 Assignment

  • Concept Quiz for Module 3
  • Quiz for Module 3 practice problems
  • Reflective Quiz for the Module 3 Assignment

6 Readings

  • Optional textbook reading
  • DBMS installation and usage notes
  • Practice Problems for Module 3
  • Extra Problems for Module 3
  • Assignment for Module 3
  • Self Evaluation for the Module 3 assignment

SQL Overview

    • 1 Videos
    • 1 Readings
Show info about module content

1 Videos

  • SQL Overview video lecture

1 Readings

  • Powerpoint lecture notes for lesson 1

SELECT statement introduction

    • 1 Videos
    • 1 Readings
Show info about module content

1 Videos

  • SELECT statement introduction video lecture

1 Readings

  • Powerpoint lecture notes for lesson 2

Join Operator

    • 1 Videos
    • 1 Readings
Show info about module content

1 Videos

  • Join Operator video lecture

1 Readings

  • Powerpoint lecture notes for lesson 3

Using join operations in SQL SELECT statements

    • 1 Videos
    • 1 Readings
Show info about module content

1 Videos

  • Using Join operations in SQL SELECT statements video lecture

1 Readings

  • Powerpoint lecture notes for lesson 4

GROUP BY clause

    • 1 Videos
    • 1 Readings
Show info about module content

1 Videos

  • GROUP BY clause video lecture

1 Readings

  • Powerpoint lecture notes for lesson 5

Concept Quiz, Lesson Examples, Practice Problems, and Assignment

    • 7 Readings
    • 3 Assignment
Show info about module content

3 Assignment

  • Concept Quiz for Module 4
  • Quiz for the practice problems in Module 4
  • Reflective Quiz for the Module 4 Assignment

7 Readings

  • Optional textbook reading
  • Lesson examples using SQL statements
  • Practice problems for Module 4
  • Extra problems for Module 4
  • Assignment for Module 4
  • Self evaluation for the Module 4 Assignment
  • DBMS installation and usage notes

Query formulation guidelines

    • 1 Videos
    • 1 Readings
Show info about module content

1 Videos

  • Query formulation guidelines video lecture

1 Readings

  • Powerpoint lecture notes for lesson 1

Multiple table problems

    • 1 Videos
    • 1 Readings
Show info about module content

1 Videos

  • Multiple table problems video lecture

1 Readings

  • Powerpoint lecture notes for lesson 2

Problems involving join and grouping operations

    • 1 Videos
    • 1 Readings
Show info about module content

1 Videos

  • Problems involving join and grouping operations video lecture

1 Readings

  • Powerpoint lecture notes for lesson 3

SQL set operators

    • 1 Videos
    • 1 Readings
Show info about module content

1 Videos

  • SQL set operators video lecture

1 Readings

  • Powerpoint lecture notes for lesson 4

SQL modification statements

    • 1 Videos
    • 1 Readings
Show info about module content

1 Videos

  • SQL modification statements video lecture

1 Readings

  • Powerpoint lecture notes for lesson 5

Query Formulation Errors

    • 1 Videos
    • 1 Readings
Show info about module content

1 Videos

  • Query formulation errors video lecture

1 Readings

  • Powerpoint lecture notes for lesson 6

Concept Quiz, Lesson Examples, Practice Problems, and Assignment

    • 7 Readings
    • 3 Assignment
Show info about module content

3 Assignment

  • Concept Quiz for Module 5
  • Quiz for practice problems in Module 5
  • Reflective Quiz for the Module 5 Assignment

7 Readings

  • Optional textbook reading
  • Lesson examples using SQL statements
  • Practice problems for Module 5
  • Extra problems for Module 5
  • Assignment for Module 5
  • Self evaluation for the Module 5 assignment
  • DBMS installation and usage notes

Database development goals

    • 1 Videos
    • 1 Readings
Show info about module content

1 Videos

  • Database development goals video lecture

1 Readings

  • Powerpoint lecture notes for lesson 1

Basic ERD notation

    • 1 Videos
    • 1 Readings
Show info about module content

1 Videos

  • Basic ERD notation video lecture

1 Readings

  • Powerpoint lecture notes for lesson 2

Relationship variations I

    • 1 Videos
    • 1 Readings
Show info about module content

1 Videos

  • Relationship variations I video lecture

1 Readings

  • Powerpoint lecture notes for lesson 3

Relationship variations II

    • 1 Videos
    • 1 Readings
Show info about module content

1 Videos

  • Relationship variations II video lecture

1 Readings

  • Powerpoint lecture notes for lesson 4

Concept Quiz, Practice Problems, and Assignment

    • 4 Readings
    • 2 Assignment
Show info about module content

2 Assignment

  • Concept Quiz for Module 6
  • Reflective Quiz for the Module 6 Assignment

4 Readings

  • Optional textbook reading
  • Practice problems for Module 6
  • Assignment for Module 6
  • Self evaluation for the Module 6 assignment

Basic diagram rules

    • 1 Videos
    • 1 Readings
Show info about module content

1 Videos

  • Basic diagram rules video lecture

1 Readings

  • Powerpoint lecture notes for lesson 1

Extended diagram rules

    • 1 Videos
    • 1 Readings
Show info about module content

1 Videos

  • Extended diagram rules video lecture

1 Readings

  • Powerpoint lecture notes for lesson 2

ERD problems I

    • 1 Videos
    • 1 Readings
Show info about module content

1 Videos

  • ERD problems I video lecture

1 Readings

  • Powerpoint lecture notes for lesson 3

ERD problems II

    • 1 Videos
    • 1 Readings
Show info about module content

1 Videos

  • ERD problems II video lecture

1 Readings

  • Powerpoint lecture notes for lesson 4

ER Assistant Demonstration

    • 1 Videos
    • 1 Readings
Show info about module content

1 Videos

  • ER Assistant Demonstration video

1 Readings

  • ER Assistant download

Visual Paradigm Demonstration

    • 1 Videos
    • 1 Readings
Show info about module content

1 Videos

  • Software demonstration video for Visual Paradigm

1 Readings

  • Download for Visual Paradigm

Concept Quiz, Practice Problems, and Assignment

    • 4 Readings
    • 2 Assignment
Show info about module content

2 Assignment

  • Concept Quiz for Module 7
  • Reflective Quiz for the Module 7 Assignment

4 Readings

  • Optional textbook reading material
  • Practice Problems for Module 7
  • Assignment for Module 7
  • Self evaluation for the Module 7 assignment

Conceptual data modeling goals and challenges

    • 1 Videos
    • 1 Readings
Show info about module content

1 Videos

  • Conceptual data modeling goals and challenges

1 Readings

  • Powerpoint lecture notes for lesson 1 and extras

Analyzing narrative problems

    • 1 Videos
    • 1 Readings
Show info about module content

1 Videos

  • Analyzing narrative problems

1 Readings

  • Powerpoint lecture notes for lesson 2

Design transformations I

    • 1 Videos
    • 1 Readings
Show info about module content

1 Videos

  • Design transformations I

1 Readings

  • Powerpoint lecture notes for lesson 3

Design transformations II

    • 1 Videos
    • 1 Readings
Show info about module content

1 Videos

  • Design transformations II video lecture

1 Readings

  • Powerpoint lecture notes for lesson 4

Concept Quiz, Practice Problems, and Assignment

    • 4 Readings
    • 2 Assignment
Show info about module content

2 Assignment

  • Concept Quiz for Module 8
  • Reflective Quiz for the Module 8 Assignment

4 Readings

  • Optional textbook reading material
  • Practice problems for Module 8
  • Assignment for Module 8
  • Self evaluation for the Module 8 assignment

Data modeling problems I

    • 1 Videos
    • 1 Readings
Show info about module content

1 Videos

  • Data modeling problems I video lecture

1 Readings

  • Powerpoint lecture notes for lesson 1

Data modeling problems II

    • 1 Videos
    • 1 Readings
Show info about module content

1 Videos

  • Data modeling problems II video lecture

1 Readings

  • Powerpoint lecture notes for lesson 2

Finalizing an ERD

    • 1 Videos
    • 1 Readings
Show info about module content

1 Videos

  • Finalizing an ERD video lecture

1 Readings

  • Powerpoint lecture notes for lesson 3

Concept Quiz, Practice Problems, and Assignment

    • 4 Readings
    • 2 Assignment
Show info about module content

2 Assignment

  • Concept Quiz for Module 9
  • Reflective Quiz for the Module 9 Assignment

4 Readings

  • Optional textbook reading material
  • Practice Problems for Module 9
  • Assignment for Module 9
  • Self evaluation for the Module 9 assignment

Goals and steps of logical database design

    • 1 Videos
    • 1 Readings
Show info about module content

1 Videos

  • Goals and steps of logical database design video lecture

1 Readings

  • Powerpoint lecture notes for lesson 1

Conversion rules

    • 1 Videos
    • 1 Readings
Show info about module content

1 Videos

  • Conversion rules video lecture

1 Readings

  • Powerpoint lecture notes for lesson 2

Conversion problems

    • 1 Videos
    • 1 Readings
Show info about module content

1 Videos

  • Conversion problems video lecture

1 Readings

  • Powerpoint lecture notes for lesson 3

Concept Quiz, Practice Problems, and Assignment

    • 4 Readings
    • 2 Assignment
Show info about module content

2 Assignment

  • Concept Quiz for Module 10
  • Reflective Quiz for the Module 10 Assignment

4 Readings

  • Optional textbook reading material
  • Practice Problems for Module 10
  • Assignment for Module 10
  • Self evaluation for the Module 10 assignment

Modification anomalies

    • 1 Videos
    • 1 Readings
Show info about module content

1 Videos

  • Modification anomalies video lecture

1 Readings

  • Powerpoint lecture notes for lesson 1 and extras

Functional dependencies

    • 1 Videos
    • 1 Readings
Show info about module content

1 Videos

  • Functional dependencies video lecture

1 Readings

  • Powerpoint lecture notes for lesson 2

Normal forms

    • 1 Videos
    • 1 Readings
Show info about module content

1 Videos

  • Normal forms video lecture

1 Readings

  • Powerpoint lecture notes for lesson 3

Practical concerns

    • 1 Videos
    • 1 Readings
Show info about module content

1 Videos

  • Practical concerns video lecture

1 Readings

  • Powerpoint lecture notes for lesson 4

Normalization problems

    • 1 Videos
    • 1 Readings
Show info about module content

1 Videos

  • Normalization problems video lecture

1 Readings

  • Powerpoint lecture notes for lesson 5

Concept Quiz, Practice Problems, and Assignment

    • 4 Readings
    • 2 Assignment
Show info about module content

2 Assignment

  • Concept Quiz for Module 11
  • Reflective Quiz for the Module 11 Assignment

4 Readings

  • Optional textbook reading materials
  • Practice Problems for Module 11
  • Assignment for Module 11
  • Self evaluation for the Module 11 assignment

Outer join operators and one-sided outer problems in SQL

    • 2 Videos
    • 2 Readings
Show info about module content

2 Videos

  • Part 1: Outer Join Operators
  • Part 2: One-Sided Outer Join Problems in SQL

2 Readings

  • Part 1: Powerpoint lecture notes for outer join operators
  • Part 2: Powerpoint lecture notes for one-sided outer join problems in SQL

Nested Queries in the SELECT Statement

    • 1 Videos
    • 1 Readings
Show info about module content

1 Videos

  • Nested queries video lecture

1 Readings

  • Powerpoint slides for nested queries in the SELECT statement

Membership Exception Problem

    • 1 Videos
    • 1 Readings
Show info about module content

1 Videos

  • Membership exception problem Video lecture

1 Readings

  • Powerpoint slides for the membership exception problem

Relational Division Operator and Containment Exceptions in the SELECT Statement

    • 2 Videos
    • 2 Readings
Show info about module content

2 Videos

  • Part 1: Relational division operator video lecture
  • Part 2: Containment exceptions video lecture

2 Readings

  • Powerpoint slides for the relational division operator
  • Part 2: Powerpoint slides for containment exceptions in the SELECT statement

Summary of Problem-Solving Guidelines

    • 1 Videos
    • 1 Readings
Show info about module content

1 Videos

  • Summary of problem-solving guidelines video lecture

1 Readings

  • Powerpoint slides for summary of problem-solving guidelines

Course Conclusion

    • 1 Videos
Show info about module content

1 Videos

  • Course Conclusion

Lecture Examples, Practice Problems, Quiz, and Assignment

    • 6 Readings
    • 2 Assignment
Show info about module content

2 Assignment

  • Concept Quiz for Module 12
  • Reflective Quiz for the Module 12 Assignment

6 Readings

  • Optional textbook reading material
  • Lesson SQL examples
  • Practice problems using the University Database
  • Extra problems using the Order Entry Database
  • Assignment for Module 12
  • Self evaluation for the Module 12 assignment

Auto Summary

Database Management Essentials is an IT & Computer Science course designed for those pursuing careers in database development, data warehousing, or business intelligence. Taught by expert instructors on Coursera, it covers creating relational databases, writing SQL statements, designing ER diagrams, and analyzing table designs. The course uses tools like Oracle, MySQL, PostgreSQL, and ER diagramming software. Available subscription options include Starter, Professional, and Paid plans. Ideal for professionals seeking a solid foundation in database management.

Michael Mannino
Instructor

Michael Mannino