Remote Course for Oracle Database 12c: Introduction to SQL Ed 2 | Certificated Course

Monday - Friday 9:00 AM - 10:00 PM CET
Call us now +44 7487633466
Keep in touch info@semosedu.com

EN / МК / RS

EN / МК / RS

Reserve a seat

reserve a seat

Description
Content
Target Audience
Benefits
Certificates

This Oracle Database: Introduction to SQL training helps you write subqueries, combine multiple queries into a single query using SET operators and report aggregated data using group functions. Learn this and more through hands-on exercises.

MODULE 1

Introduction

MODULE 2

Working with Oracle Cloud Exadata Express Cloud Service

MODULE 3

Retrieving Data using the SQL SELECT Statement

MODULE 4

Restricting and Sorting Data

MODULE 5

Using Single-Row Functions to Customize Output

MODULE 6

Using Conversion Functions and Conditional Expressions

MODULE 7

Reporting Aggregated Data Using the Group Functions

MODULE 8

Displaying Data from Multiple Tables Using Joins

MODULE 9

Using Subqueries to Solve Queries

MODULE 10

Using the SET Operators

MODULE 11

Managing Tables using DML statements

MODULE 12

Introduction to Data Definition Language

MODULE 13

Introduction to Data Dictionary Views

MODULE 14

Creating Sequences, Synonyms, Indexes

MODULE 15

Creating Views

MODULE 16

Managing Schema Objects

MODULE 17

Retrieving Data by Using Subqueries

MODULE 18

Manipulating Data by Using Subqueries

MODULE 19

Controlling User Access

MODULE 20

Manipulating Data

MODULE 21

Managing Data in Different Time Zones

Administrator
Architect
Database Administrator

Benefits to You:

Ensure fast, reliable, secure and easy to manage performance.
Optimize database workloads, lower IT costs and deliver a higher quality of service by enabling consolidation onto database clouds.
Learn Advanced Features of SQLThis course will help you understand the advanced features of SQL.
Learning these features will help you query and manipulate data within the database, use the dictionary views to retrieve metadata and create reports about their schema objects.
Some of the date-time functions available in the Oracle Database are also covered.

Learn To:

Understand the basic concepts of relational databases ensure refined code by developers.
Create reports of sorted and restricted data.Run data manipulation statements (DML).
Control database access to specific objects.
Manage schema objects.
Manage objects with data dictionary views.Retrieve row and column data from tables.
Control privileges at the object and system level.
Create indexes and constraints; alter existing schema objects.
Create and query external tables.

Course attendance certificate issued by Semos Education

Description

This Oracle Database: Introduction to SQL training helps you write subqueries, combine multiple queries into a single query using SET operators and report aggregated data using group functions. Learn this and more through hands-on exercises.

Content

MODULE 1

Introduction

MODULE 2

Working with Oracle Cloud Exadata Express Cloud Service

MODULE 3

Retrieving Data using the SQL SELECT Statement

MODULE 4

Restricting and Sorting Data

MODULE 5

Using Single-Row Functions to Customize Output

MODULE 6

Using Conversion Functions and Conditional Expressions

MODULE 7

Reporting Aggregated Data Using the Group Functions

MODULE 8

Displaying Data from Multiple Tables Using Joins

MODULE 9

Using Subqueries to Solve Queries

MODULE 10

Using the SET Operators

MODULE 11

Managing Tables using DML statements

MODULE 12

Introduction to Data Definition Language

MODULE 13

Introduction to Data Dictionary Views

MODULE 14

Creating Sequences, Synonyms, Indexes

MODULE 15

Creating Views

MODULE 16

Managing Schema Objects

MODULE 17

Retrieving Data by Using Subqueries

MODULE 18

Manipulating Data by Using Subqueries

MODULE 19

Controlling User Access

MODULE 20

Manipulating Data

MODULE 21

Managing Data in Different Time Zones

Target Audience

Administrator
Architect
Database Administrator

Benefits

Benefits to You:

Ensure fast, reliable, secure and easy to manage performance.
Optimize database workloads, lower IT costs and deliver a higher quality of service by enabling consolidation onto database clouds.
Learn Advanced Features of SQLThis course will help you understand the advanced features of SQL.
Learning these features will help you query and manipulate data within the database, use the dictionary views to retrieve metadata and create reports about their schema objects.
Some of the date-time functions available in the Oracle Database are also covered.

Learn To:

Understand the basic concepts of relational databases ensure refined code by developers.
Create reports of sorted and restricted data.Run data manipulation statements (DML).
Control database access to specific objects.
Manage schema objects.
Manage objects with data dictionary views.Retrieve row and column data from tables.
Control privileges at the object and system level.
Create indexes and constraints; alter existing schema objects.
Create and query external tables.

Certificates

Course attendance certificate issued by Semos Education

Our students for us:

- Marko Krstevski Microsoft .NET Academy

Seeking to expand my knowledge, I decided to enroll in Semos Education, where I am gaining the necessary knowledge and experience.
- Teodor Markovski Student

The desire to become a Cloud architect led me to Semos Education. I am thrilled by the positive experiences of former students and the way in which the instructors and Career Center take care of the students.
- Viktorija Georgieva Summer Mentorship Program for Python Develope

The reputation of Semos Education for quality training and the opportunity to learn from experienced instructors played an additional significant role in my decision.
- Borche Peltekovski Accredited Academy for Graphic Design

After completing my studies at Semos Education, I envision myself working in a technology company, such as Samsung, Apple, or a company of similar caliber.
- Vasilija Uzunova Oracle Certified Instructor

For me, there was no other choice but Semos Education. I want to be part of the best, I want to share my knowledge in a company that is global, and ours.

Meet the instructors

Biljana Barukchieva
Senior project manager

@Quinshift

20+ years of experience

Contact

Course info

Classes

40

Delivery method

Online

Language

English

Price

€1.210 EUR

Payment method Request a callback

Course Application

Oracle Database 12c: Introduction to SQL Ed 2

Your Details

First Name * Last Name * E-mail * Phone * Country * City *

Who is the payment made for? Personal For a company For another person

Name and surname of the person being paid

Company Informations

Company Name Address

Number of employees Number of attendees

After submitting the application, you will be contacted by our sales persons.

Request a callback

Oracle Database 12c: Introduction to SQL Ed 2

Еден чекор поблиску до посакуваната цел

Име на курс

Payment Method

Payment with credit cards

Payment via invoice