Basics of Writing Queries in T-SQL Language on Microsoft SQL Server Platform

What we teach you

• Write SELECT queries to retrieve data
• Group and summarize data by
• Join data from multiple tables
• Write queries that retrieve and modify data by using subqueries

Required skills

Basic knowledge of relational databases }tables, relations, etc.)

Course Outline

Introduction to T-SQL

• Basic terminology (DCL, DDl, DML, comments, variables, loops, conditions)
• Data types
• Operators (logical, arithmetical, concatenation)
• System functions (GETDATE, CHARINDX, ISNULL)
• Management Studio

Basics of the SELECT statement

• Selecting data with SELECT, WHERE, FROM
• Columns, constants, expressions
• Conditions and operators

Join tables

• Why and how join tables together
• INNER JOIN
• LEFT, RIGHT, FULL OUTER JOIN
• CROSS JOIN
• UNION

Aggregation in queries

• Aggregation functions
• GROUP BY
• HAVING
• Duplicity testing
• Ranking functions (ROW_NUMBER, NTILE, RANK, DENSE_RANK)

Subqueries

• Subquery in SELECT
• Subquery in FROM
• Subquery in WHERE