Course not currently available

Oracle SQL for beginners Training Course

Course

Online

£ 2,650 VAT inc.

Description

  • Type

    Course

  • Methodology

    Online

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

About this course

Computer literacy
Knowledge of any operating system

Questions & Answers

Add your question

Our advisors and other users will be able to reply to you

Fill in your details to get a reply

We will only publish your name and question

Reviews

Subjects

  • Transactions
  • Database
  • SQL
  • Database training
  • Primary
  • Syntax
  • Writing
  • Oracle SQL
  • IT
  • It skills

Course programme

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

Additional information

21 hours (usually 3 days including breaks)

Oracle SQL for beginners Training Course

£ 2,650 VAT inc.