All Training Courses

Data and Office

SQL Querying: Fundamentals

Learn to retrieve the data you need from a relational database without relying on prebuilt reports.

1 Day · Live instructor-led training

What you will work on

  • Write SELECT queries
  • Filter and sort query results
  • Use functions and group data
  • Combine tables with joins

What the course covers

Explore the curriculum to see how it fits the work you want to do.

Lesson 1: Executing a Simple Query
  • Connect to the SQL Database
  • Query a Database
  • Save a Query
  • Modify and Execute a Saved Query
Lesson 2: Performing a Conditional Search
  • Search Using One or More Conditions
  • Search for a Range of Values and NULL Values
  • Search Data Based on String Patterns
Lesson 3: Working with Functions
  • Perform Date Calculations
  • Calculate Data Using Aggregate Functions
  • Manipulate String Values
Lesson 4: Organizing Data
  • Sort Data
  • Rank Data
  • Group Data
  • Filter Grouped Data
  • Summarize Grouped Data
  • Use PIVOT and UNPIVOT Operators
Lesson 5: Retrieving Data from Multiple Tables
  • Combine the Results of Two Queries
  • Compare the Results of Two Queries
  • Retrieve Data by Joining Tables
Lesson 6: Exporting Query Results
  • Generate a Text File
  • Generate an XML File

Who this course is for

Professionals who need a foundation in querying business data.

Before you attend

Basic computer skills and familiarity with database terminology.

Included with this course

  • Live instructor-led class
  • A preparation checklist for prerequisites, class access and setup
  • Altvina support for questions, concerns and next-step guidance

Ongoing mentorship is a separate paid service.

Support from Altvina

Have a question about course fit, learner details or access? Our team is your contact for enrollment support.

Ask a Course Question

Payments, refunds and class changes

Clear payment dates

Pay a $50 deposit per learner or full tuition. With your explicit agreement, the remaining balance is charged seven days before class. You receive an advance reminder.

Flexible before the cutoff

Class payments are refundable until seven days before the start. After that they are non-refundable; contact Altvina if an issue arises.

If the scheduled class changes

If Altvina or the training provider cancels or materially changes your class, you can choose a refund or an alternative date. We will contact you to arrange your choice.

Training instruction is delivered by Logical Operations or the provider listed for the class. Altvina handles enrollment and customer support.

SQL Querying: Fundamentals | Altvina Training | Altvina