Introduction to SQL Programming

A required course in the Business Intelligence & Data Warehousing Specialized Studies Program. An elective course in the Data Analytics for Business, Data Science, Database Management 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.