Course not currently available
SQL language in MSSQL Training Course
Course
In City Of London ()
£ 2,050
VAT inc.
Description
-
Type
Course
The course answers questions
How to build a query?
What opportunities have SQL?
What is a relational database?
What is the structure and SQL commands?
About this course
Computer literacy
Knowledge of any operating system
Reviews
Have you taken this course?
Subjects
- Database
- SQL
- Database training
Course programme
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
Additional information
14 hours (usually 2 days including breaks)
SQL language in MSSQL Training Course
£ 2,050
VAT inc.