Skip to content

IT:Web:Programming-SQL

Course Number: 10-152-184
Credits: 3
Home » Academics And Training » Courses » 10152184056346

Course Information

Description: 10-152-184 IT:WEB:PROGRAMMING-SQL ...write queries in a relational database: creating tables, setting primary/foreign keys, populating tables, manipulating data and reporting. Explore join types, stored procedures, functions, and database administration SQL statements. (Corequisite: 10-154-125, IT:Web:Database Development)
Total Credits: 3

Course Competencies

  1. Translate information needs into accurate SQL statements to generate results that meet business requirements.
  2. Produce basic SQL statements with appropriate uses of each type.
  3. Develop single-table queries.
  4. Construct multiple-table queries.
  5. Construct sub-select SQL statements.
  6. Program triggers to accomplish a stated business process.
  7. Produce database views.
  8. Distinguish appropriate uses for stored procedures and user-defined functions.
  9. Generate data to populate reports to satisfy business requirements.

Course details are from the 2021-2022 academic year and are subject to change after 5/23/2022.