CSC 150 Database Applications and Design Using SQL Spring 2010 Final Exam Review

Connecticut Community Colleges

Gateway Community College

Student Info System

Contact Instructor

Home Syllabus Term Project

The final exam will cover all the materials from chapters 2 - 4, and 6 - 13 in SQL Fundamentals but will focus on the materials in Chapters 10 - 13

The following topics will be the focus of the final exam.

• Row Functions
• User/Date Functions
• Nulls and Data Conversion Functions
• Column/Aggregate Functions
• Functions for text, date, and number datatypes
• Functions for numbers only
• Group by Clause
• Groups based on one column
• Groups based on multiple columns
• Summary data vs Detail data
• Having clause
• Having clause vs where clause
• Inner Joins
• Using an alias to identify a column
• Joining two or more tables in the where clause
• Using functions in select statements with joins
• Additional criteria in where clause with a join
• Using group by, having, and orderby clauses with a join

Last Updated: 5/5/10