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.
- 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)
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.