3 Semester Credit Hours
An overview of relational databases, data types and database objects such as tables, queries, forms and reports will be covered. Basic SQL commands and database concepts are presented in a business context using MS Access, MS SQL Server and ORACLE. Major topics include basic SQL table queries, updating data, generating reports, database user management and server administration. Real-world case studies provide the background for the development of SQL and database management skills. Labs consist of assigned practice, projects and/or case studies relating to topics covered. Course contains 2 semester credit hours (30 clock hours) of lecture and 1 semester credit hour (30 clock hours) of laboratory work.