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 to take individually or as part of a degree or certificate program. To enroll, speak with an Enrollment Advisor.

Database Design

  • Explain the function of entities, attributes, and relationships in a relational database.

  • Identify primary keys.

  • 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.

Complex SQL Queries

  • Use the WHERE clause to restrict the results of the query with a compound condition.

  • Use the LIKE, IN, and BETWEEN operators to restrict the results of a query.

  • Use the ORDER BY clause to sort data.

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 UPDATE command to add rows to a table.

  • Use the ALTER TABLE command to change a tables structure.

SQL in Review

  • Apply SQL to a business application.

Start your journey now

Continue
or call us at866.766.0766

Contact us