Relational Database Management Systems and SQL

Associate of Applied Science in Information Technology – Software Development

Course ID
ASD103
Course Credits
4

About Relational Database Management Systems & SQL

This course introduces students to relational databases and Structured Query Language (SQL). The focus will be primarily SQL using MySQL and MySQL Workbench. Students will acquire the foundational understanding of databases, how they are structured, and how transactions are performed on them. SQL language concepts regarding 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 SQL databases to provide in-depth software-based solutions.


Prerequisites

Students must have completed SD102 with a satisfactory grade.


Talk to an Advisor

Reach out today and one of our knowledgeable admissions specialists will be happy to answer any questions you have about CIAT.