Thank you for sending your enquiry! One of our team members will contact you shortly.
Thank you for sending your booking! One of our team members will contact you shortly.
コース概要
Selecting data from database
- Syntax rules
- Selecting all columns
- Projection
- Arithmetical operations in SQL
- Columns aliases
- Literals
- Concatenation
Filtering outcome tables
- WHERE clause
- Comparison operators
- Condition LIKE
- Condition BETWEEN...AND
- Condition IS NULL
- Condition IN
- AND, OR, NOT operators
- Several conditions in WHERE clause
- Operators order
- DISTINCT clause
Sorting outcome tables
- ORDER BY clause
- Sort by multiple columns or expressions
SQL Functions
- Differences between single-row and multi-row functions
- Character, numeric, DateTime functions
- Explicit and implicit conversion
- Conversion functions
- Nested functions
- Dual table (Oracle vs other databases)
- Getting current date and time with different functions
Aggregate data using aggregate functions
- Aggregate functions
- Aggregate functions vs NULL value
- GROUP BY clause
- Grouping using different columns
- Filtering aggregated data - HAVING clause
- Multidimensional Data Grouping - ROLLUP and CUBE operators
- Identifying summaries - GROUPING
- GROUPING SETS operator
Retrieving data from multiple tables
- Different types of joints
- NATURAL JOIN
- Table aliases
- Oracle syntax - join conditions in WHERE clause
- SQL99 syntax - INNER JOIN
- SQL99 syntax - LEFT, RIGHT, FULL OUTER JOINS
- Cartesian product - Oracle and SQL99 syntax
subqueries
- When and where subquery can be done
- Single-row and multi-row subqueries
- Single-row subquery operators
- Aggregate functions in subqueries
- Multi-row subquery operators - IN, ALL, ANY
Set operators
- UNION
- UNION ALL
- INTERSECT
- MINUS/EXCEPT
Transactions
- COMMIT, ROLLBACK SAVEPOINT statements
Other schema objects
- Sequences
- Synonyms
- Views
Hierarchical queries and samples
- Tree construction (CONNECT BY PRIOR and START WITH clauses)
- SYS_CONNECT_BY_PATH function
Conditional expressions
- CASE expression
- DECODE expression
Data management in different time zones
- Time zones
- TIMESTAMP data types
- Differences between DATE and TIMESTAMP
- Conversion operations
Analytic functions
- Use of
- Partitions
- Windows
- Rank functions
- Reporting functions
- LAG/LEAD functions
- FIRST/LAST functions
- Reverse percentile functions
- hypothetical rank functions
- WIDTH_BUCKET functions
- Statistical functions
要求
There are no specific requirements needed to attend this course.
21 時間
お客様の声 (5)
とてもよく組織されていました
Ana - DB Global Technology SRL
コース - SQL Advanced level for Analysts
Machine Translated
トレーナーのスキルとコースの構造
Marius - DB Global Technology SRL
コース - SQL Advanced level for Analysts
Machine Translated
非常によく構成されており、テンポが良く、貴重な情報が難易度を上げながら複数のレイヤーで紹介されています。
Andrei ranac - DB Global Technology SRL
コース - SQL Advanced level for Analysts
Machine Translated
トピックに関する広範なディスカッション
Marcin - DPDgroup IT Solutions sp. z o.o.
Machine Translated
論理的思考の幅を広げることができ、頭の体操として非常に効果的でした。たくさんのことを学べたので、仕事の練習に向けてさらに準備が整いました。
Kaja - DPDgroup IT Solutions sp. z o.o.
コース - SQL Advanced level for Analysts
Machine Translated