An Introduction to SQL

Time & Location

Contact us to Schedule Courses
Virtual Instructor Led Hands on Courses

About the Course

Many organizations use databases to store their most critical information: the information that manages their day-to-day operations. After the data is stored in databases, however, it is useless unless you can retrieve it for further business analysis. This course, SQL Querying: Fundamentals, will teach you to use SQL as a tool to retrieve the information you need from databases.

COURSE CONTENT

Executing a Simple Query

• Connect to the SQL Database

• Query a Database

• Save a Query

• Modify and Execute a Saved Query

Performing a Conditional Search

• Search Using One or More Conditions

• Search for a Range of Values and NULL Values

• Search 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 Multiple Tables

• Combine the Results of Two Queries

• Compare the Results of Two Queries

• Retrieve Data by Joining Tables

Exporting Query Results

• Generate a Text File

• Generate an XML File

Register
Price
Quantity
Total
  • 4 or more Course Participants
    $299
    +$38.87 HST
    $299
    +$38.87 HST
    0
    $0
  • 2 - 3 Course Participants
    $399
    +$51.87 HST
    $399
    +$51.87 HST
    0
    $0
  • Course Calendar Date Pricing
    $299
    +$38.87 HST
    $299
    +$38.87 HST
    0
    $0
  • 1 on 1 Training
    $499
    +$64.87 HST
    $499
    +$64.87 HST
    0
    $0
Total$0

Share This Event