Introduction To SQL – it264 (3 credits)

This course provides an introduction to the Structured Query Language (SQL) that provides a unified language that lets you query, manipulate, or control data in a business applications environment.

This undergraduate-level course is 9 weeks. This course is available as part of a degree or certificate program. To enroll, speak with an Enrollment Representative.

Complex SQL Queries

  • Use the LIKE, IN, and BETWEEN operators to restrict the results of a query.
  • Use the ORDER BY clause to sort data.
  • Use the WHERE clause to restrict the results of the query with a compound condition.

Queries Using Aggregate Functions and Subqueries

  • Use aggregate functions to run calculated queries.
  • Use the GROUP BY clause to group data on a column.
  • Use the HAVING clause to restrict the groups on a column.

Queries Using Multiple Tables

  • Create joins to retrieve data from multiple tables.
  • Use IN and EXISTS operators to restrict the results of a multiple table query.

Updating Table Data Using SQL

  • Create new tables from existing tables.
  • Use the ALTER TABLE command to change a table's structure.
  • Use the UPDATE command to add rows to a table.

SQL in Review

  • Apply SQL to a business application.

Database Design

  • Identify primary keys.
  • Explain the function of entities, attributes, and relationships in a relational database.
  • Describe functional dependency.
  • Explain a normalized database.

Creating Tables

  • Create tables using SQL.

Inserting Data Into a Table Using SQL

  • Use the INSERT command to insert data into a table.
  • Describe how to save SQL for later use.

Simple SQL Queries

  • Use the SELECT command to retrieve data from a table.
  • Use the WHERE clause to restrict the results of the query with a simple condition.

Start your journey now

or call us at866.766.0766

Contact us