Skip to Content
Home └SQL for PTC Windchill
SQL for PTC Windchill

SQL for PTC Windchill

Our Free Fully-Comprehensive PLM Data Analytics Introductory Course
Join this Course
Responsible Thomas Franklin
Last Update 16/04/2025
Completion Time 2 hours 55 minutes
Members 1
Basic
  • Course Introduction
    8Lessons · 40 mins
    • Course Overview
      Preview
    • Topic Introduction
    • Database Components
    • Database System Structure
    • Database Client Tools
    • Understanding SQL Commands
    • Useful Terms and Definitions
    • Understanding SQL Commands Quiz
      10 xp
  • SQL Basics
    4Lessons · 30 mins
    • MSSQL: Writing and executing your first query
    • ORACLE: Writing and executing your first query
    • SQL Syntax
    • SQL Basics Quiz
      10 xp
  • Writing Select Statements
    7Lessons · 37 mins
    • 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
      10 xp
  • Filtering data with WHERE
    9Lessons · 50 mins
    • 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
      10 xp
  • Logical Operators
    6Lessons · 16 mins
    • Introduction to Logical Operators
    • Logical Operator: AND
    • Logical Operator: OR
    • Grouping Logical Operations using Parentheses
    • Comparative Operators: IN / NOT IN
    • Logical Operators Quiz
      10 xp
  • Aggregation, Grouping and Sorting Data
    2Lessons · 2 mins
    • Introduction to Aggregation, Grouping and Sorting Data
    • Limiting Query Results