SQL Querying Fundamentals - Part 1 (UT-SQL-QF1)


Course Description

In this course, students will compose SQL queries to retrieve desired information from a database.

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

Course Outline

1 - Executing a Simple Query

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

2 - 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

3 - Working with Functions

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

4 - Organizing Data

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

5 - 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

6 - Presenting Query Results

  • Save the Query Result
  • Generate an XML Report

 

There are no prerequisites for this course.

Course Information

Length: 1 day

Format: Lecture and Lab

Delivery Method: n/a

Max. Capacity: 16



Schedule

Contact Us

UPCOMING COURSES
Date
Geography & Location
Days
Cost
CLC
GTR
Mar 04, 2024 - 1 day(s)
Mar 04, 2024
AMER
Remote EST
AMER, Remote EST
1
$495 USD
$495 USD
Mar 13, 2024 - 1 day(s)
Mar 13, 2024
AMER
Remote EST
AMER, Remote EST
1
$495 USD
$495 USD
Mar 21, 2024 - 1 day(s)
Mar 21, 2024
AMER
Remote EST
AMER, Remote EST
1
$495 USD
$495 USD
Apr 01, 2024 - 1 day(s)
Apr 01, 2024
AMER
Remote-EST
AMER, Remote-EST
1
$495 USD
$495 USD
Apr 05, 2024 - 1 day(s)
Apr 05, 2024
AMER
Remote-EST
AMER, Remote-EST
1
$495 USD
$495 USD
Apr 16, 2024 - 1 day(s)
Apr 16, 2024
AMER
Remote-EST
AMER, Remote-EST
1
$495 USD
$495 USD
Apr 22, 2024 - 1 day(s)
Apr 22, 2024
AMER
Remote-EST
AMER, Remote-EST
1
$495 USD
$495 USD
Apr 29, 2024 - 1 day(s)
Apr 29, 2024
AMER
Remote-EST
AMER, Remote-EST
1
$495 USD
$495 USD
May 10, 2024 - 1 day(s)
May 10, 2024
AMER
Remote EST
AMER, Remote EST
1
$495 USD
$495 USD
May 23, 2024 - 1 day(s)
May 23, 2024
AMER
Remote EST
AMER, Remote EST
1
$495 USD
$495 USD
Jun 05, 2024 - 1 day(s)
Jun 05, 2024
AMER
Remote EST
AMER, Remote EST
1
$495 USD
$495 USD
Jun 13, 2024 - 1 day(s)
Jun 13, 2024
AMER
Remote EST
AMER, Remote EST
1
$495 USD
$495 USD
Jun 24, 2024 - 1 day(s)
Jun 24, 2024
AMER
Remote EST
AMER, Remote EST
1
$495 USD
$495 USD

Do you have more questions? We're delighted to assist you!

1-877-797-2799
info@firefly.cloud

Who Should Attend

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