Skip to Content
Lessons
Share Exit Fullscreen Back to course
SQL for PTC Windchill
    • Course Overview
    • Topic Introduction
    • Database Components
    • Database System Structure
    • Database Client Tools
    • Understanding SQL Commands
    • Useful Terms and Definitions
    • Understanding SQL Commands Quiz
    • MSSQL: Writing and executing your first query
    • ORACLE: Writing and executing your first query
    • SQL Syntax
    • SQL Basics Quiz
    • Retrieving all columns from a table
    • Retrieve specific columns from a table
    • Table Name Alias
    • Column Name Alias
    • Remove duplicate results using DISTINCT
    • Writing and using comments in SQL
    • Writing SELECT statements Quiz
    • Introduction to Filtering
    • Comparative Operator: EQUALS =
    • Comparative Operator: NOT EQUALS != <>
    • Comparative Operators: GREATER (>) LESS (<) THAN
    • Comparative Operator: LIKE
    • Comparative Operator: NOT LIKE
    • Comparative Operator: IS NULL
    • Comparative Operator: IS NOT NULL
    • Filtering data with WHERE Quiz
    • Introduction to Logical Operators
    • Logical Operator: AND
    • Logical Operator: OR
    • Grouping Logical Operations using Parentheses
    • Comparative Operators: IN / NOT IN
    • Logical Operators Quiz
    • Introduction to Aggregation, Grouping and Sorting Data
    • Limiting Query Results