SQL Querying Fundamentals - Part 1

Course Overview

Module 1: Executing Basic SQL Statements

• Connect to a SQL Server database
• Create, modify, and execute queries
• Save and reopen query files

Module 2: Filtering with Conditional Logic

• Limit results using comparison operators
• Combine multiple conditions
• Search for ranges, NULL values, and patterns

Module 3: Using Built-In SQL Functions

• Perform date and time calculations
• Manipulate strings and text fields
• Calculate summaries with aggregate functions

Module 4: Structuring and Summarizing Output

• Sort results and apply custom rankings
• Group data and filter grouped rows
• Pivot and unpivot results for advanced formatting

Module 5: Working Across Tables

• Merge data with inner and outer joins
• Identify records without matches
• Compare and combine multiple result sets

Module 6: Exporting Results and Creating Reports

• Format and save query results
• Generate basic XML output
• Review common reporting use cases

Prerequisites

Basic computer literacy

Basic PC operating system navigation skills

Basic Internet usage skills

Course Comments

This course is the starting point for those who are new to SQL or a good refresher for those who have some knowledge but would like to fine tune their skills.

The SQL information is ANSI standards and can be applied to any RDBMS, including DB2, Oracle, SQL/Server, Sybase, etc.

You may also be interested in our Microsoft Querying Class:  Writing Analytical Queries for Business Intelligence- Course 55232