DAP 300A- SQL Programming Part 1

Applied Bachelor’s Degree in Software Development

Course ID

DAP 300A

Course Credits

4

About DAP 300A- SQL Programming 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

DAP 300A Topics

Use various types of joins to retrieve data from multiple tables; use operators IN, EXISTS, ALL, ANY
Create new tables from existing tables
Maintain table by changing and saving data, utilizing UPDATE, INSERT, DELETE, COMMIT, ROLLBACK and DROP TABLE
Create and use views for data update
Define the security context of a database and its users in MS SQL Server; Manage database users and their privileges
Create, use and drop index
Use integrity constraints to control data entry
Understand benefits of using SQL in programming environment

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.

California Institute of Arts & Technology