The SQL (Structured Query Language) forms the basis for all work with Microsoft SQL Server.

Introduction to Querying Course:

Course Outline

• Introducing the SQL Server Management Studio
• Writing SELECT statements from a single table
  – Specifying columns
• Using the WHERE clause to filter rows
  – Comparisons
  – AND, OR and NOT operators
  – IN, BETWEEN and LIKE
  – Working with NULL
• Using the ORDER BY Clause
• Using multiple tables
  – Table aliases
  – INNER JOIN
  – OUTER JOIN
  – UNION
• Summarising data
  – GROUP BY
  – HAVING
• Working with functions
  – String functions
  – Date functions

Duration

• This course can be completed in 2 days just using examples from the sample Adventure Works Database.
• By extending it to 3 days, delegates can practice their skills using their own data