SQL language in MSSQL

Relational database models

• The structure of a relational database
• Relational operators

• Rules for writing SQL queries
• The syntax for the SELECT
• Selecting all columns
• Inquiries from arithmetic operations
• Aliases columns
• Literals
• Concatenation

• The WHERE clause
• The comparison operators.
• LIKE Condition
• Prerequisite BETWEEN ... AND
• IS NULL condition
• IN condition.
• Logical operators
• Many of the conditions in the WHERE clause
• The order of operators
• DISTINCT clause

• The ORDER BY clause
• Sorting by multiple columns or expressions

• The differences between the functions of single and multi-rows
• Functions text, numeric, date,
• Conversion functions
• Nesting functions
• Handling of NULL values

• Grouping functions
• How grouping functions treat NULL values
• Create groups of data - the GROUP BY clause
• Grouping multiple columns
• Reducing the function result grouping - the HAVING clause

• Types of joins
• Aliases tables
• Joins in the WHERE clause
• INNER JOIN Inner join
• External Merge LEFT, RIGHT
• Cartesian product

• Place subqueries in the SELECT command
• Subqueries single and multi-lineage
• Operators Subqueries single-line
• Operators Subqueries multi-IN, ALL, ANY

• UNION operator
• INTERSECT operator
• EXCEPT operator

• INSERT command
• UPDATE command
• DELETE command