Course Description | Outline | IT Home

Overview

In this course, students will learn the fundamentals of the structured query language (SQL) and how to use SQL to store, extract and present information.  Lecture, numerous hands-on lab exercises using Microsoft Access and Oracle 11g, along with an excellent textbook (which students keep) are used to provide students with a solid understanding of SQL. 

This is the perfect course for anyone who frequently queries data or works with databases or query/reporting tools: business analysts, report writers, programmers new to SQL, data quality specialists, QA testers. While the course is taught using Access and Oracle, the focus of the course is on database-independent SQL statements and concepts.

Topics

• Storing Information in Tables
• Inserting, Updating, and Deleting Information in Tables
• Getting Information from a Table
• Compound Conditions in the Where Clause
• Inner Joins
• Introduction to Row Functions
• Using Row Functions
• Controlling the Level of Summarization
• Outer Joins
• Union and Union All
• Self Joins
• If/then/else Subqueries
  

Prerequisites

Participants should be comfortable with Windows and MS Office, but do not need prior experience with databases.

Schedule

3 days

Contact

• if you have any questions about this course,
• to be notified when this course and any closely related courses are scheduled for open enrollment,
• to request a quote for group training at your location or ours.