BLOG
CATALOG
Menu
Businessman discussing budget report at the meeting with a computer and statements - Conquering the Grammar Game
a stack of orange and white books with text overlay of different training topics related to the professional workforce.
Browse hundreds of training topics to elevate team performance.
a laptop and phone with course training text on the screen.

Learn about PTR’s interactive course workbook for different learning styles.

Professional African-American woman training instructor smiling with overlay text.

PTR instructors are experts at delivering engaging, professional training.

SQL Querying: Fundamentals Training Course

Formats ⟩  Live Virtual: 4 hrs./1 Day  |  In-Person: 6 hrs./1 Day

The ability to write SQL is an essential job skill for those who need to manage large volumes of data, produce reports, mine data, or combine data from multiple sources. Even if someone else on your team creates reports for you, having a fundamental understanding of SQL querying will help you ask the right questions and know what you're looking for in your data analysis tools.

Recommended Follow-Up: SQL Querying: Advanced

Learning Objectives »

  • Connect to the database and execute a query
  • Include a search condition in a simple query
  • Use various functions to perform calculations
  • Organize the data obtained from a query before it is
    displayed onscreen
  • Retrieve data from multiple tables
  • Export the results of a query

Course Agenda

Executing a Simple Query

  1. Connect to the SQL Database
  2. Query a Database
  3. Save a Query
  4. Modify and Execute a Saved Query

Performing a Conditional Search

  1. Search Using One or More Conditions
  2. Range of Values and NULL Values
  3. Search Data Based on String Patterns

Working with Functions

  1. Perform Date Calculations
  2. Calculate Data Using Aggregate Functions
  3. Manipulate String Values

Organizing Data

  1. Sort Data
  2. Rank Data
  3. Group Data
  4. Filter Grouped Data
  5. Summarize Grouped Data
  6. Use PIVOT and UNPIVOT Operators

Retrieving Data from Multiple Tables

  1. Combine the Results of Two Queries
  2. Compare the Results of Two Queries
  3. Retrieve Data by Joining Tables

Exporting Query Results

  1. Generate a Text File
  2. Generate an XML File
Businessman discussing budget report at the meeting with a computer and statements - Conquering the Grammar Game

SQL Querying: Fundamentals Training Course

Formats ⟩  Live Virtual: 4 hrs./1 Day  |  In-Person: 6 hrs./1 Day

The ability to write SQL is an essential job skill for those who need to manage large volumes of data, produce reports, mine data, or combine data from multiple sources. Even if someone else on your team creates reports for you, having a fundamental understanding of SQL querying will help you ask the right questions and know what you're looking for in your data analysis tools.

Recommended Follow-Up: SQL Querying: Advanced

Learning Objectives »

  • Connect to the database and execute a query
  • Include a search condition in a simple query
  • Use various functions to perform calculations
  • Organize the data obtained from a query before it is
    displayed onscreen
  • Retrieve data from multiple tables
  • Export the results of a query

Course Agenda

Executing a Simple Query

  1. Connect to the SQL Database
  2. Query a Database
  3. Save a Query
  4. Modify and Execute a Saved Query

Performing a Conditional Search

  1. Search Using One or More Conditions
  2. Range of Values and NULL Values
  3. Search Data Based on String Patterns

Working with Functions

  1. Perform Date Calculations
  2. Calculate Data Using Aggregate Functions
  3. Manipulate String Values

Organizing Data

  1. Sort Data
  2. Rank Data
  3. Group Data
  4. Filter Grouped Data
  5. Summarize Grouped Data
  6. Use PIVOT and UNPIVOT Operators

Retrieving Data from Multiple Tables

  1. Combine the Results of Two Queries
  2. Compare the Results of Two Queries
  3. Retrieve Data by Joining Tables

Exporting Query Results

  1. Generate a Text File
  2. Generate an XML File
PTR Training uses 'cookies' to improve your website experience. View our Privacy Policy for details. By continuing, you agree to accept and adhere to our Terms of Use.