► CoursesSQL Fundamentals (IT-4812C)

SQL Fundamentals

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
Course Outline

Alert Me

If you would like to be notified of future classes for this course, please click on Alert Me and complete the short form.

Group Training Available

UMBC Training Centers can deliver any of our courses in a group training environment at our facilities or yours. Group training can be an effective and economical method to quickly assure competency and consistency of knowledge and skills within an organization or department.
© 2014 UMBC Training Centers, 6996 Columbia Gateway Drive, Suite 100, Columbia, MD 21046 ipR.gif 443-692-6600
Sitemap