Introduction to Databases, Part 2

Catalog description

This course introduces students to relational databases and Structured Query Language (SQL) . The focus of the course will be database design concepts. Students acquire foundational understanding of databases, how they are structured, and how transactions are performed on database. SQL language concepts concerning creating, reading, updating, and deleting data will be presented. Additional topics introduced include data types, tables, keys, relationships, functions, indexes, views, stored procedures, and optimization and replication. Upon completion of the course students will be able to understand how to create, modify, and maintain databases.