Introduction to SQL Programming

A course in the Database Management Certificate Program and an elective in the Data Analytics Certificate, Data Science Certificate, and Full Stack Web Development Certificate Programs.

Install SQL Server to your desktop and run complex queries using the Structured Query Language (SQL). This course will cover database table structures, column data types, and the T-SQL language components that go into querying against a database. Reading data from a table, row filtering, and column based functions will be discussed. We will also write queries that combine data from multiple tables, use conditional logic, and create aggregated result sets (sum, average, min, max). Database administration features of SQL will also be discussed.

Prerequisites: Familiarity with data processing concepts and techniques.

Click on "See Details" below and refer to "Special Notes" for additional section specific information.