An expert was once a beginner

Introduction to SQL Querying

1 Day, 9:00-4:00

Course Overview

This instructor-led, hands-on course, will teach you how to compose SQL queries to retrieve desired information from a database. The course is geared for individuals familiar with concepts related to database structure and terminology and who want to use SQL to query databases.

Course Objectives

  • Connect to the SQL Server database and execute a simple query
  • Include a search condition in a simple query
  • Use various functions to perform calculations on data
  • Organize data obtained from a query before it is displayed on-screen
  • Retrieve data from tables
  • Format an output, save a result, and generate a report

Course Outline

Executing a Simple Query

  • Connect to the SQL Database
  • Query a Database
  • Save a Query
  • Modify a Query
  • Execute a Saved Query

Performing a Conditional Search

  • Search Using a Simple Condition
  • Compare Column Values
  • Search Using Multiple Conditions
  • Search for a Range of Values and Null Values
  • Retrieve Data Based on Patterns

Working with Functions

  • Perform Date Calculations
  • Calculate Data Using Aggregate Functions
  • Manipulate String Values

Organizing Data

  • Sort Data
  • Rank Data
  • Group Data
  • Filter Grouped Data
  • Summarize Grouped Data
  • Use PIVOT and UNPIVOT Operators

Retrieving Data from Tables

  • Combine Results of Two Queries
  • Compare the Results of Two Queries
  • Retrieve Data by Joining Tables
  • Check for Unmatched Records
  • Retrieve Information from a Single Table Using Joins

Presenting Query Results

  • Save the Query Result
  • Generate an XML Report

Appendix A: The OGCBooks Database

 

Cost and Delivery Format Options

We offer the above listed class on our public schedule in the following delivery formats. Contact Softek for more information on private group training.

Public Class: Live Virtual or at Softek
Per student $400

Private Group Training

Private group classes are cost effective when you have a group of students who need the same course. Volume discounts of 5% to 20% are available when five or more training days are scheduled. For classes conducted at your location, you are responsible for the classroom setup which should include:

  • A computer for each student (with the appropriate software installed), and
  • An instructor workstation connected to a visual display (e.g., projector, smartboard, etc.).

Customization

Softek can easily customize a training course that covers the specific topics you require and integrate examples relevant to your work environment. Course customization is billed at $125 per hour and covers time needed to meet, discuss, prepare, and incorporate any specific examples into the training program. Once we have a better idea of what you have in mind, we will be glad to provide a specific price quote for the customization. There is a 2-hour minimum fee for customization.

Why Choose Softek?

  • Live, virtual or in-person training
  • Instructors with 15+ years of experience
  • Detailed training guide
  • Certificate of completion
  • Money-back guarantee