SQL Fundamentals

Outline:

• Unit 1: Introducing SQL
  • Topic A: Understanding Microsoft SQL
    • A-1: Discussing client/server architecture
    • A-2: Organizing data in SQL
  • Topic B: Exploring Microsoft SQL
    • B-1: Starting the SQL Server Query Analyzer
    • B-2: Examining the Query Analyzer

• Unit 2: Retrieving data from a table
  • Topic A: Selecting rows
    • A-1: Selecting all rows and columns
    • A-2: Selecting specific columns
    • A-3: Changing column headings
    • A-4: Selecting specific rows
    • A-5: Selecting rows in a specific order
    • A-6: Selecting rows with NULL values
    • A-7: Selecting rows with unique values
  • Topic B: Summarizing data
    • B-1: Using the GROUP BY clause
    • B-2: Using the COMPUTE clause
    • B-3: Using the COMPUTE BY clause

• Unit 3: Using operators
  • Topic A: Using logical operators
    • A-1: Using the AND operator
    • A-2: Using the OR operator
    • A-3: Using the NOT operator
  • Topic B: Using list operators
    • B-1: Using the IN operator
    • B-2: Using the NOT IN operator
  • Topic C: Using string operators
    • C-1: Using the LIKE operator
    • C-2: Using operators in conjugation

• Unit 4: Using functions
  • Topic A: Using string functions
    • A-1: Using the UPPER() function
    • A-2: Using the SUBSTRING() function
  • Topic B: Using date functions
    • B-1: Using the GETDATE() function
    • B-2: Using the DATEDIFF()function
    • B-3: Using the DATEADD()function
    • B-4: Using the DATENAME() function

• Unit 5: Using joins
  • Topic A: Joining tables
    • A-1: Using an equi-join
    • A-2: Using the natural join
  • Topic B: Using advanced joins
    • B-1: Using the left outer join
    • B-2: Using the self join

• Unit 6: Using subqueries
  • Topic A: Using subqueries
    • A-1: Using a subquery to return single value
    • A-2: Using a subquery to return multiple values
    • A-3: Using a correlated subquery

--------------

Please note that the material taught at some locations may differ slightly from the outline shown above. Please contact your local ExecuTrain office if you have any questions about specific course content.