• Skip to primary navigation
  • Skip to main content
Federal Solutions
Contact Us:       [email protected]       (512) 794-8440

Microassist

  • Accessibility Services
    • Accessibility Audits
    • VPAT Assessment Services
    • Accessibility Remediation Services
    • Accessible Document Remediation Services Including PDF Remediation Services
    • Accessible Website and Application Development
    • Accessible Digital Learning
    • Compliance for Digital Learning
    • Accessibility Training
    • Accessibility in the News
    • VPAT Buyers Guide
  • Custom E-Learning
    • Accessible E-Learning
    • Managed Learning Services: Training Support for Business
    • Training Staffing Solutions
    • Learning Management Systems
    • Learning Translation and Localization
    • Examples of Our Work
    • The Learning Dispatch (Blog)
  • Classes
    • Course List
    • Course Schedule
    • Classroom Rental
    • Classes FAQ
  • Public Safety Solutions
    • Sex Offender State Registry (SOR) Solution
    • RTL Connect: Modernizing State Data Repositories, Licensing, and Registrations
  • About
    • Government Solutions
    • Newsletter Subscriptions
    • Career Opportunities
    • News and Media
    • Blogs
    • Team
  • Open Search Field

SQL 2008: Fundamentals

Course Overview

You will compose SQL queries to retrieve desired information from a database.

To find out when this course is being offered next, please refer to our Course Schedule.

Course Length

1 day

Course Price

$425 (U.S.)

Register for Class


Registration Form

Target Audience

Individuals with basic computer skills, familiar with concepts related to database structure and terminology, and who want to use SQL to query databases.

Course Prerequisites

Basic end-user computer skills and some familiarity with database terminology and structure are required.

 

Learning Outcomes / Objectives

Upon successful completion of this course, students will be able to:

  • 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.

Register for Class


Registration Form

Topic List

Lesson 1: Executing a Simple Query
Topic 1A: Connect to the SQL Database
Topic 1B: Query a Database
Topic 1C: Save a Query
Topic 1D: Modify a Query
Topic 1E: Execute a Saved Query

Lesson 2: Performing a Conditional Search
Topic 2A: Search Using a Simple Condition
Topic 2B: Compare Column Values
Topic 2C: Search Using Multiple Conditions
Topic 2D: Search for a Range of Values and Null Values
Topic 2E: Retrieve Data Based on Patterns

Lesson 3: Working with Functions
Topic 3A: Perform Date Calculations
Topic 3B: Calculate Data Using Aggregate Functions
Topic 3C: Manipulate String Values

Lesson 4: Organizing Data
Topic 4A: Sort Data
Topic 4B: Rank Data
Topic 4C: Group Data
Topic 4D: Filter Grouped Data
Topic 4E: Summarize Grouped Data
Topic 4F: Use PIVOT and UNPIVOT Operators

Lesson 5: Retrieving Data from Tables
Topic 5A: Combine Results of Two Queries
Topic 5B: Compare the Results of Two Queries
Topic 5C: Retrieve Data by Joining Tables
Topic 5D: Check for Unmatched Records
Topic 5E: Retrieve Information from a Single Table Using Joins

Lesson 6: Presenting Query Results
Topic 6A: Save the Query Result
Topic 6B: Generate an XML Report

Appendix A: The OGCBooks Database

Footer

Microassist

Founded in 1988, Microassist is a leader in accessibility, training development and delivery, and software development. We serve clients nationwide across corporate, government, and higher education sectors. As a Minority-Owned Business Enterprise (MBE) and Historically Underutilized Business (HUB), we bring decades of expertise to every partnership, with contracts including GSA and multiple State of Texas DIR contracts.

Quick Links

Government Solutions

Classroom Course Schedule

Excel Classes near Austin, TX

Custom E-Learning Development

Training Managers Guide to Accessible Learning

VPAT Evaluation Services

Accessibility in the News

Accessibility Audit Services

Contact Us

Microassist, Inc.

8500 Shoal Creek
Building 4, Suite 220

Austin, Texas 78757

Tel: (512) 794-8440
Fax: (512) 794-8742

Email: [email protected] MORE

Back to Top
Copyright 2023 Microassist. All Rights Reserved.
  • Privacy
  • Accessibility Statement
  • Site Map
  • Contact Us
International Association of Accessibility Professionals (IAAP) Member
Microassist on Facebook
Microassist on Twitter
Microassist on Linked In
Microassist on Youtube
  • Accessibility Services
    • Accessibility Audits
    • VPAT Assessment Services
    • Accessibility Remediation Services
    • Accessible Document Remediation Services Including PDF Remediation Services
    • Accessible Website and Application Development
    • Accessible Digital Learning
    • Compliance for Digital Learning
    • Accessibility Training
    • Accessibility in the News
    • VPAT Buyers Guide
  • Custom E-Learning
    • Accessible E-Learning
    • Managed Learning Services: Training Support for Business
    • Training Staffing Solutions
    • Learning Management Systems
    • Learning Translation and Localization
    • Examples of Our Work
    • The Learning Dispatch (Blog)
  • Classes
    • Course List
    • Course Schedule
    • Classroom Rental
    • Classes FAQ
  • Public Safety Solutions
    • Sex Offender State Registry (SOR) Solution
    • RTL Connect: Modernizing State Data Repositories, Licensing, and Registrations
  • About
    • Government Solutions
    • Newsletter Subscriptions
    • Career Opportunities
    • News and Media
    • Blogs
    • Team