Introduces students to the basic concepts used in database design and advanced topics such as structured query language (SQL), data modeling, table creation, normalization, views, forms, queries, and reports. The lab component includes development of business applications using a relational database, MS SQL Server. This is an entry-level course. No prior database knowledge is needed.
- Understand relational database concepts and database terminology.
- Create a relational database.
- Normalize a database.
- Write moderately complex SQL queries that may include sub-query, joins, and builn functions.