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.
コース概要
Relational database models
- The structure of a relational database
- Connection types of tables
- The normalization and denormalization 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 operator
Limiting results
- The WHERE clause
- Comparison operators
- LIKE Condition
- Prerequisite BETWEEN ... AND
- IS NULL condition
- Condition IN
- Boolean operators AND, OR and NOT
- Many of the conditions in the WHERE clause
- The order of the operators.
- DISTINCT clause
Sorting Data
- The ORDER BY clause
- Sorting by multiple columns or expressions
SQL functions
- The differences between the functions of one and multilines
- Features text, numeric, date,
- Explicit and implicit conversion
- Conversion functions
- Nesting functions
- Viewing the performance of the functions - dual table
- Getting the current date function SYSDATE
- Handling of NULL values
Aggregating data using the grouping
- Grouping functions
- How grouping functions treat NULL values
- Create groups of data - the GROUP BY clause
- Grouping multiple columns
- Limiting the function result grouping - the HAVING clause
Retrieving data from multiple tables
- Types of connectors
- The use NATURAL JOIN
- Aliases tables
- Joins in the WHERE clause
- INNER JOIN Inner join
- External Merge LEFT, RIGHT, FULL OUTER JOIN
- Cartesian product
Subqueries
- Place subqueries in the SELECT command
- Subqueries single and multi-lineage
- Operators Subqueries single-line
- Features grouping in subquery
- Operators Subqueries multi-IN, ALL, ANY
- How NULL values are treated in subqueries
Operators collective
- UNION operator
- UNION ALL operator
- INTERSECT operator
- MINUS operator
Insert, update, and delete data
- INSERT command
- Copy data from another table
- UPDATE command
- DELETE command
- TRUNCATE command
Transactions
- Commands COMMIT, ROLLBACK, and SAVEPOINT
DDL commands
- The main database objects
- Rules for naming objects
- Creating tables
- The data types available for columns
- DEFAULT option
- Option NULL and NOT NULL
Managing tables
- Referential integrity CHECK, PRIMARY KEY, FOREIGN KEY, UNIQUE
- Create a table by the query
- Delete a table DROP TABLE
- DESCRIBE command
Other schema objects
- Sequences
- Synonyms
- Views
要求
- Computer literacy
- Knowledge of any operating system
21 時間
お客様の声 (6)
it was structured very well both by days and by modules, easy to follow
Melania - DB Global Technology SRL
コース - Oracle SQL for beginners
トレーナーがトピックに関する情報を説明する方法と、レッスンが非常に実践的で論理的であるため、細部にまで注意を払っていたという事実が気に入りました。
Andreea
コース - Oracle SQL for beginners
Machine Translated
トレーナーは各章にさらに多くの例を示します
Corina
コース - Oracle SQL for beginners
Machine Translated
インタラクティブな演習
BOANGIU GIORGIANA
コース - Oracle SQL for beginners
Machine Translated
説明
Daniela
コース - Oracle SQL for beginners
Machine Translated
the exercises
