BDA102A – Introduction to Databases Part 1

Associate of Applied Science in Business Data Analytics

Course ID

BDA 102A

Course Credits

4

About BDA102A – Introduction to Databases 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 102A 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. 

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.

Talk to an Advisor

Request an appointment with one of our IT expert Admissions Advisors for personalized guidance on building your education plan. You’ll be able to book an appointment instantly for a time that fits your schedule. 

Enrollment Deadline - July 24, 2023!

Oops! We could not locate your form.

*By submitting this form, you are giving your express written consent for California Institute of Arts & Technology to contact you regarding our educational programs and services using email, telephone or text – including our use of automated technology for calls and periodic texts to any wireless number you provide. Message and data rates may apply. This consent is not required to purchase goods or services and you may always call us directly at 877-559-3621. You can opt-out at any time by calling us or responding STOP to any text message.