Oracle SQL | Ingress Academy
Для частных лиц Для бизнеса Работа и найм
Карьерные пути Курсы Почему мы Преподаватели Блог
az en ru
Портал

Этот материал пока недоступен на языке Русский — показан на другом доступном языке. Доступно на: AZ, EN

Database Management

Oracle SQL

Learn advanced SQL querying techniques and optimization strategies for Oracle databases. Topics include complex joins, subqueries, indexing, and performance tuning. This course is vital for database developers and administrators. Our trainers with real-world experience provide hands-on lab sessions.

Средний Очно 12 недель 48 часов

О курсе

Learn advanced SQL querying techniques and optimization strategies for Oracle databases. Topics include complex joins, subqueries, indexing, and performance tuning. This course is vital for database developers and administrators. Our trainers with real-world experience provide hands-on lab sessions.

Преимущества

🧑‍🏫

Practical teaching

In addition to class hours, you will practice the topics covered with your instructor and mentor dur

🤝

Mentors

The knowledge and skills you learn at the academy will be further strengthened with the mentor syste

📋

Academic transcript

Assignments and projects are checked by the instructor, and your knowledge and skills are determined

Программа обучения

Скачать программу
  1. 1 Definition of RDBMS
  2. 2 What is SQL?
  3. 3 What we can do with SQL?
  4. 4 Advantages of SQL
  5. 5 Basic Select statements (Introduction to SQL)
  1. 1 Defining column alias
  2. 2 Arithmetic expressions
  3. 3 Selection all columns, specific columns
  4. 4 Concatenation operator
  5. 5 Duplicate and distinct rows
  1. 1 BETWEEN condition
  2. 2 AND, OR, NOT operators
  3. 3 LIKE condition
  4. 4 ORDER BY clause for sorting columns
  5. 5 Using WHERE clause
  1. 1 General functions
  2. 2 Number functions
  3. 3 Character functions
  4. 4 Type conversion
  5. 5 Date functions
  6. 6 Nesting functions
  1. 1 What is equijoin and non-equijoin
  2. 2 OUTER, SELF joins and others
  3. 3 Types of joins - INNER, LEFT and RIGHT
  1. 1 AVG, SUM, MIN, MAX, COUNT functions and etc.
  2. 2 What are group functions
  3. 3 GROUP BY clause, HAVING clause
  1. 1 Single-row and multiple-row subqueries
  2. 2 Subquery syntax
  3. 3 Using ANY and ALL operator
  4. 4 Types of subqueries
  1. 1 INSERT, UPDATE, DELETE, MERGE
  2. 2 COMMIT and ROLLBACK
  1. 1 MINUS
  2. 2 UNION
  3. 3 INTERSECT
  4. 4 UNION ALL
  1. 1 TRUNCATE table
  2. 2 DROP TABLE statements and others
  3. 3 CREATE TABLE statement
  4. 4 ALTER TABLE statement
  1. 1 FOREIGN KEY
  2. 2 DEFAULT
  3. 3 PRIMARY KEY
  4. 4 NOT NULL
  5. 5 Primary and Foreign Key
  6. 6 Table Constraints
  7. 7 CHECK
  8. 8 UNIQUE
  9. 9 CREATE INDEX
  1. 1 What is View?
  2. 2 Creating view
  3. 3 Updating and dropping view
  1. 1 What are SQL Sequences
  2. 2 How sequences work

Преподаватели

Saida Kerimli

Saida Kerimli

PL/SQL Developer

Yelo Bank