Relational Databases

See This Course Brochure

START:
August 1, 2020
DURATION:
Contact hours: 45
Lecture hours: 15
Lab hours: 30
ID:
RU 6002
CREDIT:
4.5

Address

205 Van Buren Street, Suite 140, Herndon, VA 20170   View map

Relational databases are covered including all database concepts such as fields, records, normalization, and database security. The course utilizes SQL Server and will use the SQL language, but the concepts are applicable to other database management systems such as Postgre, Oracle, and MySQL.

Objectives:

  • Define essential database vocabulary
  • Effectively apply data relationships and normalization techniques
  • Describe the transformation of database design from a conceptual user model (e.g., an ERD) to a normalized relational model
  • Explain and apply Structured Query Language (SQL) in a database environment
  • Describe the methods available for minimizing DBMS risks and security failures
  • Characterize the roles and responsibilities of the Database Administrator (DBA)

Prerequisite: None
Credits: 4.5
Contact hours: 45
Lecture hours: 15
Lab hours: 30
Faculty office hours: faculty is available outside class hours by appointment, via email, and at scheduled times.

Advising: faculty and career counselors are available to assist students with their career directions and questions.