Discover how to write powerful SQL queries that enable you to retrieve data from one table or from multiple tables stored in the database simultaneously. In this course, you will learn how to retrieve more meaningful data from one or more tables stored in a database. You will learn how to merge data from multiple columns, how to create calculated fields, and how to order and group the results from a query. You will also learn how to create a single join query or subquery to obtain data from multiple tables simultaneously. This course is offered in partnership with Learning Education Resource Network - UGotClass. For more information see http://yougotclass.org/index.cfm/VCC
Creating Calculated Fields and using Aggregate Functions Structured Query Language Review Creating calculated fields Concatenating columns Using aggregate functions
Using Clauses in Structured Query Language Using the ORDER BY clause Using the GROUP BY clause Using the GROUP BY clause and WHERE clause Using the HAVING clause
* Fees are approximate and subject to change. Students are required to pay any applicable fee increases. Fees listed are for domestic students. For international programs, visit VCC International.
† This information is intended as a guideline only. Program and course details are subject to change with the approval of VCC's Board of Governors.
Facebook
Twitter
Instagram
YouTube
Flickr
RSS
More accounts