BDA101A – Data Fundamentals Part 1
Associate of Applied Science in Business Data Analytics
Course ID
BDA 101A
Course Credits
4
About BDA101A – Data Fundamentals Part 1
This course introduces students to relational databases and Structured Query Language (SQL). The focus of the course will be primarily SQL using MySQL and MySQL Workbench. 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 SQL databases to provide in-depth software-based solutions.
Topics Covered In Course
BDA 101A Topics
- Define a relational database
- Gather database requirements and define business rules for a database.
- Create an entity design for a database
- Understand database normalization: normalize a database.
- Develop relational databases in SQL.
Prerequisites
Students must have experience using a keyboard and mouse in a GUI-based OS such as Microsoft Windows or Macintosh and understand how to download and install programs found on the Internet.