Oracle SQL for beginners

• Computer literacy
• Knowledge of any operating system

Listeners

This training is addressed for people starting to work with the SQL language in Oracle database

The course answer for questions:

• How to build a query?
• What possibilities have SQL?
• What is a relational database?
• What is the structure and SQL commands

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