ASD103 – Relational Database Management Systems and SQL

Associate of Applied Science in Software Development

Course ID

ASD103

Course Credits

4

About ASD103 – Relational Database Management Systems and 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. Register for our Relational Database Management Systems & SQL training course.

Topics Covered In Course

ASD103 Topics

Understanding relational databases. Developing ERDs.
Creating tables. Single-table queries.
Multiple-table queries. Updating data.
SQL functions and procedures.
Database administration.

Prerequisites

Students must have experience using a keyboard and mouse in a GUI-based OS such as Microsoft Windows or Linux, and understand how to download and install programs found on the Internet.

Meet The Faculty

Our expert, certified faculty members come with years of industry experience and are passionate about helping students build and advance their tech careers.