Duration
14 hours (usually 2 days including breaks)
Requirements
- Computer literacy
- Knowledge of any operating system
Overview
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?
Course Outline
Relational database models
- The structure of a relational database
- Relational operators
Download the data
- Rules for writing SQL queries
- The syntax for the SELECT
- Selecting all columns
- Inquiries from arithmetic operations
- Aliases columns
- Literals
- Concatenation
Restrict results
- 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
Sorting Data
- The ORDER BY clause
- Sorting by multiple columns or expressions
SQL Functions
- The differences between the functions of single and multi-rows
- Functions text, numeric, date,
- Conversion functions
- Nesting functions
- Handling of NULL values
Aggregating data using the grouping function
- 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
Retrieving data from multiple tables
- Types of joins
- Aliases tables
- Joins in the WHERE clause
- INNER JOIN Inner join
- External Merge LEFT, RIGHT
- Cartesian product
Subqueries
- Place subqueries in the SELECT command
- Subqueries single and multi-lineage
- Operators Subqueries single-line
- Operators Subqueries multi-IN, ALL, ANY
Collective operators
- UNION operator
- INTERSECT operator
- EXCEPT operator
Insert, update, and delete data
- INSERT command
- UPDATE command
- DELETE command