Fundamentals of SQL Querying

Master the essential skills of SQL querying to unlock robust data insights, perfect for database managers and IT professionals seeking to enhance their data analysis capabilities.

Course Category Icon

Essential Skills Gained

Checkmark

Connect to SQL Server and execute queries.

Checkmark

Perform complex data retrieval using functions and conditions.

Checkmark

Organize and present data efficiently.

Checkmark

Generate reports and save query outcomes.

Format

  • Instructor-led
  • 2 days with lectures and hands-on labs.

Audience

  • Database Administrators
  • Data Analysts
  • Report Developers
  • IT Support Specialists

Description

In Fundamentals of SQL Querying, students will compose SQL queries to retrieve desired information from a database.

Calendar icon

Upcoming Course Dates

No upcoming dates. Please check back later.

Course Outline

Download PDF

Lesson 1: Executing a Simple Query

  1. Connect to the SQL Database

  2. Query a Database

  3. Save a Query

  4. Modify a Query

  5. Execute a Saved Query

Lesson 2: Performing a Conditional Search

  1. Search Using a Simple Condition

  2. Compare Column Values

  3. Search Using Multiple Conditions

  4. Search for a Range of Values and Null Values

  5. Retrieve Data Based on Patterns

Lesson 3: Working with Functions

  1. Perform Date Calculations

  2. Calculate Data Using Aggregate Functions

  3. Manipulate String Values

Lesson 4: 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

Lesson 5: Retrieving Data from Tables

  1. Combine Results of Two Queries

  2. Compare the Results of Two Queries

  3. Retrieve Data by Joining Tables

  4. Check for Unmatched Records

  5. Retrieve Information from a Single Table Using Joins

Lesson 6: Presenting Query Results

  1. Save the Query Result

  2. Generate an XML Report

Appendix A: The OGCBooks Database

Your Team has Unique Training Needs.

Your team deserves training as unique as they are.

Let us tailor the course to your needs at no extra cost.