http://www.phoenix.edu
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.
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.
- The University of Phoenix reserves the right to modify courses.
- While widely available, not all programs are available in all locations or in both online and on-campus formats. Please check with a University Enrollment Advisor.
- Transferability of credit is at the discretion of the receiving institution. It is the student’s responsibility to confirm whether or not credits earned at University of Phoenix will be accepted by another institution of the student’s choice.
We're here to help
Learn more today
Find out how we can help you meet your goals. Not all courses are available to residents of all states. Ask your Enrollment Advisor for details.
Loading...
It looks like you are using
Enhance your Phoenix.edu experience
You're using an older browser (a software program used to explore the web) which is not optimal for viewing the University of Phoenix website. Consider downloading a new browser to maximize your experience on this and other websites. Your new browser should display web pages properly, increase your web surfing speed and enhance your security.
Upgrade your browser