Do you need a personalized offer for your team? Contact us at academy@esolutions.ro or call 0753.029.187

Oracle SQL

oracle sql
COURSE FEATURES
Course Duration
Duration
5 Days
Skill Level
Skill level
All levels info Course tailored to participants' expertise.
Course Language
Language
RO / EN
Course Type
Type
In-class / Online-live
Assesments
Assessments
Yes
Price for Custom Training
Custom Training
1750 Eur / Day
Price for Open Class Course
Open Class
750 Eur / Participant

Oracle SQL provides an easy, elegant, performant architecture for accessing, defining, and maintaining data.

SQL is most useful in data-focused careers, but it's also valuable for Web Developers and Software Engineers. 

In combination with other programming languages like Python, SQL can help you launch your career as a developer or data specialist. 

This course is taught in Romanian, with course materials available in either English, or Romanian. The course can be customized - on request.

 

DAY
1

TOPICS

9

TOPICS
9
Brief Recap
Clause WHERE
Limiting results: rownum
NULL
ORDER BY (Variants, NULL handling)
UNION, INTERSECT, MINUS
OUTER JOINS
Cartesian Product
Subqueries, WITH
DAY
2

TOPICS

5

TOPICS
5
Semi-joins
GROUP BY, HAVING
Eliminate duplicate
GROUP BY (Advanced Notions – ROLLUP, CUBE)
JOIN + GROUP BY
DAY
3

TOPICS

7

TOPICS
7
Analytical Functions
Tree processing, hierarchical queries: CONNECT BY PRIOR
Rotation
INSERT
UPDATE
DELETE
MERGE
DAY
4

TOPICS

4

TOPICS
4
Transactions
Indexes: advanced notions
The execution plan of a query
HINTS
DAY
5

TOPICS

5

TOPICS
5
CREATE TABLE
Working with system tables, metadata
VIEWS
PL/SQL blocks: basic notions
Triggers, procedures, functions, packages: basic notions

Contact Us

Feel free to leave us your thoughts so we can discover the solution together!

EMAIL

academy@esolutions.ro

Get in touch

0753.029.187

Our address

20 Constantin Budisteanu Street , 1 st. District, Bucharest

By clicking on "Send" button above, you agree with our terms of use.

EMAIL

academy@esolutions.ro

Get in touch

0753.029.187

Our address

20 Constantin Budisteanu Street , 1 st. District, Bucharest

Related Courses

Data Warehousing
Database

From data modeling and processing to performance and optimization, this course covers advanced data warehousing concepts.

DURATION
2 Days
Data warehousing
Database

From data modeling and processing to performance and optimization, this course covers fundamental data warehousing concepts.

DURATION
3 Days
Nosql
Database

This introductory course provides basic knowledge of the distributed data storage layer in big data architectures and NoSQL concepts.

DURATION
3 Days
MongoDb
Database

This introductory course provides the foundational skills needed to work with MongoDB and other important concepts, such as aggregation, indexing, data modeling, and transactions.

DURATION
5 Days
+ View all courses
dividerLeft

Do you want to become a trainer?

Ask not what your company can do for you, ask what you can do for your company. Apply for a training position.

Apply Now